Table: dbo.Client_Payroll_Information
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLClient record that this table references
whole_dollar_rounding_FITbit (1)NOT NULLAllow whole dollar rounding for federal income tax
default__time_entry_method_KEYint (4)NOT NULLReference to time entry method
check_output_type_KEYint (4)NOT NULLReference to check output type
primary_processor__staff_KEYint (4)Primary staff who processes this client
backup_processor__staff_KEYint (4)Backup staff who might process this client
reviewer__staff_KEYint (4)Last staff who reviewed this client
employer_type_KEYint (4)NOT NULLReference to employer type
withholding_deposit_schedule_KEYint (4)NOT NULLReference to withholding deposit schedule
seasonal_employerbit (1)NOT NULLIs client a seasonal employer
fund_payroll_transactionbit (1)NOT NULLFunding payroll transactions?
fund_tax_agent_transactionbit (1)NOT NULLFunding tax agent transactions?
fund_firm_vendor_transactionbit (1)NOT NULLFunding billing vendor transactions?
fund_payroll_agent_transactionbit (1)NOT NULLFunding deduction agent transactions?
payroll_impound_deposit__checkbook_KEYint (4)key for payroll transaction funding impound deposit bank account.
tax_agent_impound_deposit__checkbook_KEYint (4)key for tax agent transaction funding impound deposit bank account.
firm_vendor_impound_deposit__checkbook_KEYint (4)key for firm vendor transaction funding impound deposit bank account.
payroll_agent_impound_deposit__checkbook_KEYint (4)key to payroll agent transaction funding deposit impound bank account.
funding_check_reference_source_selectiontinyint (1)NOT NULLSource of funding check reference numbers : 1 == Client 2 == Impound
funding_check_layouts_source_selectiontinyint (1)NOT NULLSource of funding check layouts : 1 == Client 2 == Impound
funding_image_source_selectiontinyint (1)NOT NULLSource of funding images : 1 == Client 2 == Impound
funding_signature_source_selectiontinyint (1)NOT NULLSource of funding signatures : 1 == Client 2 == Impound
send_payroll_checks_to_netclientbit (1)NOT NULLFlag to indicate payroll checks should be sent to netclient
send_payroll_checks_to_file_cabinetbit (1)NOT NULLFlag to indicate payroll checks should be sent to file cabinet
send_vendor_checks_to_netclientbit (1)NOT NULLFlag to indicate vendor checks should be sent to netclient
send_vendor_checks_to_file_cabinetbit (1)NOT NULLFlag to indicate vendor checks should be sent to file cabinet
eftps_taxpayer_pinnvarchar (8)NOT NULLEFTPS taxpayer PIN
is_net_client_web_employeebit (1)NOT NULLFlag, true if this client is a web employee client
offers_health_care_planbit (1)NOT NULLFlag to indicate whether a client offers health care plans to their employees.
has_agricultural_employeesbit (1)NOT NULLWhether or not a client has any agricultural employees.
payroll_tax_forms_filed_by_type_KEYint (4)NOT NULLThe foreign key to the Payroll_Tax_Forms_Filed_By_Type table
exclude_client_from_filing_untilsmalldatetime (4)Date to exclude the client from filing until.
payroll_funding_check_reference__account_source_selection_KEYint (4)NOT NULLPayroll check reference source.
payroll_funding_check_layouts__account_source_selection_KEYint (4)NOT NULLPayroll check layouts source.
payroll_funding_images__account_source_selection_KEYint (4)NOT NULLPayroll images source.
tax_agent_funding_check_reference__account_source_selection_KEYint (4)NOT NULLTax agent check reference source.
tax_agent_funding_check_layouts__account_source_selection_KEYint (4)NOT NULLTax agent check layouts source.
tax_agent_funding_images__account_source_selection_KEYint (4)NOT NULLTax agent images source.
firm_vendor_funding_check_reference__account_source_selection_KEYint (4)NOT NULLFirm vendor check reference source.
firm_vendor_funding_check_layouts__account_source_selection_KEYint (4)NOT NULLFirm vendor check layouts source.
firm_vendor_funding_images__account_source_selection_KEYint (4)NOT NULLFirm vendor images source.
payroll_agent_funding_check_reference__account_source_selection_KEYint (4)NOT NULLPayroll agent check reference source.
payroll_agent_funding_check_layouts__account_source_selection_KEYint (4)NOT NULLPayroll agent check layouts source.
payroll_agent_funding_images__account_source_selection_KEYint (4)NOT NULLPayroll agent images source.
exclude_funded_checks_from_remote_printingbit (1)NOT NULLBoolean on whether to exclude funded checks from remote vendor check printing.
payroll_impound_withdrawal__checkbook_KEYint (4)key for payroll transaction funding impound withdrawal bank account
tax_agent_impound_withdrawal__checkbook_KEYint (4)key for tax agent transaction funding impound withdrawal bank account.
firm_vendor_impound_withdrawal__checkbook_KEYint (4)key for firm vendor transaction funding impound withdrawal bank account.
payroll_agent_impound_withdrawal__checkbook_KEYint (4)key to payroll agent transaction funding impound withdrawal bank account.
payroll_impound_deferred_start_datesmalldatetime (4)Deferred start date for payroll transaction funding impounding.
tax_agent_impound_deferred_start_datesmalldatetime (4)Deferred start date for tax agent transaction funding impounding.
firm_vendor_impound_deferred_start_datesmalldatetime (4)Deferred start date for firm vendor transaction funding impounding.
payroll_agent_impound_deferred_start_datesmalldatetime (4)Deferred start date for payroll agent transaction funding impounding.
exclude_zero_net_amount_payroll_checks_from_remote_printingbit (1)NOT NULLBoolean on whether to exclude payroll checks with a zero net amount from remote check printing
is_client_self_service_enabledbit (1)NOT NULLTrue if this client is enabled for Client Self Service.
eftps_enrollment_created_datesmalldatetime (4)Date latest EFTPS enrollment file was created. Null means no enrollment file has ever been created.
pays_employee_health_premiumbit (1)NOT NULLTrue if this client pays part or all of its employee's health care premiums.
has_netclient_remote_payrollbit (1)NOT NULLTrue if this client has a NetClient portal.
exclude_timerack_salary_employeesbit (1)NOT NULLTrue if salary employees are excluded from TimeRack integration.
form_adjustment_write_off__gl_account_KEYint (4)Impound only: The form adjustment write off GL account. NULL indicates no account has been selected.
do_not_create_tax_liabilitiesbit (1)NOT NULLTrue if client does not want tax liabilities created.
new_hire_name_controlnvarchar (8)NOT NULLThe name control used to for new hire filing.
shortfall_deduction__selection_scope_KEYint (4)NOT NULLForeign Key which indicates how the applicable shortfall deduction items are selected
shortfall_tax__selection_scope_KEYint (4)NOT NULLForeign Key which indicates how the applicable shortfall tax items are selected
carry_shortfall_forwardbit (1)NOT NULLFlag which indicates if the shortfall transactions need to be reimbursed by future checks
shortfall_balance_reset_datesmalldatetime (4)Next date the shortfall balances are due to be reset
do_not_reset_shortfall_balancesbit (1)NOT NULLFlag which indicates if we should refrain from resetting the shortfall balances on the balance reset date
create_liabilities_for_shortfall_write_offbit (1)NOT NULLFlag which indicates if we should create liabilities for shortfall balances that exist when the balances are reset
shortfall_balance_reset_monthint (4)NOT NULLMonth the shortfall balance reset should occur
shortfall_balance_reset_dayint (4)NOT NULLDay the shortfall balance reset should occur
do_not_combine_state_unemployment_taxbit (1)NOT NULLFlag indicating the state unemployment taxes for this client should be calculated for each work location state.
is_time_rack_enabledbit (1)NOT NULLFlag which indicates that the client can have TimeRack time entry pay schedules.
is_sbpr_client_access_enabledbit (1)NOT NULLWhether or not Client Staff are allowed to work on this client through the SBPR Client Access program.
time_rack_guiduniqueidentifier (16)NOT NULLThis should be set to contact_guid when a payroll client is created. Value of this column will be used at the time of TimeRack and ACS/SBPR integration.
impound_profile_KEYint (4)This stores the key for the payroll impound profile that the client belongs to (if any). The impound profile indicates the number of days before payroll that impounding must be funded.
disable_alerts_for_pay_rate_exceeding_limitbit (1)NOT NULLFlag 0 indicates turn on and 1 indicates turn off the new Pay rate alerts for each client
disable_alert_for_hours_entered_over_standardbit (1)NOT NULLFlag 0 indicates turn on and 1 indicates turn off the new standard hours alerts for each client
calc_months_of_quarter_employee_counts_based_on_active_datebit (1)NOT NULLFlag 0 indicates to calculate the first, second and third month of processing quarter employee counts based on payroll check records. Flag 1 indicates to calculate based on active employees.
covid_19_defer_employer_social_securitybit (1)NOT NULL1 if the client has elected to defer employer social security payments to the end of years 2021 and 2022 under COVID legislation, 0 otherwise, provided the client has a record in this table.
covid_19_employee_retention_qualifies_2020_q1bit (1)NOT NULL1 if the client has indicated they qualify for the employee retention credit in 2020 q1; 0 if not.
covid_19_employee_retention_qualifies_2020_q2bit (1)NOT NULL1 if the client has indicated they qualify for the employee retention credit in 2020 q2; 0 if not.
covid_19_employee_retention_qualifies_2020_q3bit (1)NOT NULL1 if the client has indicated they qualify for the employee retention credit in 2020 q3; 0 if not.
covid_19_employee_retention_qualifies_2020_q4bit (1)NOT NULL1 if the client has indicated they qualify for the employee retention credit in 2020 q4; 0 if not.
is_delay_employee_direct_deposit_approval_based_on_first_batch_payroll_checkdate_enabledbit (1)NOT NULLWhen true, will delay employee direct deposit approval until a provided number of days after the first batch payroll check date. Column delay_employee_direct_deposit_approval_number_of_days is used to provide the number of days.
client_delay_direct_deposit_status_type_KEYtinyint (1)NOT NULLTO save client delay direct deposit status
covid_19_health_plan_expense_allocated_to_sick_leave_wage_2020_q2decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q2 of 2020 that may be treated as sick leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_family_leave_wage_2020_q2decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q2 of 2020 that may be treated as family leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_sick_leave_wage_2020_q3decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q3 of 2020 that may be treated as sick leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_family_leave_wage_2020_q3decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q3 of 2020 that may be treated as family leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_sick_leave_wage_2020_q4decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q4 of 2020 that may be treated as sick leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_family_leave_wage_2020_q4decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q4 of 2020 that may be treated as family leave wages for the purposes of the tax credit
onvio_client_idnvarchar (64)Onvio Core client identifier
covid_19_employee_retention_qualifies_2021_q1bit (1)NOT NULL1 if the client has indicated they qualify for the employee retention credit in 2021 q1; 0 if not.
covid_19_employee_retention_qualifies_2021_q2bit (1)NOT NULL1 if the client has indicated they qualify for the employee retention credit in 2021 q2; 0 if not.
covid_19_employee_retention_qualifies_2021_q3bit (1)NOT NULL1 if the client has indicated they qualify for the employee retention credit in 2021 q3; 0 if not.
covid_19_employee_retention_qualifies_2021_q4bit (1)NOT NULL1 if the client has indicated they qualify for the employee retention credit in 2021 q4; 0 if not.
covid_19_health_plan_expense_allocated_to_sick_leave_wage_2021_q1decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q1 of 2021 that may be treated as sick leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_family_leave_wage_2021_q1decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q1 of 2021 that may be treated as family leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_sick_leave_wage_2021_q2decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q2 of 2021 that may be treated as sick leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_family_leave_wage_2021_q2decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q2 of 2021 that may be treated as family leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_sick_leave_wage_2021_q3decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q3 of 2021 that may be treated as sick leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_family_leave_wage_2021_q3decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q3 of 2021 that may be treated as family leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_sick_leave_wage_2021_q4decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q4 of 2021 that may be treated as sick leave wages for the purposes of the tax credit
covid_19_health_plan_expense_allocated_to_family_leave_wage_2021_q4decimal (9, 2)NOT NULLHolds the nonnegative amount of health plan expense paid during Q4 of 2021 that may be treated as family leave wages for the purposes of the tax credit
arpa_cobra_credit_amount_2021_q2decimal (9, 2)NOT NULLHolds the nonnegative amount of cobra credit for Q2 of 2021
arpa_cobra_credit_amount_2021_q3decimal (9, 2)NOT NULLHolds the nonnegative amount of cobra credit for Q3 of 2021
arpa_cobra_number_of_individuals_2021_q2int (4)NOT NULLHolds the nonnegative amount of cobra individuals for Q2 of 2021
arpa_cobra_number_of_individuals_2021_q3int (4)NOT NULLHolds the nonnegative amount of cobra individuals for Q3 of 2021
arpa_health_plan_expense_allocated_to_sick_leave_wage_2021_q2decimal (9, 2)NOT NULLHolds the nonnegative amount of ARPA health plan expense allocated to sick leave wage for Q2 of 2021
arpa_health_plan_expense_allocated_to_sick_leave_wage_2021_q3decimal (9, 2)NOT NULLHolds the nonnegative amount of ARPA health plan expense allocated to sick leave wage for Q3 of 2021
arpa_health_plan_expense_allocated_to_family_leave_wage_2021_q2decimal (9, 2)NOT NULLHolds the nonnegative amount of ARPA health plan expense allocated to family leave wage for Q2 of 2021
arpa_health_plan_expense_allocated_to_family_leave_wage_2021_q3decimal (9, 2)NOT NULLHolds the nonnegative amount of ARPA health plan expense allocated to family leave wage for Q3 of 2021
arpa_collectively_bargained_expense_allocated_to_family_leave_wage_2021_q2decimal (9, 2)NOT NULLHolds the nonnegative amount of ARPA health plan expense allocated to family leave wage for Q2 of 2021
arpa_collectively_bargained_expense_allocated_to_family_leave_wage_2021_q3decimal (9, 2)NOT NULLHolds the nonnegative amount of ARPA health plan expense allocated to family leave wage for Q3 of 2021
arpa_collectively_bargained_expense_allocated_to_sick_leave_wage_2021_q2decimal (9, 2)NOT NULLHolds the nonnegative amount of ARPA health plan expense allocated to sick leave wage for Q2 of 2021
arpa_collectively_bargained_expense_allocated_to_sick_leave_wage_2021_q3decimal (9, 2)NOT NULLHolds the nonnegative amount of ARPA health plan expense allocated to sick leave wage for Q3 of 2021
delay_employee_direct_deposit_approval_number_of_daystinyint (1)NOT NULLNumber of days to delay direct deposit approval for employees past the first batch payroll check date.
swipe_clock_options_type_KEYtinyint (1)NOT NULLKey into the Swipe_Clock_Options_Type table that indicates what type of SwipeClock integration the Client has.Column value populates None for clients created after v2023.3.0. or clients that do not have SwipeClock or WorkforceHub enabled at the time the v2023.3.0 release was applied. Column value populates TimeWorks Plus for clients that have SwipeClock check box enabled and WorkforceHub check box disabled at the time the v2023.3.0 release was applied. Column value populates WorkforceHub (Legacy) for clients that have WorkforceHub check box enabled and SwipeClock check box disabled at the time the v2023.3.0 release was applied Column value populates TimeWorks Plus and WorkforceHub (Legacy) for clients that have SwipeClock and WorkforceHub check boxes enabled at the time the v2023.3.0 release was applied.
swipe_clock_client_guiduniqueidentifier (16)NOT NULLThe value in this column will be used to link ACS/SBPR Clients with their matching WorkForceHub Clients/sites in the internal micro service database when using SwipeClock integration with the "WorkforceHub (Advanced)" and "WorkforceHub (Plus)" options.
Primary key
NameColumnsDescription
PK_Client_Payroll_Information$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Payroll_Information__Account_Source_Selection__firm_vendor_funding_check_layouts__account_source_selection_KEYfirm_vendor_funding_check_layouts__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__firm_vendor_funding_check_reference__account_source_selection_KEYfirm_vendor_funding_check_reference__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__firm_vendor_funding_images__account_source_selection_KEYfirm_vendor_funding_images__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__payroll_agent_funding_check_layouts__account_source_selection_KEYpayroll_agent_funding_check_layouts__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__payroll_agent_funding_check_reference__account_source_selection_KEYpayroll_agent_funding_check_reference__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__payroll_agent_funding_images__account_source_selection_KEYpayroll_agent_funding_images__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__payroll_funding_check_layouts__account_source_selection_KEYpayroll_funding_check_layouts__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__payroll_funding_check_reference__account_source_selection_KEYpayroll_funding_check_reference__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__payroll_funding_images__account_source_selection_KEYpayroll_funding_images__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__tax_agent_funding_check_layouts__account_source_selection_KEYtax_agent_funding_check_layouts__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__tax_agent_funding_check_reference__account_source_selection_KEYtax_agent_funding_check_reference__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Account_Source_Selection__tax_agent_funding_images__account_source_selection_KEYtax_agent_funding_images__account_source_selection_KEYAccount_Source_Selection (account_source_selection_KEY)
FK_Client_Payroll_Information__Check_Output_Type__check_output_type_KEYcheck_output_type_KEYCheck_Output_Type (check_output_type_KEY)
FK_Client_Payroll_Information__Checkbook__firm_vendor_impound_deposit__checkbook_KEYfirm_vendor_impound_deposit__checkbook_KEYCheckbook (checkbook_KEY)
FK_Client_Payroll_Information__Checkbook__firm_vendor_impound_withdrawal__checkbook_KEYfirm_vendor_impound_withdrawal__checkbook_KEYCheckbook (checkbook_KEY)
FK_Client_Payroll_Information__Checkbook__payroll_agent_impound_deposit__checkbook_KEYpayroll_agent_impound_deposit__checkbook_KEYCheckbook (checkbook_KEY)
FK_Client_Payroll_Information__Checkbook__payroll_agent_impound_withdrawal__checkbook_KEYpayroll_agent_impound_withdrawal__checkbook_KEYCheckbook (checkbook_KEY)
FK_Client_Payroll_Information__Checkbook__payroll_impound_deposit__checkbook_KEYpayroll_impound_deposit__checkbook_KEYCheckbook (checkbook_KEY)
FK_Client_Payroll_Information__Checkbook__payroll_impound_withdrawal__checkbook_KEYpayroll_impound_withdrawal__checkbook_KEYCheckbook (checkbook_KEY)
FK_Client_Payroll_Information__Checkbook__tax_agent_impound_deposit__checkbook_KEYtax_agent_impound_deposit__checkbook_KEYCheckbook (checkbook_KEY)
FK_Client_Payroll_Information__Checkbook__tax_agent_impound_withdrawal__checkbook_KEYtax_agent_impound_withdrawal__checkbook_KEYCheckbook (checkbook_KEY)
FK_Client_Payroll_Information__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Payroll_Information__Employer_Type__employer_type_KEYemployer_type_KEYEmployer_Type (employer_type_KEY)
FK_Client_Payroll_Information__GL_Account__form_adjustment_write_off__gl_account_KEYform_adjustment_write_off__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_Payroll_Information__Payroll_Tax_Forms_Filed_By_Type__payroll_tax_forms_filed_by_type_KEYpayroll_tax_forms_filed_by_type_KEYPayroll_Tax_Forms_Filed_By_Type (payroll_tax_forms_filed_by_type_KEY)
FK_Client_Payroll_Information__Selection_Scope__shortfall_deduction__selection_scope_KEYshortfall_deduction__selection_scope_KEYSelection_Scope (selection_scope_KEY)
FK_Client_Payroll_Information__Selection_Scope__shortfall_tax__selection_scope_KEYshortfall_tax__selection_scope_KEYSelection_Scope (selection_scope_KEY)
FK_Client_Payroll_Information__Staff__backup_processor__staff_KEYbackup_processor__staff_KEYStaff (staff_KEY)
FK_Client_Payroll_Information__Staff__primary_processor__staff_KEYprimary_processor__staff_KEYStaff (staff_KEY)
FK_Client_Payroll_Information__Staff__reviewer__staff_KEYreviewer__staff_KEYStaff (staff_KEY)
FK_Client_Payroll_Information__Time_Entry_Method__default__time_entry_method_KEYdefault__time_entry_method_KEYTime_Entry_Method (time_entry_method_KEY)
FK_Client_Payroll_Information__Withholding_Deposit_Schedule__withholding_deposit_schedule_KEYwithholding_deposit_schedule_KEYWithholding_Deposit_Schedule (withholding_deposit_schedule_KEY)
FK_Client_Payroll_Information__Impound_Profile__impound_profile_KEYimpound_profile_KEYImpound_Profile (impound_profile_KEY)
FK_Client_Payroll_Information__Swipe_Clock_Options_Type__swipe_clock_options_type_KEYswipe_clock_options_type_KEYSwipe_Clock_Options_Type (swipe_clock_options_type_KEY)
FK_Client_Payroll_Information__Client_Delay_Direct_Deposit_Status_Type__client_delay_direct_deposit_status_type_KEYclient_delay_direct_deposit_status_type_KEYClient_Delay_Direct_Deposit_Status_Type (client_delay_direct_deposit_status_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials__Client_Payroll_Information__client_KEYclient_KEYClient_Payroll_Information_Swipe_Clock_Partner_Login_CredentialsClient key on which swipe clock is enabled and it is Foreign-keyed to["BR"] Client_Payroll_Information rather than directly to Client.
FK_Client_Payroll_Information_Swipe_Clock_Details__Client_Payroll_Information__client_KEYclient_KEYClient_Payroll_Information_Swipe_Clock_DetailsClient["BR"] key on which swipe clock is enabled and it is Foreign-keyed to Client_Payroll_Information rather than directly to Client.
FK_Payroll_Consolidation_Group__Client_Payroll_Information__primary__client_KEYprimary__client_KEYPayroll_Consolidation_Group
FK_BS_Client_Payroll_Information__Checkbook__payroll_impound_depositclient_KEYBS_Client_Payroll_Information__Checkbook__payroll_impound_deposit
FK_BS_Client_Payroll_Information__Checkbook__tax_agent_impound_withdrawalclient_KEYBS_Client_Payroll_Information__Checkbook__tax_agent_impound_withdrawal
FK_BS_Client_Payroll_Information__Checkbook__tax_agent_impound_depositclient_KEYBS_Client_Payroll_Information__Checkbook__tax_agent_impound_deposit
FK_BS_Client_Payroll_Information__Checkbook__payroll_impound_withdrawalclient_KEYBS_Client_Payroll_Information__Checkbook__payroll_impound_withdrawal
FK_BS_Client_Payroll_Information__Checkbook__payroll_agent_impound_depositclient_KEYBS_Client_Payroll_Information__Checkbook__payroll_agent_impound_deposit
FK_BS_Client_Payroll_Information__Checkbook__payroll_agent_impound_withdrawalclient_KEYBS_Client_Payroll_Information__Checkbook__payroll_agent_impound_withdrawal
FK_BS_Client_Payroll_Information__Checkbook__firm_vendor_impound_depositclient_KEYBS_Client_Payroll_Information__Checkbook__firm_vendor_impound_deposit
FK_BS_Client_Payroll_Information__Checkbook__firm_vendor_impound_withdrawalclient_KEYBS_Client_Payroll_Information__Checkbook__firm_vendor_impound_withdrawal
FK_Form_7200_Payment_Requested__Client_Payroll_Information__client_KEYclient_KEYForm_7200_Payment_Requested
FK_Client_1099_Tax_Form_Selection__Client_Payroll_Information__client_KEYclient_KEYClient_1099_Tax_Form_SelectionFOREIGN KEY constraint of client_KEY for the Client_1099_Tax_Form_Selection table.
FK_Payroll_Consolidation_Group_Member__Client_Payroll_Information__client_KEYclient_KEYPayroll_Consolidation_Group_Member

Schema diagram