Table: dbo.Payroll_Check_Entry_Option
This table contains the data entry options to configure the batch check entry grid.
Columns
Name | Type | Constraints | Description
client_pay_schedule_KEY | int (4) | NOT NULL | Primary Key. Also a Foreign Key to the Client_Pay_Schedule table.
employee_sort_by_type_KEY | int (4) | NOT NULL | Indicates a sort order of the checks displayed.
hide_employee_id | bit (1) | NOT NULL | Flag representing whether to show the employee id in the display.
hide_employee_name | bit (1) | NOT NULL | Flag representing whether to show the employee name in the display.
hide_location | bit (1) | NOT NULL | Flag representing whether to show the location in the display.
hide_department | bit (1) | NOT NULL | Flag representing whether to show the department in the display.
hide_gross_pay | bit (1) | NOT NULL | Flag representing whether to show the gross pay in the display.
hide_net_pay | bit (1) | NOT NULL | Flag representing whether to show the net pay in the display.
minimum_wage_payroll_check_treatment_KEY | int (4) | NOT NULL | Indicates which action to take if a check does not meet minimum wage requirements.
negative_payroll_check_treatment_KEY | int (4) | NOT NULL | Indicates which action to take if a check has a negative net pay.
shortfall_deduction__selection_scope_KEY | int (4) | NOT NULL | Indicates what portion of the deduction items will be used to reduce a negative check.
shortfall_tax__selection_scope_KEY | int (4) | NOT NULL | Indicates what portion of the tax items will be used to reduce a negative check.
shortfall_balance_payroll_check_treatment_KEY | int (4) | NOT NULL | Indicates what action to take to apply current check to a prior shortfall.
default__checkbook_KEY | int (4) |  | Foreign key for the optional default checkbook to be used.
secondary__employee_sort_by_type_KEY | int (4) |  | Foreign key for the optional secondary employee sort to be used.
primary_sort_ascending | bit (1) | NOT NULL | True if we are sorting the primary sort order ascending, false if sorting descending.
secondary_sort_ascending | bit (1) | NOT NULL | True if we are sorting the secondary sort order ascending, false if sorting descending.
suppress_gl_account_verification | bit (1) | NOT NULL | True if we are suppressing the gl account verification message.
convert_hours_to_decimal | bit (1) | NOT NULL | True if we are converting hours entered to decimal.
suppress_benefit_accrual_verification | bit (1) | NOT NULL | True if we don't want to verify number of hours exceeding hours available.
use_alternate_direct_deposit_allocations | bit (1) | NOT NULL | True if we are using the alternate direct deposit allocations settings.
hide_overtime_hours | bit (1) | NOT NULL | True if we want to hide the overtime hours column in the rapid tab of batch check entry.
hide_double_time_hours | bit (1) | NOT NULL | True if we want to hide the double time hours column in the rapid tab of batch check entry.
display_all_pay_items | bit (1) | NOT NULL | True if we are displaying all pay items in the grid.
display_taxes_with_zero_amounts | bit (1) | NOT NULL | Flag indicating that the display of zero amount taxes is desired in the enter transactions screen.
pay_exclusion__selection_scope_KEY | int (4) | NOT NULL | Specifies the selection scope value for pay item exclusion.
deduction_exclusion__selection_scope_KEY | int (4) | NOT NULL | Specifies the selection scope value for deduction item exclusion.
employer_contribution_exclusion__selection_scope_KEY | int (4) | NOT NULL | Specifies the selection scope value for employer contribution item exclusion.
detail_hide_over_time_hours | bit (1) | NOT NULL | True if we want to hide the over time hours column in the detail tab of batch check entry.
detail_hide_double_time_hours | bit (1) | NOT NULL | True if we want to hide the double time hours column in the detail tab of batch check entry.
detail_hide_benefit_one_hours | bit (1) | NOT NULL | True if we want to hide the benefit one hours column in the detail tab of batch check entry.
detail_hide_benefit_two_hours | bit (1) | NOT NULL | True if we want to hide the benefit two hours column in the detail tab of batch check entry.
payroll_check_entry_option_version | timestamp (8) | NOT NULL | The version of this row. It's an aid in versioning the row.
prompt_for_prior_batch_if_not_processed | bit (1) | NOT NULL | Indicates whether or not to show dialog allowing selection of a prior unprocessed["BR"]batch.

