Table: dbo.Payroll_Consolidation_Group_Member
Defines which payroll consolidation group a client might belong to as well as["BR"] the client's sequence number in the group. These are all secondary clients in the group.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLThe primary key for this table. Also a foreign key to the Client_Payroll_Information table.
payroll_consolidation_group_KEYint (4)NOT NULLFK to the Payroll_Consolidation_Group table. Defines which group this record is a part of.
sequence_numberint (4)NOT NULLThe sequence number of this client. State and local information is used from clients with a["BR"] lesser sequence number before clients with a greater sequence number.
Primary key
NameColumnsDescription
PK_Payroll_Consolidation_Group_Member$client_KEYclient_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Consolidation_Group_Member$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Consolidation_Group_Member__Client_Payroll_Information__client_KEYclient_KEYClient_Payroll_Information (client_KEY)
FK_Payroll_Consolidation_Group_Member__Payroll_Consolidation_Group__payroll_consolidation_group_KEYpayroll_consolidation_group_KEYPayroll_Consolidation_Group (payroll_consolidation_group_KEY)

Schema diagram