Table: dbo.Conversion_Wizard_Client_Payroll_Information
The conversion wizard has different screens where users select various options that affect the conversion of data from CSA. This table holds options concerning certain data that is held in the Client_Payroll_Information table.
Columns
NameTypeConstraintsDescription
firm_KEYint (4)NOT NULL
check_output_type_KEYint (4)NOT NULLReference to check output type
send_payroll_checks_to_netclientbit (1)NOT NULLFlag to indicate payroll checks should be sent to netclient
send_payroll_checks_to_file_cabinetbit (1)NOT NULLFlag to indicate payroll checks should be sent to file cabinet
send_vendor_checks_to_netclientbit (1)NOT NULLFlag to indicate vendor checks should be sent to netclient
send_vendor_checks_to_file_cabinetbit (1)NOT NULLFlag to indicate vendor checks should be sent to file cabinet
primary_processor__staff_KEYint (4)Primary staff who will processes the converted client
backup_processor__staff_KEYint (4)Backup staff who might process the converted client
time_entry_method_KEYint (4)NOT NULLReference to time entry method
exclude_funded_checks_from_remote_printingbit (1)NOT NULLBoolean on whether to exclude funded checks from remote vendor check printing.
exclude_net_checks_from_remote_printingbit (1)NOT NULLBoolean on whether to exclude net checks from remote payroll check printing.
Primary key
NameColumnsDescription
PK_Conversion_Wizard_Client_Payroll_Information$firm_KEYfirm_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Conversion_Wizard_Client_Payroll_Information__Check_Output_Type__check_output_type_KEYcheck_output_type_KEYCheck_Output_Type (check_output_type_KEY)
FK_Conversion_Wizard_Client_Payroll_Information__Firm__firm_KEYfirm_KEYFirm (firm_KEY)
FK_Conversion_Wizard_Client_Payroll_Information__Staff__backup_processor__staff_KEYbackup_processor__staff_KEYStaff (staff_KEY)
FK_Conversion_Wizard_Client_Payroll_Information__Staff__primary_processor__staff_KEYprimary_processor__staff_KEYStaff (staff_KEY)
FK_Conversion_Wizard_Client_Payroll_Information__Time_Entry_Method__time_entry_method_KEYtime_entry_method_KEYTime_Entry_Method (time_entry_method_KEY)

Schema diagram