Table: dbo.Payroll_Item_Special_Timing_Date_Basis
Table to identify which date to base the payroll special timing on.
Columns
Name | Type | Constraints | Description
payroll_item_special_timing_date_basis_KEY | int (4) | NOT NULL | Primary key; payroll item date basis key
description | nvarchar (22) | NOT NULL | Description of the date basis key

Primary key
Name | Columns | Description
PK_Payroll_Item_Special_Timing_Date_Basis | payroll_item_special_timing_date_basis_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Item_Special_Timing_Date_Basis$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing_Date_Basis__payroll_item_special_timing_date_basis_KEY | payroll_item_special_timing_date_basis_KEY | Payroll_Item_Special_Timing |
FK_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing_Date_Basis__selected_payroll__payroll_item_special_timing_date_basis | selected_payroll__payroll_item_special_timing_date_basis_KEY | Payroll_Item_Special_Timing |