{"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:  3/25/2024"]
["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. \nNote: DO NOT change the format on the template when you copy and paste.  When copying the data from the query and into the applicable excel template, ensure that:  \n        a.  The columns from the query and the template match and are aligned;  \n        b.  After copying the data, when pasting into the template, right click cell 2A and hover over \n             the options under Paste Options until you find one of the following:  Keep Text Only, \n             Match Destination Formatting, or Values (any one of these options will function  \n             properly) and select it;  \n        c.  Ensure that only the rows that are being changed are copied over into the applicable \n             excel template from the query.  Providing data that contains no changes will result in the \n             data failing to load into Cardinal.  This will impact the error report.   "]
["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 file 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 coordinate with the agency to correct the errors on Excel and resubmit the upload file or the agency can enter the rejected transactions through an online data entry."]

{"sheet":"Column Definitions","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,4,0],[3,1,4,1],[3,2,4,2]]}
["Print the Instructions and Column Definitions tabs for easy reference."]
["PY362 - General Deduction Mass Upload"]
["Column Definitions"]
["Cardinal Field Name","Required","Online Processing Rules/Format"]
[]
["Employee ID","Y","Must be 11 digits \n\nNote:\nNo apostrophe (') before the digits\nColumn format must be text"]
["Company","Y","3 characters"]
["Deduction Code","Y","6 characters"]
["Effective Date","Y","Format: MM/DD/YYYY \nNote: Column format must be date"]
["Calculation Routine","Y","A - Flat Amount \nD - Default to Deduction Table \nN - Percent of Net Pay\nB - Percentage\n"]
["Flat/Addl Amount","Y","Format: 40.00 – requires 2 decimal places\nIf the “Flat Amount” calculation routine was selected, enter the flat amount here.\n\nIf the \"Percentage\" or \"Percent of Net Pay\" calculation routine was selected, enter 0.00 here."]
["Deduction Rate or %","Y","Format: 40.00 (40%) – requires 2 decimal places\nIf the \"Percentage\" or \"Percentage of Net Pay\" calculation routine was selected, enter the percentage here.\n\nIf \"Flat Amount\" calculation routine was selected, enter the percentage 0.00 here."]
["Deduction End Date","N","Format: MM/DD/YYYY\nNote: Column format must be date"]
["Goal Amount","Y","Format: 2222.33 - requires 2 decimal places\nIf there is no Goal Amount enter 0.00"]
["Current Goal Balance","Y","Format: 2222.33 - requires 2 decimal places\nIf there is no Current Goal Balance enter 0.00"]

{"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","Calculation Routine","Flat/Addl Amount","Deduction Rate or %","Deduction End Date","Goal Amount","Current Goal Balance"]
["00012220000","DOT","AFSCME","2029-12-25","A","0.00","100.00","2029-12-25","100.50","50.50"]