| 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) | |