{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","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":"Introduction","index":0,"n_rows":33,"n_cols":1,"rows_kept":33,"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],[25,0,25,9],[11,0,11,9],[12,0,12,9],[15,0,15,9],[16,0,16,9],[17,0,17,9],[18,0,18,9],[20,0,20,9],[21,0,21,9],[22,0,22,9],[23,0,23,9],[24,0,24,9],[19,0,19,9],[32,0,32,9],[26,0,26,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."]
["HR373 - Department Position Funding 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_HR_POS_FUNDING_MASS_LOAD query to obtain a list of existing position funding information that requires updating."]
["2. The agency updates the query spreadsheet with the applicable position funding values. \nNote: The mass upload will not support split funding.  Departments with split funding will need to be manually entered.  Positions with split funding will need to be manually entered or entered through the Position Upload interface."]
["3. Once the query spreadsheet is complete, copy the data and paste it into the template on the \"Department-Position Funding\" 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."]
["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 > Dept-Pos Funding 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 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."]
["8. Use the Browse button to find and attach the file for Department-Position Funding that was created in Step 4. Once the file is uploaded, click Run."]
["9. Click the OK button at the bottom of the page."]
["10. Record the Process Instance Number. This will be helpful in case there are issues with the upload."]
["11. Click on the Process Monitor hyperlink."]
["12. Click the Refresh button periodically until the process completes with a Run Status of Success and Distribution Status of Posted."]
["13. Select Details link in the row where the recorded process instance is listed."]
["14. Click View Log/Trace 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 Defintions","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"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,3,5,4],[6,3,6,4],[5,0,5,2],[6,0,6,2],[5,5,5,6],[6,5,6,6],[5,7,5,9],[6,7,6,9],[7,3,7,4],[8,3,8,4],[9,3,9,4],[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],[17,0,17,2],[18,0,18,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[11,3,11,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[10,3,10,4],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[23,0,23,2],[24,0,24,2],[28,3,28,4],[29,3,29,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[11,5,11,6],[12,5,12,6],[22,3,22,4],[23,3,23,4],[24,3,24,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[12,3,12,4],[7,7,7,9],[8,7,8,9],[9,7,9,9],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[10,7,10,9],[11,7,11,9],[12,7,12,9],[13,7,13,9],[14,7,14,9],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[15,7,15,9],[16,7,16,9],[17,7,17,9],[18,7,18,9],[20,7,20,9],[19,7,19,9],[21,7,21,9],[28,5,28,6],[29,5,29,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,7,28,9],[29,7,29,9],[22,7,22,9],[23,7,23,9],[24,7,24,9],[25,7,25,9],[26,7,26,9],[27,7,27,9]]}
["Print the Instructions and Column Definitions tabs for easy reference."]
["HR373 - Department Position Funding Mass Upload"]
["Column Definitions"]
["Cardinal Field Name",null,null,"Configuration Work Unit #",null,"Required",null,"Online Processing Rules/Format"]
[]
["SetID",null,null,"CGL002",null,"Y",null,"Agency Number + 2 zeros. (e.g., 15100, 11100, 99900, etc.)"]
["Department",null,null,"CGL006",null,"Y",null,"Maximum of 10 digits"]
["Fiscal Year",null,null,null,null,"Y",null," 4 digits"]
["Budget Level",null,null,null,null,"Y",null,"D - Department\nP - Position"]
["Effective Date of the new/changed funding distribution",null,null,null,null,"Y",null,"Format: MM/DD/YYYY"]
["Status as of Effective Date",null,null,null,null,"Y",null,"A = Active\nI = Inactive"]
["Position Number",null,null,null,null,"N",null,"Required if Budget Level = Position"]
["Fund",null,null,"CGL007",null,"Y",null," 5 digits"]
["Program",null,null,"CGL012",null,"Y",null," Maximum of 10 digits"]
["Department",null,null,"CGL006",null,"Y",null," Maximum of 10 digits"]
["Cost Center",null,null,"CGL011",null,"N",null," Maximum of 10 digits"]
["Task",null,null,"CGL009",null,"N",null," Maximum of 6 digits"]
["FIPS",null,null,"CGL020",null,"N",null," Maximum of 5 digits"]
["Asset",null,null,"CGL008",null,"N",null," Maximum of 8 digits"]
["Agency Use 1",null,null,"CGL013",null,"N",null," Maximum of 10 digits"]
["Agency Use 2",null,null,"CGL064",null,"N",null," Maximum of 8 digits"]
["PC Business Unit",null,null,"CPC002",null,"N",null," Maximum of 5 digits"]
["Project",null,null,"CGL010",null,"N",null," Maximum of 15 digits"]
["Activity",null,null,"CPC015",null,"N",null," Maximum of 15 digits"]
["Source Type",null,null,"CPC005",null,null,null,"For Future Use "]
["Category",null,null,"CPC006",null,null,null,"For Future Use "]
["Subcategory",null,null,"CPC007",null,null,null,"For Future Use "]
["Affiliate",null,null,null,null,null,null,"For Future Use "]
["Fund Affiliate",null,null,null,null,null,null,"For Future Use "]
["Future Use 1",null,null,null,null,null,null,"For Future Use "]

{"sheet":"Department-Position Funding","index":2,"n_rows":1,"n_cols":25,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SetID","Department","Fiscal Year","Budget Level","Effective Date of the new/changed funding distribution","Status as of Effective Date","Position Number","Fund","Program","Department","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"]