Table: dbo.Payroll_Item_Special_Timing
Table that holds how a payroll items special timing is handled.
Columns
Name | Type | Constraints | Description
payroll_item_special_timing_KEY | int (4) | NOT NULL | Primary key; payroll item special timing key
payroll_item_special_timing_frequency_KEY | int (4) | NOT NULL | Foreign key into the Payroll Item Special Timing Frequency table
selected_week_one | bit (1) | NOT NULL | First week selected
selected_week_two | bit (1) | NOT NULL | Second week selected
selected_week_three | bit (1) | NOT NULL | Third week selected
selected_week_four | bit (1) | NOT NULL | Fourth week selected
selected_week_five | bit (1) | NOT NULL | Fifth week selected
payroll_item_special_timing_selected_payroll_period_basis_KEY | int (4) | NOT NULL | Foregin key into the Payroll Item Special Timing Selected Payroll Period basis key
selected_payroll__payroll_item_special_timing_date_basis_KEY | int (4) | NOT NULL | Foreign key into the Payroll Item Special Timing Date Basis table which the selected payroll frequency will use.
start_date | smalldatetime (4) |  | Start date special timing will begin.
end_date | smalldatetime (4) |  | End date special timing will end.
payroll_item_special_timing_date_basis_KEY | int (4) | NOT NULL | Foreign key into the Payroll Item Special Timing Date Basis table which start and end date will use.

Primary key
Name | Columns | Description
PK_Payroll_Item_Special_Timing | payroll_item_special_timing_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing_Date_Basis__payroll_item_special_timing_date_basis_KEY | payroll_item_special_timing_date_basis_KEY | Payroll_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_basis | selected_payroll__payroll_item_special_timing_date_basis_KEY | Payroll_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_KEY | payroll_item_special_timing_frequency_KEY | Payroll_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_KEY | Payroll_Item_Special_Timing_Selected_Payroll_Period_Basis (payroll_item_special_timing_selected_payroll_period_basis_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_Payroll_Item__Payroll_Item_Special_Timing__payroll_item_special_timing_KEY | payroll_item_special_timing_KEY | Client_Payroll_Item |
FK_Garnishment_Order__Payroll_Item_Special_Timing__payroll_item_special_timing_KEY | payroll_item_special_timing_KEY | Garnishment_Order |
FK_Employee_Payroll_Item_N_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing__payroll_item_special_timing_KEY | payroll_item_special_timing_KEY | Employee_Payroll_Item_N_Payroll_Item_Special_Timing |
FK_Child_Support_Order__Payroll_Item_Special_Timing__payroll_item_special_timing_KEY | payroll_item_special_timing_KEY | Child_Support_Order |
FK_Creditor_Garnishment_Order__Payroll_Item_Special_Timing__payroll_item_special_timing_KEY | payroll_item_special_timing_KEY | Creditor_Garnishment_Order |