{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Column Defintions","Department-Position Funding"],"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":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":false,"merged":[[9,0,9,9],[0,0,0,9],[1,0,1,9],[3,0,3,9],[8,0,8,9],[4,0,5,9],[6,0,6,9],[20,0,20,9],[23,0,23,9],[24,0,24,9],[25,0,25,9],[26,0,26,9],[22,0,22,9],[21,0,21,9],[10,0,10,9],[11,0,11,9],[14,0,14,9],[15,0,15,9],[19,0,19,9],[18,0,18,9],[17,0,17,9],[16,0,16,9],[28,0,28,9],[27,0,27,9],[35,0,35,9],[29,0,29,9],[30,0,30,9],[31,0,31,9],[32,0,32,9],[33,0,33,9],[34,0,34,9]]}
["HR373 - Department Position Funding Mass Upload"]
["Instructions"]
["Rev:  07/25/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. Department-Position Funding Template"]
[]
[]
["Instructions:"]
["The Agency Must:"]
["1. Review Column Definitions tab closely as some requirements have changed. "]
["2. Run the V_HR_POS_FUNDING_MASS_LOAD query to obtain a list of existing department/position funding information that requires updating."]
["Note: The mass upload has recently been enhanced with a new column \"Percent of Distribution\" (column H) to support spilt funding for departments and positions.  "]
["3. Update the Data in the Query Results spreadsheet:  Remove the department or position funding rows that are not being updated.  All rows for the changing department or position funding MUST be included in the file and the distribution sum MUST total 100%.  For rows where you are making updates, only update the values in the cells you are changing.  Leave everything else alone.  If the change in distribution break down requires, insert or remove row(s) as needed.  "]
["4. Once the query spreadsheet is complete with the desired position data updates, copy the data and paste it into the template on the \"Department-Position Funding\" tab in this workbook. "]
["5.  Ensure that the formatting is not incorrectly updated when populating the query spreadsheet and copying to the mass upload template. Agencies must use the template and validate that the processing rules are correct. "]
["6. 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."]
["Steps 7 - 17 are preformed by the agency to load the file into Cardinal:"]
["7. The PY Budget Processor will upload this file online by navigating to:  Cardinal Interfaces > Mass Uploads > Dept-Pos Funding Mass Upload"]
["8. Click the Add a New Value tab for the first run of this mass upload."]
["9. Enter the Run Control ID and click Add. \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 Search."]
["10. Use the Browse button to find and attach the file for Department-Position Funding that was created in Step 6. Once the file is uploaded, click Run."]
["11. Click the OK button at the bottom of the page."]
["12. Record the Process Instance Number. This will be helpful in case there are issues with the upload."]
["13. Click on the Process Monitor hyperlink."]
["14. Click the Refresh button periodically until the process completes with a Run Status of Success and Distribution Status of Posted."]
["15. Select Details link in the row where the recorded process instance is listed."]
["16. Click View Log/Trace to download the error log. "]
["17. 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 after making corrections, with only the rows that errored if there are many. "]

{"sheet":"Column Defintions","index":1,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,5,11,7],[0,0,0,9],[1,0,1,9],[2,0,3,2],[2,3,3,4],[2,5,3,7],[4,0,4,2],[5,0,5,2],[4,3,4,4],[5,3,5,4],[4,5,4,7],[5,5,5,7],[6,0,6,2],[10,3,10,4],[28,0,28,2],[29,0,29,2],[23,0,23,2],[24,0,24,2],[12,0,12,2],[25,0,25,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[26,0,26,2],[27,0,27,2],[12,3,12,4],[11,3,11,4],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[21,3,21,4],[22,3,22,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[17,0,17,2],[18,0,18,2],[6,5,6,7],[7,5,7,7],[8,5,8,7],[9,5,9,7],[10,5,10,7],[12,5,12,7],[13,5,13,7],[14,5,14,7],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[15,5,15,7],[16,5,16,7],[28,5,28,7],[29,5,29,7],[22,5,22,7],[23,5,23,7],[24,5,24,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[28,3,28,4],[29,3,29,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[17,5,17,7],[18,5,18,7],[20,5,20,7],[19,5,19,7],[21,5,21,7]]}
["HR373 - Department Position Funding Mass Upload"]
["Column Definitions"]
["Cardinal Field Name",null,null,"Required",null,"Online Processing Rules/Format"]
[]
["SetID",null,null,"Y",null,"Agency Number + 2 zeros. (e.g., 15100, 11100, 99900, etc.)"]
["Department (Position)",null,null,"Y",null,"Maximum of 10 digits (For position level funding, this is the department on the position)"]
["Fiscal Year",null,null,"Y",null," 4 digits"]
["Budget Level",null,null,"Y",null,"D - Department\nP - Position"]
["Effective Date of the new/changed funding distribution",null,null,"Y",null,"Format: MM/DD/YYYY \n* Must be within Fiscal Year"]
["Status as of Effective Date",null,null,"Y",null,"A = Active\nI = Inactive"]
["Position Number",null,null,"N*",null,"* Required if Budget Level = Position"]
["Percent Of Distribution",null,null,"Y",null,"Number 3 digits and 3 decimals (e.g., 99.999)"]
["Fund",null,null,"Y",null," 5 digits"]
["Program",null,null,"Y",null," Maximum of 10 digits"]
["Department (Funding)",null,null,"Y",null," Maximum of 10 digits (This is the department where the payroll will be recorded)"]
["Cost Center",null,null,"N",null," Maximum of 10 digits"]
["Task",null,null,"N",null," Maximum of 6 digits"]
["FIPS",null,null,"N",null," Maximum of 5 digits"]
["Asset",null,null,"N",null," Maximum of 8 digits"]
["Agency Use 1",null,null,"N",null," Maximum of 10 digits"]
["Agency Use 2",null,null,"N",null," Maximum of 8 digits"]
["PC Business Unit",null,null,"N*",null," Maximum of 5 digits\n* Required for Project"]
["Project",null,null,"N",null," Maximum of 15 digits"]
["Activity",null,null,"N*",null," Maximum of 15 digits\n* Required for Project"]
["Source Type",null,null,null,null,"For Future Use "]
["Category",null,null,null,null,"For Future Use "]
["Subcategory",null,null,null,null,"For Future Use "]
["Affiliate",null,null,null,null,"For Future Use "]
["Fund Affiliate",null,null,null,null,"For Future Use "]
["Future Use 1",null,null,null,null,"For Future Use "]

{"sheet":"Department-Position Funding","index":2,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SetID","Department (Position)","Fiscal Year","Budget Level","Effective Date of the new/changed funding distribution","Status as of Effective Date","Position Number","Percent of Distribution","Fund","Program","Department (Funding)","Cost Center","Task","FIPS","Asset","Agency Use 1","Agency Use 2","PC Business Unit","Project","Activity","Source Type","Category","Subcategory","Affiliate","Fund Affiliate","Future Use 1"]