Table: dbo.Do_Not_Pay_Reason
This table stores various types of DNP(do not pay) reasons.
Columns
NameTypeConstraintsDescription
do_not_pay_reason_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (200)NOT NULLDetail for the reason.
Primary key
NameColumnsDescription
PK_Do_Not_Pay_Reasondo_not_pay_reason_KEY
Unique constraints
NameColumnsDescription
UK_Do_Not_Pay_Reason$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Scheduled_Payroll_Tracking_Detail__Do_Not_Pay_Reason__do_not_pay_reason_KEYdo_not_pay_reason_KEYScheduled_Payroll_Tracking_Detail

Schema diagram