| 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 | |||
| Name | Type | Constraints | Description |
| employee_payroll_item_KEY | int (4) | NOT NULL | Primary Key; foreign key to Employee Payroll Item table. |
| payroll_item_special_timing_KEY | int (4) | NOT NULL | Foreign key to the Payroll Item Special timing table. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Employee_Payroll_Item_N_Payroll_Item_Special_Timing$employee_payroll_item_KEY | employee_payroll_item_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Employee_Payroll_Item_N_Payroll_Item_Special_Timing$payroll_item_special_timing_KEY | payroll_item_special_timing_KEY | ||