{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Biographical & Job Data","Days & Earnings"],"not_rendered":{"charts":0,"images":4,"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":"Biographical & Job Data","index":0,"n_rows":10,"n_cols":22,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,0,8,19],[7,0,7,19]]}
["Biographical Data (1)","NYSLRS ID (NEW)","Empl Inst (NEW)","Last 4 of SSN\n(XX6789)","First 3 Characters of First Name","Complete SSN\n(123456789)","Name Prefix (Dr, Lt, etc.)","First Name","Middle Name","Last Name","Name Suffix \n(Jr, II, MD, PhD, etc)","DOB\n(MM/DD/YYYY)","Sex \n(M, F, U, or X)","Country \n(USA, CAN, etc.)","Address 1","Address 2","Address 3","City","State\n(XX)","Zip"]
[1,11,3,4,3,9,4,30,30,30,15,10,1,3,55,55,55,30,6,10]
["Job Data (2)","NYSLRS ID\n(R12345678 or NEW)","Empl Inst (NYSLRS provided number or NEW)","Last 4 of SSN\n(XX6789)","First 3 Characters of First Name","Transaction Date\n(MM/DD/YYYY)","HR Transaction Type \n(HIR, DTA, LOA, etc.)","Job Code (03600E, 08000P, etc)","Pay Freq\n(A, B, S, M, etc.)","Annual Comp Rate\n(i.e. 12345.67)","Standard Work Hours \n(# between 6 and 8, up to 2 decimals)","Annualized Rate of Pay\n(i.e. 12345.67)","Regular / Temporary\n(R or T)","Full Time / Part Time\n(F or P)","Empl Class\n(12, 12P, S, OC, etc.)","Retirement Indicator\n(Y or N)","Retired in Retirement System\n(if yes - NYSERS, NYSTRS, NYCERS, etc.)"]
[1,11,3,4,3,10,3,6,5,12.6,4.2,15.3,1,1,3,1,7]
[]
[]
[]
["Release: 02/2021B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output"]
[null,"<-- Must Enter Location Code Here"]

{"sheet":"Days & Earnings","index":1,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Days & Contributions (3)","NYSLRS ID (R12345678)","NYSLRS provided Empl Inst (00)","Last 4 of SSN\n(XX6789)","First 3 Characters of First Name","Regular/Adjustment Indicator (R or A)","Payroll End Date\n(MM/DD/YYYY)","Number of Pay Cycles in Period\n(1,2,3,4, or 5)","Reported Days\n(0, 12.25, 123.5, etc.)","Pre-Tax Contributions\n(0, 123.45, etc.)","Post-Tax Contributions\n(0, 123.45, etc)","Loan\n(0, 123.45, etc.)","Pre-Tax Service Credit Payment\n(0, 123.45, etc)","Post-Tax Service Credit Payment\n(0, 123.45 etc)"]
[1,11,3,4,3,1,10,1,6.2,16.2,16.2,16.2,16.2,16.2]
["Earnings Data (4)","NYSLRS ID (R12345678)","NYSLRS provided Empl Inst (00)","Last 4 of SSN\n(XX6789)","First 3 Characters of First Name","Regular/Adjustment Indicator (R or A)","Payroll End Date\n(MM/DD/YYYY)","Reported Earnings Code\n(REG, OVT, MNP, etc.)","Reported Earnings Amount\n(0, 1234.56, etc.)","Reported Earnings Hours\n(0, 12.25, etc.)"]
[1,11,3,4,3,1,10,3,16.2,4.2]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output"]
[null,"<-- Must Enter Location Code Here"]