| 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 | ||