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
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | The primary key for this table. Also a foreign key to the Client_Payroll_Information table.
payroll_consolidation_group_KEY | int (4) | NOT NULL | FK to the Payroll_Consolidation_Group table. Defines which group this record is a part of.
sequence_number | int (4) | NOT NULL | The 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
Name | Columns | Description
PK_Payroll_Consolidation_Group_Member$client_KEY | client_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Consolidation_Group_Member$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Consolidation_Group_Member__Client_Payroll_Information__client_KEY | client_KEY | Client_Payroll_Information (client_KEY) |
FK_Payroll_Consolidation_Group_Member__Payroll_Consolidation_Group__payroll_consolidation_group_KEY | payroll_consolidation_group_KEY | Payroll_Consolidation_Group (payroll_consolidation_group_KEY) |