Table: dbo.Payroll_Consolidation_Group
Payroll consolidation involves selecting a set of clients whose data will be combined["BR"] in order to produce a single tax form with the combined amounts. Each consolidated group has a primary client["BR"] and any number of secondary clients. Tax processing calculations combine data across multiple clients when["BR"] producing tax forms.
Columns
Name | Type | Constraints | Description
payroll_consolidation_group_KEY | int (4) | NOT NULL | The primary key for this table.
payroll_consolidation_group_id | nvarchar (22) | NOT NULL | User assigned group id.
description | nvarchar (100) | NOT NULL | User assigned group name.
group_impound_tax_payments | bit (1) | NOT NULL | Flag indicating whether or not impounded tax payments should be grouped.
do_not_combine_duplicate_employees | bit (1) | NOT NULL | Flag indicating whether or not employees from different clients within the group that have the same["BR"] SSN should have their payroll tax information combined when processing forms.
payroll_consolidation_group_id_sortable | nvarchar (96) | NOT NULL | A representation of the payroll_consolidation_group_id column that sorts in natural order.["BR"] A trigger keeps this field synchronized with the content of payroll_consolidation_group_id.
primary__client_KEY | int (4) | NOT NULL | The primary client in this consolidation group. The consolidated tax forms will be filed["BR"] under this client.

Primary key
Name | Columns | Description
PK_Payroll_Consolidation_Group | payroll_consolidation_group_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Consolidation_Group$payroll_consolidation_group_id | payroll_consolidation_group_id |
UK_Payroll_Consolidation_Group$payroll_consolidation_group_id_sortable | payroll_consolidation_group_id_sortable |
UK_Payroll_Consolidation_Group$payroll_consolidation_group_KEY | payroll_consolidation_group_KEY |
UK_Payroll_Consolidation_Group$primary__client_KEY | primary__client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Consolidation_Group__Client_Payroll_Information__primary__client_KEY | primary__client_KEY | Client_Payroll_Information (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payroll_Consolidation_Group_Member__Payroll_Consolidation_Group__payroll_consolidation_group_KEY | payroll_consolidation_group_KEY | Payroll_Consolidation_Group_Member |