Table: dbo.Ascii_Time_Clock_Payroll_Department_Id_Map
This table is used for ASCII time clock import. It maps a payroll department to a (user-provided) id. The format of the id is specified by a legacy file format.
Columns
Name | Type | Constraints | Description
ascii_time_clock_payroll_department_id_map_KEY | int (4) | NOT NULL | We want a surrogate primary key column for this table because, in the future, the Id will refer to a department/location pair instead of just a location.
payroll_department_KEY | int (4) | NOT NULL | The payroll department that we want to identify for time clock import.
id | nvarchar (4) | NOT NULL | Identifies the payroll department for the purposes of time clock import.

Primary key
Name | Columns | Description
PK_Ascii_Time_Clock_Payroll_Department_Id_Map | ascii_time_clock_payroll_department_id_map_KEY |
Unique constraints
Name | Columns | Description
UK_Ascii_Time_Clock_Payroll_Department_Id_Map$payroll_department_KEY | payroll_department_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Ascii_Time_Clock_Payroll_Department_Id_Map__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Department (payroll_department_KEY) |