{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Column Definitions","Position Mass Upload"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":65,"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":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":false,"merged":[[15,0,15,9],[0,0,0,9],[1,0,1,9],[3,0,3,9],[4,0,5,9],[8,0,8,9],[9,0,9,9],[10,0,10,9],[11,0,11,9],[13,0,13,9],[14,0,14,9],[25,0,25,9],[26,0,26,9],[16,0,16,9],[17,0,17,9],[21,0,21,9],[22,0,22,9],[23,0,23,9],[20,0,20,9],[18,0,18,9],[19,0,19,9],[24,0,24,9]]}
["HR411 - Position Data Mass Upload"]
["Instructions"]
["Rev: 03/21/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 the Enable Content button in this workbook before proceeding. "]
[]
["This workbook contains the following tabs:"]
["1. Instructions"]
["2. Column Definitions"]
["3. Position Mass Upload Template"]
[]
["Instructions:"]
["The Agency Must:"]
["1. Review Column Definitions tab closely as some requirements have changed. "]
["2. Run the V_HR_POSITION_MASS_DATA_CHANGE query to obtain a list of existing positions and position data in Cardinal."]
["3. Update the Data in the Query Results spreadsheet: \n\nStep 1. Delete all ROWS of positions that do NOT need updating.\nStep 2. Copy all existing data to the template. \nStep 3. Change ONLY the values in the cells that needs to be changed. (NOTE: this will ensure all \"required and non required\" fields are populated correctly. Leave everything else alone.)"]
["4. Once the query spreadsheet is completed with the desired position data updates, copy the data and paste it into the template on the \"Position Mass Upload\" tab in this workbook.  "]
["5. Insure 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."]
["7. The CSV file must be uploaded to DHRM's \"File Utility Upload\" repository by the agency. If you do not have access to this repository, please submit the DHRM Computer Applications Access Request Form (https://web1.dhrm.virginia.gov/itech/forms/DHRMUserAccessRegistrationform.pdf) to iHelp@dhrm.virginia.gov."]
["8. After DHRM reviews the mass upload, DHRM will place the file in a secure folder on the Change Network (CN) SharePoint site. DHRM will create a VCCC ticket for Cardinal Post Production Support (PPS) to process the mass upload."]
["8. After PPS runs the file, they will provide the error log to the agency with a copy to DHRM."]
["9. Verify your updates: Run another V_HR_POSITION_MASS_DATA_CHANGE query and compare it to the one that you used to make the updates. "]
["10. The agency can either correct the errors on Excel document and resubmit the upload file or enter the transaction through an online data entry."]
["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":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["HR411 - Position Mass Upload"]
["Column Definitions"]
["Cardinal Field Name",null,null,"Job Aids","Required",null,"Online Processing Rules/Format"]
[]
["Position Number",null,null,null,"Y",null,"3 char agency + 5 numbers"]
["Effective Date",null,null,null,"Y",null,"Format: MM/DD/YYYY"]
["Effective Sequence",null,null,null,"Y"]
["Effective Status",null,null,null,"Y",null,"A - Active / I - Inactive"]
["Action",null,null,"HR351_Action Reason Codes","Y",null,"3 characters"]
["Action Reason",null,null,"HR351_Action Reason Codes","Y",null,"3 characters"]
["Description",null,null,null,"Y",null,"Field open for agencies to enter Working Title"]
["Short Description",null,null,null,"N",null,"Same as Job Code – 5 digits"]
["Business Unit",null,null,null,"Y",null,"5 digits"]
["Department ID",null,null,null,"Y",null,"Maximum of 10 digits"]
["Location",null,null,null,"Y",null,"Maximum of 10 digits"]
["Job Code",null,null,null,"Y",null,"5 digits"]
["Position Status",null,null,null,"Y",null,"A - Approved / R - Frozen"]
["Reports To",null,null,null,"Y",null,"Valid Position Number – for TA/AM Approvals"]
["Company",null,null,null,"Y",null,"3 characters"]
["Standard Hours",null,null,null,"Y",null,"Format: 40.00 – whole numbers only, if 0 submitted, 40 will default for new positions only "]
["Full / Part Time",null,null,null,"Y",null,"F - Full-Time / P - Part-Time / Q - Quasi"]
["FLSA Status",null,null,null,"Y",null,"P - Professional / N - Nonexempt"]
["FTE",null,null,null,"N",null,"Standard value is 1 – this field impacts EPR and DPB reports"]
["Avail for Telework",null,null,null,"Y",null,"Y or N"]
["Salary Step",null,null,null,"N",null,"Only allowed for agencies who have alternate salary plans in place "]
["Position Review Date",null,null,null,"N",null,"Format: MM/DD/YYYY"]
["Position Months",null,null,null,"Y",null,"Format: 12.00 – whole numbers only"]
["Statement of Economic Interests",null,null,null,"Y",null,"Y or N - defaults to N if blank for new positions"]
["Position Agency Field 1 Optional",null,null,null,"N",null,"Maximum of 10 characters"]
["Position Agency Field 2 Optional ",null,null,null,"N",null,"Maximum of 10 characters"]
["Position Agency Field 3 Optional ",null,null,null,"N",null,"Maximum of 10 characters"]
["EEO4 Code",null,null,null,"Y",null,"Number 1 thru 8 / N = No EEO4 Reporting\n1 = Officials and Administrators\n2 = Professionals\n3 = Technicians\n4 = Protective Service\n5 = Paraprofessionals\n6 = Office/Clerical\n7 = Skilled Craft\n8 = Service Maintenance\nN = No EEO-4 Reporting"]
["Position Safety Sensitive Indicator ",null,null,null,"Y",null,"Y or N - defaults to N if blank for new positions"]
["Fingerprinting Required",null,null,null,"Y",null,"Y or N - defaults to N if blank for new positions"]
["Standard Occupational Classification (SOC) Code",null,null,"HR351_Overview of US SOC and Job Code Combinations","Y*",null,"Format: 22-2222 or 22-2222.01 - *only required for VPA and AHD positions. "]
["Position Alternate Work Schedule",null,null,null,"Y",null,"Y or N - defaults to N if blank "]
["Supervisor Position Number",null,null,null,"Y",null,"Valid Position Number – could be same as or different from Reports To "]
["Workers Comp Code",null,null,"DHRM NCCI Codes","Y",null,"4 digits"]
["Position License 1",null,null,null,"N",null,"Maximum of 9 characters"]
["Position License 2",null,null,null,"N",null,"Maximum of 9 characters"]
["Position License 3",null,null,null,"N",null,"Maximum of 9 characters"]
["Critical or Hard to Hire",null,null,null,"Y",null,"Y or N - defaults to N if blank for new positions"]
["VPA Eligible",null,null,null,"Y",null,"Y or N"]
["Key Position",null,null,null,"Y",null,"Y or N - defaults to N if blank for new positions"]
["Job Sharing Permitted",null,null,null,"Y",null,"Y or N - defaults to N if blank for new positions"]
["Max Head Count",null,null,null,"Y",null,"Maximum of 4 digits. Default = 1 "]
["Budgeted Position",null,null,null,"Y",null,"Y or N - defaults to Y if blank for new positions"]
["Confidential Position",null,null,null,"Y",null,"Y or N - defaults to N if blank for new positions"]
["Regular/Temporary",null,null,null,"Y",null,"R - Regular, T- Temporary, X - Restricted"]
["Supervisor Level",null,null,null,"Y",null,"Maximum of 8 characters. Default = 'E'"]
["Certifications",null,null,null,"Y",null,"Y or N - defaults to N if blank for new positions"]
["Language",null,null,null,"Y",null,"Y or N - defaults to N if blank for new positions"]
["Physical Requirements/ Restrict",null,null,null,"Y",null,"Y or N - defaults to N if blank for new positions"]
["Appointed Category",null,null,null,"Y",null,"B - Board Appointed, E - Elected Official, G - Governor Appointed, L - Legislative, N - N/A. Default = 'N/A' "]

{"sheet":"Position Mass Upload","index":2,"n_rows":1,"n_cols":50,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Position Number","Effective Date","Effective Sequence","Effective Status","Action","Action Reason","Description","Short Description","Business Unit","Department ID","Location","Job Code","Position Status","Reports To","Company","Standard Hours","Full / Part Time","FLSA Status","FTE","Avail for Telework","Salary Step","Position Review Date","Position Months","Position Economic Interests","Position Agency Field 1 Optional ","Position Agency Field 2 Optional ","Position Agency Field 3 Optional ","Position EEO Code","Position Safety Sensitive Indicator ","Fingerprinting Required","Standard Occupational Classification (SOC) Code","Position Alternate Work Schedule","Supervisor Position #","Workers Comp Code","Position License 1","Position License 2","Position License 3","Critical or Hard to Hire","VPA Eligible","Key Position","Job Sharing Permitted","Max Head Count","Budgeted Position","Confidential Position","Regular/ Temporary","Supervisor Level","Certifications","Language","Physical Requirements/ Restrict","Appointed Category"]