{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Column Definitions","Additional Pay Mass 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":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[[18,0,18,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[4,0,4,9],[9,0,9,9],[10,0,10,9],[11,0,11,9],[12,0,12,9],[15,0,15,9],[16,0,16,9],[17,0,17,9],[5,0,6,9],[7,0,7,9],[19,0,19,9],[32,0,32,9],[20,0,20,9],[21,0,21,9],[22,0,22,9],[23,0,23,9],[24,0,24,9],[26,0,26,9],[25,0,25,9],[27,0,27,9],[28,0,28,9],[29,0,29,9],[30,0,30,9],[31,0,31,9]]}
["Print the Instructions and Column Definitions tabs for easy reference."]
["PY361 - Additional Pay Mass Upload"]
["Instructions"]
[]
["Please read before you begin:"]
["Review the Performing a Mass Upload Job Aid located in the Cardinal website (www.cardinalproject.virginia.gov/massuploads) prior to completing the mass upload process. "]
[]
["Note: Click on Enable Content in this workbook before proceeding. "]
[]
["This workbook contains the following tabs:"]
["1. Instructions"]
["2. Column Definitions"]
["3. Position Mass Upload Template"]
[]
[]
["Instructions:"]
["1. The agency should run the V_ADDLPAY_MASS query to extract the employees that require additional pay updates."]
["2. The agency updates the additional pay for existing employee in the query spreadsheet.  The agency can also use this document to create new additional pay types for employees."]
["3. Once the query spreadsheet is complete, copy the data and paste it into the template on the \"Addition Pay Mass 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 into the applicable excel template. "]
["4. Click 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."]
["Steps 5 - 15 are performed by the agency to load the file into Cardinal:"]
["5. The HR Administrator will upload this file online by navigating to: Cardinal Interfaces > Mass Uploads > Additional Pay Mass Upload"]
["6. Click the Add a New Value tab for the first run of this mass upload."]
["7. Enter the Run Control ID and click the Add button. \nNote: For future runs of this mass upload by the same user at the same agency, select the Find Existing Value tab and enter the Run Control ID and click the Search button."]
["8. Use the Browse button to find and attach the file that was created in Step 4.  Once the file is uploaded, click the Run button."]
["9. Click the OK button at the bottom of the page."]
["10. Record the Process Instance Number.  This will be helpful in cases where there are issues with the upload."]
["11. Click the Process Monitor link."]
["12. Click the Refresh button periodically until the process completes with a Run Status of \"Success\" and a Distribution Status of \"Posted\"."]
["13. Click the Details link in the row where the recorded process instance number is listed."]
["14. Click the View Log/Trace link to download the error log. "]
["15. The agency will review the error log and manually key any data rows that did not load successfully."]
["Note: Agencies can also resubmit the mass upload with only the rows that errored if there are many. "]

{"sheet":"Column Definitions","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[11,0,11,2],[12,0,12,2],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[11,5,11,6],[9,5,9,6],[10,5,10,6],[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],[14,0,14,2],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[5,0,5,2],[6,0,6,2],[11,3,11,4],[12,3,12,4],[10,3,10,4],[13,0,13,2],[10,7,10,9],[11,7,11,9],[12,7,12,9],[14,7,14,9],[14,3,14,4],[12,5,12,6],[14,5,14,6],[13,3,13,4],[13,5,13,6],[13,7,13,9],[5,7,5,9],[6,7,6,9],[7,7,7,9],[8,7,8,9],[9,7,9,9]]}
["Print the Instructions and Column Definitions tabs for easy reference."]
["PY361 - Additional Pay 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"]
["Employee Record",null,null,null,null,"Y",null,"1 digit (Maximum of 3 digits)"]
["Earning Code",null,null,"CPY005  - Earnings Table",null,"Y",null,"3 letters"]
["Effective Date",null,null,null,null,"Y",null,"Format: MM/DD/YYYY"]
["Earnings Amount",null,null,null,null,"Y",null,"Format: 2222.33"]
["Goal Amount",null,null,null,null,"N",null,"Format: 2222.33"]
["Earnings End Date",null,null,null,null,"N",null,"Format: MM/DD/YYYY"]
["Separate Check Number",null,null,null,null,"N",null,"2 numbers"]
["Ok To Pay",null,null,null,null,"N",null,"Y or N"]
["Additional Sequence Number",null,null,null,null,"Y",null,"1 digit (Maximum of 2 digits)"]

{"sheet":"Additional Pay Mass Upload","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Employee ID","Employee Rcd","Earning Code","Effective Date","Earnings Amount","Goal Amount","Earnings End Date","Separate Check Number","Ok To Pay","Additional Sequence Number"]
["00900017000",0,"PRW","2021-09-24",400,0,null,0,"Y",1]