Table: dbo.Conversion_Wizard_Segment_Choice
The conversion wizard has different screens where users select various options that affect the conversion of data from CSA. This table holds the options pertaining to what segments of the CSA date should be converted, such as employees, payroll items or conversions.
Columns
NameTypeConstraintsDescription
firm_KEYint (4)NOT NULL
convert_impound_checkbooksbit (1)NOT NULLShould impound checkbooks be converted?
convert_payroll_schedulesbit (1)NOT NULLShould payroll schedules be converted?
convert_bank_accountsbit (1)NOT NULLShould bank accounts be converted?
use_bank_name_for_bank_account_namebit (1)NOT NULLIf bank accounts are being converted should we use the bank name as the new name instead of the original bank account name?
convert_vendorsbit (1)NOT NULLShould vendors be converted?
convert_employeesbit (1)NOT NULLShould employees be converted?
convert_payroll_departmentsbit (1)NOT NULLShould payroll departments be converted?
convert_payroll_itemsbit (1)NOT NULLShould payroll items be converted?
convert_earningsbit (1)NOT NULLShould earnings be converted?
convert_processing_notesbit (1)NOT NULLShould processing notes be converted?
convert_workers_compensationbit (1)NOT NULLShould worker compensation codes be converted?
Primary key
NameColumnsDescription
PK_Conversion_Wizard_Segment_Choice$firm_KEYfirm_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Conversion_Wizard_Segment_Choice__Firm__firm_KEYfirm_KEYFirm (firm_KEY)

Schema diagram