{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Column Definitions","General Deduction Upload"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":49,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,0,10,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[4,0,4,9],[9,0,9,9],[5,0,6,9],[7,0,7,9],[21,0,21,9],[22,0,22,9],[11,0,11,9],[12,0,12,9],[15,0,15,9],[16,0,16,9],[17,0,17,9],[19,0,19,9],[18,0,18,9],[20,0,20,9]]}
["Print the Instructions and Column Definitions tabs for easy reference."]
["PY362 - General Deduction Mass Upload"]
["Instructions"]
["Rev:  10/27/2023"]
["Please read before you begin:"]
["Review the Performing a Mass Upload Job Aid located on the Cardinal website (www.cardinalproject.virginia.gov/massuploads) prior to completing the mass upload process. "]
[]
["Note: Click on the Enable Content button in this workbook before proceeding. "]
[]
["This workbook contains the following tabs:"]
["1. Instructions"]
["2. Column Definitions"]
["3. General Deduction Upload Template"]
[]
[]
["Instructions:"]
["1. The agency should run the V_GENL_DEDUCTION_MASS query to obtain a list of employees and their general deductions."]
["2. The agency updates the query spreadsheet with the applicable general deduction information.  Make sure to remove the sample row provided."]
["3. Once the query spreadsheet is complete, copy the data and paste it into the template on the \"General Deduction Upload\" tab in this workbook. Agencies must use the template and validate that the processing rules are correct. Refer to the Performing a Mass Upload job aid for additional information regarding copying the data from the query and into the applicable excel template. "]
["4. Click on the Create/Save CSV File button before saving to the appropriate folder. Once the folder is selected the file name cannot be changed, and it is automatically saved. This will overwrite the previous saved file if it is in the same location."]
["5. Load the saved CSV file to SPO Sharepoint in the General Deduction Mass Upload Requests\nfolder. Once the file has been loaded the appropriate SPO staff will be automatically alerted that a\nfile exists."]
["6. The file will be processed by SPO. "]
["7. SPO will take the necessary actions to correct all identified errors. In the event of errors, the entire file does not error out, only the lines containing an error(s).\nNote: SPO will either correct the errors on Excel and resubmit the upload file or enter the\ntransaction through an online data entry."]

{"sheet":"Column Definitions","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,4,2],[3,3,4,4],[3,5,4,6],[3,7,4,9],[5,0,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,9],[6,0,6,2],[6,3,6,4],[6,5,6,6],[6,7,6,9],[7,0,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,9],[8,0,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,9],[9,0,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,9],[10,0,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,9],[11,0,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,9],[12,0,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,9],[13,0,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,9],[14,0,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,9]]}
["Print the Instructions and Column Definitions tabs for easy reference."]
["PY362 - General Deduction Mass Upload"]
["Column Definitions"]
["Cardinal Field Name",null,null,"Configuration Work Unit #",null,"Required",null,"Online Processing Rules/Format"]
[]
["Employee ID",null,null,null,null,"Y",null,"11 digits"]
["Company",null,null,"CHR039",null,"Y",null,"3 characters"]
["Deduction Code",null,null,"CPY023\nCPY024\nCPY025",null,"Y",null,"6 characters"]
["Effective Date",null,null,null,null,"Y",null,"Format: MM/DD/YYYY"]
["Deduction Calculation",null,null,null,null,"Y",null,"A - Flat Amount \nD - Default to Deduction Table \nE - Percent of Special Earnings \nG - Percent of Total Gross\nH - Rate x Total Hours \nN - Percent of Net Pay \nP - Rate x Special Hours\nS - Special Deduction Calculation \nW - Rate x Hours Worked Default to D"]
["Deduction Amount",null,null,null,null,"N",null,"Format: 40.00 – whole numbers only"]
["Deduction Percent",null,null,null,null,"N",null,"Format: 40.00 – whole numbers only"]
["Deduction End Date",null,null,null,null,"N",null,"Format: MM/DD/YYYY"]
["Goal Amount",null,null,null,null,"N",null,"Format: 2222.33"]
["Goal Balance",null,null,null,null,"N",null,"Format: 2222.33"]

{"sheet":"General Deduction Upload","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Employee ID","Company","Deduction Code","Effective Date","Deduction Calculation","Deduction Amount","Deduction Percent","Deduction End Date","Goal Amount","Goal Balance"]
["0001222","DOT","AFSCME","2029-12-25","A","0.00","100.00","2029-12-25","100.50","50.50"]