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 |