{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Pay Request","Job Aid","Personnel Areas"],"not_rendered":{"defined_names":31},"read":"whole","date_system":"1900"}

{"sheet":"Pay Request","index":0,"n_rows":84,"n_cols":16,"rows_kept":84,"merged":[[0,0,0,2],[0,3,0,9],[0,10,0,11],[0,12,0,16],[1,0,1,16],[2,0,2,2],[2,3,2,11],[2,12,2,13],[2,14,2,16],[3,0,3,2],[3,3,3,4],[3,8,3,11],[3,12,3,13],[3,14,3,16],[4,0,4,2],[4,3,4,4],[4,5,4,6],[4,8,4,13],[4,14,4,16],[5,0,5,2],[5,3,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,12],[5,13,5,16],[6,0,6,2],[6,3,6,4],[6,6,6,7],[6,8,6,10],[6,11,6,12],[6,14,6,16],[7,0,7,16],[8,0,11,16],[12,0,12,16],[13,0,13,2],[13,3,13,5],[13,6,13,8],[13,9,13,16],[14,0,14,2],[14,3,14,5],[14,6,14,8],[14,9,14,16],[15,0,15,2],[15,3,15,5],[15,6,15,8],[15,9,15,11],[15,12,15,15],[16,0,16,16],[17,0,20,16],[21,0,21,16],[22,0,22,16],[23,0,23,4],[23,5,23,6],[23,7,23,9],[23,10,23,11],[23,12,23,15],[24,0,24,16],[25,0,25,10],[25,11,25,16],[27,1,27,3],[27,4,27,5],[27,6,27,11],[27,12,27,13],[28,1,28,3],[28,4,28,11],[30,1,30,3],[30,4,30,5],[30,6,30,16],[31,1,31,3],[31,4,31,6],[31,7,31,16],[32,1,32,3],[32,4,32,7],[34,1,34,4],[34,7,34,9],[35,1,35,3],[35,4,35,6],[37,1,37,2],[37,3,37,5],[38,2,38,3],[38,4,38,7],[39,4,39,5],[40,3,40,6],[40,7,40,10],[40,11,40,13],[40,15,40,16],[41,7,41,10],[41,11,41,12],[43,6,43,8],[43,9,43,10],[45,0,45,16],[46,0,46,2],[46,3,46,8],[46,9,46,10],[46,11,46,16],[47,0,47,2],[47,3,47,8],[47,9,47,10],[47,11,47,16],[49,0,49,16],[50,0,50,9],[50,10,50,12],[50,13,50,16],[51,0,51,2],[51,3,51,9],[51,10,51,11],[51,12,51,16],[52,0,52,2],[52,3,52,8],[52,9,52,11],[52,12,52,16],[53,0,53,2],[53,3,53,8],[53,9,53,11],[53,12,53,16],[54,0,54,2],[54,3,54,8],[54,9,54,11],[54,12,54,16],[55,0,55,2],[55,4,55,6],[55,7,55,9],[55,10,55,11],[55,12,55,13],[55,14,55,16],[56,0,56,2],[56,4,56,6],[56,7,56,9],[56,10,56,11],[56,12,56,13],[56,14,56,16],[57,0,57,2],[57,4,57,6],[57,7,57,9],[57,10,57,11],[57,12,57,13],[57,14,57,16],[58,0,58,2],[58,4,58,6],[58,7,58,9],[58,10,58,11],[58,12,58,13],[58,14,58,16],[59,0,59,2],[59,4,59,6],[59,7,59,9],[59,10,59,11],[59,12,59,13],[59,14,59,16],[60,0,60,2],[60,4,60,6],[60,7,60,9],[60,10,60,11],[60,12,60,13],[60,14,60,16],[61,0,61,2],[61,4,61,6],[61,7,61,9],[61,10,61,11],[61,12,61,13],[61,14,61,16],[62,0,62,2],[62,4,62,6],[62,7,62,9],[62,10,62,11],[62,12,62,13],[62,14,62,16],[63,0,63,2],[63,4,63,6],[63,7,63,9],[63,10,63,11],[63,12,63,13],[63,14,63,16],[64,0,64,2],[64,4,64,6],[64,7,64,9],[64,10,64,11],[64,12,64,13],[64,14,64,16],[65,0,65,2],[65,4,65,6],[65,7,65,9],[65,10,65,11],[65,12,65,13],[65,14,65,16],[66,11,66,13],[66,14,66,16],[67,0,68,16],[69,0,69,8],[69,9,69,16],[70,0,70,16],[71,0,71,2],[71,3,71,9],[71,10,71,11],[71,12,71,16],[72,0,72,2],[72,3,72,9],[72,10,72,11],[72,12,72,16],[73,0,73,16],[74,0,80,16],[81,0,81,16],[82,0,82,2],[82,3,82,7],[82,8,82,9],[82,10,82,12],[82,14,82,16],[83,0,83,2],[83,3,83,7],[83,8,83,9],[83,10,83,12],[83,13,83,16]]}
["Agency/University",{"$nulls":9},"Division"]
["Employee Information"]
["Employee Name",{"$nulls":11},"Personnel #"]
["RIF Sep. Date",{"$nulls":4},"Sex",null,"Race",{"$nulls":4},"Date Notified"]
["Annual  Salary",{"$nulls":4},"Annual Months",null,null,"Promoted within twelve months"]
["Previous Salary",{"$nulls":5},"Acting Pay",{"$nulls":3},"Acting Pay Salary"]
["Date of Birth",{"$nulls":4},"Age",{"$f":"IF(ISBLANK(DOB),\" \",INT(YEARFRAC(DOB,TODAY())))","v":" "},null,"Service Months",{"$nulls":4},"As of"]
["Please provide the  reason for Reduction In Force below: "]
[]
[]
[]
[]
["Position Information"]
["Position Number",{"$nulls":5},"Classification Title"]
["Org Unit #",{"$nulls":5},"Org Unit Name"]
["Grade/Band Level",{"$nulls":5},"Budgeted Salary",{"$nulls":5},"Position will be abolished"]
["If position is not being abolished, please explain how \"economies of the State Budget\" are being achieved:"]
[]
[]
[]
[]
["Discontinued Service Retirement (DSR)"]
["THIS SECTION MUST BE COMPLETED IF THE EMPLOYEE IS ELIGIBLE FOR DSR (PLEASE ENSURE CALCULATION FROM RETIREMENT SYSTEM IS ATTACHED)"]
["Is Employee Eligible for DSR",{"$nulls":6},"Cost of DSR",{"$nulls":4},"Calculation Attached"]
["Severance Calculation"]
[" The following  Severance Salary Calculation is based on the employee's",{"$nulls":10},{"$f":"IF(ISBLANK(ANNSAL),\" \",IF(ACT=\"Yes\",\"Acting Salary\",IF(PROMO=\"Yes\",\"Pre-Promotion Salary\",\"Annual Salary\")))","v":" "}]
[]
[null,"Employee Number",null,null,{"$f":"IF(ISBLANK(PERNR),\" \", PERNR)","v":" "},null,"Date of RIF Separation",{"$nulls":5},{"$f":"IF(ISBLANK(RIFDate),\" \", RIFDate)","v":" "}]
[null,"Employee Name",null,null,{"$f":"IF(ISBLANK(NAME),\" \", NAME)","v":" "}]
[]
[null,"Personnel Area",null,null,{"$f":"IF(ISBLANK(AGENCY),\" \",VLOOKUP(AGENCY,'Personnel Areas'!A1:C29,3,FALSE))","v":" "},null,{"$f":"IF(ISBLANK(AGENCY),\" \",VLOOKUP(AGENCY,'Personnel Areas'!A1:C29,2,FALSE))","v":" "}]
[null,"Position Number",null,null,{"$f":"IF(ISBLANK(POSITNO),\" \",POSITNO)","v":" "},null,null,{"$f":"IF(ISBLANK(CLASS),\" \", CLASS)","v":" "}]
[null,"Employee Salary",null,null,{"$f":"IF(ISBLANK(ANNSAL),\" \",IF(L26=\"Pre-Promotion Salary\",PRESAL,IF(L26=\"Acting Salary\",ACTSAL,IF(L26=\"Annual Salary\",ANNSAL,\" \"))))","v":" "}]
[]
[null,"Current Service Months",{"$nulls":3},{"$f":"IF(ISBLANK(SVC),\" \",SVC)","v":" "},"As of",{"$f":"IF(ISBLANK(ASOF),\" \",ASOF)","v":" "}]
[null,"Service Factor",null,null,{"$f":"IF(ISBLANK(SVC),\" \",IF(ASM=9,(SS/9)*O41,IF(ASM=10,(SS/10)*O41,IF(ASM=11,(#REF!),(SS/12)*O41))))","v":" "}]
[]
[null,"Date of Birth",null,{"$f":"IF(ISBLANK(DOB),\" \",DOB)","v":" "}]
[null,null,"Age Factor ",null,{"$f":"IF(DOB<=0, \" \",IF(AF<SF,AF,SF))","v":" "},{"$f":"IF(Age<40,0,(SS*0.025)*(Age-40))","v":{"$error":"#VALUE!"}},{"$f":"IF(Age<40,0,(SS*0.025)*(Age-40))","v":{"$error":"#VALUE!"}},{"$f":"IF(Age<40,0,(SS*0.025)*(Age-40))","v":{"$error":"#VALUE!"}},{"$nulls":7},{"$f":"IF(Age<40,0,(SS*0.025)*(Age-39))","v":{"$error":"#VALUE!"}}]
[]
[{"$nulls":3},"Total Severance pay",{"$nulls":3},{"$f":"IF(ISBLANK(SVC),\" \",SF+E39)","v":" "},{"$nulls":3},"Distributed Over",null,null,{"$f":"IF(AND(SVC>=12,SVC<60),1,IF(AND(SVC>=60,SVC<120),2,IF(AND(SVC>=120,SVC<240),3,IF(SVC>=240,4,\" \"))))","v":" "},"Months"]
[{"$nulls":7},{"$f":"IF(ISBLANK(SVC),\" \",H41/O41)","v":" "},{"$nulls":3},"Per Month"]
[]
[{"$nulls":6},"(Based on",null,null,{"$f":"IF(ISBLANK(SVC),\" \",CSM/12)","v":" "},null,"Years of Service)"]
[]
["Agency/University Contact Information"]
["Name",{"$nulls":8},"Title"]
["Email",{"$nulls":8},"Phone"]
[]
["Budget Information"]
[{"$nulls":10},"Request Type"]
["Agency/University",null,null,{"$f":"IF(ISBLANK(AGENCY),\" \", AGENCY)","v":" "},{"$nulls":6},"Division",null,{"$f":"IF(ISBLANK(Division),\" \", Division)","v":" "}]
["Employee Name",null,null,{"$f":"IF(ISBLANK(NAME), \" \", NAME)","v":" "},{"$nulls":5},"Personnel No.",null,null,{"$f":"IF(ISBLANK(PERNR), \" \", PERNR)","v":" "}]
["RIF Sep Date",null,null,{"$f":"IF(ISBLANK(RIFDate),\" \",RIFDate)","v":" "},{"$nulls":5},"Severance Salary",null,null,{"$f":"Sev","v":" "}]
["Position Number",null,null,{"$f":"IF(ISBLANK(POSITNO),\" \",POSITNO)","v":" "},{"$nulls":5},"Position Title",null,null,{"$f":"IF(ISBLANK(CLASS), \" \",CLASS)","v":" "}]
["Budge Code",null,null,"FTE","Fund Code",null,null,"Account",null,null,"Company Code",null,"Source of Funds",null,"Budgeted Salary"]
{"$rows_empty":10}
[{"$nulls":11},"Total Salary",null,null,{"$f":"SUM(O57:Q66)","v":{"v":0,"d":"$0.00"}}]
["Agency/University Budget office has confirmed funds are available and budgeted to pay severance from the same source of funds as the position being funded."]
[]
[]
["Budget Office Contact Information"]
["Name",{"$nulls":9},"Title"]
["Email",{"$nulls":9},"Phone"]
["Agency Budget Office Comments"]
{"$rows_empty":7}
["Office of State Budget Management"]
["OSBM Analyst",{"$nulls":7},"Date"]
["Budget Director",{"$nulls":7},"Date"]

{"sheet":"Job Aid","index":1,"n_rows":66,"n_cols":4,"rows_kept":66,"merged":[[0,0,1,3],[3,0,4,3],[20,0,20,3],[29,0,29,3],[35,0,35,3],[52,0,52,3],[58,0,58,3]]}
["The RIF Severance/DSR Pay Request Job aid will assist you in completing all the necessary fields to complete the request for severance or DSR."]
[]
[]
["Employee Information"]
[]
["Field","Description","Field Type","Required"]
["Agency/University","Please choose your agency or university from the list.","Dropdown List","Y"]
["Division","Enter the divistion within your agecy","Data Entry","N"]
["Employee Name","Enter the employee's full name","Data Entry","Y"]
["Employee Number","Enter the employee's BEACON Identification number","Data Entry","Y"]
["RIF Date","Enter the effective date of the employee's RIF","Data Entry","Y"]
["Date Notified","Enter the date the agency notified the employee in writing that they will be RIFd ","Data Entry","Y"]
["Annual Salary","Enter the employee's current annual salary.  This salary does not include any temporary acting pay.","Data Entry","Y"]
["Promoted within twelve months","Please review the employee's actions and reasons in BEACON and verify that the employee has not received a promotion within the last twelve months.","Dropdown Yes/No","Y"]
["Previous Salary","Enter the salary of the employee prior to receiving last promotion if the promotion was within 12 month.","Data Entry","N"]
["Acting Pay","Indicate whether the employee has a current Acting Pay action.","Dropdown Yes/No","Y"]
["Date of Birth","Provide the employee's Date of Birth","Data Entry","Y"]
["Age","This is a calculated field that will automtically populate once you enter the employee's Date of Birth","Locked","N/A"]
["Service Months","Enter the number of months the employee has been a state employee","Data Entry","Y"]
["As of","Enter the date you verified the employee's information.  This date should be within the week you make the request to ensure we are using the most recent data to determine employee's eligible salary.","Data Entry","Y"]
["Position Information"]
["Field","Description","Field Type","Required"]
["Position Number","Enter the employees position nummber","Data Entry","Y"]
["Classification Title","Enter the employee's classification Title","Data Entry","Y"]
["Org Unit #","Enter the position org unit","Data Entry","Y"]
["org Unit Name","Enter the org unit name.","Data Entry","Y"]
["Grade/Band Level","Enter the Grade or band level of the position the RIF employee is  in.","Data Entry","Y"]
["Budgeted Salary","What is the current Budgeted salary of the position","Data Entry","Y"]
["Position will be abolished","Please indicate if this position will be abolished.","Dropdown Yes/No","Y"]
["Discontinued Service Retirement (DSR)"]
["Field","Description","Field Type","Required"]
["Eligible for DSR","Indicate whether the employee is eligible for DSR even if the agency will not pay DSR.","Dropdown Yes/No","Y"]
["Agency Paying DSR","Indicate if the agency will pay DSR","Dropdown Yes/No","N"]
["Cost of DSR","If agency will pay DSR please indicate it with a yes/no answer.","Dropdown Yes/No","N"]
["Calculation Attached","Have you attached the DSR calculation provided by the retirement system.","Dropdown Yes/No","N"]
["Severance Calculation"]
["Field","Description","Field Type","Required"]
["Employee Number","This field will autopopulate","Auto Populated","Y"]
["Date of RIF Separation","This field will autopopulate","Auto Populated","Y"]
["Employee Name","This field will autopopulate","Auto Populated","Y"]
["Personnel Area","This field will autopopulate","Auto Populated","Y"]
["Position Number","This field will autopopulate","Auto Populated","Y"]
["Employee Salary","This field will autopopulate","Auto Populated","Y"]
["Current Service Months","This field will autopopulate","Auto Populated","Y"]
["As of","This field will autopopulate","Auto Populated","Y"]
["Service Factor","This field will autopopulate","Auto Populated","Y"]
["Date of Birth","This field will autopopulate","Auto Populated","Y"]
["Age Factor","This field will autopopulate","Auto Populated","Y"]
["Total Severance Pay","This field will autopopulate","Auto Populated","Y"]
["Distributed over","This field will autopopulate","Auto Populated","Y"]
["Per Months","This field will autopopulate","Auto Populated","Y"]
["Based on ","This field will autopopulate","Auto Populated","Y"]
["Agency/University Contact Information"]
["Field","Description","Field Type","Required"]
["Name","Please enter the name of the person OSHR should contact with questions regarding the RIF request.","Data Entry","Y"]
["Title","Please enter the title of the person OSHR should contact with questions regarding the RIF request.","Data Entry","Y"]
["Email ","Please enter the email address of the person OSHR should contact with questions regarding the RIF request.","Data Entry","Y"]
["Phone","Please enter the phone number of the person OSHR should contact with questions regarding the RIF request.","Data Entry","Y"]
["Budget Information"]
["Field","Description","Field Type","Required"]
["Request Type","This field will autopopulate","Auto Populated","Y"]
["Agency/University","This field will autopopulate","Auto Populated","Y"]
["Division","This field will autopopulate","Auto Populated","Y"]
["Employee Name","This field will autopopulate","Auto Populated","Y"]
["Personnel No.","This field will autopopulate","Auto Populated","Y"]
["RIF Date","This field will autopopulate","Auto Populated","Y"]

{"sheet":"Personnel Areas","index":2,"n_rows":47,"n_cols":4,"rows_kept":47,"hidden":true}
["Agency","Personnel Area Text","PA","CoCd"]
["Board of Elections","Elections","B025","NC01"]
["Department of Administration","Administration",1301,"NC01"]
["Department of Agriculture","Agriculture Consumer Services",1001,"NC01"]
["Department of Commerce","Commerce",4301,"NC01"]
["Department of Environmental Quality","Environmental Quality",1601,"NC01"]
["Department of Health and Human Services","Health Human Services",2001,"NC01"]
["Department of Information Technology","Information Technology",4101,"NC01"]
["Department of Instruction","Public Instruction",{"v":801,"d":"0801"},"NC01"]
["Department of Insurance","Insurance",1201,"NC01"]
["Department of Justice","Justice",{"v":901,"d":"0901"},"NC01"]
["Department of Labor","Labor",1101,"NC01"]
["Department of Natural and Cultural Resources","Natural and Cultural Resources",4601,"NC01"]
["Department of Public Safety","Public Safety",1901,"NC01"]
["Department of Revenue","Revenue",4501,"NC01"]
["Department of Transportation","Transportation",1501,"NC02"]
["Governor's Office","Governor's Office",{"v":301,"d":"0301"},"NC01"]
["NC Education Lottery","Education Lottery",6101,"NC01"]
["NC Judicial Brance","Judicial Branch",{"v":201,"d":"0201"},"NC01"]
["NC School of Science & Math","School of Science & Math",8701,"NC01"]
["NC Secretary of State","Secretary of State",{"v":501,"d":"0501"},"NC01"]
["NC State Auditor","State Auditor",{"v":601,"d":"0601"},"NC01"]
["NC State Treasurer","State Treasurer",{"v":701,"d":"0701"},"NC01"]
["NC Wildlife Resources Commission ","Wildlife Resources Commission",1701,"NC01"]
["North Carolina Community Colleges","Carolina Community Colleges",5001,"NC01"]
["Office of Administrative Hearings","Administrative Hearings",6701,"NC01"]
["Office of State Budget & Management","State Budget & Management",{"v":310,"d":"0310"},"NC01"]
["Office of State Controller ","State Controller",1401,"NC01"]
["Office of State Human Resources","State Human Resources","Z101","NC01"]
["Appalachian State University","University System","XXXX","XXXX"]
["East Carolina University","University System","XXXX","XXXX"]
["Elizabeth City University","University System","XXXX","XXXX"]
["Fayetteville State University","University System","XXXX","XXXX"]
["NC School of Science and Mathematics","University System","XXXX","XXXX"]
["North Carolina A&T University","University System","XXXX","XXXX"]
["North Carolina Central University","University System","XXXX","XXXX"]
["North Carolina State University","University System","XXXX","XXXX"]
["UNC Asheville","University System","XXXX","XXXX"]
["UNC Charlotte","University System","XXXX","XXXX"]
["UNC General Administration","University System","XXXX","XXXX"]
["UNC Greensboro","University System","XXXX","XXXX"]
["UNC Pembroke","University System","XXXX","XXXX"]
["UNC School of the Arts","University System","XXXX","XXXX"]
["UNC Wilmington","University System","XXXX","XXXX"]
["UNC-Chapel Hill","University System","XXXX","XXXX"]
["Western Carolina","University System","XXXX","XXXX"]
["Winston-Salem State University","University System","XXXX","XXXX"]