| 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) | |