Table: dbo.Employee_Payroll_Item_N_Payroll_Item_Special_Timing
This dictionary table associates a employee payroll item record with a payroll item special timing record. All employee payroll items will have a special timing row associated with it except payroll items of type garnishment.
Columns
NameTypeConstraintsDescription
employee_payroll_item_KEYint (4)NOT NULLPrimary Key; foreign key to Employee Payroll Item table.
payroll_item_special_timing_KEYint (4)NOT NULLForeign key to the Payroll Item Special timing table.
Primary key
NameColumnsDescription
PK_Employee_Payroll_Item_N_Payroll_Item_Special_Timing$employee_payroll_item_KEYemployee_payroll_item_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Payroll_Item_N_Payroll_Item_Special_Timing$payroll_item_special_timing_KEYpayroll_item_special_timing_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Payroll_Item_N_Payroll_Item_Special_Timing__Employee_Payroll_Item__employee_payroll_item_KEYemployee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)
FK_Employee_Payroll_Item_N_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing__payroll_item_special_timing_KEYpayroll_item_special_timing_KEYPayroll_Item_Special_Timing (payroll_item_special_timing_KEY)

Schema diagram