| 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 | |