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
NameTypeConstraintsDescription
ascii_time_clock_payroll_department_id_map_KEYint (4)NOT NULLWe 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_KEYint (4)NOT NULLThe payroll department that we want to identify for time clock import.
idnvarchar (4)NOT NULLIdentifies the payroll department for the purposes of time clock import.
Primary key
NameColumnsDescription
PK_Ascii_Time_Clock_Payroll_Department_Id_Mapascii_time_clock_payroll_department_id_map_KEY
Unique constraints
NameColumnsDescription
UK_Ascii_Time_Clock_Payroll_Department_Id_Map$payroll_department_KEYpayroll_department_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ascii_Time_Clock_Payroll_Department_Id_Map__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Department (payroll_department_KEY)

Schema diagram