Table: dbo.Payroll_Item_Special_Timing_Date_Basis
Table to identify which date to base the payroll special timing on.
Columns
NameTypeConstraintsDescription
payroll_item_special_timing_date_basis_KEYint (4)NOT NULLPrimary key; payroll item date basis key
descriptionnvarchar (22)NOT NULLDescription of the date basis key
Primary key
NameColumnsDescription
PK_Payroll_Item_Special_Timing_Date_Basispayroll_item_special_timing_date_basis_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Item_Special_Timing_Date_Basis$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing_Date_Basis__payroll_item_special_timing_date_basis_KEYpayroll_item_special_timing_date_basis_KEYPayroll_Item_Special_Timing
FK_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing_Date_Basis__selected_payroll__payroll_item_special_timing_date_basisselected_payroll__payroll_item_special_timing_date_basis_KEYPayroll_Item_Special_Timing

Schema diagram