{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Coversheet","Connect Information","Template","Data Input","Staging & Submission","Config","Required Fields","Translate Values"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":51,"comments":1,"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":"Coversheet","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Job Code Data"]
[null,null,"The purpose of this workbook is to upload data from Excel into PeopleSoft using the Component Interface to execute business logic for each transaction. This source workbook contains both worksheets and Excel VBA code modules.  The Worksheets can be copied to other workbooks for distribution without copying the code modules."]
[]
[null,"Process:"]
[null,"1)","Connection Information sheet: The information provided on this sheet is required to create a new template or submit data to the database. You will need to specify environment information as well as information in regard to how each transaction should be handled. The Action will be filled in automatically."]
[]
[null,"2)","Template sheet: Here you create the template that you are going to use. The template is based upon the structure of a Component Interface on the PeopleSoft database."]
[null,null,"2.1. New Template: When prompted, enter the name of your PeopleSoft User ID, password, and the Component Interface you wish to use. The connect information previously provided is used to retrieve the PeopleSoft Component Interface properties. The Component Interface structure is displayed graphically."]
[null,null,"2.2. Manipulate Template: Here input cells are selected for inclusion on the Data Input and Staging & Submisson sheets.  The purpose of each button provided to allow manipulation of the template is more fully described by mousing over the button on the toolbar."]
[null,null,"2.3. New Data Input: This button copies the selected input cells into the Data Input sheet. The Data Input sheet becomes active, and you will be prompted before the structures and data on that sheet are deleted."]
[]
[null,"3)","Data Input sheet: Here you enter data values for submission to the PeopleSoft database."]
[null,null,"3.1. Stage Data for Submission: The data entered on the Data Input sheet is then staged in hierarchical form in preparation for submission to the database."]
[]
[null,"4)","Staging & Submission sheet: The last step is to format the data and submit to the database."]
[null,null,"4.1. Submit Data: This submits the data to the database.  Your PeopleSoft User ID and Password will be required. Each row submitted is marked with the reply from the database which will either be OK, Warning, or Error."]
[null,null,"4.2. Post Results: This posts the status for each row submitted to the database on the Data Input sheet so that data in a status of error can be corrected and resubmitted."]

{"sheet":"Connect Information","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Environment:","AG - Production COPY"]
[null,"Web Server Machine Name:",{"$f":"IF(ISNA(VLOOKUP(C3 & \"\",ConnectTable,2,FALSE)),\"\", VLOOKUP(C3 & \"\",ConnectTable,2,FALSE))","v":"empusda.copy.nfc.usda.gov"}]
[null,"Protocol:",{"$f":"IF(ISNA(VLOOKUP(C3 & \"\",ConnectTable,3,FALSE)),\"\", VLOOKUP(C3 & \"\",ConnectTable,3,FALSE))","v":"https"}]
[null,"HTTP Port:",{"$f":"IF(ISNA(VLOOKUP(C3 & \"\",ConnectTable,4,FALSE)),\"\", VLOOKUP(C3 & \"\",ConnectTable,4,FALSE))","v":443}]
[null,"Portal:",{"$f":"IF(ISNA(VLOOKUP(C3 & \"\",ConnectTable,5,FALSE)),\"\", VLOOKUP(C3 & \"\",ConnectTable,5,FALSE))","v":"EMPLOYEE"}]
[null,"PeopleSoft Site Name:",{"$f":"IF(ISNA(VLOOKUP(C3 & \"\",ConnectTable,6,FALSE)),\"\", VLOOKUP(C3 & \"\",ConnectTable,6,FALSE))","v":"hr"}]
[null,"Node:",{"$f":"IF(ISNA(VLOOKUP(C3 & \"\",ConnectTable,7,FALSE)),\"\", VLOOKUP(C3 & \"\",ConnectTable,7,FALSE))","v":"PT_LOCAL"}]
[null,"Language Code:",{"$f":"IF(ISNA(VLOOKUP(C3 & \"\",ConnectTable,8,FALSE)),\"\", VLOOKUP(C3 & \"\",ConnectTable,8,FALSE))","v":"ENG"}]
[]
[null,"Chunking Factor:",1]
[null,"Error Threshold:",1]
[]
[null,"Action:","CREATE"]
[]
[]
[]
[null,"Z_JOBCODE_CI"," "]

