Table: dbo.Do_Not_Pay_Reason | |||
This table stores various types of DNP(do not pay) reasons. | |||
Columns | |||
Name | Type | Constraints | Description |
do_not_pay_reason_KEY | int (4) | NOT NULL | Primary key. |
description | nvarchar (200) | NOT NULL | Detail for the reason. |
Primary key | |||
Name | Columns | Description | |
PK_Do_Not_Pay_Reason | do_not_pay_reason_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Do_Not_Pay_Reason$description | description |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Scheduled_Payroll_Tracking_Detail__Do_Not_Pay_Reason__do_not_pay_reason_KEY | do_not_pay_reason_KEY | Scheduled_Payroll_Tracking_Detail |