Table Changes in Spectrum 2023 R3
A list of the database table changes made since the previous release.
For reference purposes only
This information is intended for use in creating customized reports.New Table
This version has one new Table.- VN_TEMP_INV_APP_ROUTING_MC
New Views
This version has one new Table View.- VN_TEMP_INV_APP_ROUTING
New Columns
New columns listed by table.| Table | Column(s) Added |
|---|---|
| PR_EMPL_STATE_TAX_HIST_MC |
CPP_Second_Contribution_List1 CPP_Second_Contribution_List2 |
| PR_EMPL_VOL_DEDUCT_MC | Shared Code |
| PR_EMPLOYEE_ENTITY_VOL_DED_MC | Shared Code |
| PR_INCOME_TAX_TABLE_MC |
CPP_Second_Contribution_Rate1 CPP_Second_Contribution_Rate2 CPP_Second_Contribution_Limit1 CPP_Second_Contribution_Limit2 |
| PR_LAYOFF_STATE_TAX_HOLD_MC |
CPP_Second_Contribution_List1 CPP_Second_Contribution_List2 |
| PR_T4_EMPLOYEE_MC |
Dental_Benefit_Code CPP_Amount2 Employer_CPP2 QPP_Amount2 |
| PR_T4_HISTORY_MC |
Dental_Benefit_Code CPP_Amount2 Employer_CPP2 QPP_Amount2 |
| PR_TEMP_EMPL_STATE_TAX_MC |
CPP_Second_Contribution_List1 CPP_Second_Contribution_List2 |
| PR_TEMP_EMPL_VOL_DEDUCT_MC | Other_Shared_Amount |
| PR_TEMP_LAYOFF_EMPL_DED | Other_Shared_Amount |
| PR_TEMP_LAYOFF_STATE_TAX_MC |
CPP_Second_Contribution_List1 CPP_Second_Contribution_List2 |
| PR_VOL_DEDUCT_MASTER_MC | Shared_Code |
| VN_CURRENT_ROUT_PROCESS_MC | Approval_Limit |
| VN_ROUTING_HISTORY_MC | Approval_Limit |
| VN_ROUTING_MASTER_DETAIL_MC | Approval_Limit |
