Table: dbo.Payroll_Item_Special_Timing_Selected_Payroll_Period_Basis
Table to identify the period basis for a payroll special timing frequency of selected payrolls.
Columns
NameTypeConstraintsDescription
payroll_item_special_timing_selected_payroll_period_basis_KEYint (4)NOT NULLPrimary key; period basis key
descriptionnvarchar (28)NOT NULLDescription of the period basis
Primary key
NameColumnsDescription
PK_Payroll_Item_Special_Timing_Selected_Payroll_Period_Basispayroll_item_special_timing_selected_payroll_period_basis_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Item_Special_Timing_Selected_Payroll_Period_Basis$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing_Selected_Payroll_Period_Basis__payroll_item_special_timing_selected_payroll_item_special_timing_selected_payroll_period_basis_KEYPayroll_Item_Special_Timing

Schema diagram