Table: dbo.Client_Payroll_Information
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | Client record that this table references
whole_dollar_rounding_FIT | bit (1) | NOT NULL | Allow whole dollar rounding for federal income tax
default__time_entry_method_KEY | int (4) | NOT NULL | Reference to time entry method
check_output_type_KEY | int (4) | NOT NULL | Reference to check output type
primary_processor__staff_KEY | int (4) |  | Primary staff who processes this client
backup_processor__staff_KEY | int (4) |  | Backup staff who might process this client
reviewer__staff_KEY | int (4) |  | Last staff who reviewed this client
employer_type_KEY | int (4) | NOT NULL | Reference to employer type
withholding_deposit_schedule_KEY | int (4) | NOT NULL | Reference to withholding deposit schedule
seasonal_employer | bit (1) | NOT NULL | Is client a seasonal employer
fund_payroll_transaction | bit (1) | NOT NULL | Funding payroll transactions?
fund_tax_agent_transaction | bit (1) | NOT NULL | Funding tax agent transactions?
fund_firm_vendor_transaction | bit (1) | NOT NULL | Funding billing vendor transactions?
fund_payroll_agent_transaction | bit (1) | NOT NULL | Funding deduction agent transactions?
payroll_impound_deposit__checkbook_KEY | int (4) |  | key for payroll transaction funding impound deposit bank account.
tax_agent_impound_deposit__checkbook_KEY | int (4) |  | key for tax agent transaction funding impound deposit bank account.
firm_vendor_impound_deposit__checkbook_KEY | int (4) |  | key for firm vendor transaction funding impound deposit bank account.
payroll_agent_impound_deposit__checkbook_KEY | int (4) |  | key to payroll agent transaction funding deposit impound bank account.
funding_check_reference_source_selection | tinyint (1) | NOT NULL | Source of funding check reference numbers : 1 == Client 2 == Impound
funding_check_layouts_source_selection | tinyint (1) | NOT NULL | Source of funding check layouts : 1 == Client 2 == Impound
funding_image_source_selection | tinyint (1) | NOT NULL | Source of funding images : 1 == Client 2 == Impound
funding_signature_source_selection | tinyint (1) | NOT NULL | Source of funding signatures : 1 == Client 2 == Impound
send_payroll_checks_to_netclient | bit (1) | NOT NULL | Flag to indicate payroll checks should be sent to netclient
send_payroll_checks_to_file_cabinet | bit (1) | NOT NULL | Flag to indicate payroll checks should be sent to file cabinet
send_vendor_checks_to_netclient | bit (1) | NOT NULL | Flag to indicate vendor checks should be sent to netclient
send_vendor_checks_to_file_cabinet | bit (1) | NOT NULL | Flag to indicate vendor checks should be sent to file cabinet
eftps_taxpayer_pin | nvarchar (8) | NOT NULL | EFTPS taxpayer PIN
is_net_client_web_employee | bit (1) | NOT NULL | Flag, true if this client is a web employee client
offers_health_care_plan | bit (1) | NOT NULL | Flag to indicate whether a client offers health care plans to their employees.
has_agricultural_employees | bit (1) | NOT NULL | Whether or not a client has any agricultural employees.
payroll_tax_forms_filed_by_type_KEY | int (4) | NOT NULL | The foreign key to the Payroll_Tax_Forms_Filed_By_Type table
exclude_client_from_filing_until | smalldatetime (4) |  | Date to exclude the client from filing until.
payroll_funding_check_reference__account_source_selection_KEY | int (4) | NOT NULL | Payroll check reference source.
payroll_funding_check_layouts__account_source_selection_KEY | int (4) | NOT NULL | Payroll check layouts source.
payroll_funding_images__account_source_selection_KEY | int (4) | NOT NULL | Payroll images source.
tax_agent_funding_check_reference__account_source_selection_KEY | int (4) | NOT NULL | Tax agent check reference source.
tax_agent_funding_check_layouts__account_source_selection_KEY | int (4) | NOT NULL | Tax agent check layouts source.
tax_agent_funding_images__account_source_selection_KEY | int (4) | NOT NULL | Tax agent images source.
firm_vendor_funding_check_reference__account_source_selection_KEY | int (4) | NOT NULL | Firm vendor check reference source.
firm_vendor_funding_check_layouts__account_source_selection_KEY | int (4) | NOT NULL | Firm vendor check layouts source.
firm_vendor_funding_images__account_source_selection_KEY | int (4) | NOT NULL | Firm vendor images source.
payroll_agent_funding_check_reference__account_source_selection_KEY | int (4) | NOT NULL | Payroll agent check reference source.
payroll_agent_funding_check_layouts__account_source_selection_KEY | int (4) | NOT NULL | Payroll agent check layouts source.
payroll_agent_funding_images__account_source_selection_KEY | int (4) | NOT NULL | Payroll agent images source.
exclude_funded_checks_from_remote_printing | bit (1) | NOT NULL | Boolean on whether to exclude funded checks from remote vendor check printing.
payroll_impound_withdrawal__checkbook_KEY | int (4) |  | key for payroll transaction funding impound withdrawal bank account
tax_agent_impound_withdrawal__checkbook_KEY | int (4) |  | key for tax agent transaction funding impound withdrawal bank account.
firm_vendor_impound_withdrawal__checkbook_KEY | int (4) |  | key for firm vendor transaction funding impound withdrawal bank account.
payroll_agent_impound_withdrawal__checkbook_KEY | int (4) |  | key to payroll agent transaction funding impound withdrawal bank account.
payroll_impound_deferred_start_date | smalldatetime (4) |  | Deferred start date for payroll transaction funding impounding.
tax_agent_impound_deferred_start_date | smalldatetime (4) |  | Deferred start date for tax agent transaction funding impounding.
firm_vendor_impound_deferred_start_date | smalldatetime (4) |  | Deferred start date for firm vendor transaction funding impounding.
payroll_agent_impound_deferred_start_date | smalldatetime (4) |  | Deferred start date for payroll agent transaction funding impounding.
exclude_zero_net_amount_payroll_checks_from_remote_printing | bit (1) | NOT NULL | Boolean on whether to exclude payroll checks with a zero net amount from remote check printing
is_client_self_service_enabled | bit (1) | NOT NULL | True if this client is enabled for Client Self Service.
eftps_enrollment_created_date | smalldatetime (4) |  | Date latest EFTPS enrollment file was created. Null means no enrollment file has ever been created.
pays_employee_health_premium | bit (1) | NOT NULL | True if this client pays part or all of its employee's health care premiums.
has_netclient_remote_payroll | bit (1) | NOT NULL | True if this client has a NetClient portal.
exclude_timerack_salary_employees | bit (1) | NOT NULL | True if salary employees are excluded from TimeRack integration.
form_adjustment_write_off__gl_account_KEY | int (4) |  | Impound only: The form adjustment write off GL account. NULL indicates no account has been selected.
do_not_create_tax_liabilities | bit (1) | NOT NULL | True if client does not want tax liabilities created.
new_hire_name_control | nvarchar (8) | NOT NULL | The name control used to for new hire filing.
shortfall_deduction__selection_scope_KEY | int (4) | NOT NULL | Foreign Key which indicates how the applicable shortfall deduction items are selected
shortfall_tax__selection_scope_KEY | int (4) | NOT NULL | Foreign Key which indicates how the applicable shortfall tax items are selected
carry_shortfall_forward | bit (1) | NOT NULL | Flag which indicates if the shortfall transactions need to be reimbursed by future checks
shortfall_balance_reset_date | smalldatetime (4) |  | Next date the shortfall balances are due to be reset
do_not_reset_shortfall_balances | bit (1) | NOT NULL | Flag which indicates if we should refrain from resetting the shortfall balances on the balance reset date
create_liabilities_for_shortfall_write_off | bit (1) | NOT NULL | Flag which indicates if we should create liabilities for shortfall balances that exist when the balances are reset
shortfall_balance_reset_month | int (4) | NOT NULL | Month the shortfall balance reset should occur
shortfall_balance_reset_day | int (4) | NOT NULL | Day the shortfall balance reset should occur
do_not_combine_state_unemployment_tax | bit (1) | NOT NULL | Flag indicating the state unemployment taxes for this client should be calculated for each work location state.
is_time_rack_enabled | bit (1) | NOT NULL | Flag which indicates that the client can have TimeRack time entry pay schedules.
is_sbpr_client_access_enabled | bit (1) | NOT NULL | Whether or not Client Staff are allowed to work on this client through the SBPR Client Access program.
time_rack_guid | uniqueidentifier (16) | NOT NULL | This 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_KEY | int (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_limit | bit (1) | NOT NULL | Flag 0 indicates turn on and 1 indicates turn off the new Pay rate alerts for each client
disable_alert_for_hours_entered_over_standard | bit (1) | NOT NULL | Flag 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_date | bit (1) | NOT NULL | Flag 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_security | bit (1) | NOT NULL | 1 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_q1 | bit (1) | NOT NULL | 1 if the client has indicated they qualify for the employee retention credit in 2020 q1; 0 if not.
covid_19_employee_retention_qualifies_2020_q2 | bit (1) | NOT NULL | 1 if the client has indicated they qualify for the employee retention credit in 2020 q2; 0 if not.
covid_19_employee_retention_qualifies_2020_q3 | bit (1) | NOT NULL | 1 if the client has indicated they qualify for the employee retention credit in 2020 q3; 0 if not.
covid_19_employee_retention_qualifies_2020_q4 | bit (1) | NOT NULL | 1 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_enabled | bit (1) | NOT NULL | When 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_KEY | tinyint (1) | NOT NULL | TO save client delay direct deposit status
covid_19_health_plan_expense_allocated_to_sick_leave_wage_2020_q2 | decimal (9, 2) | NOT NULL | Holds 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_q2 | decimal (9, 2) | NOT NULL | Holds 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_q3 | decimal (9, 2) | NOT NULL | Holds 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_q3 | decimal (9, 2) | NOT NULL | Holds 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_q4 | decimal (9, 2) | NOT NULL | Holds 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_q4 | decimal (9, 2) | NOT NULL | Holds 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_id | nvarchar (64) |  | Onvio Core client identifier
covid_19_employee_retention_qualifies_2021_q1 | bit (1) | NOT NULL | 1 if the client has indicated they qualify for the employee retention credit in 2021 q1; 0 if not.
covid_19_employee_retention_qualifies_2021_q2 | bit (1) | NOT NULL | 1 if the client has indicated they qualify for the employee retention credit in 2021 q2; 0 if not.
covid_19_employee_retention_qualifies_2021_q3 | bit (1) | NOT NULL | 1 if the client has indicated they qualify for the employee retention credit in 2021 q3; 0 if not.
covid_19_employee_retention_qualifies_2021_q4 | bit (1) | NOT NULL | 1 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_q1 | decimal (9, 2) | NOT NULL | Holds 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_q1 | decimal (9, 2) | NOT NULL | Holds 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_q2 | decimal (9, 2) | NOT NULL | Holds 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_q2 | decimal (9, 2) | NOT NULL | Holds 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_q3 | decimal (9, 2) | NOT NULL | Holds 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_q3 | decimal (9, 2) | NOT NULL | Holds 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_q4 | decimal (9, 2) | NOT NULL | Holds 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_q4 | decimal (9, 2) | NOT NULL | Holds 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_q2 | decimal (9, 2) | NOT NULL | Holds the nonnegative amount of cobra credit for Q2 of 2021
arpa_cobra_credit_amount_2021_q3 | decimal (9, 2) | NOT NULL | Holds the nonnegative amount of cobra credit for Q3 of 2021
arpa_cobra_number_of_individuals_2021_q2 | int (4) | NOT NULL | Holds the nonnegative amount of cobra individuals for Q2 of 2021
arpa_cobra_number_of_individuals_2021_q3 | int (4) | NOT NULL | Holds the nonnegative amount of cobra individuals for Q3 of 2021
arpa_health_plan_expense_allocated_to_sick_leave_wage_2021_q2 | decimal (9, 2) | NOT NULL | Holds 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_q3 | decimal (9, 2) | NOT NULL | Holds 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_q2 | decimal (9, 2) | NOT NULL | Holds 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_q3 | decimal (9, 2) | NOT NULL | Holds 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_q2 | decimal (9, 2) | NOT NULL | Holds 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_q3 | decimal (9, 2) | NOT NULL | Holds 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_q2 | decimal (9, 2) | NOT NULL | Holds 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_q3 | decimal (9, 2) | NOT NULL | Holds the nonnegative amount of ARPA health plan expense allocated to sick leave wage for Q3 of 2021
delay_employee_direct_deposit_approval_number_of_days | tinyint (1) | NOT NULL | Number of days to delay direct deposit approval for employees past the first batch payroll check date.
swipe_clock_options_type_KEY | tinyint (1) | NOT NULL | Key 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 `TimeWorksPlus` 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 `TimeWorksPlus 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_guid | uniqueidentifier (16) | NOT NULL | The 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
Name | Columns | Description
PK_Client_Payroll_Information$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Payroll_Information__Account_Source_Selection__firm_vendor_funding_check_layouts__account_source_selection_KEY | firm_vendor_funding_check_layouts__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__firm_vendor_funding_check_reference__account_source_selection_KEY | firm_vendor_funding_check_reference__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__firm_vendor_funding_images__account_source_selection_KEY | firm_vendor_funding_images__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__payroll_agent_funding_check_layouts__account_source_selection_KEY | payroll_agent_funding_check_layouts__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__payroll_agent_funding_check_reference__account_source_selection_KEY | payroll_agent_funding_check_reference__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__payroll_agent_funding_images__account_source_selection_KEY | payroll_agent_funding_images__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__payroll_funding_check_layouts__account_source_selection_KEY | payroll_funding_check_layouts__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__payroll_funding_check_reference__account_source_selection_KEY | payroll_funding_check_reference__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__payroll_funding_images__account_source_selection_KEY | payroll_funding_images__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__tax_agent_funding_check_layouts__account_source_selection_KEY | tax_agent_funding_check_layouts__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__tax_agent_funding_check_reference__account_source_selection_KEY | tax_agent_funding_check_reference__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Account_Source_Selection__tax_agent_funding_images__account_source_selection_KEY | tax_agent_funding_images__account_source_selection_KEY | Account_Source_Selection (account_source_selection_KEY) |
FK_Client_Payroll_Information__Check_Output_Type__check_output_type_KEY | check_output_type_KEY | Check_Output_Type (check_output_type_KEY) |
FK_Client_Payroll_Information__Checkbook__firm_vendor_impound_deposit__checkbook_KEY | firm_vendor_impound_deposit__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Client_Payroll_Information__Checkbook__firm_vendor_impound_withdrawal__checkbook_KEY | firm_vendor_impound_withdrawal__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Client_Payroll_Information__Checkbook__payroll_agent_impound_deposit__checkbook_KEY | payroll_agent_impound_deposit__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Client_Payroll_Information__Checkbook__payroll_agent_impound_withdrawal__checkbook_KEY | payroll_agent_impound_withdrawal__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Client_Payroll_Information__Checkbook__payroll_impound_deposit__checkbook_KEY | payroll_impound_deposit__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Client_Payroll_Information__Checkbook__payroll_impound_withdrawal__checkbook_KEY | payroll_impound_withdrawal__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Client_Payroll_Information__Checkbook__tax_agent_impound_deposit__checkbook_KEY | tax_agent_impound_deposit__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Client_Payroll_Information__Checkbook__tax_agent_impound_withdrawal__checkbook_KEY | tax_agent_impound_withdrawal__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Client_Payroll_Information__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_Payroll_Information__Employer_Type__employer_type_KEY | employer_type_KEY | Employer_Type (employer_type_KEY) |
FK_Client_Payroll_Information__GL_Account__form_adjustment_write_off__gl_account_KEY | form_adjustment_write_off__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_Payroll_Information__Payroll_Tax_Forms_Filed_By_Type__payroll_tax_forms_filed_by_type_KEY | payroll_tax_forms_filed_by_type_KEY | Payroll_Tax_Forms_Filed_By_Type (payroll_tax_forms_filed_by_type_KEY) |
FK_Client_Payroll_Information__Selection_Scope__shortfall_deduction__selection_scope_KEY | shortfall_deduction__selection_scope_KEY | Selection_Scope (selection_scope_KEY) |
FK_Client_Payroll_Information__Selection_Scope__shortfall_tax__selection_scope_KEY | shortfall_tax__selection_scope_KEY | Selection_Scope (selection_scope_KEY) |
FK_Client_Payroll_Information__Staff__backup_processor__staff_KEY | backup_processor__staff_KEY | Staff (staff_KEY) |
FK_Client_Payroll_Information__Staff__primary_processor__staff_KEY | primary_processor__staff_KEY | Staff (staff_KEY) |
FK_Client_Payroll_Information__Staff__reviewer__staff_KEY | reviewer__staff_KEY | Staff (staff_KEY) |
FK_Client_Payroll_Information__Time_Entry_Method__default__time_entry_method_KEY | default__time_entry_method_KEY | Time_Entry_Method (time_entry_method_KEY) |
FK_Client_Payroll_Information__Withholding_Deposit_Schedule__withholding_deposit_schedule_KEY | withholding_deposit_schedule_KEY | Withholding_Deposit_Schedule (withholding_deposit_schedule_KEY) |
FK_Client_Payroll_Information__Impound_Profile__impound_profile_KEY | impound_profile_KEY | Impound_Profile (impound_profile_KEY) |
FK_Client_Payroll_Information__Swipe_Clock_Options_Type__swipe_clock_options_type_KEY | swipe_clock_options_type_KEY | Swipe_Clock_Options_Type (swipe_clock_options_type_KEY) |
FK_Client_Payroll_Information__Client_Delay_Direct_Deposit_Status_Type__client_delay_direct_deposit_status_type_KEY | client_delay_direct_deposit_status_type_KEY | Client_Delay_Direct_Deposit_Status_Type (client_delay_direct_deposit_status_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials__Client_Payroll_Information__client_KEY | client_KEY | Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials | Client key on which swipe clock is enabled and it is Foreign-keyed to["BR"] Client_Payroll_Information rather than directly to Client.
FK_BS_Client_Payroll_Information__Checkbook__payroll_impound_deposit | client_KEY | BS_Client_Payroll_Information__Checkbook__payroll_impound_deposit |
FK_Client_Payroll_Information_Swipe_Clock_Details__Client_Payroll_Information__client_KEY | client_KEY | Client_Payroll_Information_Swipe_Clock_Details | Client["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_KEY | primary__client_KEY | Payroll_Consolidation_Group |
FK_BS_Client_Payroll_Information__Checkbook__tax_agent_impound_withdrawal | client_KEY | BS_Client_Payroll_Information__Checkbook__tax_agent_impound_withdrawal |
FK_BS_Client_Payroll_Information__Checkbook__tax_agent_impound_deposit | client_KEY | BS_Client_Payroll_Information__Checkbook__tax_agent_impound_deposit |
FK_BS_Client_Payroll_Information__Checkbook__payroll_impound_withdrawal | client_KEY | BS_Client_Payroll_Information__Checkbook__payroll_impound_withdrawal |
FK_BS_Client_Payroll_Information__Checkbook__payroll_agent_impound_deposit | client_KEY | BS_Client_Payroll_Information__Checkbook__payroll_agent_impound_deposit |
FK_BS_Client_Payroll_Information__Checkbook__payroll_agent_impound_withdrawal | client_KEY | BS_Client_Payroll_Information__Checkbook__payroll_agent_impound_withdrawal |
FK_BS_Client_Payroll_Information__Checkbook__firm_vendor_impound_deposit | client_KEY | BS_Client_Payroll_Information__Checkbook__firm_vendor_impound_deposit |
FK_BS_Client_Payroll_Information__Checkbook__firm_vendor_impound_withdrawal | client_KEY | BS_Client_Payroll_Information__Checkbook__firm_vendor_impound_withdrawal |
FK_Form_7200_Payment_Requested__Client_Payroll_Information__client_KEY | client_KEY | Form_7200_Payment_Requested |
FK_Client_1099_Tax_Form_Selection__Client_Payroll_Information__client_KEY | client_KEY | Client_1099_Tax_Form_Selection | FOREIGN KEY constraint of client_KEY for the Client_1099_Tax_Form_Selection table.
FK_Payroll_Consolidation_Group_Member__Client_Payroll_Information__client_KEY | client_KEY | Payroll_Consolidation_Group_Member |