Table: dbo.Netclient_Time_Entry_Option | |||
This tables purpose is to store client-level options used by the NetClient portal. | |||
Columns | |||
Name | Type | Constraints | Description |
disable_bank_setup | bit (1) | NOT NULL | True if the NetClient bank setup UI is disabled. |
disable_employee_main_tab | bit (1) | NOT NULL | True if the NetClient employee main tab is disabled. |
disable_employee_personal_tab | bit (1) | NOT NULL | True if the NetClient employee personal tab is disabled. |
disable_employee_payroll_taxes_tab | bit (1) | NOT NULL | True if the NetClient employee payroll taxes tab is disabled. |
disable_employee_direct_deposit_tab | bit (1) | NOT NULL | True if the NetClient employee direct deposit tab is disabled. |
mask_pay_rates_and_amounts | bit (1) | NOT NULL | True if the time sheet pay rates and amounts should be masked on NetClient. |
mask_deduction_rates | bit (1) | NOT NULL | True if the time sheet deduction rates should be masked on NetClient. |
hide_overtime_hours | bit (1) | NOT NULL | True if the time sheet overtime column should be hidden on NetClient. |
hide_double_time_hours | bit (1) | NOT NULL | True if the time sheet double time column should be hidden on NetClient. |
notify_client_on_timesheet_available | bit (1) | NOT NULL | True if the client should receive an email notice when a new time sheet is available on NetClient. |
notify_email_address_on_timesheet_available | bit (1) | NOT NULL | True if a designated email address should receive an email notice when a new time sheet is available on NetClient. |
timesheet_available_email_address | nvarchar (640) | NOT NULL | Email address that should receive an email notice when a new time sheet is available on NetClient. |
notify_primary_processor_on_timesheet_complete | bit (1) | NOT NULL | True if the primary processor should receive an email notice when a time sheet is completed on NetClient. |
notify_backup_processor_on_timesheet_complete | bit (1) | NOT NULL | True if the backup processor should receive an email notice when a time sheet is completed on NetClient. |
notify_reviewer_on_timesheet_complete | bit (1) | NOT NULL | True if the reviewer should receive an email notice when a time sheet is completed on NetClient. |
notify_email_address_on_timesheet_complete | bit (1) | NOT NULL | True if a designated email address should receive an email notice when a time sheet is completed on NetClient. |
timesheet_complete_email_address | nvarchar (640) | NOT NULL | Email address that should receive an email notice when a time sheet is completed on NetClient. |
client_pay_schedule_KEY | int (4) | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Netclient_Time_Entry_Option$client_pay_schedule_KEY | client_pay_schedule_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Netclient_Time_Entry_Option__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Pay_Schedule (client_pay_schedule_KEY) |