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. |
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. |