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
NameTypeConstraintsDescription
payroll_consolidation_group_KEYint (4)NOT NULLThe primary key for this table.
payroll_consolidation_group_idnvarchar (22)NOT NULLUser assigned group id.
descriptionnvarchar (100)NOT NULLUser assigned group name.
group_impound_tax_paymentsbit (1)NOT NULLFlag indicating whether or not impounded tax payments should be grouped.
do_not_combine_duplicate_employeesbit (1)NOT NULLFlag 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_sortablenvarchar (96)NOT NULLA 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_KEYint (4)NOT NULLThe primary client in this consolidation group. The consolidated tax forms will be filed["BR"] under this client.
Primary key
NameColumnsDescription
PK_Payroll_Consolidation_Grouppayroll_consolidation_group_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Consolidation_Group$payroll_consolidation_group_idpayroll_consolidation_group_id
UK_Payroll_Consolidation_Group$payroll_consolidation_group_id_sortablepayroll_consolidation_group_id_sortable
UK_Payroll_Consolidation_Group$payroll_consolidation_group_KEYpayroll_consolidation_group_KEY
UK_Payroll_Consolidation_Group$primary__client_KEYprimary__client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Consolidation_Group__Client_Payroll_Information__primary__client_KEYprimary__client_KEYClient_Payroll_Information (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Consolidation_Group_Member__Payroll_Consolidation_Group__payroll_consolidation_group_KEYpayroll_consolidation_group_KEYPayroll_Consolidation_Group_Member

Schema diagram