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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Payroll_Item_N_Payroll_Item_Special_Timing__Employee_Payroll_Item__employee_payroll_item_KEY | employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |
FK_Employee_Payroll_Item_N_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing__payroll_item_special_timing_KEY | payroll_item_special_timing_KEY | Payroll_Item_Special_Timing (payroll_item_special_timing_KEY) |