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
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary/foreign key. There is a 1-0..1 relationship between Client and this table.
default__checkbook_KEYint (4)Foreign key for the optional default Checkbook to be used. A null value means there wasn't one specified.
employee_sort_by_type_KEYint (4)NOT NULLIndicates a sort order of the checks displayed.
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.
suppress_benefit_accrual_verificationbit (1)NOT NULLTrue if we don't want to verify number of hours exceeding hours available.
convert_hours_to_decimalbit (1)NOT NULLTrue if we are converting hours entered to decimal.
suppress_generate_liabilities_promptbit (1)NOT NULLTrue if we are not going to show the generate liabilities prompt.
display_taxes_with_zero_amountsbit (1)NOT NULLFlag indicating that the display of zero amount taxes is desired in the enter transactions screen.
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_dnpbit (1)NOT NULLFlag representing whether to show the Do Not Pay column in the display.
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.
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.
display_all_pay_and_employee_tax_itemsbit (1)NOT NULLTrue if we are displaying all pay and employee tax items in the grid.
row_versiontimestamp (8)NOT NULLThe version of this row. It's an aid in versioning the row.
Primary key
NameColumnsDescription
PK_ATF_Payroll_Check_Entry_Option$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_ATF_Payroll_Check_Entry_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_ATF_Payroll_Check_Entry_Option__Checkbook__default__checkbook_KEYdefault__checkbook_KEYCheckbook (checkbook_KEY)
FK_ATF_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_ATF_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)

Schema diagram