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 |