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 | |||
Name | Type | Constraints | Description |
firm_KEY | int (4) | NOT NULL | |
convert_impound_checkbooks | bit (1) | NOT NULL | Should impound checkbooks be converted? |
convert_payroll_schedules | bit (1) | NOT NULL | Should payroll schedules be converted? |
convert_bank_accounts | bit (1) | NOT NULL | Should bank accounts be converted? |
use_bank_name_for_bank_account_name | bit (1) | NOT NULL | If bank accounts are being converted should we use the bank name as the new name instead of the original bank account name? |
convert_vendors | bit (1) | NOT NULL | Should vendors be converted? |
convert_employees | bit (1) | NOT NULL | Should employees be converted? |
convert_payroll_departments | bit (1) | NOT NULL | Should payroll departments be converted? |
convert_payroll_items | bit (1) | NOT NULL | Should payroll items be converted? |
convert_earnings | bit (1) | NOT NULL | Should earnings be converted? |
convert_processing_notes | bit (1) | NOT NULL | Should processing notes be converted? |
convert_workers_compensation | bit (1) | NOT NULL | Should worker compensation codes be converted? |
Primary key | |||
Name | Columns | Description | |
PK_Conversion_Wizard_Segment_Choice$firm_KEY | firm_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Conversion_Wizard_Segment_Choice__Firm__firm_KEY | firm_KEY | Firm (firm_KEY) |