Table: dbo.ATF_Payroll_Check_Entry_Option
This table contains the data entry options to configure the After The Fact handwritten batch check entry grid.
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | Primary/foreign key. There is a 1-0..1 relationship between Client and this table.
default__checkbook_KEY | int (4) |  | Foreign key for the optional default Checkbook to be used. A null value means there wasn't one specified.
employee_sort_by_type_KEY | int (4) | NOT NULL | Indicates a sort order of the checks displayed.
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.
suppress_benefit_accrual_verification | bit (1) | NOT NULL | True if we don't want to verify number of hours exceeding hours available.
convert_hours_to_decimal | bit (1) | NOT NULL | True if we are converting hours entered to decimal.
suppress_generate_liabilities_prompt | bit (1) | NOT NULL | True if we are not going to show the generate liabilities prompt.
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.
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_dnp | bit (1) | NOT NULL | Flag representing whether to show the Do Not Pay column in the display.
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.
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.
display_all_pay_and_employee_tax_items | bit (1) | NOT NULL | True if we are displaying all pay and employee tax items in the grid.
row_version | timestamp (8) | NOT NULL | The version of this row. It's an aid in versioning the row.

Primary key
Name | Columns | Description
PK_ATF_Payroll_Check_Entry_Option$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_ATF_Payroll_Check_Entry_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_ATF_Payroll_Check_Entry_Option__Checkbook__default__checkbook_KEY | default__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_ATF_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_ATF_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) |