Table: dbo.Ascii_Time_Clock_Employee_Id_Map
This table is used for ASCII time clock import. It maps an employee to a (user-provided) id. The format of the id is specified by a legacy file format.
Columns
NameTypeConstraintsDescription
employee_KEYint (4)NOT NULLThe employee we want to identify for time clock import.
idnvarchar (8)NOT NULLThis is an identifier to uniquely identify employees for the purpose of time clock import.
Primary key
NameColumnsDescription
PK_Ascii_Time_Clock_Employee_Id_Map$employee_KEYemployee_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ascii_Time_Clock_Employee_Id_Map__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)

Schema diagram