{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Column Definitions","Performance Rating 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":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9]]}
[]
["HR371 - Performance Rating Mass Upload"]

{"sheet":"Column Definitions","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[[14,5,14,6],[6,7,6,9],[7,7,7,9],[8,7,8,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[13,7,13,9],[12,7,12,9],[14,7,14,9],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,0,14,2],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[7,0,7,2],[6,5,6,6],[7,5,7,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],[5,0,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,9],[6,0,6,2]]}
["Print the Instructions and Column Definitions tabs for easy reference."]
["HR371 - Performance Rating 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"]
["Effective Date",null,null,null,null,"Y",null,"Format: MM/DD/YYYY"]
["Effective Sequence",null,null,null,null,"Y",null,"Default 0"]
["Rating Type",null,null,null,null,"Y",null,"A = Annual \nC = Certification \nP = Re-Evaluation Translate Value "]
["Rating Cycle",null,null,"CHR095",null,"Y",null,"Prompt on V_PERF_CYC_TBL"]
["Rating",null,null,"CHR096",null,"Y",null,"X = Extraordinary \nC = Contributor \nB = Below \nL = Leave"]
["Re-eval Status",null,null,null,null,"Y – if B",null,"C = Completed \nIP = In Progress \nNS = Not Started"]
["Re-eval Date",null,null,null,null,"Y – if B",null,"Format: MM/DD/YYYY"]
["Comments",null,null,null,null,"N",null," Max field length is 254"]

{"sheet":"Performance Rating Mass Upload","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Employee ID","Employee Rcd","Effective Date","Effective Sequence","Rating Type","Ratings Cycle","Review Rating","Re-eval Status","Re-eval Date","Comments"]
[6666,0,"2020-02-21",1,"A","RATING","B","A","2020-02-21"]