{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Column Definitions","TELEWORKERS_MASS_UPLOAD"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[[29,0,29,9],[30,0,30,9],[31,0,31,9],[5,0,5,9],[7,0,7,9],[12,0,12,9],[13,0,13,9],[23,0,23,9],[24,0,24,9],[25,0,25,9],[26,0,26,9],[27,0,27,9],[28,0,28,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],[8,0,8,9],[9,0,9,9],[10,0,10,9],[11,0,11,9],[14,0,14,9],[15,0,15,9],[19,0,19,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[4,0,4,9],[6,0,6,9],[3,0,3,9]]}
["Print the Instructions and Column Definitions tabs for easy reference."]
["HR520 - Maintain Teleworkers 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. Teleworkers Mass Upload Template"]
[]
[]
["Instructions:"]
["1. The agency should run the V_HR_TELEWORK_MASS_UPLOAD query to obtain a list of employees that are eligible for telework.  Running the query with \"New Telework Agreement\" selected will return only the Employee ID, Employee Record number, and name for those employees who are eligible for telework.  This option is ideal for the first load of agreement data.  Running the query with \"New Telework Agreement\" not selected will return all existing agreements based on the \"As of Date\" parameter entered.  This option is ideal for assisting with the load of renewed agreements."]
["2. The agency updates the query spreadsheet with the specific telework information for eligible employees.\na) Delete any rows for employees who do not have an approved and active Telework Agreement.\nb) Enter the start and end date for each approved Telework Agreement with a format of MM/DD/YYYY\nc) Enter the Approved Telework Days per Week from the approved Telework Agreement. This number can only be 1-5. Zeros or any number greater than 5 will error out.\nd) If the employee is teleworking because they reside and work out of state, set Out of State to Y. All others, set Out of State to N.\ne) Clear all filters and check your work for accuracy."]
["3. Once the query spreadsheet is complete, copy the data from columns E-J and paste it into the template on the \"Teleworkers Mass Upload\" tab.  Ensure that the formatting is not incorrectly updated by accident when copying from the query spreadsheet and pasting to the mass upload template.  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 > HR Interfaces > Mass Uploads > Teleworkers 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 (Teleworkers Mass Upload 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.  Select the .TXT file to review the results.  \n"]
["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":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,0,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,9],[10,0,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,9],[7,0,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,9],[8,0,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,9],[5,0,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,9],[6,0,6,2],[6,3,6,4],[6,5,6,6],[6,7,6,9],[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]]}
["Print the Instructions and Column Definitions tabs for easy reference."]
["HR520 - Teleworkers 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"]
["Empl Record",null,null,null,null,"Y",null,"1 digit (Maximum of 3 digits)"]
["Start Date",null,null,null,null,"Y",null,"Format: MM/DD/YYYY"]
["End Date",null,null,null,null,"Y",null,"Format: MM/DD/YYYY"]
["Approved Telwork Days per Week",null,null,null,null,"Y",null,"valid values 1 - 5"]
["Out of State",null,null,null,null,"Y",null,"Y or N"]

{"sheet":"TELEWORKERS_MASS_UPLOAD","index":2,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Employee ID","Empl Record","Start Date","End Date","Approved Telework Days per Week","Out of State"]