Primary key
Name | Columns | Description
PK_Payroll_Check_Entry_Option$client_pay_schedule_KEY | client_pay_schedule_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Entry_Option__Checkbook__default__checkbook_KEY | default__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Payroll_Check_Entry_Option__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Pay_Schedule (client_pay_schedule_KEY) |
FK_Payroll_Check_Entry_Option__Employee_Sort_By_Type__employee_sort_by_type_KEY | employee_sort_by_type_KEY | Employee_Sort_By_Type (employee_sort_by_type_KEY) |
FK_Payroll_Check_Entry_Option__Employee_Sort_By_Type__secondary__employee_sort_by_type_KEY | secondary__employee_sort_by_type_KEY | Employee_Sort_By_Type (employee_sort_by_type_KEY) |
FK_Payroll_Check_Entry_Option__Minimum_Wage_Payroll_Check_Treatment__minimum_wage_payroll_check_treatment_KEY | minimum_wage_payroll_check_treatment_KEY | Minimum_Wage_Payroll_Check_Treatment (minimum_wage_payroll_check_treatment_KEY) |
FK_Payroll_Check_Entry_Option__Negative_Payroll_Check_Treatment__negative_payroll_check_treatment_KEY | negative_payroll_check_treatment_KEY | Negative_Payroll_Check_Treatment (negative_payroll_check_treatment_KEY) |
FK_Payroll_Check_Entry_Option__Selection_Scope__deduction_exclusion__selection_scope_KEY | deduction_exclusion__selection_scope_KEY | Selection_Scope (selection_scope_KEY) |
FK_Payroll_Check_Entry_Option__Selection_Scope__employer_contribution_exclusion__selection_scope_KEY | employer_contribution_exclusion__selection_scope_KEY | Selection_Scope (selection_scope_KEY) |
FK_Payroll_Check_Entry_Option__Selection_Scope__pay_exclusion__selection_scope_KEY | pay_exclusion__selection_scope_KEY | Selection_Scope (selection_scope_KEY) |
FK_Payroll_Check_Entry_Option__Selection_Scope__shortfall_deduction__selection_scope_KEY | shortfall_deduction__selection_scope_KEY | Selection_Scope (selection_scope_KEY) |
FK_Payroll_Check_Entry_Option__Selection_Scope__shortfall_tax__selection_scope_KEY | shortfall_tax__selection_scope_KEY | Selection_Scope (selection_scope_KEY) |
FK_Payroll_Check_Entry_Option__Shortfall_Balance_Payroll_Check_Treatment__shortfall_balance_payroll_check_treatment_KEY | shortfall_balance_payroll_check_treatment_KEY | Shortfall_Balance_Payroll_Check_Treatment (shortfall_balance_payroll_check_treatment_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payroll_Check_Entry_Option_Payroll_Item_Exclusion__Payroll_Check_Entry_Option__client_pay_schedule_KEY | client_pay_schedule_KEY | Payroll_Check_Entry_Option_Payroll_Item_Exclusion |
FK_Payroll_Check_Entry_Option_Payroll_Item_Definition__Payroll_Check_Entry_Option__client_pay_schedule_KEY | client_pay_schedule_KEY | Payroll_Check_Entry_Option_Payroll_Item_Definition |
FK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment__Payroll_Check_Entry_Option__client_pay_schedule_KEY | client_pay_schedule_KEY | Payroll_Check_Entry_Option_Shortfall_Tax_Treatment |
FK_Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment__Payroll_Check_Entry_Option__client_pay_schedule_KEY | client_pay_schedule_KEY | Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment |