Table: dbo.Ascii_Time_Clock_Client_Payroll_Item_Id_Map
This table is used for ASCII time clock import. It maps a client payroll item to a (user-provided) id. The format of the id is specified by a legacy file format.
Columns
NameTypeConstraintsDescription
client_payroll_item_KEYint (4)NOT NULLThe client payroll item that we want to identify for time clock import.
idnvarchar (4)NOT NULLThis is an identifier to uniquely identify client payroll items for the purpose of time clock import.
Primary key
NameColumnsDescription
PK_Ascii_Time_Clock_Client_Payroll_Item_Id_Map$client_payroll_item_KEYclient_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ascii_Time_Clock_Client_Payroll_Item_Id_Map__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)

Schema diagram