Table: dbo.Ascii_Time_Clock_Client_Benefit_Id_Map
This table is used for ASCII time clock import. It maps a client benefit to a (user-provided) id. The format of the id is specified by a legacy file format.
Columns
NameTypeConstraintsDescription
client_benefit_KEYint (4)NOT NULLThe client benefit that we want to identify for time clock import
idnvarchar (4)NOT NULLThis is an identifier to uniquely identify client benefits for the purpose of time clock import
Primary key
NameColumnsDescription
PK_Ascii_Time_Clock_Client_Benefit_Id_Map$client_benefit_KEYclient_benefit_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ascii_Time_Clock_Client_Benefit_Id_Map$client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)

Schema diagram