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