Table: dbo.Netclient_Time_Entry_Option
This tables purpose is to store client-level options used by the NetClient portal.
Columns
NameTypeConstraintsDescription
disable_bank_setupbit (1)NOT NULLTrue if the NetClient bank setup UI is disabled.
disable_employee_main_tabbit (1)NOT NULLTrue if the NetClient employee main tab is disabled.
disable_employee_personal_tabbit (1)NOT NULLTrue if the NetClient employee personal tab is disabled.
disable_employee_payroll_taxes_tabbit (1)NOT NULLTrue if the NetClient employee payroll taxes tab is disabled.
disable_employee_direct_deposit_tabbit (1)NOT NULLTrue if the NetClient employee direct deposit tab is disabled.
mask_pay_rates_and_amountsbit (1)NOT NULLTrue if the time sheet pay rates and amounts should be masked on NetClient.
mask_deduction_ratesbit (1)NOT NULLTrue if the time sheet deduction rates should be masked on NetClient.
hide_overtime_hoursbit (1)NOT NULLTrue if the time sheet overtime column should be hidden on NetClient.
hide_double_time_hoursbit (1)NOT NULLTrue if the time sheet double time column should be hidden on NetClient.
notify_client_on_timesheet_availablebit (1)NOT NULLTrue if the client should receive an email notice when a new time sheet is available on NetClient.
notify_email_address_on_timesheet_availablebit (1)NOT NULLTrue if a designated email address should receive an email notice when a new time sheet is available on NetClient.
timesheet_available_email_addressnvarchar (640)NOT NULLEmail address that should receive an email notice when a new time sheet is available on NetClient.
notify_primary_processor_on_timesheet_completebit (1)NOT NULLTrue if the primary processor should receive an email notice when a time sheet is completed on NetClient.
notify_backup_processor_on_timesheet_completebit (1)NOT NULLTrue if the backup processor should receive an email notice when a time sheet is completed on NetClient.
notify_reviewer_on_timesheet_completebit (1)NOT NULLTrue if the reviewer should receive an email notice when a time sheet is completed on NetClient.
notify_email_address_on_timesheet_completebit (1)NOT NULLTrue if a designated email address should receive an email notice when a time sheet is completed on NetClient.
timesheet_complete_email_addressnvarchar (640)NOT NULLEmail address that should receive an email notice when a time sheet is completed on NetClient.
client_pay_schedule_KEYint (4)NOT NULL
Primary key
NameColumnsDescription
PK_Netclient_Time_Entry_Option$client_pay_schedule_KEYclient_pay_schedule_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Netclient_Time_Entry_Option__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule (client_pay_schedule_KEY)

Schema diagram