Table: dbo.Payroll_Check_Entry_Option
This table contains the data entry options to configure the batch check entry grid.
Columns
NameTypeConstraintsDescription
client_pay_schedule_KEYint (4)NOT NULLPrimary Key. Also a Foreign Key to the Client_Pay_Schedule table.
employee_sort_by_type_KEYint (4)NOT NULLIndicates a sort order of the checks displayed.
hide_employee_idbit (1)NOT NULLFlag representing whether to show the employee id in the display.
hide_employee_namebit (1)NOT NULLFlag representing whether to show the employee name in the display.
hide_locationbit (1)NOT NULLFlag representing whether to show the location in the display.
hide_departmentbit (1)NOT NULLFlag representing whether to show the department in the display.
hide_gross_paybit (1)NOT NULLFlag representing whether to show the gross pay in the display.
hide_net_paybit (1)NOT NULLFlag representing whether to show the net pay in the display.
minimum_wage_payroll_check_treatment_KEYint (4)NOT NULLIndicates which action to take if a check does not meet minimum wage requirements.
negative_payroll_check_treatment_KEYint (4)NOT NULLIndicates which action to take if a check has a negative net pay.
shortfall_deduction__selection_scope_KEYint (4)NOT NULLIndicates what portion of the deduction items will be used to reduce a negative check.
shortfall_tax__selection_scope_KEYint (4)NOT NULLIndicates what portion of the tax items will be used to reduce a negative check.
shortfall_balance_payroll_check_treatment_KEYint (4)NOT NULLIndicates what action to take to apply current check to a prior shortfall.
default__checkbook_KEYint (4)Foreign key for the optional default checkbook to be used.
secondary__employee_sort_by_type_KEYint (4)Foreign key for the optional secondary employee sort to be used.
primary_sort_ascendingbit (1)NOT NULLTrue if we are sorting the primary sort order ascending, false if sorting descending.
secondary_sort_ascendingbit (1)NOT NULLTrue if we are sorting the secondary sort order ascending, false if sorting descending.
suppress_gl_account_verificationbit (1)NOT NULLTrue if we are suppressing the gl account verification message.
convert_hours_to_decimalbit (1)NOT NULLTrue if we are converting hours entered to decimal.
suppress_benefit_accrual_verificationbit (1)NOT NULLTrue if we don't want to verify number of hours exceeding hours available.
use_alternate_direct_deposit_allocationsbit (1)NOT NULLTrue if we are using the alternate direct deposit allocations settings.
hide_overtime_hoursbit (1)NOT NULLTrue if we want to hide the overtime hours column in the rapid tab of batch check entry.
hide_double_time_hoursbit (1)NOT NULLTrue if we want to hide the double time hours column in the rapid tab of batch check entry.
display_all_pay_itemsbit (1)NOT NULLTrue if we are displaying all pay items in the grid.
display_taxes_with_zero_amountsbit (1)NOT NULLFlag indicating that the display of zero amount taxes is desired in the enter transactions screen.
pay_exclusion__selection_scope_KEYint (4)NOT NULLSpecifies the selection scope value for pay item exclusion.
deduction_exclusion__selection_scope_KEYint (4)NOT NULLSpecifies the selection scope value for deduction item exclusion.
employer_contribution_exclusion__selection_scope_KEYint (4)NOT NULLSpecifies the selection scope value for employer contribution item exclusion.
detail_hide_over_time_hoursbit (1)NOT NULLTrue if we want to hide the over time hours column in the detail tab of batch check entry.
detail_hide_double_time_hoursbit (1)NOT NULLTrue if we want to hide the double time hours column in the detail tab of batch check entry.
detail_hide_benefit_one_hoursbit (1)NOT NULLTrue if we want to hide the benefit one hours column in the detail tab of batch check entry.
detail_hide_benefit_two_hoursbit (1)NOT NULLTrue if we want to hide the benefit two hours column in the detail tab of batch check entry.
payroll_check_entry_option_versiontimestamp (8)NOT NULLThe version of this row. It's an aid in versioning the row.
prompt_for_prior_batch_if_not_processedbit (1)NOT NULLIndicates whether or not to show dialog allowing selection of a prior unprocessed["BR"]batch.
Primary key
NameColumnsDescription
PK_Payroll_Check_Entry_Option$client_pay_schedule_KEYclient_pay_schedule_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Entry_Option__Checkbook__default__checkbook_KEYdefault__checkbook_KEYCheckbook (checkbook_KEY)
FK_Payroll_Check_Entry_Option__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule (client_pay_schedule_KEY)
FK_Payroll_Check_Entry_Option__Employee_Sort_By_Type__employee_sort_by_type_KEYemployee_sort_by_type_KEYEmployee_Sort_By_Type (employee_sort_by_type_KEY)
FK_Payroll_Check_Entry_Option__Employee_Sort_By_Type__secondary__employee_sort_by_type_KEYsecondary__employee_sort_by_type_KEYEmployee_Sort_By_Type (employee_sort_by_type_KEY)
FK_Payroll_Check_Entry_Option__Minimum_Wage_Payroll_Check_Treatment__minimum_wage_payroll_check_treatment_KEYminimum_wage_payroll_check_treatment_KEYMinimum_Wage_Payroll_Check_Treatment (minimum_wage_payroll_check_treatment_KEY)
FK_Payroll_Check_Entry_Option__Negative_Payroll_Check_Treatment__negative_payroll_check_treatment_KEYnegative_payroll_check_treatment_KEYNegative_Payroll_Check_Treatment (negative_payroll_check_treatment_KEY)
FK_Payroll_Check_Entry_Option__Selection_Scope__deduction_exclusion__selection_scope_KEYdeduction_exclusion__selection_scope_KEYSelection_Scope (selection_scope_KEY)
FK_Payroll_Check_Entry_Option__Selection_Scope__employer_contribution_exclusion__selection_scope_KEYemployer_contribution_exclusion__selection_scope_KEYSelection_Scope (selection_scope_KEY)
FK_Payroll_Check_Entry_Option__Selection_Scope__pay_exclusion__selection_scope_KEYpay_exclusion__selection_scope_KEYSelection_Scope (selection_scope_KEY)
FK_Payroll_Check_Entry_Option__Selection_Scope__shortfall_deduction__selection_scope_KEYshortfall_deduction__selection_scope_KEYSelection_Scope (selection_scope_KEY)
FK_Payroll_Check_Entry_Option__Selection_Scope__shortfall_tax__selection_scope_KEYshortfall_tax__selection_scope_KEYSelection_Scope (selection_scope_KEY)
FK_Payroll_Check_Entry_Option__Shortfall_Balance_Payroll_Check_Treatment__shortfall_balance_payroll_check_treatment_KEYshortfall_balance_payroll_check_treatment_KEYShortfall_Balance_Payroll_Check_Treatment (shortfall_balance_payroll_check_treatment_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Entry_Option_Payroll_Item_Exclusion__Payroll_Check_Entry_Option__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Entry_Option_Payroll_Item_Exclusion
FK_Payroll_Check_Entry_Option_Payroll_Item_Definition__Payroll_Check_Entry_Option__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Entry_Option_Payroll_Item_Definition
FK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment__Payroll_Check_Entry_Option__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Entry_Option_Shortfall_Tax_Treatment
FK_Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment__Payroll_Check_Entry_Option__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Entry_Option_Shortfall_Deduction_Treatment

Schema diagram