{"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,"Position 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_POSITION_MASSLOAD_CI"," "]

{"sheet":"Template","index":2,"n_rows":14,"n_cols":87,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
["Z_POSITION_MASSLOAD_CI"]
[]
[null,null,"Collection","Z_POSITION_MASSLOAD_CI","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","POSITION_DATA","`"]
[null,null,"Property","POSITION_NBR","EFFDT_0","DESCR","BUSINESS_UNIT","DEPTID","JOBCODE","POSN_STATUS","JOB_SHARE","REPORTS_TO","EFF_STATUS","DESCRSHORT","ACTION_REASON","STATUS_DT","BUDGETED_POSN","CONFIDENTIAL_POSN","KEY_POSITION","MAX_HEAD_COUNT_0","UPDATE_INCUMBENTS","LOCATION","MAIL_DROP","PHONE","STD_HOURS","SHIFT","REG_TEMP","BARG_UNIT","SEASONAL","TRN_PROGRAM","LANGUAGE_SKILL","FLSA_STATUS","GVT_WORK_SCHED","GVT_DT_POSN_ESTAB","GVT_COMP_AREA","GVT_COMP_LEVEL","GVT_ORG_TTL_CD","GVT_DRUG_TEST_REQ","GVT_FUND_SOURCE","GVT_INTEL_POSN","GVT_LEO_POSITION","GVT_MOB_POSN_IND","GVT_PROC_INTEG_PSN","GVT_PRESIDENT_APPT","GVT_NTE_DATE","GVT_PAR_NBR","GVT_POSN_LOC","GVT_POSN_OCCUPIED","GVT_POSN_SENS_CD","SECURITY_CLEARANCE","GVT_STAFF_LINE","GVT_LAST_AUDIT_DT","GVT_AUDITED_BY_ID","GVT_OBLIGATED_TO","GVT_OBLIG_EXPIR_DT","GVT_TARGET_GRADE","GVT_FIN_DISCLOSURE","CLASS_INDC","ENCUMBER_INDC","FTE","ENCUMB_SAL_OPTN","ENCUMB_SAL_AMT","HEALTH_CERTIFICATE","SIGN_AUTHORITY","ADDS_TO_FTE_ACTUAL","SAL_ADMIN_PLAN","INCLUDE_SALPLN_FLG","Z_NFC_POSITION_NBR","Z_NF_CLSIF_ACTN_CD","Z_NF_MAINT_REV_CD","Z_NF_POSN_SENS_CD2","Z_NF_VAC_REV_CD","Z_AS_ACTG_STTN_CD","Z_NF_IP_AGNCY_USE","Z_COPR_ST","ACCT_CD","EMERG_CNTCT_GB","Z_COOP_IND","Z_EMERG_PREP","Z_TELEWORK","Z_CYBERSECURITY_CD","Z_CYBER_SEC_CODE_1","Z_CYBER_SEC_CODE_2","Z_CYBER_SEC_CODE_3","Z_REMOTE_AGR_TYPE_0","Z_MGMT_JOBID"]
[null,null,"Record Type","000","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100","100"]
[null,null,"Field Type","CHARACTER","DATE","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","DATE","CHARACTER","CHARACTER","CHARACTER","NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","DATE","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","DATE","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","DATE","CHARACTER","CHARACTER","DATE","CHARACTER","CHARACTER","CHARACTER","CHARACTER","NUMBER","CHARACTER","SIGNED_NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER"]
[null,null,"Field Length","8","10","30","5","10","6","1","1","8","1","10","3","10","1","1","1","4","1","10","50","24","4.2","1","1","4","1","6","2","1","1","10","2","4","4","1","1","1","1","1","1","1","10","15","1","1","1","1","1","10","11","11","10","2","1","1","1","1.6","3","15.3","1","1","1","4","1","8","1","1","1","1","4","12","1","25","1","1","1","1","2","3","3","3","2","1"]
[null,null,"Key / Required","Y/R","Y/R"," / "," /R"," / "," / "," /R"," /R"," / "," /R"," / "," /R"," / "," /R"," /R"," /R"," / "," /R"," / "," / "," / "," / "," /R"," /R"," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," /R"," /R"," / "," /R"," / "," / "," / "," /R"," / "," /R"," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," / "," /R"," / "," / "," / "," / "," / "]
[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","71","72","73","74","75","76","77","78","79","80","81","82","83"]
["Status","Line No","Record Type","Position Number","Effective Date","Description","Business Unit","Department","Job Code","Position Status","Job Sharing Permitted","Reports To Position Number","Status as of Effective Date","Short Description","Reason Code","Status Date","Budgeted Position","Confidential Position","Key Position","Max Head Count","Update Incumbents","Location Code","Mail Drop ID","Telephone","Standard Hours","Regular Shift","Regular/Temporary","Bargaining Unit","Seasonal","Training Program","Language Required","FLSA Status","Work Schedule","Date Position Established","Competitive Area","Competitive Level","Organization Posn Title Cd","Drug Test (Applicable)","Fund Source","Intelligence Position","LEO/Fire Position","Mobility Position","Procurement Integ Posn","Presidential Appt Posn","Not To Exceed Date","Personnel Action Request Nbr","Position Location","Position Occupied","Sensitivity Code","Security Clearance","Staff/Line Position","Position Audit Date","Position Audited By","Obligated To ID","Obligation Expiration","Target Grade","Financial Disclosure Required","Classified/Unclassified Indc","Encumbrance Indicator","FTE","Encumber Salary Option","Encumber Salary Amount","Health Certificate","Signature Authority","Adds to FTE Actual Count","Salary Administration Plan","Include Salary Plan/Grade","NFC IP #","Classification Action","Classification Review","Computer Sensitivity","Vacancy Review","Accounting Station Code","Agency Use","COPR Act/HHS Title Indicator","Account Code","Emergency Contact","Continuity of Operations Desig","Emergency Preparedness Partici","Telework Eligibility","Cyber Security Category","Cyber Security Code","Cyber Security Code","Cyber Security Code","Remote\\Telework Agreement Type","Program & Project Mgmt Job ID"]
["Template",null,"000",""]
["Template",null,"100",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"```"]

{"sheet":"Data Input","index":3,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Z_POSITION_MASSLOAD_CI"]
["Record Type 000"]
["Position Number"]
["01234"]

{"sheet":"Staging & Submission","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["Z_POSITION_MASSLOAD_CI"]
[null,null,null,"Z_POSITION_MASSLOAD_CI"]
[null,null,null,"POSITION_NBR"]
[null,null,null,"000"]
[null,null,null,"CHARACTER"]
[null,null,null,"8"]
[null,null,null,"Y/R"]
[null,null,null,"1"]
["Status","Line No","Record Type","Position Number"]
[" ",5,"000","01234"]
[" ",5,"100"]
["STOP"]

{"sheet":"Config","index":5,"n_rows":20,"n_cols":10,"rows_kept":20,"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]
["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]
["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]
["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]
["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":90,"n_cols":3,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["FIELDS","TRANSLATE VALUES","TRANSLATE DESCRIPTION"]
["POSITION NBR"]
["EFFECTIVE DATE"]
["BUSINESS UNIT"]
["DEPARTMENT"]
["JOB CODE"]
["REPORTS TO POSITION NUMBER"]
["LOCATION "]
["REGULAR/TEMPORARY","R","Regular"]
[null,"T","Temporary"]
["BARGAINING UNIT"]
["COMPETITIVE LEVEL"]
["DRUG TEST (APPLICABLE)","A","Applicant & Incumbent"]
[null,"C","Comm Motor Vechicle License"]
[null,"F","FAA Regulated"]
[null,"N","Not Applicable"]
[null,"U","Undesignated"]
[null,"V","Volunteer"]
[null,"Y","Incumbent Only"]
["POSITION OCCUPIED",1,"Competitive"]
[null,2,"Excepted"]
[null,3,"SES General"]
[null,4,"SES Career Reserved"]
["SENSITIVITY CODE",1,"Non Sensitive"]
[null,2,"Non-Critical, Sensitive"]
[null,3,"Critical Sensitive"]
[null,4,"Special Sensitive"]
[null,5,"Moderate Risk"]
[null,6,"High Risk"]
[null,7,"NCS\\High Risk"]
["FINANCIAL DISCLOSURE REQUIRED",0,"Not Required"]
[null,1,"CD 219"]
[null,2,"CD 220"]
[null,3,"OGE 278e Required"]
[null,4,"OGE 450 Required"]
[null,5,"MSPB 849 Required"]
[null,8,"FSA-324 for County"]
[null,9,"450 RAMP"]
[null,"A","RAMP ONLY"]
[null,"B","278 RAMP"]
["CLASSIFICATION ACTION",0,"N/A for this field"]
[null,1,"No Action Required"]
[null,2,"Minor Description Changes"]
[null,3,"Rewrite or New Posn Desc Rqd"]
[null,4,"Position Title Change"]
[null,5,"Occupational Series Change"]
[null,6,"Position Upgraded"]
[null,7,"Position Downgraded"]
[null,8,"New Position"]
[null,9,"Other"]
["CLASSIFICATION REVIEW",0,"N/A for this field"]
[null,1,"Normal Desk Audit"]
[null,2,"Normal Supervisory Audit"]
[null,3,"Normal Paper Review"]
[null,4,"Normal PME/Activity Review"]
[null,5,"Maintenance Desk Audit"]
[null,6,"Maintenance Supervisory Audit"]
[null,7,"Maintenance Paper Review"]
[null,8,"Maintenance Panel Review"]
["COMPUTER SENSITIVITY","C","Computer-ADP"]
[null,"N","NonComputer-ADP"]
["VACANCY REVIEW",0,"Position Action No Vacancy"]
[null,"A","No Change"]
[null,"B","Lower Grade"]
[null,"C","Higher Grade"]
[null,"D","Different Title and/or Series"]
[null,"E","New Position/New FTE"]
["ACCOUNTING STATION CODE"]
["REASON CODE","ABO","Position Abolished"]
[null,"CHG","Submit to NFC as NEW"]
[null,"INA","Position Inactivated"]
[null,"NEW","New Position"]
[null,"REA","Reactivate an Inactivated Posn"]
[null,"UBO","UnAbolish"]
[null,"UPD","Position Data Update"]
["TELEWORK","Y","Eligible"]
[null,"N","Not Eligible"]
["REMOTE/TELEWORK AGREEMENT TYPE ","MW","MW:Mobile Work Agrmt"]
[null,"NN","NN:Non-Teleworker"]
[null,"RW","RW:Remote Work Agrmt"]
[null,"TF","TF:Frequent Routine Agrmt"]
[null,"TP","TP:Periodic Routine Agrmt"]
[null,"TS","TS:Situational Telework Agrmt"]
["PROGRAM AND PROJECT MANAGEMENT JOB IDENTIFIER",1,"1:Program Management"]
[null,2,"2:Project Management"]
[null,3,"3:Program & Project Management"]
[null,4,"4:Not Applicable"]
[" "]
[]
["Note: for Update actions, only \"Position Number\", \"Business Unit\", \"Reason Code\", and \"Effective Date\" are required in addition to the data to be updated."]

{"sheet":"Translate Values","index":7,"n_rows":773,"n_cols":3,"rows_kept":773,"cut":false,"hidden":false,"merged":[]}
["FIELDS","TRANSLATE VALUES","TRANSLATE DESCRIPTION"]
["STATUS","A","Active"]
[null,"I","Inactive"]
["POSITION STATUS","A","Approved"]
[null,"P","Proposed"]
[null,"R","Frozen"]
["REASON CODE","ABO","Position Abolished"]
[null,"CHG","Submit to NFC as NEW"]
[null,"INA","Position Inactivated"]
[null,"NEW","New Position"]
[null,"REA","Reactivate an Inactivated Posn"]
[null,"UBO","UnAbolish"]
[null,"UPD","Position Data Update"]
["REGULAR SHIFT","1","1st"]
[null,"2","2nd"]
[null,"3","3rd"]
[null,"C","Compressed"]
[null,"N","Not Applicable"]
[null,"R","Rotating"]
["REG/TEMP","R","Regular"]
[null,"T","Temporary"]
["CLASSIFIED/UNCLASSIFIED INDICATOR","B","All"]
[null,"C","Classified"]
[null,"T","Temporary"]
[null,"U","Unclassified"]
["ENCUMBRANCE INDICATOR","I","Encumber Immediately"]
[null,"N","No Encumbrance"]
[null,"R","Encumber on Requisition"]
["SIGNATURE AUTHORITY","1","Credit Competence"]
[null,"2","Signature Competence"]
[null,"3","Procuration"]
["PRE-ENCUMBRANCE INDICATOR","I","Encumber Immediately"]
[null,"N","No Encumbrance"]
[null,"R","Encumber on Requisition"]
["CLASSIFIED INDICATOR","B","All"]
[null,"C","Classified"]
[null,"T","Temporary"]
[null,"U","Unclassified"]
["HEALTH CERTIFICATE","1","Full Health Check"]
[null,"2","Eye Check"]
[null,"3","Ear Check"]
[null,"4","Radiation Check"]
["BARGAINING UNIT","1","Bargaining Unit 1"]
[null,"2","Bargaining Unit 2"]
["FLSA STATUS","E","Exempt"]
[null,"N","Nonexempt"]
["DRUG TEST (IF APPLICABLE)","A","Applicant & Incumbent"]
[null,"C","Comm Motor Vehicle License"]
[null,"N","Not Applicable"]
[null,"U","Undesignated"]
[null,"Y","Incumbent Only"]
["POSITION SCHEDULE","0","Excepted, Not A, B or C"]
[null,"A","Schedule A"]
[null,"B","Schedule B"]
[null,"C","Schedule C"]
["GRADE BASIS","1","Review When Vacant"]
[null,"2","Impact of the Person"]
[null,"3","Supervisory Posn Supp by GSSG"]
[null,"4","Super Posn Supp by Prgm Duties"]
[null,"5","Research Grade Evaluation Guid"]
[null,"6","Policy Anal Grade Eval Guide"]
[null,"7","Eqp Dev Grd Eval Guide"]
[null,"8","Agency Use"]
[null,"9","Agency Use"]
[null,"A","Administrative"]
[null,"C","Core"]
[null,"F","Focal Point"]
["ENCUMBER SALARY OPTION","COM","Sum of Default Components"]
[null,"MAX","Salary Grade Maximum"]
[null,"MID","Salary Grade Midpoint"]
[null,"MIN","Salary Grade Minimum"]
[null,"STP","Salary Step"]
[null,"USR","User Specified Amount"]
["CLASSIFICATION ACTION","0","N/A for this field"]
[null,"1","No Action Required"]
[null,"2","Minor Description Changes"]
[null,"3","Rewrite or New Posn Desc Rqd"]
[null,"4","Position Title Change"]
[null,"5","Occupational Series Change"]
[null,"6","Position Upgraded"]
[null,"7","Position Downgraded"]
[null,"8","New Position"]
[null,"9","Other"]
["CLASSIFICATION REVIEW","0","N/A for this field"]
[null,"1","Normal Desk Audit"]
[null,"2","Normal Supervisory Audit"]
[null,"3","Normal Paper Review"]
[null,"4","Normal PME/Activity Review"]
[null,"5","Maintenance Desk Audit"]
[null,"6","Maintenance Supervisory Audit"]
[null,"7","Maintenance Paper Review"]
[null,"8","Maintenance Panel Review"]
["VACANCY REVIEW","0","Position Action No Vacancy"]
[null,"A","No Change"]
[null,"B","Lower Grade"]
[null,"C","Higher Grade"]
[null,"D","Different Title and/or Series"]
[null,"E","New Position/New FTE"]
["COMPUTER SENSITIVITY","C","Computer-ADP"]
[null,"N","NonComputer-ADP"]
["FINANCIAL DISCLOSURE REQUIRED","0","Not Required"]
[null,"1","CD 219"]
[null,"2","CD 220"]
[null,"3","SF 278 Required"]
[null,"4","OGE 450 Required"]
[null,"5","MSPB 849 Required"]
[null,"8","278RAMP"]
[null,"9","450RAMP"]
[null,"A","RAMP ONLY"]
["FUND SOURCE","A","Appropriated Funds"]
[null,"E","External Funds"]
[null,"N","Non-Appropriated Funds"]
[null,"O","Other Funds"]
["LEO/FIRE POSITION","A","LEO Posn - pay under 7A FLSA"]
[null,"N","Not Applicable"]
[null,"Y","LEO Posn - pay under 7K FLSA"]
["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"]
["POSITION OCCUPIED","1","Competitive"]
[null,"2","Excepted"]
[null,"3","SES General"]
[null,"4","SES Career Reserved"]
["SENSITIVITY CODE","1","Non Sensitive"]
[null,"2","Non-Critical, Sensitive"]
[null,"3","Critical Sensitive"]
[null,"4","Special Sensitive"]
[null,"5","Moderate Risk"]
[null,"6","High Risk"]
["WORK SCHEDULE","B","Baylor Plan"]
[null,"F","Full Time"]
[null,"G","Full Time Seasonal"]
[null,"I","Intermittent"]
[null,"J","Intermittent-Seasonal"]
[null,"P","Part Time"]
[null,"Q","Part-Time Seasonal"]
[null,"S","Part-Time Job Sharer"]
[null,"T","Part-Time Seasonal Job Sharer"]
["SECURITY CLEARANCE","0","Not Required"]
[null,"1","Confidential"]
[null,"2","Secret"]
[null,"3","Top Secret"]
[null,"4","Sensitive Compartmented Info"]
[null,"5","Q Sensitive"]
[null,"6","Q Non-Sensitive"]
[null,"7","L (Atomic Energy Act)"]
[null,"8","Other"]
[null,"9","National Agency Check & Inq"]
[null,"A","Public Trust"]
[null,"B","Natl Agcy Chck w/ Law & Credit"]
["COPR STATUS","C","Title 42 Regular Fellows Train"]
[null,"D","Title 38 Non-Market Pay Ind."]
[null,"N","No"]
[null,"Y","Yes"]
["CONTINUITY OF OPERATIONS DESIGNEE","Y","Participant"]
[null,"N","Non-Participant"]
["EMERGENCY PREPAREDNESS PARTICIPANT","Y","Participant"]
[null,"N","Non-Participant"]
["TELEWORK","Y","Eligible"]
[null,"N","Not Eligible"]
["CYBERSECURITY CODES 1,2 and 3 Valid from 12/01/2016","000","NOT APPLICABLE"]
[null,"111","ALL SOURCE ANALYST - ALL-SOURCE ANALYSIS"]
[null,"112","MISSION ASSESSMENT SPECIALIST - ALL-SOURCE ANALYSIS"]
[null,"121","EXPLOITATION ANALYST - EXPLOITATION ANALYSIS"]
[null,"131","TARGET DEVELOPER - TARGETS"]
[null,"132","TARGET NETWORK ANALYST - TARGETS"]
[null,"141","WARNING ANALYSTS - THREAT ANALYSIS"]
[null,"151","MULTI-DISCIPLINED LANGUAGE ANALYST - LANGUAGE ANALYST"]
[null,"211","FORENSICS ANALYST - DIGITAL FORENSICS"]
[null,"212","CYBER DEFENSE FORENSICS ANALYST - DIGITAL FORENSICS"]
[null,"221","CYBER CRIME INVESTIGATOR - CYBER INVESTIGATION"]
[null,"311","ALL SOURCE-COLLECTION MANAGER-COLLECTION OPERATIONS"]
[null,"312","ALL SOURCE-COLLECTION REQUIREMENTS MANAGER-COLLECTION OPERATIONS"]
[null,"321","CYBER OPERATOR - CYBER OPERATIONS"]
[null,"331","CYBER INTEL PLANNER - CYBER OPERATIONAL PLANNING"]
[null,"332","CYBER OPS PLANNER - CYBER OPERATIONAL PLANNING"]
[null,"333","PARTNER INTEGRATION PLANNER - CYBER OPERATIONAL PLANNING"]
[null,"411","TECHNICAL SUPPORT ANALYST - CUSTOMER SERVICE & TECHNICAL SUPPPORT"]
[null,"421","DATABASE ADMINISTRATOR - DATABASE ADMINISTRATION"]
[null,"422","DATABASE ANALYST - DATA ADMINISTRATION"]
[null,"431","KNOWLEDGE MANAGER - KNOWLEDGE MANAGEMENT"]
[null,"441","NETWORK OPERATIONS SPECIALIST - NETWORK SERVICES"]
[null,"451","SYSTEM ADMINISTRATOR - SYSTEM ADMINISTRATION"]
[null,"461","SYSTEMS SECURITY ANALYST - SYSTEMS ANALYSIS"]
[null,"511","CYBER DEFENSE ANALYST - CYBER DEFENSE ANALYSIS"]
[null,"521","CYBER DEFENSE INFRASTRUCTURE SUPPORT SPECIALIST"]
[null,"531","CYBER DEFENSE INCIDENCE RESPONDER - INCIDENCE RESPONSE"]
[null,"541","VULNERABILITY ASSESSMENT ANALYST"]
[null,"611","AUTHORIZING OFFICIAL/DESIGNATING REPRESENTATIVE - RISK MANAGEMENT"]
[null,"612","SECURITY CONTROL ASSESSOR - RISK MANAGEMENT"]
[null,"621","SOFTWARE DEVELOPER - SOFTWARE DEVELOPMENT"]
[null,"622","SECURE SOFTWARE ASSESSOR - SOFTWARE DEVELOPMENT"]
[null,"631","INFORMATION SYSTEMS SECURITY DEVELOPER - SYSTEMS DEVELOPMENT"]
[null,"632","SYSTEMS DEVELOPER - SYSTEMS DEVELOPMENT"]
[null,"641","SYSTEMS REQUIREMENTS PLANNER - SYSTEMS REQUIREMENTS PLANNING"]
[null,"651","ENTERPRISE ARCHITECTURE - SYSTEMS ARCHITECTURE"]
[null,"652","SECURITY ARCHITECT - SYSTEMS ARCHITECTURE"]
[null,"661","RESEARCH & DEVELOPMENT SPECIALIST - TECHNOLOGY R&D"]
[null,"671","SYSTEM TESTING & EVALUATION SPECIALIST - TEST & EVALUATION"]
[null,"711","CYBER INSTRUCTIONAL CURRICULUM DEVELOPER"]
[null,"712","CYBER INSTRUCTOR - TRAINING, EDUCATION & AWARENESS"]
[null,"722","INFORMATION SYSTEMS SECURITY MANAGER"]
[null,"723","COMSEC MANAGER - CYBERSECURTY MANAGEMENT"]
[null,"731","CYBER LEGAL ADVISOR - LEGAL ADVICE & ADVOCACY"]
[null,"732","PRIVACY COMPLIANCE MANAGER - LEGAL ADVICE & ADVOCACY"]
[null,"751","CYBER WORKFORCE DEVELOPER & MANAGER"]
[null,"752","CYBER POLICY & STRATEGY PLANNER - STRATEGIC PLANNING & POLICY"]
[null,"801","PROGRAM MANAGER - ACQUISITION & PROGRAM/PROJECT MANAGEMENT"]
[null,"802","IT PROJECT MANAGER - ACQUISITION & PROGRAM/PROJECT MANAGEMENT"]
[null,"803","PRODUCT SUPPORT MANAGER"]
[null,"804","IT INVESTMENT/PORTFOLIO MANAGER"]
[null,"805","IT PROGRAM AUDITOR - ACQUISITION & PROGRAM/PROJECT MANAGEMENT"]
[null,"901","EXECUTIVE CYBER LEADERSHIP - EXECUTIVE CYBER LEADERSHIP"]
["CYBERSECURITY prior to 12/01/2016","00","Not Applicable"]
[null,"10","Analyze"]
[null,"11","All Source Intelligence"]
[null,"12 ","Exploitation Analysis"]
[null,"13 ","Targets"]
[null,"14 ","Threat Analysis"]
[null,"20","Investigate"]
[null,"21 ","Digital Forensics"]
[null,"22 ","Investigation"]
[null,"30","Collect and Operate"]
[null,"31","Collection Operations "]
[null,"32","Cyber Operations"]
[null,"33","Cyber Operations Planning"]
[null,"40","Operate and Maintain"]
[null,"41 ","Customer Service and Technical Support "]
[null,"42 ","Data Administration"]
[null,"43 ","Knowledge Management"]
[null,"44 ","Network Services"]
[null,"45 ","System Administration"]
[null,"46 ","Systems Security Analysis "]
[null,"50","Protect and Defend"]
[null,"51 ","Computer Network Defense (CND) Analysis"]
[null,"52","Computer Network Defense (CND) Infrastructure Support"]
[null,"53 ","Incident Response"]
[null,"54","Vulnerability Assessment and Management "]
[null,"60","Securely Provision "]
[null,"61 ","Information Assurance (IA) Compliance"]
[null,"62","Software Assurance and Security Engineering"]
[null,"63 ","Systems Development"]
[null,"64 ","Systems Requirements Planning"]
[null,"65 ","Systems Security Architecture"]
[null,"66 ","Technology Research and Development"]
[null,"67 ","Test and Evaluation"]
[null,"70 ","Oversight and Development"]
[null,"71 ","Education and Training"]
[null,"72 ","Information Systems Security Operations (Information Systems Security Officer [ISSO]) "]
[null,"73 ","Legal Advice and Advocacy"]
[null,"74","Security Program Management (Chief Information Security Officer [CISO])"]
[null,"75 ","Strategic Planning and Policy Development "]
[null,"80 ","Cybersecurity Program/Project Management "]
[null,"90 ","Cybersecurity Supervision, Management, and Leadership "]
["REMOTE/TELEWORK AGREEMENT TYPE ","NN","Non-Teleworker"]
[null,"RW","Remote Work Agreement"]
[null,"TF","Frequent Routine Telework Agreement"]
[null,"TP","Periodic Routine Telework Agreement"]
[null,"TS","Situational Telework Agreement"]
["PROGRAM AND PROJECT MANAGEMENT JOB IDENTIFIER","1","Program Management"]
[null,"2","Project Management"]
[null,"3","Program and Project Management"]
[null,"4","Not Applicable"]
["LANGUAGE REQUIRED","A0","Achinese"]
[null,"A1","Albanian-Gheg"]
[null,"A2","Albanian-Tosk"]
[null,"A3","Aleut"]
[null,"A4","Apache"]
[null,"A5","Arabic-Iraqi"]
[null,"A6","Arabic-Maghrebi"]
[null,"A7","Assamese"]
[null,"A8","Azerbaijani, North"]
[null,"A9","Azerbaijani, South"]
[null,"AB","Albanian"]
[null,"AD","Arabic (Modern Standard)"]
[null,"AE","Arabic-Egyptian"]
[null,"AF","Afrikaans"]
[null,"AG","Adigey"]
[null,"AH","Acholi"]
[null,"AJ","Arabic-Classical"]
[null,"AK","Arabic-Jordanian"]
[null,"AL","Arabic-Libyan"]
[null,"AM","Amharic"]
[null,"AN","Arabic-Peninsula"]
[null,"AP","Arabic-Syrian"]
[null,"AQ","Arabic-Lebanese"]
[null,"AR","Armenian"]
[null,"AS","American Sign Language"]
[null,"AT","Aramaic"]
[null,"AU","Arabic-Yemeni"]
[null,"AV","Arabic-Sudanese"]
[null,"AW","Avar"]
[null,"AX","Azerbaijani"]
[null,"AY","Aymara"]
[null,"B0","Beti"]
[null,"B1","Bhili"]
[null,"B2","Blackfoot"]
[null,"B3","Brahui"]
[null,"B4","Bulgarian"]
[null,"B5","Burushaski"]
[null,"B6","Baule"]
[null,"BB","Bahnar"]
[null,"BC","Akposso"]
[null,"BD","Balinese"]
[null,"BE","Beja"]
[null,"BF","Batak"]
[null,"BG","Bassa-Kru"]
[null,"BH","Baule"]
[null,"BJ","Bamilike"]
[null,"BK","Bakweri"]
[null,"BL","Belorussian"]
[null,"BM","Bemba"]
[null,"BO","Bengali"]
[null,"BP","Bashkir"]
[null,"BQ","Basque"]
[null,"BR","Berber"]
[null,"BS","Arabic-Moroccan"]
[null,"BT","Baluchi"]
[null,"BU","Burmese"]
[null,"BV","Bihari"]
[null,"BW","Arabic-Tunisian"]
[null,"BX","Breton"]
[null,"BZ","Bantu"]
[null,"C0","Cajun"]
[null,"C1","Cherokee"]
[null,"C2","Chiga"]
[null,"C3","Chinese-Gan"]
[null,"C4","Chinese-Hsiang"]
[null,"C5","Choctaw"]
[null,"C6","Chuvash"]
[null,"C7","Comorian"]
[null,"C8","Cree"]
[null,"C9","Chinese-Wu"]
[null,"CA","Cambodian"]
[null,"CB","Catalan"]
[null,"CC","Chinese (Cantonese)"]
[null,"CD","South Min"]
[null,"CE","Buginese-Makassarese"]
[null,"CF","Chinese-Fukienese"]
[null,"CG","Bicol"]
[null,"CH","Chinese-Hakka"]
[null,"CJ","Guamanian"]
[null,"CK","Chechen"]
[null,"CL","Coptic"]
[null,"CM","Chinese (Mandarin)"]
[null,"CN","Chinese-Anhwei"]
[null,"CP","Cornish"]
[null,"CQ","Chinese-Fuchow"]
[null,"CR","Amashi"]
[null,"CS","Chinese-Wu"]
[null,"CT","Chinese-Toishan"]
[null,"CU","Bini"]
[null,"CV","Chukchi"]
[null,"CW","T-Ung"]
[null,"CY","Chokwe"]
[null,"CZ","Czech"]
[null,"D0","Dakota"]
[null,"D1","Dimli"]
[null,"D2","Dogri-Kangri"]
[null,"DA","Danish"]
[null,"DB","Djerma-Songhai"]
[null,"DC","Karachai-Balkhar"]
[null,"DD","Mpongwe"]
[null,"DE","Sundanese"]
[null,"DF","Syriac"]
[null,"DG","Arabic-Gulf"]
[null,"DH","Arabic-Algerian"]
[null,"DJ","Dinka"]
[null,"DK","Dzongkha"]
[null,"DL","Duala"]
[null,"DR","Chinese-Standard"]
[null,"DU","Dutch"]
[null,"DV","Divehi"]
[null,"DW","Dutch-Creole"]
[null,"DZ","North American"]
[null,"E0","English Caribbean Creole"]
[null,"EA","Old English"]
[null,"EB","Kumbo / Lamnso"]
[null,"EC","Bassa (Camaroons)"]
[null,"EF","Efik"]
[null,"EK","Eskimo"]
[null,"EL","Esperanto"]
[null,"EN","English"]
[null,"ES","Estonian"]
[null,"EW","Ewe"]
[null,"EX","Ewondo"]
[null,"EZ","South American"]
[null,"F0","French Creole"]
[null,"F1","Futnian"]
[null,"F2","Fuuta Jalon"]
[null,"F3","Fang"]
[null,"FA","Farsi (Persian)"]
[null,"FB","Akan"]
[null,"FC","Old French"]
[null,"FD","Faroese"]
[null,"FE","Frisian"]
[null,"FG","Fijian"]
[null,"FL","Flemish"]
[null,"FM","Formosan"]
[null,"FQ","Fon"]
[null,"FR","French"]
[null,"FS","Finish"]
[null,"FV","Fulani"]
[null,"FZ","West European"]
[null,"G0","Galician"]
[null,"G1","Gilaki"]
[null,"G2","Gogo"]
[null,"G3","Greek (New Testament)"]
[null,"G4","Greek Demotic"]
[null,"G5","Greek Katharevousa"]
[null,"G6","Gusii"]
[null,"G7","Hadiyya"]
[null,"GA","Galla"]
[null,"GB","Ga"]
[null,"GD","Gothic"]
[null,"GE","German"]
[null,"GF","Irish"]
[null,"GG","Georgian"]
[null,"GH","Old High German"]
[null,"GL","Gaelic"]
[null,"GN","Scotch-Gaelic"]
[null,"GP","Kapingamarangi"]
[null,"GQ","Gondi"]
[null,"GR","Greek"]
[null,"GS","German-Swiss"]
[null,"GT","German-Bavarian"]
[null,"GU","Guarani"]
[null,"GW","Gujarati"]
[null,"GX","Fana"]
[null,"GZ","Sub Sahara African"]
[null,"H0","Hawaiian Creole"]
[null,"H1","Haya"]
[null,"H2","Ho"]
[null,"H3","Hopi"]
[null,"HA","Hawaiian"]
[null,"HC","Haitian-Creole"]
[null,"HE","Hebrew"]
[null,"HI","Hindi"]
[null,"HN","Hindustani"]
[null,"HR","Herero"]
[null,"HS","Hausa"]
[null,"HU","Hungarian"]
[null,"HV","Chavacano"]
[null,"HZ","N Africa/Mideast/Sw Asia"]
[null,"IA","Indian (Kannada)"]
[null,"IH","Indian (Hindi)"]
[null,"IK","Indian (Konkani)"]
[null,"IN","Indian"]
[null,"IS","Luganda"]
[null,"IT","Italian"]
[null,"JA","Japanese"]
[null,"JB","Ibo"]
[null,"JC","Icelandic"]
[null,"JD","Iban"]
[null,"JE","Ibanag"]
[null,"JF","Ila-Tonga"]
[null,"JG","Kambatta"]
[null,"JH","Kanuri"]
[null,"JJ","Ijaw"]
[null,"JK","Italian-Sardinian"]
[null,"JL","Ilocano"]
[null,"JM","Italian-Neapolitan"]
[null,"JR","Jarai"]
[null,"JS","Italian-Sicilian"]
[null,"JV","Javanese"]
[null,"JZ","Continental Eurasian"]
[null,"K0","Kadazan-Dusun"]
[null,"K1","Kamba"]
[null,"K2","Keres"]
[null,"K3","Kiribati"]
[null,"KA","Kanarese"]
[null,"KB","Kashmiri"]
[null,"KC","Karen"]
[null,"KD","Kherwari"]
[null,"KE","Kazakh"]
[null,"KF","Kirundi"]
[null,"KG","Kikongo"]
[null,"KH","Kachin"]
[null,"KI","Kiswahili"]
[null,"KJ","Kikuyu"]
[null,"KK","Kimbundu"]
[null,"KL","Kinyarwanda"]
[null,"KM","Kirghiz"]
[null,"KN","Kituba"]
[null,"KO","Korean"]
[null,"KR","Kashubian"]
[null,"KS","Kissi"]
[null,"KT","Kabre"]
[null,"KU","Kurdish"]
[null,"KV","Kpelle"]
[null,"KW","Krio"]
[null,"KX","Kurukh"]
[null,"KY","Kabyle"]
[null,"KZ","South Asian"]
[null,"L0","Lakota"]
[null,"L1","Lampung"]
[null,"L2","Lanna"]
[null,"L3","Lomwe"]
[null,"L4","Lubu"]
[null,"L5","Luri"]
[null,"L6","Luvale"]
[null,"L7","Luyia"]
[null,"LA","Latvian"]
[null,"LB","Lisu"]
[null,"LD","Ladino"]
[null,"LF","Lolo"]
[null,"LG","Lomongo"]
[null,"LH","Latin (Ecclesiastic)"]
[null,"LI","Lithuanian"]
[null,"LJ","Lingala"]
[null,"LK","Luba Kasai"]
[null,"LL","Lamba"]
[null,"LM","Lunda"]
[null,"LN","Lahnda"]
[null,"LO","Laotian"]
[null,"LP","Lapp"]
[null,"LQ","Luba Katanga"]
[null,"LR","Landsmal"]
[null,"LS","Luganda"]
[null,"LT","Latin"]
[null,"LU","Luo"]
[null,"LV","Loma"]
[null,"LY","Maranao"]
[null,"LZ","Pacific Islands"]
[null,"M0","Macedonian"]
[null,"M1","Makassar"]
[null,"M2","Mazanderani"]
[null,"M3","Meithei"]
[null,"M4","Meru"]
[null,"M5","Muskogee"]
[null,"M6","Mandingo-Bambara"]
[null,"MA","Malay"]
[null,"MB","Mandingo-Dioula"]
[null,"MC","Hmong"]
[null,"MD","Madurese"]
[null,"ME","Maori"]
[null,"MF","Maya"]
[null,"MG","Malagasy"]
[null,"MH","Moro"]
[null,"MJ","Makua"]
[null,"MK","Manx"]
[null,"MM","Marshalese"]
[null,"MN","Malayalam"]
[null,"MP","Maltese"]
[null,"MQ","Mandingo-Malinke"]
[null,"MR","Marathi"]
[null,"MS","Masai"]
[null,"MT","Mende"]
[null,"MU","Minangkabau"]
[null,"MV","Mongolian"]
[null,"MW","Mordvin"]
[null,"MX","Muong"]
[null,"MY","Mossi"]
[null,"MZ","Germanic"]
[null,"N0","Nahuatl"]
[null,"N1","Nauruan"]
[null,"N2","Navajo"]
[null,"N3","Ngbani"]
[null,"N4","None – Yyy"]
[null,"N5","Nung"]
[null,"N6","Nupe"]
[null,"N7","Nyankole"]
[null,"N8","Ogibwa"]
[null,"NA","Old Norse"]
[null,"NB","Niue"]
[null,"ND","Ndebele"]
[null,"NE","Nepalese"]
[null,"NG","Magindanaon"]
[null,"NM","Miskito"]
[null,"NO","Norwegian"]
[null,"NV","Nubian"]
[null,"NX","Nyoro"]
[null,"NY","Nyanja"]
[null,"NZ","Romance"]
[null,"OZ","Indic"]
[null,"P0","Pahari"]
[null,"P1","Paktai"]
[null,"P2","Papago-Pima"]
[null,"P3","Pennsylvania Dutch"]
[null,"PA","Papiamento"]
[null,"PB","Pidgin English"]
[null,"PC","Ponapean"]
[null,"PD","Palauan"]
[null,"PF","Persian-Iranian"]
[null,"PG","Persian-Afghan"]
[null,"PH","Polish"]
[null,"PJ","Punjabi"]
[null,"PK","Old Slavonic"]
[null,"PM","Pali"]
[null,"PN","Pangasinan"]
[null,"PO","Portuguese"]
[null,"PP","Papuan"]
[null,"PQ","Portuguese-Brazilian"]
[null,"PR","Provencal"]
[null,"PS","Pizar Malay"]
[null,"PT","Portuguese-European"]
[null,"PU","Pushtu"]
[null,"PV","Pushtu-Afghan"]
[null,"PW","Pushtu-Peshawari"]
[null,"PX","Pulap"]
[null,"PZ","Slavic"]
[null,"QA","Oriya"]
[null,"QC","Spanish-Caribbean"]
[null,"QE","Arabic (Modern Standard)"]
[null,"QR","Kusaie"]
[null,"QS","Ossetic"]
[null,"QT","Otetela"]
[null,"QV","Pampangan"]
[null,"QW","Arabic-Western"]
[null,"QZ","Indic"]
[null,"R0","Rejang"]
[null,"R1","Rorotongan"]
[null,"R2","Sama"]
[null,"RA","Rajasthani"]
[null,"RB","Santali"]
[null,"RC","Rhaeto-Romance"]
[null,"RD","Sidamo"]
[null,"RF","Sena"]
[null,"RG","Sanskrit"]
[null,"RH","Rhade"]
[null,"RL","Mortlockese"]
[null,"RM","Romany"]
[null,"RN","Rundi"]
[null,"RO","Rumanian"]
[null,"RT","Ruthenian"]
[null,"RU","Russian"]
[null,"RY","Ryukyuan"]
[null,"RZ","Indo-European"]
[null,"S0","Sasak"]
[null,"S1","Soga"]
[null,"S2","Songe"]
[null,"S3","Sylhetti"]
[null,"S4","Sotho"]
[null,"S5","Spanish-American"]
[null,"S6","Spanish-Castilian"]
[null,"SA","Samoan"]
[null,"SB","Sango"]
[null,"SD","Sindhi"]
[null,"SE","Sara"]
[null,"SF","Shan"]
[null,"SG","Shluh"]
[null,"SH","Shona"]
[null,"SI","Swahili"]
[null,"SJ","Singhalese"]
[null,"SK","Slovak"]
[null,"SL","Slovenian"]
[null,"SM","Somali"]
[null,"SN","Soninke"]
[null,"SP","Spanish"]
[null,"SQ","Sedang"]
[null,"SR","Serbo-Croatian"]
[null,"SS","Spanish-Creole"]
[null,"ST","Sukuma-Nyamwezi"]
[null,"SU","Susu"]
[null,"SV","Serer"]
[null,"SW","Swedish"]
[null,"SX","Swati"]
[null,"SZ","Semitic"]
[null,"T0","Tamazight"]
[null,"T1","Tarift"]
[null,"T2","Tetum"]
[null,"T3","Tho"]
[null,"T4","Tiv"]
[null,"T5","Tokelauan"]
[null,"T6","Tuvulan"]
[null,"T7","Tumbuka"]
[null,"T8","Tatar"]
[null,"TA","Tagalog (Philippines)"]
[null,"TB","Tadjik (Tajik)"]
[null,"TD","Tahitian"]
[null,"TE","Telugu"]
[null,"TF","Temne"]
[null,"TG","Taki-Taki"]
[null,"TH","Thai"]
[null,"TI","Tamil (India)"]
[null,"TJ","Tibetan"]
[null,"TK","Tapachula"]
[null,"TL","Tigrinya"]
[null,"TM","Tamil (Ceylon)"]
[null,"TN","Tigre"]
[null,"TP","Tsonga"]
[null,"TQ","Trukese"]
[null,"TR","Tswa"]
[null,"TS","Tswana"]
[null,"TT","Tamachek"]
[null,"TU","Turkish"]
[null,"TV","Tulu"]
[null,"TW","Twi (Ghana)"]
[null,"TY","Tungusu"]
[null,"TZ","Afro-Asian"]
[null,"U0","Unknown"]
[null,"U1","Unspecified-Other – Xxx"]
[null,"UA","Tupi"]
[null,"UB","Turkoman"]
[null,"UC","Tonga -Toi"]
[null,"UJ","Uighur"]
[null,"UK","Ukrainian"]
[null,"UL","Ulithi"]
[null,"UM","Umbundu Or Mbundu"]
[null,"UR","Urdu (Pakistan)"]
[null,"UX","Uzbek"]
[null,"UZ","Sino-Tibetan"]
[null,"VA","Vai"]
[null,"VB","Cebuano"]
[null,"VC","Vietnamese-Central"]
[null,"VH","Hiligaynon"]
[null,"VI","Vietnamese"]
[null,"VQ","Volapuk"]
[null,"VS","Vietnamese-Saigon"]
[null,"VY","Visayan Or Bisayan"]
[null,"W0","Wallisian"]
[null,"WA","Walamo"]
[null,"WB","Wendish"]
[null,"WE","Welsh"]
[null,"WH","Xhosa"]
[null,"WL","Woleai"]
[null,"WQ","Wolof"]
[null,"WS","Wescos"]
[null,"WV","Wa"]
[null,"WW","Waray-Waray"]
[null,"WZ","Baltic"]
[null,"XA","Zenaga"]
[null,"XB","Avestan"]
[null,"XC","Chaldean"]
[null,"XE","Zerba"]
[null,"XK","Kurmanje"]
[null,"XS","Sorani"]
[null,"XU","Zulu"]
[null,"XY","Assyrian"]
[null,"XZ","Artificial"]
[null,"YA","Yakut"]
[null,"YB","Yao (Malawi & Mozambique)"]
[null,"YC","Yao (China)"]
[null,"YD","Chinese-Amoy"]
[null,"YE","Chinese-Swatow"]
[null,"YG","Greek-Ancient"]
[null,"YH","Hebrew-Ancient"]
[null,"YJ","Yiddish"]
[null,"YM","Lahu"]
[null,"YN","Yakan"]
[null,"YP","Yappese"]
[null,"YQ","Yoruba"]
[null,"YS","Sumerian"]
[null,"YW","Malay Pattani"]
[null,"Z0","Zande"]
[null,"Z1","Zapoteco"]
[null,"Z2","Zuni – Zun"]