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