Table: dbo.Payroll_Item_Special_Timing
Table that holds how a payroll items special timing is handled.
Columns
NameTypeConstraintsDescription
payroll_item_special_timing_KEYint (4)NOT NULLPrimary key; payroll item special timing key
payroll_item_special_timing_frequency_KEYint (4)NOT NULLForeign key into the Payroll Item Special Timing Frequency table
selected_week_onebit (1)NOT NULLFirst week selected
selected_week_twobit (1)NOT NULLSecond week selected
selected_week_threebit (1)NOT NULLThird week selected
selected_week_fourbit (1)NOT NULLFourth week selected
selected_week_fivebit (1)NOT NULLFifth week selected
payroll_item_special_timing_selected_payroll_period_basis_KEYint (4)NOT NULLForegin key into the Payroll Item Special Timing Selected Payroll Period basis key
selected_payroll__payroll_item_special_timing_date_basis_KEYint (4)NOT NULLForeign key into the Payroll Item Special Timing Date Basis table which the selected payroll frequency will use.
start_datesmalldatetime (4)Start date special timing will begin.
end_datesmalldatetime (4)End date special timing will end.
payroll_item_special_timing_date_basis_KEYint (4)NOT NULLForeign key into the Payroll Item Special Timing Date Basis table which start and end date will use.
Primary key
NameColumnsDescription
PK_Payroll_Item_Special_Timingpayroll_item_special_timing_KEY
Foreign keys
NameColumnsReferenced 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_Date_Basis (payroll_item_special_timing_date_basis_KEY)
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_Date_Basis (payroll_item_special_timing_date_basis_KEY)
FK_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing_Frequency__payroll_item_special_timing_frequency_KEYpayroll_item_special_timing_frequency_KEYPayroll_Item_Special_Timing_Frequency (payroll_item_special_timing_frequency_KEY)
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_Selected_Payroll_Period_Basis (payroll_item_special_timing_selected_payroll_period_basis_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Payroll_Item__Payroll_Item_Special_Timing__payroll_item_special_timing_KEYpayroll_item_special_timing_KEYClient_Payroll_Item
FK_Garnishment_Order__Payroll_Item_Special_Timing__payroll_item_special_timing_KEYpayroll_item_special_timing_KEYGarnishment_Order
FK_Employee_Payroll_Item_N_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing__payroll_item_special_timing_KEYpayroll_item_special_timing_KEYEmployee_Payroll_Item_N_Payroll_Item_Special_Timing
FK_Creditor_Garnishment_Order__Payroll_Item_Special_Timing__payroll_item_special_timing_KEYpayroll_item_special_timing_KEYCreditor_Garnishment_Order
FK_Child_Support_Order__Payroll_Item_Special_Timing__payroll_item_special_timing_KEYpayroll_item_special_timing_KEYChild_Support_Order

Schema diagram