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 |