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
Name | Type | Constraints | Description
firm_KEY | int (4) | NOT NULL |
check_output_type_KEY | int (4) | NOT NULL | Reference to check output type
send_payroll_checks_to_netclient | bit (1) | NOT NULL | Flag to indicate payroll checks should be sent to netclient
send_payroll_checks_to_file_cabinet | bit (1) | NOT NULL | Flag to indicate payroll checks should be sent to file cabinet
send_vendor_checks_to_netclient | bit (1) | NOT NULL | Flag to indicate vendor checks should be sent to netclient
send_vendor_checks_to_file_cabinet | bit (1) | NOT NULL | Flag to indicate vendor checks should be sent to file cabinet
primary_processor__staff_KEY | int (4) |  | Primary staff who will processes the converted client
backup_processor__staff_KEY | int (4) |  | Backup staff who might process the converted client
time_entry_method_KEY | int (4) | NOT NULL | Reference to time entry method
exclude_funded_checks_from_remote_printing | bit (1) | NOT NULL | Boolean on whether to exclude funded checks from remote vendor check printing.
exclude_net_checks_from_remote_printing | bit (1) | NOT NULL | Boolean on whether to exclude net checks from remote payroll check printing.

Primary key
Name | Columns | Description
PK_Conversion_Wizard_Client_Payroll_Information$firm_KEY | firm_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Conversion_Wizard_Client_Payroll_Information__Check_Output_Type__check_output_type_KEY | check_output_type_KEY | Check_Output_Type (check_output_type_KEY) |
FK_Conversion_Wizard_Client_Payroll_Information__Firm__firm_KEY | firm_KEY | Firm (firm_KEY) |
FK_Conversion_Wizard_Client_Payroll_Information__Staff__backup_processor__staff_KEY | backup_processor__staff_KEY | Staff (staff_KEY) |
FK_Conversion_Wizard_Client_Payroll_Information__Staff__primary_processor__staff_KEY | primary_processor__staff_KEY | Staff (staff_KEY) |
FK_Conversion_Wizard_Client_Payroll_Information__Time_Entry_Method__time_entry_method_KEY | time_entry_method_KEY | Time_Entry_Method (time_entry_method_KEY) |