Columns Removed
A list of all columns removed from Spectrum database tables since v13.19.
| Table | Column(s) Removed |
|---|---|
| CP_TEMP_UTILIZATION_REP_MC | Social_Security |
| CR_DRAW_REQUEST_DETAIL_MC | CO_Amount |
| CR_DRAW_UNIT_PRICE_BILL_MC | CO_Quantity |
| CO_Amount | |
| DI_MASTER_MC | Description |
| Create_Date | |
| Create_Operator | |
| Change_Date | |
| Change_Operator | |
| Path | |
| Filename | |
| Create_Time | |
| Change_Time | |
| File_Modify_Stamp | |
| EC_FIELD_EVENT_MC | Device_ID |
| Employee_Code | |
| Manual_Meter | |
| Manual_Fuel | |
| Tracker_Present | |
| EC_RECUR_TRAN_HEADER_MC | Source_Code |
| EC_TEMP_FUEL_TRUCK_MC | Device_ID |
| HR_EMPLOYEE_FORMS_MC | Employee_Form_Code |
| Employee_Form_Operator | |
| Employee_Form_Completed_By | |
| HR_TEMP_VET100_HDR_MC | Hiring_Name |
| Hiring_Address | |
| Hiring_City | |
| Hiring_County | |
| Hiring_State | |
| Hiring_Zip | |
| IM_REQ_PHASE_XREF_MC | Company_Code |
| Job_Number | |
| Phase_Code | |
| Cost_Type | |
| Req_Company_Code | |
| Transfer_Type | |
| Transaction_Reference | |
| Requisition_Sequence | |
| Transaction_Sequence | |
| JC_JOB_MASTER_MC | Revised_Contract |
| Change_Orders | |
| Date_Last_Projected | |
| Approved_Change_Orders | |
| Proposed_Change_Orders | |
| JC_OVERHEAD_DETAIL_MC | Include_Cost_Types |
| JC_PHASE_MASTER_MC | Est_Quantity |
| Est_Hours | |
| Est_Cost | |
| Projected_Cost | |
| Last_Est_Date | |
| Projected_Qty | |
| Projected_Hours | |
| Last_Projected_Date | |
| JC_TEMP_GROUP_MC | Last_Est_Date |
| PA_NOTES_MC | Notes_Sequence |
| Notes_Text_Length | |
| PJ_BUILDING_AREA_MC | Customer |
| PJ_PROJECT_BUILDING_MC | Customer |
| PJ_TEMP_PROJECT_AREA_MC | Customer |
| Project_Name | |
| Customer_Name | |
| PJ_TEMP_PROJECT_BUILDING_MC | Customer |
| Project_Name | |
| Customer_Name | |
| PR_EMPLOYEE_MASTER_1_MC | Update_Flag |
| Last_Job_Number | |
| Last_Equipment_Code | |
| Calc_Flag | |
| Suppress_Last_Job_Flag | |
| Last_Crew | |
| PR_EMPLOYMENT_UTILIZATION_MC | Social_Security |
| PR_INCOME_TAX_TABLE_MC | Tax_GL_Payable |
| Tax_Base_Type | |
| Tax_Deduct_List1 | |
| Tax_Deduct_List2 | |
| Tax_Deduct_List3 | |
| Tax_Deduct_List4 | |
| Tax_Deduct_List5 | |
| Rate_Type | |
| Percent_List1 | |
| Percent_List2 | |
| Percent_List3 | |
| Percent_List4 | |
| Minimum_Amount_List1 | |
| Minimum_Amount_List2 | |
| Minimum_Amount_List3 | |
| Minimum_Amount_List4 | |
| Maximum_Amount_List1 | |
| Maximum_Amount_List2 | |
| Maximum_Amount_List3 | |
| Maximum_Amount_List4 | |
| STD_Deduct_Type | |
| STD_Deduct_Apply_Flag | |
| STD_Deduct_Annual_List1 | |
| STD_Deduct_Annual_List2 | |
| STD_Deduct_Annual_List3 | |
| STD_Deduct_Annual_List4 | |
| STD_Deduct_Percent_List1 | |
| STD_Deduct_Percent_List2 | |
| STD_Deduct_Percent_List3 | |
| STD_Deduct_Percent_List4 | |
| STD_Deduct_Min_List1 | |
| STD_Deduct_Min_List2 | |
| STD_Deduct_Min_List3 | |
| STD_Deduct_Min_List4 | |
| STD_Deduct_Max_List1 | |
| STD_Deduct_Max_List2 | |
| STD_Deduct_Max_List3 | |
| STD_Deduct_Max_List4 | |
| Standard_Deduct_Adjust | |
| STD_Deduct_Adjust_Flag | |
| Credit_Type | |
| Tax_Credit_Method | |
| Credit_Percent_List1 | |
| Credit_Percent_List2 | |
| Credit_Percent_List3 | |
| Credit_Percent_List4 | |
| Minimum_Credit_List1 | |
| Minimum_Credit_List2 | |
| Minimum_Credit_List3 | |
| Minimum_Credit_List4 | |
| Tax_Credit_List1 | |
| Tax_Credit_List2 | |
| Tax_Credit_List3 | |
| Tax_Credit_List4 | |
| Tax_Credit_Exempt_List1 | |
| Tax_Credit_Exempt_List2 | |
| Tax_Credit_Exempt_List3 | |
| Tax_Credit_Exempt_List4 | |
| Tax_Credit_Exempt_List5 | |
| Tax_Credit_Exempt_List6 | |
| Tax_Credit_Exempt_List7 | |
| Tax_Credit_Exempt_List8 | |
| Tax_Credit_Exempt_List9 | |
| Tax_Credit_Exempt_List10 | |
| Tax_Credit_Exempt_List11 | |
| Tax_Credit_Exempt_List12 | |
| Tax_Credit_Exempt_List13 | |
| Tax_Credit_Exempt_List14 | |
| Tax_Credit_Exempt_List15 | |
| Tax_Credit_Exempt_List16 | |
| Tax_Credit_Exempt_List17 | |
| Tax_Credit_Exempt_List18 | |
| Tax_Credit_Exempt_List19 | |
| Tax_Credit_Exempt_List20 | |
| Tax_Credit_Exempt_List21 | |
| Tax_Credit_Exempt_List22 | |
| Tax_Credit_Exempt_List23 | |
| Tax_Credit_Exempt_List24 | |
| Tax_Credit_Exempt_List25 | |
| Tax_Credit_Exempt_List26 | |
| Tax_Credit_Exempt_List27 | |
| Tax_Credit_Exempt_List28 | |
| Tax_Credit_Exempt_List29 | |
| Tax_Credit_Exempt_List30 | |
| Tax_Credit_Exempt_List31 | |
| Tax_Credit_Exempt_List32 | |
| Tax_Credit_Exempt_List33 | |
| Tax_Credit_Exempt_List34 | |
| Tax_Credit_Exempt_List35 | |
| Tax_Credit_Exempt_List36 | |
| Tax_Credit_Exempt_List37 | |
| Tax_Credit_Exempt_List38 | |
| Tax_Credit_Exempt_List39 | |
| Tax_Credit_Exempt_List40 | |
| Exemption_Flag | |
| Personal_Exempt_Flag | |
| Exempt_Amount_List1 | |
| Exempt_Amount_List2 | |
| Exempt_Amount_List3 | |
| Exempt_Amount_List4 | |
| Dependent_Exempt_Amount | |
| Unemployment_Payable_GL | |
| FICA_Payable_GL_List1 | |
| FICA_Payable_GL_List2 | |
| Max_Deduct_List1 | |
| Max_Deduct_List2 | |
| Max_Deduct_List3 | |
| Max_Deduct_List4 | |
| Max_Deduct_List5 | |
| Non_Resident_Flag | |
| SDI_Rate_List1 | |
| SDI_Rate_List2 | |
| Round_Withholding_Flag | |
| Wk_Limit_Type | |
| Wk_Limit | |
| PR_TEMP_AFFIDAVIT_MC | Sort_Variable |
| PR_TEMP_CHECK_PRINT_MC | Social_Security |
| Account_Number_List1 | |
| Account_Number_List2 | |
| Account_Number_List3 | |
| Account_Number_List4 | |
| Account_Number_List5 | |
| PR_TEMP_EMPLOYEE_MASTER_1_MC | Social_Security |
| Bank_Account_Number | |
| Driver_License | |
| Update_Flag | |
| Calc_Flag | |
| Bank_Account_Number_2 | |
| Bank_Account_Number_3 | |
| Bank_Account_Number_4 | |
| Bank_Account_Number_5 | |
| PR_W2_FORM_PRINT_MC | Not_Used_1 |
| Not_Used_2 | |
| Not_Used_3 | |
| Not_Used_4 | |
| Not_Used_5 | |
| Not_Used_6 | |
| Not_Used_7 | |
| VN_SUBCONTRACT_MC | Total_Change_Orders |
| Revised_Contract | |
| Balance | |
| Last_CO_Number | |
| VN_SUBCONTRACT_PHASE_MC | CO_Quantity |
| CO_Amount | |
| VN_TEMP_1099_MC | Federal_ID |
| VN_TEMP_LIEN_CRYSTAL_MC | Legal_Description_List1 |
| Legal_Description_List2 | |
| Legal_Description_List3 | |
| Legal_Description_List4 | |
| Legal_Description_List5 | |
| VN_TEMP_SUB_BILLING_DET_MC | Contract_Number |
| Bill_Description | |
| GL_Account | |
| VN_TEMP_SUB_BILLING_HDR_MC | Batch_Code |
| Status | |
| AP_GL_Account | |
| Cash_GL_Account | |
| Year | |
| Period | |
| Check_Number | |
| Check_Amount | |
| Check_Date | |
| Discount_Eligible | |
| Date_List2 | |
| Date_List3 | |
| Date_List4 | |
| Date_List5 | |
| PO_Number | |
| Remarks | |
| Post_Flag | |
| Time_Entered | |
| Print_Flag | |
| Retention_Percent | |
| Routing_Code | |
| Job_Cost_Center | |
| Cost_Center_Description | |
| VN_TEMP_SUB_BILLING_OTH_MC | Subcontract_Number |
| Distribution_GL_Account | |
| Credit_Amount | |
| GL_Post_Flag | |
| Job_Number | |
| Equipment_Code | |
| Equipment_Category | |
| Company_Code_2 | |
| This_Company_GL | |
| Other_Company_GL | |
| PM_Work_Order | |
| Cost_Center |