{"sheet":"Template","index":2,"n_rows":17,"n_cols":73,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Z_JOBCODE_CI"]
[]
[null,null,"Collection","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","GVT_JCOD_FCT","JOBCD_TRN_PROG","Z_NF_XDISC_OCC","Z_NF_XDISC_OCC","Z_NF_XDISC_OCC","Z_NF_XDISC_OCC","Z_NF_XDISC_OCC"]
[null,null,"Property","SETID","JOBCODE","COMPANY","GVT_SUB_AGENCY","GVT_POI","Z_JC_MSTR_RCRD","GVT_PAY_PLAN","SAL_ADMIN_PLAN","GRADE","EFFDT","EFFDT_0","EFF_STATUS","DESCR","SAL_ADMIN_PLAN","STEP","MANAGER_LEVEL","JOB_FAMILY","MED_CHKUP_REQ","FLSA_STATUS","GVT_PAY_PLAN","GVT_OCC_SERIES","COMPANY","GVT_FUNC_CLASS","GVT_POSN_TITLE_CD","GVT_OFFICIAL_DESCR","GVT_ORG_TTL_CD","GVT_ORG_TTL_DESCR","GVT_PAY_BASIS","GVT_SUB_AGENCY","GVT_POI","GVT_PAREN_TITLE","GVT_OPM_CERT_NBR","GVT_POSN_CLASS_STD","GVT_IA_ACTIONS","GVT_PATCOB_CD","GVT_CLS_STANDARD","GVT_CLASSIFIER_ID","GVT_DT_CLASSIFIED","BARG_UNIT","GVT_FUND_SOURCE","GVT_TARGET_GRADE","GVT_POSN_LOC","GVT_PI_UPD_IND","GVT_OFF_TITLEPREFX","SAL_RANGE_FREQ","Z_JC_MSTR_RCRD","Z_NF_MR_AGNCY_USE","ACTION_REASON","Z_PROFSNAL_CATEGRY","Z_LC_XREF","Z_LC_PROMOTION_PLN","Z_LC_IA_POS_MAX","Z_LC_IA_NTBFC","Z_LC_DRIVER_LIC","Z_LC_TYPING40","Z_LC_TYPING25","Z_LC_EXEC_FIN_DISC","Z_LC_INTRD_CODE","DEPTID","Z_CLASS_STD_CD","Z_EARLY_RET_CD","Z_FS_ASPD","Z_JC_PER_TYPE","GVT_CLS_LEVEL","TRN_PROGRAM","Z_GVT_OCC_SERIES","GVT_POSN_TITLE_CD","GVT_OFF_TITLEPREFX","GVT_PAREN_TITLE","Z_INTERDISCIPLINAR"]
[null,null,"Record Type","000","000","000","000","000","000","000","000","000","000","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","200","210","220","230","230","230","230","230"]
[null,null,"Field Type","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","DATE","DATE","CHARACTER","CHARACTER","CHARACTER","NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","DATE","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER"]
[null,null,"Field Length","5","6","3","2","4","6","2","4","3","10","10","1","30","4","2","2","6","1","1","2","4","3","2","4","70","4","70","2","2","4","1","8","254","1","1","15","11","10","4","1","2","1","1","1","5","6","10","3","1","6","1","3","1","1","1","1","1","1","10","1","1","1","1","1","6","4","4","1","1","1"]
[null,null,"Key / Required","Y/R","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/R","Y/R"," /R"," / "," / "," / "," /R"," / "," / "," /R"," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," /R"," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," /R"," / ","Y/ ","Y/ ","Y/ "," / "," / "," / "]
[null,null,"Sequence","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63","64","65","66","67","68","69","70"]
["Status","Line No","Record Type","SetID","Job Code","Agency","Sub-Agency","Personnel Office ID","Master Record Number (NFC)","Pay Plan","Salary Administration Plan","Salary Grade","Effective Date","Effective Date","Status as of Effective Date","Description","Salary Administration Plan","Step","Supervisory Status","Job Family","Medical Checkup Required","FLSA Status","Pay Plan","Occupational Series","Agency","Functional Class","Official Posn Title Code","Official Position Title","Organization Posn Title Cd","Organization Position Title","Pay Basis","Sub-Agency","Personnel Office ID","Parenthetical Title","OPM Certification Number","Position Classification Stds","IA Actions","PATCOB Code","Classification Standard","Classifier's ID","Date Classified","Bargaining Unit","Fund Source","Target Grade","Position Location","Transaction Status","Official Title Prefix","Salary Range Frequency","Master Record Number (NFC)","Agency Use","Reason Code","Professional Category","Replaces Job Code","Promotion Plan","Max Number of IA","Not to be Filled Concurrently","Driver License Required","Typing (40) Required","Typing (25) Required","Financial Disclosure Required","Interdisciplinary Code","Department","Classification Standard Code","Early Retirement Code","ASPD","Person Type","Classification Factor Level","Training Program","Occupational Series","Official Posn Title Code","Official Title Prefix","Parenthetical Title","Interdisciplinary Code"]
["Template",null,"000",null," ","AG ","11","5035","","GS","0000","06","1901-01-01"]
["Template",null,"100"]
["Template",null,"200",null,null,null,null,null,null,null,null,null,null,null,"A","","","","8","","",null,"","0203","","00","0003","","","","PA","","","","","","","","","","01/01/2017","","","","","","","","TEST","","NEW","","","","","","","","","","","","","","","E"]
["Template",null,"210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Template",null,"220",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Template",null,"230",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]

{"sheet":"Data Input","index":3,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Z_JOBCODE_CI"]
["Record Type 000","Record Type 000","Record Type 200","Record Type 200"]
["SetID","Job Code","Effective Date","FLSA Status"]
["COMMN","NEW","2017-06-01","E"]

{"sheet":"Staging & Submission","index":4,"n_rows":17,"n_cols":24,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Z_JOBCODE_CI"]
[null,null,null,"Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","Z_JOBCODE_CI","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL","JOBCODE_TBL"]
[null,null,null,"SETID","JOBCODE","COMPANY","GVT_SUB_AGENCY","GVT_POI","GVT_PAY_PLAN","SAL_ADMIN_PLAN","GRADE","EFFDT","EFFDT_0","EFF_STATUS","MANAGER_LEVEL","FLSA_STATUS","GVT_OCC_SERIES","GVT_FUNC_CLASS","GVT_POSN_TITLE_CD","GVT_PAY_BASIS","GVT_DT_CLASSIFIED","Z_JC_MSTR_RCRD","ACTION_REASON","Z_JC_PER_TYPE"]
[null,null,null,"000","000","000","000","000","000","000","000","000","200","200","200","200","200","200","200","200","200","200","200","200"]
[null,null,null,"CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","DATE","DATE","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","DATE","CHARACTER","CHARACTER","CHARACTER"]
[null,null,null,"5","6","3","2","4","2","4","3","10","10","1","2","1","4","2","4","2","10","6","3","1"]
[null,null,null,"Y/R","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/R","Y/R"," /R"," /R"," /R"," / "," / "," / "," / "," / "," / "," /R"," /R"]
[null,null,null,"1","2","3","4","5","7","8","9","10","11","12","16","19","21","23","24","28","38","46","48","63"]
["Status","Line No","Record Type","SetID","Job Code","Agency","Sub-Agency","Personnel Office ID","Pay Plan","Salary Administration Plan","Salary Grade","Effective Date","Effective Date","Status as of Effective Date","Supervisory Status","FLSA Status","Occupational Series","Functional Class","Official Posn Title Code","Pay Basis","Date Classified","Master Record Number (NFC)","Reason Code","Person Type"]
[" ",5,"000","COMMN","NEW","AG ","11","5035","GS","0000","06","1901-01-01"]
[" ",5,"100"]
[" ",5,"200",null,null,null,null,null,null,null,null,null,"2017-06-01","A","8","E","0203","00","0003","PA","01/01/2017","TEST","NEW","E"]
[" ",5,"210"]
[" ",5,"220"]
[" ",5,"230"]
["STOP"]

{"sheet":"Config","index":5,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["AG - Production COPY","empusda.copy.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["AG - Production","usda.empowhr.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["DHS - Production COPY","empdhs.copy.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["DHS - Production","dhs.empowhr.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["DOJ - Production COPY","empdoj.copy.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["DOJ - Production  ","doj.empowhr.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["OFA - Production","ofa.empowhr.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["OFA - Production COPY","empofa.copy.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["USDAUAT","empusda.cuat.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["DHSUAT","empdhs.cuat.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["DOJUAT","empdoj.cuat.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["OFAUAT","empofa.cuat.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["USDAQA","empusda.qa.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["DHSQA","empdhs.qa.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["DOJQA","empdoj.qa.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["OFAQA","empofa.qa.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["USDATEST","empusda.test.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["DHSTEST","empdhs.test.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["DOJTEST","empdoj.test.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["OFATEST","empofa.test.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["Training","train.empowhr.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
["Development","empowhr.dev.nfc.usda.gov","https",443,"EMPLOYEE","hr","PT_LOCAL","ENG",10,10]
[]
["CREATE"]
["UPDATE"]

{"sheet":"Required Fields","index":6,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["NFC FIELD / EMPOWHR FIELDS","TRANSLATE VALUES","TRANSLATE DESCRIPTION"]
["SETID"]
["JOB CODE"]
["NFC DEPARTMENT / EMPOWHR AGENCY CODE"]
["NFC AGENCY / EMPOWHR SUBAGENCY"]
["POI"]
["PAY PLAN"]
["SAL ADMIN PLAN"]
["GRADE"]
["EFFECTIVE DATE"]
["NFC OCC SERIES / EMPOWHR OCCUPATIONAL SERIES"]
["NFC POSITION TITLE CD / EMPOWHR OFFICIAL POSN TITLE CODE"]
["DATE CLASSIFIED"]
["EMPOWHR REASON CODE","CHG","Submit to NFC as NEW"]
[null,"INA","Job Code Inactivated"]
[null,"NEW","Add A New Job Code"]
[null,"REA","Reactivate an Inactivated Job Code"]
[null,"UPD","Job Code Data Update"]
[]
["Note: for Update actions, only \"Job Code\", \"Reason Code\", and \"Effective Date\" are required in addition to the data to be updated."]
[]
["In order to alter the status of a jobcode to NFC Ready, required and/or optional fields must be selected in the component interface.   "]

{"sheet":"Translate Values","index":7,"n_rows":116,"n_cols":3,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["FIELDS","TRANSLATE VALUES","TRANSLATE DESCRIPTION"]
["STATUS","A","Active"]
[null,"I","Inactive"]
["MANAGER LEVEL",2,"Supervisor or Manager"]
[null,4,"Supervisor (CSRA)"]
[null,5,"Management Official (CSRA)"]
[null,6,"Leader"]
[null,7,"Team Leader"]
[null,8,"All Other Positions"]
["FLSA STATUS","E","Exempt"]
[null,"N","Nonexempt"]
["PERSON TYPE","C","Contingent Worker"]
[null,"E","Federal Employee"]
[null,"P","Person of Interest"]
["FUNCTIONAL CLASS",0,"Not Applicable"]
[null,11,"Research"]
[null,12,"Research,Contract/Grant Admin"]
[null,13,"Development"]
[null,14,"Test and Evaluation"]
[null,21,"Design"]
[null,22,"Construction"]
[null,23,"Production"]
[null,24,"Install/Operations/Maintenance"]
[null,31,"Data Collect/Process/Analysis"]
[null,32,"Scientific/Technical Info"]
[null,41,"Standards and Specifications"]
[null,42,"Regulatory Enforcement/License"]
[null,51,"Natural Resource Operations"]
[null,81,"Clinical Practice/Counseling"]
[null,91,"Planning"]
[null,92,"Management"]
[null,93,"Teaching/Training"]
[null,94,"Technical Assistance/Consult"]
[null,99,"Other"]
["FUND SOURCE","A","Appropriated Funds"]
[null,"E","External Funds"]
[null,"N","Non-Appropriated Funds"]
[null,"O","Other Funds"]
["OFFICIAL TITLE PREFX","L","Lead"]
[null,"O","Senior"]
[null,"R","Research"]
[null,"S","Supervisory"]
["PARENTHETICAL TITLE","A","Apprentice"]
[null,"B","Data Transcribing"]
[null,"C","Office Automation"]
[null,"D","Data Transcribing"]
[null,"E","Steno/Office Automation"]
[null,"F","Foreman"]
[null,"G","General Foreman"]
[null,"H","Helper"]
[null,"I","Inspector"]
[null,"J","Correctional"]
[null,"K","Supervisor"]
[null,"M","Instructor"]
[null,"N","Trainee"]
[null,"R","Leader"]
[null,"T","Typing"]
[null,"V","Still in School"]
[null,"W","Night"]
[null,"X","Training Leader"]
[null,"Y","Stenography"]
["PATCOB CODE","A","Administrative"]
[null,"B","Blue Collar"]
[null,"C","Clerical"]
[null,"M","Mixed Collar"]
[null,"O","Other White Collar"]
[null,"P","Professional"]
[null,"T","Technical"]
["PAY BASIS","BW","Bi-weekly"]
[null,"FB","Fee Basis"]
[null,"PA","Per Annum"]
[null,"PD","Per Diem"]
[null,"PH","Per Hour"]
[null,"PM","Per Month"]
[null,"PW","Piece Work"]
[null,"SM","Semi-monthly"]
[null,"SY","School Year"]
[null,"WC","Without Compensation"]
["TRANSACTION STATUS","A","NFC Automatic Action"]
[null,"B","Rolled Back"]
[null,"C","Cancelled"]
[null,"E","Payroll Interface Error"]
[null,"F","Ready - Future"]
[null,"H","HCUP Hold"]
[null,"L","Data Load"]
[null,"N","In Progress"]
[null,"P","Sent to NFC"]
[null,"Q","Applied - Loading to Worklist"]
[null,"R","Ready for NFC Transmission"]
[null,"S","Not Applied at NFC"]
[null,"T","Applied at NFC"]
[null,"X","CAMS Only"]
[null,"Z","Non-NFC (Internal)"]
["POSITION LOCATION","A","01-State Office"]
[null,"B","02-Area Office"]
[null,"C","04-Field Office"]
[null,"D","10-MLRA Project Office"]
[null,"E","08-Soil Survey Project Office"]
[null,"F","Field"]
[null,"G","11-Project Office"]
[null,"H","Headquarters"]
[null,"I","15-RC&D Office"]
[null,"J","21-Plant Materials Center"]
[null,"K","64-Regional Office"]
[null,"L","67-National Center"]
[null,"M","68-National Institute"]
[null,"N","75-National Headquarters"]
["EARLY RETIREMENT CODE",1,"Primary Position"]
[null,2,"Secondary Position"]
[null,3,"Foreign Service Position"]
["PROFESSIONAL CATEGORY",1,"Statutory"]
[null,2,"Professional Auditor"]
[null,3,"Other Professional"]
[null,4,"Admin, Tech., Clerical"]
[null,5,"Wage Plan"]
[null,6,"Experts and Consultants"]