{
 "currentVersion": 11.1,
 "cimVersion": "3.1.0",
 "id": 5,
 "name": "Firm",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "PI_FIRM_NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "PI_FIRM_NO",
   "type": "esriFieldTypeInteger",
   "alias": "Firm Number",
   "domain": null
  },
  {
   "name": "PI_FIRM_NAME",
   "type": "esriFieldTypeString",
   "alias": "Firm Name",
   "length": 250,
   "domain": null
  },
  {
   "name": "PI_FIRM_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Firm Type",
   "length": 100,
   "domain": {
    "type": "codedValue",
    "name": "PI_FirmTypes",
    "description": "",
    "codedValues": [
     {
      "name": "NURSERY",
      "code": "NURSERY"
     },
     {
      "name": "STOCK DEALER",
      "code": "STOCK DEALER"
     },
     {
      "name": "UNREGISTERED",
      "code": "UNREGISTERED"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PI_FIRM_AGTYPE",
   "type": "esriFieldTypeString",
   "alias": "Firm Agreement Type",
   "length": 100,
   "domain": {
    "type": "codedValue",
    "name": "PI_BN_Firm_ComplianceTypes",
    "description": "",
    "codedValues": [
     {
      "name": "APPLICATION FOR CERTIFICATE OF REGISTRATION",
      "code": "APPLICATION FOR CERTIFICATE OF REGISTRATION"
     },
     {
      "name": "COMPLIANCE AGREEMENT FOR CITRUS GIFT FRUIT FUMIGATION",
      "code": "COMPLIANCE AGREEMENT FOR CITRUS GIFT FRUIT FUMIGATION"
     },
     {
      "name": "COMPLIANCE AGREEMENT / EUROPEAN CORN BORER",
      "code": "COMPLIANCE AGREEMENT / EUROPEAN CORN BORER"
     },
     {
      "name": "COMPLIANCE AGREEMENT FIREWOOD AND UNPROCESSED WOOD PRODUCTS MOVEMENT WITHIN THE STATE OF FLORIDA",
      "code": "COMPLIANCE AGREEMENT FIREWOOD AND UNPROCESSED WOOD PRODUCTS MOVEMENT WITHIN THE STATE OF FLORIDA"
     },
     {
      "name": "COMPLIANCE AGREEMENT / HYDRILLA",
      "code": "COMPLIANCE AGREEMENT / HYDRILLA"
     },
     {
      "name": "COMPLIANCE AGREEMENT / APPLE SNAIL",
      "code": "COMPLIANCE AGREEMENT / APPLE SNAIL"
     },
     {
      "name": "COMPLIANCE AGREEMENT / NEMATODE - CERTIFIED NURSERIES",
      "code": "COMPLIANCE AGREEMENT / NEMATODE - CERTIFIED NURSERIES"
     },
     {
      "name": "COMPLIANCE AGREEMENT / WASHINGTON APPLES AND PEARS",
      "code": "COMPLIANCE AGREEMENT / WASHINGTON APPLES AND PEARS"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PI_FIRM_STATUS",
   "type": "esriFieldTypeString",
   "alias": "Firm Status",
   "length": 100,
   "domain": {
    "type": "codedValue",
    "name": "PI_STATUS",
    "description": "",
    "codedValues": [
     {
      "name": "Active",
      "code": "Active"
     },
     {
      "name": "Delinquent",
      "code": "Delinquent"
     },
     {
      "name": "OB Inspector",
      "code": "OB Inspector"
     },
     {
      "name": "OB Owner",
      "code": "OB Owner"
     },
     {
      "name": "OB Administrative",
      "code": "OB Administrative"
     },
     {
      "name": "Pending",
      "code": "Pending"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PI_FIRM_OWNERNAME",
   "type": "esriFieldTypeString",
   "alias": "Firm Owner Name",
   "length": 250,
   "domain": null
  },
  {
   "name": "PI_FIRM_PHONE",
   "type": "esriFieldTypeString",
   "alias": "Firm Phone Number",
   "length": 20,
   "domain": null
  },
  {
   "name": "PI_FIRM_EMAIL",
   "type": "esriFieldTypeString",
   "alias": "Firm Email",
   "length": 50,
   "domain": null
  },
  {
   "name": "PI_FIRM_MAILINGADD",
   "type": "esriFieldTypeString",
   "alias": "Firm Mailing Address",
   "length": 250,
   "domain": null
  },
  {
   "name": "PI_FIRM_CITY",
   "type": "esriFieldTypeString",
   "alias": "City",
   "length": 150,
   "domain": null
  },
  {
   "name": "PI_FIRM_STATE",
   "type": "esriFieldTypeString",
   "alias": "State",
   "length": 150,
   "domain": {
    "type": "codedValue",
    "name": "StatesList",
    "description": "States List",
    "codedValues": [
     {
      "name": "ALASKA",
      "code": "AK"
     },
     {
      "name": "ALABAMA",
      "code": "AL"
     },
     {
      "name": "ARKANSAS",
      "code": "AR"
     },
     {
      "name": "ARIZONA",
      "code": "AZ"
     },
     {
      "name": "CALIFORNIA",
      "code": "CA"
     },
     {
      "name": "COLORADO",
      "code": "CO"
     },
     {
      "name": "CONNECTICUT",
      "code": "CT"
     },
     {
      "name": "DISTRICT OF COLUMBIA",
      "code": "DC"
     },
     {
      "name": "DELAWARE",
      "code": "DE"
     },
     {
      "name": "FLORIDA",
      "code": "FL"
     },
     {
      "name": "GEORGIA",
      "code": "GA"
     },
     {
      "name": "HAWAII",
      "code": "HI"
     },
     {
      "name": "IOWA",
      "code": "IA"
     },
     {
      "name": "IDAHO",
      "code": "ID"
     },
     {
      "name": "ILLINOIS",
      "code": "IL"
     },
     {
      "name": "INDIANA",
      "code": "IN"
     },
     {
      "name": "KANSAS",
      "code": "KS"
     },
     {
      "name": "KENTUCKY",
      "code": "KY"
     },
     {
      "name": "LOUISIANA",
      "code": "LA"
     },
     {
      "name": "MASSACHUSETTS",
      "code": "MA"
     },
     {
      "name": "MARYLAND",
      "code": "MD"
     },
     {
      "name": "MAINE",
      "code": "ME"
     },
     {
      "name": "MICHIGAN",
      "code": "MI"
     },
     {
      "name": "MINNESOTA",
      "code": "MN"
     },
     {
      "name": "MISSOURI",
      "code": "MO"
     },
     {
      "name": "MISSISSIPPI",
      "code": "MS"
     },
     {
      "name": "MONTANA",
      "code": "MT"
     },
     {
      "name": "NORTH CAROLINA",
      "code": "NC"
     },
     {
      "name": "NORTH DAKOTA",
      "code": "ND"
     },
     {
      "name": "NEBRASKA",
      "code": "NE"
     },
     {
      "name": "NEW HAMPSHIRE",
      "code": "NH"
     },
     {
      "name": "NEW JERSEY",
      "code": "NJ"
     },
     {
      "name": "NEW MEXICO",
      "code": "NM"
     },
     {
      "name": "NEVADA",
      "code": "NV"
     },
     {
      "name": "NEW YORK",
      "code": "NY"
     },
     {
      "name": "OHIO",
      "code": "OH"
     },
     {
      "name": "OKLAHOMA",
      "code": "OK"
     },
     {
      "name": "OREGON",
      "code": "OR"
     },
     {
      "name": "PENNSYLVANIA",
      "code": "PA"
     },
     {
      "name": "RHODE ISLAND",
      "code": "RI"
     },
     {
      "name": "SOUTH CAROLINA",
      "code": "SC"
     },
     {
      "name": "SOUTH DAKOTA",
      "code": "SD"
     },
     {
      "name": "TENNESSEE",
      "code": "TN"
     },
     {
      "name": "TEXAS",
      "code": "TX"
     },
     {
      "name": "UTAH",
      "code": "UT"
     },
     {
      "name": "VIRGINIA",
      "code": "VA"
     },
     {
      "name": "VERMONT",
      "code": "VT"
     },
     {
      "name": "WASHINGTON",
      "code": "WA"
     },
     {
      "name": "WISCONSIN",
      "code": "WI"
     },
     {
      "name": "WEST VIRGINIA",
      "code": "WV"
     },
     {
      "name": "WYOMING",
      "code": "WY"
     },
     {
      "name": "Unknown or Invalid Copes Value",
      "code": "ZZ"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PI_FIRM_ZIP",
   "type": "esriFieldTypeString",
   "alias": "Zip",
   "length": 150,
   "domain": null
  },
  {
   "name": "PI_FIRM_COUNTY",
   "type": "esriFieldTypeString",
   "alias": "County",
   "length": 150,
   "domain": {
    "type": "codedValue",
    "name": "CountyList",
    "description": "County Name List",
    "codedValues": [
     {
      "name": "ALACHUA",
      "code": "ALACHUA"
     },
     {
      "name": "BAKER",
      "code": "BAKER"
     },
     {
      "name": "BAY",
      "code": "BAY"
     },
     {
      "name": "BRADFORD",
      "code": "BRADFORD"
     },
     {
      "name": "BREVARD",
      "code": "BREVARD"
     },
     {
      "name": "BROWARD",
      "code": "BROWARD"
     },
     {
      "name": "CALHOUN",
      "code": "CALHOUN"
     },
     {
      "name": "CHARLOTTE",
      "code": "CHARLOTTE"
     },
     {
      "name": "CITRUS",
      "code": "CITRUS"
     },
     {
      "name": "CLAY",
      "code": "CLAY"
     },
     {
      "name": "COLLIER",
      "code": "COLLIER"
     },
     {
      "name": "COLUMBIA",
      "code": "COLUMBIA"
     },
     {
      "name": "DESOTO",
      "code": "DESOTO"
     },
     {
      "name": "DIXIE",
      "code": "DIXIE"
     },
     {
      "name": "DUVAL",
      "code": "DUVAL"
     },
     {
      "name": "ESCAMBIA",
      "code": "ESCAMBIA"
     },
     {
      "name": "FLAGLER",
      "code": "FLAGLER"
     },
     {
      "name": "FRANKLIN",
      "code": "FRANKLIN"
     },
     {
      "name": "GADSDEN",
      "code": "GADSDEN"
     },
     {
      "name": "GILCHRIST",
      "code": "GILCHRIST"
     },
     {
      "name": "GLADES",
      "code": "GLADES"
     },
     {
      "name": "GULF",
      "code": "GULF"
     },
     {
      "name": "HAMILTON",
      "code": "HAMILTON"
     },
     {
      "name": "HARDEE",
      "code": "HARDEE"
     },
     {
      "name": "HENDRY",
      "code": "HENDRY"
     },
     {
      "name": "HERNANDO",
      "code": "HERNANDO"
     },
     {
      "name": "HIGHLANDS",
      "code": "HIGHLANDS"
     },
     {
      "name": "HILLSBOROUGH",
      "code": "HILLSBOROUGH"
     },
     {
      "name": "HOLMES",
      "code": "HOLMES"
     },
     {
      "name": "INDIAN RIVER",
      "code": "INDIAN RIVER"
     },
     {
      "name": "JACKSON",
      "code": "JACKSON"
     },
     {
      "name": "JEFFERSON",
      "code": "JEFFERSON"
     },
     {
      "name": "LAFAYETTE",
      "code": "LAFAYETTE"
     },
     {
      "name": "LAKE",
      "code": "LAKE"
     },
     {
      "name": "LEE",
      "code": "LEE"
     },
     {
      "name": "LEON",
      "code": "LEON"
     },
     {
      "name": "LEVY",
      "code": "LEVY"
     },
     {
      "name": "LIBERTY",
      "code": "LIBERTY"
     },
     {
      "name": "MADISON",
      "code": "MADISON"
     },
     {
      "name": "MANATEE",
      "code": "MANATEE"
     },
     {
      "name": "MARION",
      "code": "MARION"
     },
     {
      "name": "MARTIN",
      "code": "MARTIN"
     },
     {
      "name": "MIAMI-DADE",
      "code": "MIAMI-DADE"
     },
     {
      "name": "MONROE",
      "code": "MONROE"
     },
     {
      "name": "NASSAU",
      "code": "NASSAU"
     },
     {
      "name": "OKALOOSA",
      "code": "OKALOOSA"
     },
     {
      "name": "OKEECHOBEE",
      "code": "OKEECHOBEE"
     },
     {
      "name": "ORANGE",
      "code": "ORANGE"
     },
     {
      "name": "OSCEOLA",
      "code": "OSCEOLA"
     },
     {
      "name": "OUT OF STATE",
      "code": "OUT OF STATE"
     },
     {
      "name": "PALM BEACH",
      "code": "PALM BEACH"
     },
     {
      "name": "PASCO",
      "code": "PASCO"
     },
     {
      "name": "PINELLAS",
      "code": "PINELLAS"
     },
     {
      "name": "POLK",
      "code": "POLK"
     },
     {
      "name": "PUTNAM",
      "code": "PUTNAM"
     },
     {
      "name": "SANTA ROSA",
      "code": "SANTA ROSA"
     },
     {
      "name": "SARASOTA",
      "code": "SARASOTA"
     },
     {
      "name": "SEMINOLE",
      "code": "SEMINOLE"
     },
     {
      "name": "ST. JOHNS",
      "code": "ST. JOHNS"
     },
     {
      "name": "ST. LUCIE",
      "code": "ST. LUCIE"
     },
     {
      "name": "SUMTER",
      "code": "SUMTER"
     },
     {
      "name": "SUWANNEE",
      "code": "SUWANNEE"
     },
     {
      "name": "TAYLOR",
      "code": "TAYLOR"
     },
     {
      "name": "UNION",
      "code": "UNION"
     },
     {
      "name": "VOLUSIA",
      "code": "VOLUSIA"
     },
     {
      "name": "WAKULLA",
      "code": "WAKULLA"
     },
     {
      "name": "WALTON",
      "code": "WALTON"
     },
     {
      "name": "WASHINGTON",
      "code": "WASHINGTON"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PI_FIRM_COUNTRY",
   "type": "esriFieldTypeString",
   "alias": "Country",
   "length": 150,
   "domain": {
    "type": "codedValue",
    "name": "CountryList",
    "description": "Country List",
    "codedValues": [
     {
      "name": "AFGHANISTAN",
      "code": "AFGHANISTAN"
     },
     {
      "name": "ALGERIA",
      "code": "ALGERIA"
     },
     {
      "name": "ALBANIA",
      "code": "ALBANIA"
     },
     {
      "name": "AMERICAN SAMOA",
      "code": "AMERICAN SAMOA"
     },
     {
      "name": "ANDORRA",
      "code": "ANDORRA"
     },
     {
      "name": "ANGOLA",
      "code": "ANGOLA"
     },
     {
      "name": "ARGENTINA",
      "code": "ARGENTINA"
     },
     {
      "name": "ARMENIA",
      "code": "ARMENIA"
     },
     {
      "name": "ARUBA",
      "code": "ARUBA"
     },
     {
      "name": "ASCENSION ISLAND",
      "code": "ASCENSION ISLAND"
     },
     {
      "name": "AUSTRALIA",
      "code": "AUSTRALIA"
     },
     {
      "name": "AUSTRIA",
      "code": "AUSTRIA"
     },
     {
      "name": "BAHRAIN",
      "code": "BAHRAIN"
     },
     {
      "name": "BANGLADESH",
      "code": "BANGLADESH"
     },
     {
      "name": "BELARUS",
      "code": "BELARUS"
     },
     {
      "name": "BELGIUM",
      "code": "BELGIUM"
     },
     {
      "name": "BELIZE",
      "code": "BELIZE"
     },
     {
      "name": "BENIN",
      "code": "BENIN"
     },
     {
      "name": "BOLIVIA",
      "code": "BOLIVIA"
     },
     {
      "name": "BOSNIA AND HERZEGOVINA",
      "code": "BOSNIA AND HERZEGOVINA"
     },
     {
      "name": "BRAZIL",
      "code": "BRAZIL"
     },
     {
      "name": "BULGARIA",
      "code": "BULGARIA"
     },
     {
      "name": "BURUNDI",
      "code": "BURUNDI"
     },
     {
      "name": "CAMEROON",
      "code": "CAMEROON"
     },
     {
      "name": "CANADA",
      "code": "CANADA"
     },
     {
      "name": "CAPE VERDE IS.",
      "code": "CAPE VERDE IS."
     },
     {
      "name": "CENTRAL AFRICAN REPUBLIC",
      "code": "CENTRAL AFRICAN REPUBLIC"
     },
     {
      "name": "CHAD",
      "code": "CHAD"
     },
     {
      "name": "CHILE",
      "code": "CHILE"
     },
     {
      "name": "CHINA",
      "code": "CHINA"
     },
     {
      "name": "COLUMBIA",
      "code": "COLUMBIA"
     },
     {
      "name": "COMOROS",
      "code": "COMOROS"
     },
     {
      "name": "CONGO (BRAZZAVILLE)",
      "code": "CONGO (BRAZZAVILLE)"
     },
     {
      "name": "COSTA RICA",
      "code": "COSTA RICA"
     },
     {
      "name": "CROATIA",
      "code": "CROATIA"
     },
     {
      "name": "CYPRUS",
      "code": "CYPRUS"
     },
     {
      "name": "CZECHOSLOVAKIA",
      "code": "CZECHOSLOVAKIA"
     },
     {
      "name": "DENMARK",
      "code": "DENMARK"
     },
     {
      "name": "ECUADOR",
      "code": "ECUADOR"
     },
     {
      "name": "EGYPT",
      "code": "EGYPT"
     },
     {
      "name": "EL SALVADOR",
      "code": "EL SALVADOR"
     },
     {
      "name": "EQUATORIAL GUINEA, REPUBLIC",
      "code": "EQUATORIAL GUINEA, REPUBLIC"
     },
     {
      "name": "ETHIOPIA",
      "code": "ETHIOPIA"
     },
     {
      "name": "FALKLAND ISLANDS",
      "code": "FALKLAND ISLANDS"
     },
     {
      "name": "FIJI",
      "code": "FIJI"
     },
     {
      "name": "FINLAND",
      "code": "FINLAND"
     },
     {
      "name": "FRANCE",
      "code": "FRANCE"
     },
     {
      "name": "FRENCH ANTILLES",
      "code": "FRENCH ANTILLES"
     },
     {
      "name": "FRENCH GUIANA",
      "code": "FRENCH GUIANA"
     },
     {
      "name": "FRENCH POLYNESIA",
      "code": "FRENCH POLYNESIA"
     },
     {
      "name": "GABON",
      "code": "GABON"
     },
     {
      "name": "GAMBIA",
      "code": "GAMBIA"
     },
     {
      "name": "GEORGIA",
      "code": "GEORGIA"
     },
     {
      "name": "GERMANY, FEDERAL REPUBLIC OF",
      "code": "GERMANY, FEDERAL REPUBLIC OF"
     },
     {
      "name": "GIBRALTAR",
      "code": "GIBRALTAR"
     },
     {
      "name": "GREECE",
      "code": "GREECE"
     },
     {
      "name": "GREENLAND",
      "code": "GREENLAND"
     },
     {
      "name": "GUADELOUPE",
      "code": "GUADELOUPE"
     },
     {
      "name": "GUAM",
      "code": "GUAM"
     },
     {
      "name": "GUATEMALA",
      "code": "GUATEMALA"
     },
     {
      "name": "GUINEA-BISSAU",
      "code": "GUINEA-BISSAU"
     },
     {
      "name": "GUYANA",
      "code": "GUYANA"
     },
     {
      "name": "HAITI",
      "code": "HAITI"
     },
     {
      "name": "HOLLAND",
      "code": "HOLLAND"
     },
     {
      "name": "HONDURAS",
      "code": "HONDURAS"
     },
     {
      "name": "HONG KONG",
      "code": "HONG KONG"
     },
     {
      "name": "HUNGARY",
      "code": "HUNGARY"
     },
     {
      "name": "ICELAND",
      "code": "ICELAND"
     },
     {
      "name": "INDIA",
      "code": "INDIA"
     },
     {
      "name": "INDONESIA",
      "code": "INDONESIA"
     },
     {
      "name": "IRAN",
      "code": "IRAN"
     },
     {
      "name": "IRELAND",
      "code": "IRELAND"
     },
     {
      "name": "ISRAEL",
      "code": "ISRAEL"
     },
     {
      "name": "ITALY",
      "code": "ITALY"
     },
     {
      "name": "IVORY COAST",
      "code": "IVORY COAST"
     },
     {
      "name": "JAPAN",
      "code": "JAPAN"
     },
     {
      "name": "JORDAN",
      "code": "JORDAN"
     },
     {
      "name": "KENYA",
      "code": "KENYA"
     },
     {
      "name": "KOREA, REPUBLIC OF",
      "code": "KOREA, REPUBLIC OF"
     },
     {
      "name": "KUWAIT",
      "code": "KUWAIT"
     },
     {
      "name": "LEBANON",
      "code": "LEBANON"
     },
     {
      "name": "LOSOTHO",
      "code": "LOSOTHO"
     },
     {
      "name": "LIBERIA",
      "code": "LIBERIA"
     },
     {
      "name": "LIBYA",
      "code": "LIBYA"
     },
     {
      "name": "LIECHTENSTEIN",
      "code": "LIECHTENSTEIN"
     },
     {
      "name": "LUXEMBOURG",
      "code": "LUXEMBOURG"
     },
     {
      "name": "MACAU",
      "code": "MACAU"
     },
     {
      "name": "MACEDONIA",
      "code": "MACEDONIA"
     },
     {
      "name": "MADAGASCAR",
      "code": "MADAGASCAR"
     },
     {
      "name": "MALAYSIA",
      "code": "MALAYSIA"
     },
     {
      "name": "MEXICO",
      "code": "MEXICO"
     },
     {
      "name": "NAMIBIA",
      "code": "NAMIBIA"
     },
     {
      "name": "NETHERLANDS ANTILLES",
      "code": "NETHERLANDS ANTILLES"
     },
     {
      "name": "NEW ZEALAND",
      "code": "NEW ZEALAND"
     },
     {
      "name": "NORTH KOREA",
      "code": "NORTH KOREA"
     },
     {
      "name": "OMAN",
      "code": "OMAN"
     },
     {
      "name": "PALAU",
      "code": "PALAU"
     },
     {
      "name": "PARAGUAY",
      "code": "PARAGUAY"
     },
     {
      "name": "PHILIPPINES",
      "code": "PHILIPPINES"
     },
     {
      "name": "PUERTO RICO",
      "code": "PUERTO RICO"
     },
     {
      "name": "ROMANIA",
      "code": "ROMANIA"
     },
     {
      "name": "SAIPAN",
      "code": "SAIPAN"
     },
     {
      "name": "SAUDI ARABIA",
      "code": "SAUDI ARABIA"
     },
     {
      "name": "SLOVENIA",
      "code": "SLOVENIA"
     },
     {
      "name": "SOUTH AFRICA",
      "code": "SOUTH AFRICA"
     },
     {
      "name": "SRI LANKA",
      "code": "SRI LANKA"
     },
     {
      "name": "ST. PIERRE AND MIQUELON",
      "code": "ST. PIERRE AND MIQUELON"
     },
     {
      "name": "SWAZILAND",
      "code": "SWAZILAND"
     },
     {
      "name": "TANZANIA",
      "code": "TANZANIA"
     },
     {
      "name": "THAILAND",
      "code": "THAILAND"
     },
     {
      "name": "TURKEY",
      "code": "TURKEY"
     },
     {
      "name": "UKRAINE",
      "code": "UKRAINE"
     },
     {
      "name": "UNITED KINGDOM",
      "code": "UNITED KINGDOM"
     },
     {
      "name": "YUGOSLAVIA",
      "code": "YUGOSLAVIA"
     },
     {
      "name": "ZAIRE",
      "code": "ZAIRE"
     },
     {
      "name": "ZIMBABWE",
      "code": "ZIMBABWE"
     },
     {
      "name": "USA",
      "code": "USA"
     },
     {
      "name": "BARBADOS",
      "code": "BARBADOS"
     },
     {
      "name": "DOMINICAN REPUBLIC",
      "code": "DOMINICAN REPUBLIC"
     },
     {
      "name": "CENTRAL AMERICA",
      "code": "CENTRAL AMERICA"
     },
     {
      "name": "SOUTH AMERICA",
      "code": "SOUTH AMERICA"
     },
     {
      "name": "PERSIA",
      "code": "PERSIA"
     },
     {
      "name": "VIETNAM",
      "code": "VIETNAM"
     },
     {
      "name": "AZERBAIJAN",
      "code": "AZERBAIJAN"
     },
     {
      "name": "BAHAMAS",
      "code": "BAHAMAS"
     },
     {
      "name": "ANGUILLA",
      "code": "ANGUILLA"
     },
     {
      "name": "ANTARCTICA",
      "code": "ANTARCTICA"
     },
     {
      "name": "ANTIGUA AND BARBUDA",
      "code": "ANTIGUA AND BARBUDA"
     },
     {
      "name": "BAKER ISLAND",
      "code": "BAKER ISLAND"
     },
     {
      "name": "BERMUDA",
      "code": "BERMUDA"
     },
     {
      "name": "BHUTAN",
      "code": "BHUTAN"
     },
     {
      "name": "BOTSWANA",
      "code": "BOTSWANA"
     },
     {
      "name": "BOUVET ISLAND",
      "code": "BOUVET ISLAND"
     },
     {
      "name": "BRITISH INDIAN OCEAN TERRITORY",
      "code": "BRITISH INDIAN OCEAN TERRITORY"
     },
     {
      "name": "BURKINA FASO",
      "code": "BURKINA FASO"
     },
     {
      "name": "CAMBODIA",
      "code": "CAMBODIA"
     },
     {
      "name": "CAYMAN ISLANDS",
      "code": "CAYMAN ISLANDS"
     },
     {
      "name": "CHRISTMAS ISLAND",
      "code": "CHRISTMAS ISLAND"
     },
     {
      "name": "COCOS(KEELING) ISLANDS",
      "code": "COCOS(KEELING) ISLANDS"
     },
     {
      "name": "CONGO (KINSHASA)",
      "code": "CONGO (KINSHASA)"
     },
     {
      "name": "COOK ISLANDS",
      "code": "COOK ISLANDS"
     },
     {
      "name": "COTE D'IVOIRE",
      "code": "COTE D'IVOIRE"
     },
     {
      "name": "CUBA",
      "code": "CUBA"
     },
     {
      "name": "DJIBOUTI",
      "code": "DJIBOUTI"
     },
     {
      "name": "DOMINICA",
      "code": "DOMINICA"
     },
     {
      "name": "ERITREA",
      "code": "ERITREA"
     },
     {
      "name": "ESTONIA",
      "code": "ESTONIA"
     },
     {
      "name": "FAROE ISLANDS",
      "code": "FAROE ISLANDS"
     },
     {
      "name": "FRENCH SOUTHERN TERRITORIES",
      "code": "FRENCH SOUTHERN TERRITORIES"
     },
     {
      "name": "GAZA STRIP",
      "code": "GAZA STRIP"
     },
     {
      "name": "GHANA",
      "code": "GHANA"
     },
     {
      "name": "GRENADA",
      "code": "GRENADA"
     },
     {
      "name": "GUINEA",
      "code": "GUINEA"
     },
     {
      "name": "HEARD AND MCDONALD ISLANDS",
      "code": "HEARD AND MCDONALD ISLANDS"
     },
     {
      "name": "HOWLAND ISLAND",
      "code": "HOWLAND ISLAND"
     },
     {
      "name": "IRAQ",
      "code": "IRAQ"
     },
     {
      "name": "JAMAICA",
      "code": "JAMAICA"
     },
     {
      "name": "JAN MAYEN ISLAND",
      "code": "JAN MAYEN ISLAND"
     },
     {
      "name": "JARVIS ISLAND",
      "code": "JARVIS ISLAND"
     },
     {
      "name": "JOHNSTON ATOLL",
      "code": "JOHNSTON ATOLL"
     },
     {
      "name": "KAZAKHSTAN",
      "code": "KAZAKHSTAN"
     },
     {
      "name": "KINGMAN REEF",
      "code": "KINGMAN REEF"
     },
     {
      "name": "KYRGYZSTAN",
      "code": "KYRGYZSTAN"
     },
     {
      "name": "LAOS",
      "code": "LAOS"
     },
     {
      "name": "KIRIBATI",
      "code": "KIRIBATI"
     },
     {
      "name": "KOREA, NORTH",
      "code": "KOREA, NORTH"
     },
     {
      "name": "KOREA, SOUTH",
      "code": "KOREA, SOUTH"
     },
     {
      "name": "LATVIA",
      "code": "LATVIA"
     },
     {
      "name": "LESOTHO",
      "code": "LESOTHO"
     },
     {
      "name": "LITHUANIA",
      "code": "LITHUANIA"
     },
     {
      "name": "MALAWI",
      "code": "MALAWI"
     },
     {
      "name": "MARTINIQUE",
      "code": "MARTINIQUE"
     },
     {
      "name": "MONACO",
      "code": "MONACO"
     },
     {
      "name": "MOROCCO",
      "code": "MOROCCO"
     },
     {
      "name": "MALDIVES",
      "code": "MALDIVES"
     },
     {
      "name": "MALI",
      "code": "MALI"
     },
     {
      "name": "MALTA",
      "code": "MALTA"
     },
     {
      "name": "MARSHALL ISLANDS",
      "code": "MARSHALL ISLANDS"
     },
     {
      "name": "MAURITANIA",
      "code": "MAURITANIA"
     },
     {
      "name": "MAURITIUS",
      "code": "MAURITIUS"
     },
     {
      "name": "MICRONESIA",
      "code": "MICRONESIA"
     },
     {
      "name": "MIDWAY ISLANDS",
      "code": "MIDWAY ISLANDS"
     },
     {
      "name": "MOLDOVA",
      "code": "MOLDOVA"
     },
     {
      "name": "MONGOLIA",
      "code": "MONGOLIA"
     },
     {
      "name": "MONTSERRAT",
      "code": "MONTSERRAT"
     },
     {
      "name": "MOZAMBIQUE",
      "code": "MOZAMBIQUE"
     },
     {
      "name": "MYANMAR",
      "code": "MYANMAR"
     },
     {
      "name": "NETHERLANDS",
      "code": "NETHERLANDS"
     },
     {
      "name": "NEW CALEDONIA",
      "code": "NEW CALEDONIA"
     },
     {
      "name": "NICARAGUA",
      "code": "NICARAGUA"
     },
     {
      "name": "NIGERIA",
      "code": "NIGERIA"
     },
     {
      "name": "NAURU",
      "code": "NAURU"
     },
     {
      "name": "NAVASSA ISLAND",
      "code": "NAVASSA ISLAND"
     },
     {
      "name": "NEPAL",
      "code": "NEPAL"
     },
     {
      "name": "NORWAY",
      "code": "NORWAY"
     },
     {
      "name": "NIUE",
      "code": "NIUE"
     },
     {
      "name": "NORFOLK ISLAND",
      "code": "NORFOLK ISLAND"
     },
     {
      "name": "NORTHERN MARIANA ISLANDS",
      "code": "NORTHERN MARIANA ISLANDS"
     },
     {
      "name": "PAKISTAN",
      "code": "PAKISTAN"
     },
     {
      "name": "PANAMA",
      "code": "PANAMA"
     },
     {
      "name": "PERU",
      "code": "PERU"
     },
     {
      "name": "POLAND",
      "code": "POLAND"
     },
     {
      "name": "PORTUGAL",
      "code": "PORTUGAL"
     },
     {
      "name": "QATAR",
      "code": "QATAR"
     },
     {
      "name": "PAPUA NEW GUINEA",
      "code": "PAPUA NEW GUINEA"
     },
     {
      "name": "PALESTINE",
      "code": "PALESTINE"
     },
     {
      "name": "PALMYRA ATOLL",
      "code": "PALMYRA ATOLL"
     },
     {
      "name": "PITCAIRN",
      "code": "PITCAIRN"
     },
     {
      "name": "REUNION",
      "code": "REUNION"
     },
     {
      "name": "RUSSIAN FEDERATION",
      "code": "RUSSIAN FEDERATION"
     },
     {
      "name": "RWANDA",
      "code": "RWANDA"
     },
     {
      "name": "SAN MARINO",
      "code": "SAN MARINO"
     },
     {
      "name": "SAO TOME AD PRINCIPE",
      "code": "SAO TOME AD PRINCIPE"
     },
     {
      "name": "SENEGAL",
      "code": "SENEGAL"
     },
     {
      "name": "ST. KITTS AND NEVIS",
      "code": "ST. KITTS AND NEVIS"
     },
     {
      "name": "ST. LUCIA",
      "code": "ST. LUCIA"
     },
     {
      "name": "ST. VINCENT AND THE GRENADINES",
      "code": "ST. VINCENT AND THE GRENADINES"
     },
     {
      "name": "SAMOA",
      "code": "SAMOA"
     },
     {
      "name": "SERBIA AND MONTENEGRO",
      "code": "SERBIA AND MONTENEGRO"
     },
     {
      "name": "SEYCHELLES",
      "code": "SEYCHELLES"
     },
     {
      "name": "SIERRA LEONE",
      "code": "SIERRA LEONE"
     },
     {
      "name": "SINGAPORE",
      "code": "SINGAPORE"
     },
     {
      "name": "SOLOMON ISLANDS",
      "code": "SOLOMON ISLANDS"
     },
     {
      "name": "SPAIN",
      "code": "SPAIN"
     },
     {
      "name": "SLOVAKIA",
      "code": "SLOVAKIA"
     },
     {
      "name": "SOMALIA",
      "code": "SOMALIA"
     },
     {
      "name": "SOUTH GEORGIA AND SOUTH SANDWICH ISLANDS",
      "code": "SOUTH GEORGIA AND SOUTH SANDWICH ISLANDS"
     },
     {
      "name": "SUDAN",
      "code": "SUDAN"
     },
     {
      "name": "SURINAM",
      "code": "SURINAM"
     },
     {
      "name": "SWEDEN",
      "code": "SWEDEN"
     },
     {
      "name": "SWITZERLAND",
      "code": "SWITZERLAND"
     },
     {
      "name": "SVALBARD AND JAN MAYEN",
      "code": "SVALBARD AND JAN MAYEN"
     },
     {
      "name": "SYRIAN ARAB REPUBLIC",
      "code": "SYRIAN ARAB REPUBLIC"
     },
     {
      "name": "TAIWAN",
      "code": "TAIWAN"
     },
     {
      "name": "TAJIKISTAN",
      "code": "TAJIKISTAN"
     },
     {
      "name": "TIMOR-LESTE",
      "code": "TIMOR-LESTE"
     },
     {
      "name": "TOGO",
      "code": "TOGO"
     },
     {
      "name": "TOKELAU",
      "code": "TOKELAU"
     },
     {
      "name": "TUNISIA",
      "code": "TUNISIA"
     },
     {
      "name": "UGANDA",
      "code": "UGANDA"
     },
     {
      "name": "UNITED ARAB EMIRATES",
      "code": "UNITED ARAB EMIRATES"
     },
     {
      "name": "TONGA",
      "code": "TONGA"
     },
     {
      "name": "TURKMENISTAN",
      "code": "TURKMENISTAN"
     },
     {
      "name": "TURKS AND CAICOS ISLANDS",
      "code": "TURKS AND CAICOS ISLANDS"
     },
     {
      "name": "TUVALU",
      "code": "TUVALU"
     },
     {
      "name": "URUGUAY",
      "code": "URUGUAY"
     },
     {
      "name": "UNITED STATES MINOR OUTLYING ISLANDS",
      "code": "UNITED STATES MINOR OUTLYING ISLANDS"
     },
     {
      "name": "VATICAN CITY",
      "code": "VATICAN CITY"
     },
     {
      "name": "VENEZUELA",
      "code": "VENEZUELA"
     },
     {
      "name": "YEMEN ARAB REPUBLIC",
      "code": "YEMEN ARAB REPUBLIC"
     },
     {
      "name": "UZBEKISTAN",
      "code": "UZBEKISTAN"
     },
     {
      "name": "VANUATU",
      "code": "VANUATU"
     },
     {
      "name": "VIRGIN ISLANDS, BRITISH",
      "code": "VIRGIN ISLANDS, BRITISH"
     },
     {
      "name": "VIRGIN ISLANDS, U.S.",
      "code": "VIRGIN ISLANDS, U.S."
     },
     {
      "name": "WALLIS AND FUTUNA ISLANDS",
      "code": "WALLIS AND FUTUNA ISLANDS"
     },
     {
      "name": "WAKE ISLAND",
      "code": "WAKE ISLAND"
     },
     {
      "name": "WEST BANK",
      "code": "WEST BANK"
     },
     {
      "name": "WESTERN SAHARA",
      "code": "WESTERN SAHARA"
     },
     {
      "name": "ZAMBIA",
      "code": "ZAMBIA"
     },
     {
      "name": "BRUNEI DARUSSALAM",
      "code": "BRUNEI DARUSSALAM"
     },
     {
      "name": "MAYOTTE",
      "code": "MAYOTTE"
     },
     {
      "name": "ST. HELENA",
      "code": "ST. HELENA"
     },
     {
      "name": "NIGER",
      "code": "NIGER"
     },
     {
      "name": "TRINIDAD AND TOBAGO",
      "code": "TRINIDAD AND TOBAGO"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PI_NEMA_NO",
   "type": "esriFieldTypeString",
   "alias": "Nema Number",
   "length": 15,
   "domain": null
  },
  {
   "name": "PI_IFA_NO",
   "type": "esriFieldTypeString",
   "alias": "IFA Number",
   "length": 15,
   "domain": null
  },
  {
   "name": "PI_NOTES",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "length": 250,
   "domain": null
  },
  {
   "name": "BN_EXPIREDATE",
   "type": "esriFieldTypeDate",
   "alias": "Expire Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "PI_DELETEFLAG",
   "type": "esriFieldTypeString",
   "alias": "Delete Flag",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "PI_YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "CERT_EXPIRE",
   "type": "esriFieldTypeDate",
   "alias": "Certificate Experation",
   "length": 8,
   "domain": null
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "PI_FIRM_PHONE2",
   "type": "esriFieldTypeString",
   "alias": "Secondary Phon Number",
   "length": 20,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "UUID_106",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "gdb_ct3_106",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "PI_FIRM_NO",
   "fields": "PI_FIRM_NO",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "DPI_PI_ADMIN.PI_FirmLocations",
   "relatedTableId": 1,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{F1C757A2-C507-4A3F-9B39-D4FF4EE4B4CE}"
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1639746284000
 },
 "serviceItemId": "b1ffa3584903471d8c09f44cdcf2ca7b"
}