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 |