{"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":4,"macros":1,"external_links":0,"defined_names":60,"comments":4,"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,"DEPARTMENT_TBL Excel To CI Utility"]
[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.  Please review documentation on NFC's website for more information."]
[]
[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. By default, character fields which are left blank or only contain blanks will not be submitted for update. There is an option to override this setting."]
[]
[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":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Environment","AG - Production COPY"]
[null,"Web Server Machine Name:",{"$f":"IF(ISNA(VLOOKUP(C5 & \"\",ConnectTable,2,FALSE)),\"\", VLOOKUP(C5 & \"\",ConnectTable,2,FALSE))","v":"empusda.copy.nfc.usda.gov"}]
[null,"Protocol:",{"$f":"IF(ISNA(VLOOKUP(C5 & \"\",ConnectTable,3,FALSE)),\"\", VLOOKUP(C5 & \"\",ConnectTable,3,FALSE))","v":"https"}]
[null,"HTTP Port:",{"$f":"IF(ISNA(VLOOKUP(C5 & \"\",ConnectTable,4,FALSE)),\"\", VLOOKUP(C5 & \"\",ConnectTable,4,FALSE))","v":443}]
[null,"Portal:",{"$f":"IF(ISNA(VLOOKUP(C5 & \"\",ConnectTable,5,FALSE)),\"\", VLOOKUP(C5 & \"\",ConnectTable,5,FALSE))","v":"EMPLOYEE"}]
[null,"PeopleSoft Site Name:",{"$f":"IF(ISNA(VLOOKUP(C5 & \"\",ConnectTable,6,FALSE)),\"\", VLOOKUP(C5 & \"\",ConnectTable,6,FALSE))","v":"hr"}]
[null,"Node:",{"$f":"IF(ISNA(VLOOKUP(C5 & \"\",ConnectTable,7,FALSE)),\"\", VLOOKUP(C5 & \"\",ConnectTable,7,FALSE))","v":"hrms"}]
[null,"Language Code:",{"$f":"IF(ISNA(VLOOKUP(C5 & \"\",ConnectTable,8,FALSE)),\"\", VLOOKUP(C5 & \"\",ConnectTable,8,FALSE))","v":"ENG"}]
[null,"Optional Keys:"]
[null,"Chunking Factor:","1"]
[null,"Error Threshold:","1"]
[null,"Submit Blanks as Input:"]
[null,"Action:","CREATE"]
[]
[]
[null,"Action:"]
[null,"Submit Options"]
[null,null," "]
[null,"Allow Blanks:"]
[null,"Z_DEPT_MASSLOAD_CI"]
[null,"Submit Options"]

{"sheet":"Template","index":2,"n_rows":15,"n_cols":47,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
["Z_DEPT_MASSLOAD_CI"]
[]
[null,null,"Collection","Z_DEPT_MASSLOAD_CI","Z_DEPT_MASSLOAD_CI","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","Z_DEPT_TBL_JR","Z_DEPT_TBL_JR","Z_DEPT_TBL_JR","Z_DEPT_PHONE","Z_DEPT_PHONE"]
[null,null,"Property","SETID","DEPTID","EFFDT","COMPANY","SETID_LOCATION","Z_OSC_LVL_2","Z_OSC_LVL_3","Z_OSC_LVL_4","Z_OSC_LVL_5","Z_OSC_LVL_6","Z_OSC_LVL_7","Z_OSC_LVL_8","MANAGER_ID","BUDGET_DEPTID","EFF_STATUS","DESCRSHORT","LOCATION","TAX_LOCATION_CD","MANAGER_POSN","BUDGET_YR_END_DT","BUDGET_LVL","GL_EXPENSE","EEO4_FUNCTION","GVT_DESCR40","GVT_SUB_AGENCY","GVT_PAR_DESCR2","GVT_PAR_DESCR3","GVT_PAR_DESCR4","GVT_PAR_DESCR5","FTE_EDIT_INDC","DEPT_TENURE_FLG","USE_BUDGETS","USE_ENCUMBRANCES","USE_DISTRIBUTION","Z_OFFICE_SYMBOL","MAIL_DROP","Z_FUNCT_AREA","Z_OFFICE_LOC","Z_OFFICE_TYPE","BUILDING","ROOM_NBR","EMAIL_ADDR","PHONE_TYPE","PHONE"]
[null,null,"Record Type","000","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","110","110","110","120","120"]
[null,null,"Field Type","CHARACTER","CHARACTER","DATE","CHARACTER","CHARACTER","CHARACTER","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","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER"]
[null,null,"Field Length","5","10","10","3","5","2","2","4","2","2","2","2","11","10","1","10","10","10","8","4","1","35","2","40","2","40","40","40","40","1","1","1","1","1","30","50","2","9","2","10","30","70","4","24"]
[null,null,"Key / Required","Y/R","Y/R","Y/R"," /R"," / "," /R"," /R"," /R"," /R"," /R"," /R"," /R"," / "," /R"," /R"," / "," / "," / "," / "," / "," /R"," / "," / "," /R"," /R"," / "," / "," / "," / "," /R"," / "," /R"," /R"," /R"," / "," / "," / "," / "," / "," / "," / "," / ","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"]
["Status","Line No","Record Type","SetID","Department","Effective Date","Agency","Location SetID","Org Structure Code 2nd Level","Org Structure Code 3rd Level","Org Structure Code 4th Level","Org Structure Code 5th Level","Org Structure Code 6th Level","Org Structure Code 7th Level","Org Structure Code 8th Level","Manager ID","Budget with Department","Status","Short Description","Location","Tax Location","Manager Position","Budget Yr End Dt","Level","GL Account #-Payroll Expense","EEO4 Function","Description","Sub-Agency","PAR Line 2 Description","PAR Line 3 Description","PAR Line 4 Description","PAR Line 5 Description","FTE Edit Indicator","Can Grant Tenure","Use Comm. Acctg. / Budgeting","Use Encumbrance Processing","Use Actuals Distribution","Office Symbol","Mail Stop","Functional Responsibility","Office Location","Office Type","Office Building #","Office Room Number","Office Email Address","Phone Type","Phone Number"]
["Template",null,"000","LA001",""]
["Template",null,"100",null,null,null,"","","","","","","","","","","",null,"","","","","","D","","","","","","","","","","","","","","","","","",""]
["Template",null,"110",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,"120",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":13,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Z_DEPT_MASSLOAD_CI"]
["Record Type 000","Record Type 100","Record Type 100","Record Type 100","Record Type 100","Record Type 100","Record Type 100","Record Type 100","Record Type 100","Record Type 100","Record Type 100","Record Type 100","Record Type 100"]
["Department","Effective Date","Agency","Org Structure Code 2nd Level","Org Structure Code 3rd Level","Org Structure Code 4th Level","Org Structure Code 5th Level","Org Structure Code 6th Level","Org Structure Code 7th Level","Org Structure Code 8th Level","Status","Description","Sub-Agency"]
["NEW","2017-11-12","LA","02","12","0008","08","00","00","00","A","TALENT ACQUISITION AND CLASSIFICATION BRANCH","LA"]

{"sheet":"Staging & Submission","index":4,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
["Z_DEPT_MASSLOAD_CI"]
[null,null,null,"Z_DEPT_MASSLOAD_CI","Z_DEPT_MASSLOAD_CI","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL","DEPT_TBL"]
[null,null,null,"SETID","DEPTID","EFFDT","COMPANY","Z_OSC_LVL_2","Z_OSC_LVL_3","Z_OSC_LVL_4","Z_OSC_LVL_5","Z_OSC_LVL_6","Z_OSC_LVL_7","Z_OSC_LVL_8","EFF_STATUS","BUDGET_LVL","GVT_DESCR40","GVT_SUB_AGENCY"]
[null,null,null,"000","000","100","100","100","100","100","100","100","100","100","100","100","100","100"]
[null,null,null,"CHARACTER","CHARACTER","DATE","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER"]
[null,null,null,"5","10","10","3","2","2","4","2","2","2","2","1","1","40","2"]
[null,null,null,"Y/R","Y/R","Y/R"," /R"," /R"," /R"," /R"," /R"," /R"," /R"," /R"," /R"," /R"," /R"," /R"]
[null,null,null,"1","2","3","4","6","7","8","9","10","11","12","15","21","24","25"]
["Status","Line No","Record Type","SetID","Department","Effective Date","Agency","Org Structure Code 2nd Level","Org Structure Code 3rd Level","Org Structure Code 4th Level","Org Structure Code 5th Level","Org Structure Code 6th Level","Org Structure Code 7th Level","Org Structure Code 8th Level","Status","Level","Description","Sub-Agency"]
[" ",5,"000","LA001","NEW"]
[" ",5,"100",null,null,"2017-11-12","LA","02","12","0008","08","00","00","00","A","D","TALENT ACQUISITION AND CLASSIFICATION BRANCH","LA"]
[" ",5,"110"]
[" ",5,"120"]
["STOP"]

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

{"sheet":"Required Fields","index":6,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"TO CREATE A DEPTID, THE FOLLOWING FIELDS ARE REQUIRED:"]
[]
[]
[null,"FIELDS","VALUES","TRANSLATE DESCRIPTION"]
[null,"SETID"]
[null,"DEPTID","Use NEW for create"]
[null,"EFFECTIVE DATE"]
[null,"DESCRIPTION"]
[null,"AGENCY"]
[null,"SUB-AGENCY"]
[null,"ORG STRUCTURE CODE 2ND LEVEL"]
[null,"ORG STRUCTURE CODE 3RD LEVEL"]
[null,"ORG STRUCTURE CODE 4TH LEVEL"]
[null,"ORG STRUCTURE CODE 5TH LEVEL"]
[null,"ORG STRUCTURE CODE 6TH LEVEL"]
[null,"ORG STRUCTURE CODE 7TH LEVEL"]
[null,"ORG STRUCTURE CODE 8TH LEVEL"]
[null,"STATUS","I","INACTIVE"]
[null,null,"A","ACTIVE"]
[]
[null,"TO UPDATE A DEPTID, THE FOLLOWING FIELDS ARE REQUIRED IN ADDITION TO THE DATA TO BE UPDATED:"]
[]
[]
[null,"FIELDS","VALUES","TRANSLATE DESCRIPTION"]
[null,"SETID"]
[null,"DEPTID","Use deptid # for update"]
[null,"EFFECTIVE DATE","Must be greater than maximum effective-dated row"]
[]
[null,"TO USE UPDATEDATA FOR A DEPTID, THE FOLLOWING FIELDS ARE REQUIRED IN ADDITION TO THE DATA TO BE UPDATED:"]
[]
[]
[null,"FIELDS","VALUES","TRANSLATE DESCRIPTION"]
[null,"SETID"]
[null,"DEPTID","Use deptid # for update"]
[null,"EFFECTIVE DATE","Must match an existing row"]

{"sheet":"Translate Values","index":7,"n_rows":179,"n_cols":3,"rows_kept":179,"cut":false,"hidden":false,"merged":[]}
["FIELDS","TRANSLATE VALUES","TRANSLATE DESCRIPTION"]
["STATUS","A","Active"]
[null,"I","Inactive"]
["LEVEL","D","Department "]
[null,"J","Jobcode"]
[null,"L","Line Item"]
[null,"N","None"]
[null,"P","Position Number"]
["EEO4 FUNCTION",1,"Financ Adm"]
[null,2,"Strts/Hwys"]
[null,3,"Publ Welfr"]
[null,4,"Police Prt"]
[null,5,"Fire Prtct"]
[null,6,"Natrl Rsrc"]
[null,7,"Hosp/Sanat"]
[null,8,"Health"]
[null,9,"Housing"]
[null,10,"Comm Dvlp"]
[null,11,"Correctns"]
[null,12,"Util/Trans"]
[null,13,"Sanit/Sewg"]
[null,14,"Empl Secur"]
[null,15,"Other"]
[null,99,"Not Countd"]
["FTE EDIT INDICATOR","H","Error"]
[null,"N","No Edit"]
[null,"S","Warning"]
["FUNCTIONAL RESPONSIBILITY",0,"Not Applicable"]
[null,1,"Administrative & Mgmt Servc"]
[null,2,"Agency Leadership"]
[null,3,"Agricultural Marketing"]
[null,4,"Alt Dispute Resolution Program"]
[null,5,"Animal Health/Welfare Oper"]
[null,6,"Asian Long-Horned Beetle"]
[null,7,"Biotechnology"]
[null,8,"Budget/Financial Mgmt"]
[null,9,"Civil Rights"]
[null,10,"Classing"]
[null,11,"Climate Change"]
[null,12,"Commodity Operations"]
[null,13,"Conservation Education"]
[null,14,"Contact Center (Help Desk)"]
[null,15,"Contracting/Procurement"]
[null,16,"COOP"]
[null,17,"Cooperative Forestry"]
[null,18,"Correspondence"]
[null,19,"Economic Analysis"]
[null,20,"Ecosystem Management"]
[null,21,"Enforcement & Compliance"]
[null,22,"Engineering"]
[null,23,"Environmental Analysis"]
[null,24,"Environmental Sciences"]
[null,25,"Ethics"]
[null,26,"Evaluations and Assessments"]
[null,27,"Facility Management"]
[null,28,"Farm Programs"]
[null,29,"Fire and Aviation Management"]
[null,30,"FOIA"]
[null,31,"Food Defense"]
[null,32,"Foreign Affairs"]
[null,33,"Foreign Posts"]
[null,34,"Forest Health Protection"]
[null,35,"Forest Management"]
[null,36,"Forest Management Sciences"]
[null,37,"Grading"]
[null,38,"Human Resources"]
[null,39,"Human Resources Info Systems"]
[null,40,"Import/Export Services"]
[null,41,"Industrial Hygiene/Environ"]
[null,42,"Information Security"]
[null,43,"Information Technology"]
[null,44,"Inspection"]
[null,45,"International Development"]
[null,46,"International Programs"]
[null,47,"International Trade Policy"]
[null,48,"Investigation"]
[null,49,"Lands"]
[null,50,"Law Enforcement & Invest"]
[null,51,"Legal"]
[null,52,"Legislative Affairs"]
[null,53,"Loan Servicing"]
[null,54,"Logistics/Warehousing"]
[null,55,"Mgmt Services (Directives)"]
[null,56,"Methods Develpmnt & Validation"]
[null,57,"Minerals and Geology"]
[null,58,"National Partnership Offic"]
[null,59,"Nat'l Dog Detector"]
[null,60,"Office of Tribal Relations"]
[null,61,"Organic Agriculture"]
[null,62,"Packers & Stockyards"]
[null,63,"Personnel or Physical Security"]
[null,64,"Pest Management"]
[null,65,"Plant Health Operations"]
[null,66,"Plant Inspection"]
[null,67,"Policy/Policy Analysis"]
[null,68,"Pre-Departure"]
[null,69,"Prevention & Release"]
[null,70,"Program Analysis"]
[null,71,"Program Leadership"]
[null,72,"Program Operations"]
[null,73,"Program Support"]
[null,74,"Public Affairs/Ofc of Commu"]
[null,75,"Quality Assurance"]
[null,76,"Quantitative Sciences"]
[null,77,"Rangeland Management"]
[null,78,"Rec, Heritage & Volun Resc"]
[null,79,"Regulatory/Progrm Compliance"]
[null,80,"Research"]
[null,81,"Resource Use Sciences"]
[null,82,"Risk Management"]
[null,83,"Safety & Health"]
[null,84,"Sample Analysis"]
[null,85,"Science Quality Services"]
[null,86,"Shipping"]
[null,87,"SITC"]
[null,88,"Strategic/Wkforce Planning"]
[null,89,"Surveillance"]
[null,90,"Survey & Detection"]
[null,91,"Sustainable Operations"]
[null,92,"Trade"]
[null,93,"Training/Employee Development"]
[null,94,"Treatment"]
[null,95,"Urban & Community Forestry"]
[null,96,"Veterinary"]
[null,97,"Vet Biologics/Diagnostics"]
[null,98,"Wild & Wild and Scenic Rivers"]
[null,99,"Wildlife Health Operations"]
[null,"A1","Laboratory"]
["OFFICE TYPE","00","Not Aplicable"]
[null,"01","Administrative Support"]
[null,"02","Area Office"]
[null,"03","County Office"]
[null,"04","Departmental Management"]
[null,"05","Dispatch Centers"]
[null,"06","District Office"]
[null,"07","Emergency Program"]
[null,"08","Field Office"]
[null,"09","Foreign Posts"]
[null,10,"Import/Export Facility"]
[null,11,"Insect Rearing/ReleaseFacility"]
[null,12,"International Office"]
[null,13,"International Programs"]
[null,14,"JobCorps National Office"]
[null,15,"JobCorps Work Center"]
[null,16,"Laboratory"]
[null,17,"MLRA Project Office"]
[null,18,"National Center"]
[null,19,"National Headquarters"]
[null,20,"National Institute"]
[null,21,"Operations"]
[null,22,"Plant Inspection Station"]
[null,23,"Plant Materials Center"]
[null,24,"Port (Air/Sea)"]
[null,25,"Program Support Office"]
[null,26,"Project Office"]
[null,27,"Ranger/Guard Stations"]
[null,28,"RC&D Office"]
[null,29,"Regional Office"]
[null,30,"Research Facility"]
[null,31,"Research Labs"]
[null,32,"Research Station Headquarters"]
[null,33,"Snow Survey Office"]
[null,34,"Soil Survey Project Office"]
[null,35,"State Office"]
[null,36,"Supervisors Office"]
[null,37,"Technical Support Office"]
[null,38,"Terminal"]
["PHONE TYPE","BUSN","Business"]
[null,"CAMP","Campus"]
[null,"CELL","Mobile"]
[null,"DORM","Dormitory"]
[null,"FAX","FAX"]
[null,"FLEX","Flex. Ph."]
[null,"HOME","Home"]
[null,"MAIN","Main"]
[null,"OTR","Other"]
[null,"PGR1","Pager 1"]
[null,"PGR2","Pager 2"]
[null,"TELX","Telex"]