Docstoc

Dictionary - Excel

Document Sample
Dictionary - Excel Powered By Docstoc
					                                                                                              DMIS ID
                                                                                          Data Dictionary

           Name                                             Definition                                      Size   Data Type                        Source/Values                       Comments
                            Unique identification code assigned by TMA to facilities, catchment
1         DMIS ID                                                                                            4     character                                                           Mandatory Field
                            areas, and other entities.
                            Unique identification code of a treatment facility that reports or has
2         DCW ID                                                                                             5     character                                                           Optional Field
                            reported direct care workload (biometrics) data.
                            Unique identification code of a facility that reports or has reported
3     MEPRS Unit ID                                                                                          6     character                                                           Optional Field
                            MEPRS data.
                                                                                                                               A - Army
                                                                                                                               C - Coast Guard
                                                                                                                               F - Air Force
                                                                                                                               J - Joint Military Organization
                                                                                                                               M - Managed Care Support Contractor
                                                                                                                               N - Navy
4   Facility Service Code   Military service responsible for a treatment facility.                           1     character                                                           Optional Field
                                                                                                                               O - Other Government (i.e., other than DoD)
                                                                                                                               S - Noncatchment Area or Navy Afloat Area
                                                                                                                               T - Uniformed Services Family Health Plan
                                                                                                                               V - Veterans Administration
                                                                                                                               X - Not Applicable; used for DMIS IDs with a Facility
                                                                                                                               Type Code of "Flag"

                                                                                                                               ADMIN
                                                                                                                               AFLOAT
                                                                                                                               ASC (Ambulatory Surgery Centers)
                                                                                                                               CLINIC
                                                                                                                               DECOMM (used for decommissioned Navy ships)
                                                                                                                               DENTAL
                                                                                                                               FLAG
                                                                                                                               HOSP (This should be consistent with the hospitals
                                                                                                                               designated by the Catchment Area Directory)
                                                                                                                               INACT
                            Category of the overall capability of a treatment facility or other entity
5    Facility Type Code                                                                                      6     character   NONCAT (state/country non catchment areas)              Optional Field
                            associated with a DMIS ID.
                                                                                                                               OOTW (an Army code; normally means "Operations
                                                                                                                               Other Than War")
                                                                                                                               SHIP
                                                                                                                               STSF (a designated Specialized Treatment Services
                                                                                                                               Facility)
                                                                                                                               TGRO (TRICARE Global Remote Overseas program)
                                                                                                                               TPR (TRICARE Prime Remote)
                                                                                                                               TSCPCM (TRICARE Support Contractor Primary Care
                                                                                                                               Manager)
                                                                                                                               VETCL (veterinarian clinic)

6   DMIS Facility Name      Name and installation of the treatment facility as assigned by TMA.              30    character                                                           Mandatory Field

7      Facility Name        Distintive designation of a treatment facility.                                  42    character                                                           Mandatory Field

8    Installation Name      Designation of the base on which a treatment facility is located.                35    character                                                           Optional Field




                                                                                                 8/8/2011                                                                                                Page 1
                                                                                                  DMIS ID
                                                                                              Data Dictionary

              Name                                                Definition                                     Size   Data Type                         Source/Values                              Comments

                                                                                                                                    FIPS PUB 10-4, "Countries, Dependencies, Areas of
                                                                                                                                    Special Sovereignty, and Their Principal Administrative
                                                                                                                                    Divisions" April 1995. Also, FIPS PUB 10-4 updates.
      Facility FIPS Country
9                                Code of the country in which a facility is located.                              2     character   See "FIPS Country Codes" tab. This publication may be           Mandatory Field
               Code
                                                                                                                                    found online at http://www.itl.nist.gov/fipspubs/fip10-
                                                                                                                                    4.htm, and the updates at http://earth-
                                                                                                                                    info.nga.mil/gns/html/fips_files.htm.


                                                                                                                                    FIPS PUB 5-2, "Codes for the Identification of the States,
                                                                                                                                    the District of Columbia and the Outlying Areas of the
                                                                                                                                    United States, and Associated Areas" 28 May 1987.
10     Facility State Code       Code of the US state, territory, or possesion in which a facility is located.    2     character                                                                   Optional Field
                                                                                                                                    See "State Codes" tab. This publication may be found
                                                                                                                                    online at http://www.itl.nist.gov/fipspubs/fip5-2.htm.


11     Facility City Name      City in which a facility is located.                                               32    character                                                                   Optional Field
12   Facility 5-Digit ZIP Code Five-digit ZIP Code or APO/FPO of a facility.                                       5    character                                                                   Optional Field
13   Facility 4-Digit ZIP Code Four-digit extension, if provided, to a facility's five-digit ZIP Code.             4    character                                                                   Optional Field
                                                                                                                                    00 - No region
                                                                                                                                    01 - Northeast
                                                                                                                                    02 - Mid-Atlantic
                                                                                                                                    03 - Southeast
                                                                                                                                    04 - Gulf South
                                                                                                                                    05 - Heartland
                                                                                                                                    06 - Southwest
                                                                                                                                    07 - Central
                                                                                                                                    08 - Central
14   Health Service Region       The TRICARE Lead Agent region in which a treatment facility is located.          2     character   09 - Southern California                                        Mandatory Field
                                                                                                                                    10 - Golden Gate
                                                                                                                                    11 - Northwest
                                                                                                                                    12 - Hawaii & Alaska
                                                                                                                                    13 - Europe
                                                                                                                                    14 - Pacific
                                                                                                                                    15 - Latin America & Canada
                                                                                                                                    17 - North (T-Nex)
                                                                                                                                    18 - South (T-Nex)
                                                                                                                                    19 - West (T-Nex)

                                                                                                                                    Y - entity is in the United States, or a territory/possession
                                 Flag indicating that a location is either inside or outside of the United
15        US Flag Code                                                                                            1     character   N - entity is not in the United States, or a                    Mandatory Field
                                 States, or its territories/possesions.
                                                                                                                                    territory/possession

16       DMIS Parent ID          DMIS ID through which a treatment facility reports data.                         4     character                                                                   Optional Field
17      MEPRS Parent ID          DMIS ID through which a treatment facility reports MEPRS data.                   4     character                                                                   Optional Field




                                                                                                     8/8/2011                                                                                                         Page 2
                                                                                             DMIS ID
                                                                                         Data Dictionary

             Name                                            Definition                                    Size   Data Type                         Source/Values                         Comments
                                                                                                                              6002
                                                                                                                              6003
                                                                                                                              6004
                                                                                                                              6005
                                                                                                                              6006
                             Code for the aggregation of two or more significantly overlapping                                6008
                             catchment areas in which at least 25 percent of the population within 40                         6009
18     Service Area Code                                                                                    4     character                                                              Optional Field
                             miles of one treatment facility is also within 40 miles of another                               6010
                             treatment facility.                                                                              6011
                                                                                                                              6012
                                                                                                                              6013
                                                                                                                              6014
                                                                                                                              6015
                                                                                                                              6512
                                                                                                                              18TH
                                                                                                                                                                 NARMC
                                                                                                                              7THMC
                                                                                                                                                                 NAVMED_E
                                                                                                                              ACC
                                                                                                                                                                 NAVMED_W
                                                                                                                              AETC
                                                                                                                                                                 NCA
                                                                                                                              AFDW
                                                                                                                                                                 NHPENSA
                                                                                                                              AFMC
                                                                                                                                                                 NMSC
                                                                                                                              AFSOC
                                                                                                                                                                 NWHSSA
                                                                                                                              AFSPC
                                                                                                                                                                 OPSFORCE
                                                                                                                              AMC
                                                                                                                                                                 OSD
                                                                                                                              BUMED
                                                                                                                                                                 PACAF
                                                                                                                              CENTCOM
                                                                                                                                                                 PHSSA
                                                                                                                              CHSSA
                             Major command or intermediate command to which a treatment facility                                                                 PRMC
19   Facility Command Code                                                                                  8     character   DOD                                                        Optional Field
                             has been assigned.                                                                                                                  SCHSSA
                                                                                                                              EHSSA
                                                                                                                                                                 SEHSSA
                                                                                                                              ERMC
                                                                                                                                                                 SERMC
                                                                                                                              EUCOM
                                                                                                                                                                 SHIPS
                                                                                                                              GPRMC
                                                                                                                                                                 SWHSSA
                                                                                                                              HSC
                                                                                                                                                                 TEACH
                                                                                                                              HSO(JAX)
                                                                                                                                                                 TMA
                                                                                                                              HSO(NOR)
                                                                                                                                                                 USAFA
                                                                                                                              HSO(SD)
                                                                                                                                                                 USAFE
                                                                                                                              JFCOM
                                                                                                                                                                 USCENTAF
                                                                                                                              MTC
                                                                                                                                                                 WRMC
                                                                                                                              NAHSSA
                                                                                                                                                                 XXXX
                                                                                                                              NAMI

      Authorized TRICARE     Flag indicating whether a facility is or has ever been authorized to enroll                      Y - entity is an authorized TRICARE enrollment site
20                                                                                                          1     character                                                             Mandatory Field
      Enrollment Site Code   DoD beneficiaries in the various TRICARE programs.                                               N - entity is not an authorized TRICARE enrollment site

                             Flag indicating whether the DMIS ID is operated under/affiliated with the                        Y - entity is DHP-affiliated
21        DHP Code                                                                                          1     character                                                             Mandatory Field
                             Defense Health Program.                                                                          N - entity is not DHP-affiliated




                                                                                               8/8/2011                                                                                                   Page 3
                                                                                           DMIS ID
                                                                                       Data Dictionary

             Name                                           Definition                                   Size   Data Type                        Source/Values                        Comments
                                                                                                                            A = Army DHP
                                                                                                                            B = Army Civilian Resource Sharing
                                                                                                                            C = Coast Guard
                                                                                                                            D = Army Line Unit
                                                                                                                            F = Air Force DHP
                                                                                                                            G = AF Civilian Resource Sharing
                                                                                                                            I = Inactive
                                                                                                                            J = US Defense Attache Office (USDAO)
                                                                                                                            L = AF Line Unit
                                                                                                                            M = Managed Care Support Contractor
                                                                                                                            N = Navy DHP
       Branch of Service /   Code indicating the DMIS ID's branch of service and source of
22                                                                                                        1     character   O = Other                                               Mandatory Field
         Authority Code      operational authority.
                                                                                                                            Q = Navy Line Unit
                                                                                                                            R = Navy Civilian Resource Sharing
                                                                                                                            S = Non-catchment
                                                                                                                            T = US Family Health Plan (USFHP)
                                                                                                                            V = Veterans Admin
                                                                                                                            X = Administrative
                                                                                                                            1 = Army VA Resource Sharing
                                                                                                                            2 = Navy VA Resource Sharing
                                                                                                                            3 = AF VA Resource Sharing
                                                                                                                            Blank = Unknown

                             Flag indicating whether a Type 2 (organizational) National Provider ID is                      Y - entity requires NPI
23      NPI 2 Required                                                                                    1     character                                                          Mandatory Field
                             required for the entity.                                                                       N - entity does not require NPI
                                                                                                                                                                                   Mandatory if NPI 2
24       NPI 2 Number        National Provider ID                                                         10    character
                                                                                                                                                                                   Required = Y

                             Heath Care Provider Taxonomy Code as maintained by the National                                The Health Care Provider Taxonomy code set may be      Mandatory if NPI 2
25   NPI 2 HIPAA Taxonomy                                                                                 10    character
                             Uniform Claim Committee (NUCC).                                                                found online at http://www.wpc-edi.com/codes/taxonomy. Required = Y




                                                                                             8/8/2011                                                                                                   Page 4
                                                              Country Codes


ISO Country   FIPs Country
   Code           Code                             ISO Country Name                              FIPS Country Name
    AF             AF      AFGHANISTAN                                          AFGHANISTAN
                   AX                                                           AKROTIRI
   AX                      ALAND ISLANDS
   AL              AL      ALBANIA                                              ALBANIA
   DZ              AG      ALGERIA                                              ALGERIA
   AS              AQ      AMERICAN SAMOA                                       AMERICAN SAMOA
   AD              AN      ANDORRA                                              ANDORRA
   AO              AO      ANGOLA                                               ANGOLA
    AI             AV      ANGUILLA                                             ANGUILLA
   AQ              AY      ANTARCTICA                                           ANTARCTICA
   AG              AC      ANTIGUA AND BARBUDA                                  ANTIGUA AND BARBUDA
   AR              AR      ARGENTINA                                            ARGENTINA
   AM              AM      ARMENIA                                              ARMENIA
   AW              AA      ARUBA                                                ARUBA
                   AT      (ISO includes with AUSTRALIA)                        ASHMORE AND CARTIER ISLANDS
    AU             AS      AUSTRALIA                                            AUSTRALIA
    AT             AU      AUSTRIA                                              AUSTRIA
    AZ             AJ      AZERBAIJAN                                           AZERBAIJAN
    BS             BF      BAHAMAS                                              BAHAMAS, THE
    BH             BA      BAHRAIN                                              BAHRAIN
                   FQ      (ISO includes with the US MINOR OUTLYING ISLANDS)    BAKER ISLAND
    BD             BG      BANGLADESH                                           BANGLADESH
    BB             BB      BARBADOS                                             BARBADOS
                   BS                                                           BASSAS DA INDIA
   BY              BO      BELARUS                                              BELARUS
   BE              BE      BELGIUM                                              BELGIUM
   BZ              BH      BELIZE                                               BELIZE
   BJ              BN      BENIN                                                BENIN
   BM              BD      BERMUDA                                              BERMUDA
   BT              BT      BHUTAN                                               BHUTAN
   BO              BL      BOLIVIA, PLURINATIONAL STATE OF                      BOLIVIA
   BQ                      BONAIRE, SINT EUSTATIUS AND SABA
   BA              BK      BOSNIA AND HERZEGOVINA                               BOSNIA AND HERZEGOVINA
   BW              BC      BOTSWANA                                             BOTSWANA
   BV              BV      BOUVET ISLAND                                        BOUVET ISLAND
   BR              BR      BRAZIL                                               BRAZIL
   IO              IO      BRITISH INDIAN OCEAN TERRITORY                       BRITISH INDIAN OCEAN TERRITORY
   BN              BX      BRUNEI DARUSSALAM                                    BRUNEI
   BG              BU      BULGARIA                                             BULGARIA
   BF              UV      BURKINA FASO                                         BURKINA FASO
    BI             BY      BURUNDI                                              BURUNDI
   KH              CB      CAMBODIA                                             CAMBODIA
   CM              CM      CAMEROON                                             CAMEROON
   CA              CA      CANADA                                               CANADA
   CV              CV      CAPE VERDE                                           CAPE VERDE
   KY              CJ      CAYMAN ISLANDS                                       CAYMAN ISLANDS
   CF              CT      CENTRAL AFRICAN REPUBLIC                             CENTRAL AFRICAN REPUBLIC
   TD              CD      CHAD                                                 CHAD
   CL              CI      CHILE                                                CHILE
   CN              CH      CHINA                                                CHINA
   CX              KT      CHRISTMAS ISLAND                                     CHRISTMAS ISLAND
                    IP     (ISO includes with FRANCE)                           CLIPPERTON ISLAND
    CC             CK      COCOS (KEELING) ISLANDS                              COCOS (KEELING) ISLANDS
    CO             CO      COLOMBIA                                             COLOMBIA
    KM             CN      COMOROS                                              COMOROS
    CG             CF      CONGO                                                CONGO, REPUBLIC OF THE
    CD             CG      CONGO, THE DEMOCRATIC REPUBLIC OF THE                CONGO, DEMOCRATIC REPUBLIC OF THE
    CK             CW      COOK ISLANDS                                         COOK ISLANDS
                   CR      (ISO includes with AUSTRALIA)                        CORAL SEA ISLANDS
   CR              CS      COSTA RICA                                           COSTA RICA
    CI              IV     COTE D'IVOIRE                                        COTE D'IVOIRE
   HR              HR      CROATIA                                              CROATIA
   CU              CU      CUBA                                                 CUBA
   CW              UC      CURACAO                                              CURACAO
   CY              CY      CYPRUS                                               CYPRUS
   CZ              EZ      CZECH REPUBLIC                                       CZECH REPUBLIC
   DK              DA      DENMARK                                              DENMARK
                   DX                                                           DHEKELIA




                                                                     8/8/2011                                        Page 5
                                                                Country Codes


ISO Country   FIPs Country
   Code           Code                           ISO Country Name                                   FIPS Country Name
    DJ             DJ        DJIBOUTI                                              DJIBOUTI
    DM             DO        DOMINICA                                              DOMINICA
    DO             DR        DOMINICAN REPUBLIC                                    DOMINICAN REPUBLIC
    EC             EC        ECUADOR                                               ECUADOR
    EG             EG        EGYPT                                                 EGYPT
    SV             ES        EL SALVADOR                                           EL SALVADOR
    GQ             EK        EQUATORIAL GUINEA                                     EQUATORIAL GUINEA
    ER             ER        ERITREA                                               ERITREA
    EE            EN         ESTONIA                                               ESTONIA
    ET            ET         ETHIOPIA                                              ETHIOPIA
                  PJ                                                               ETOROFU, HABOMAI, KUNASHIRI AND SHIKOTAN ISLANDS
                  EU                                                               EUROPA ISLAND
    FK            FK         FALKLAND ISLANDS (MALVINAS)                           FALKLAND ISLANDS (ISLAS MALVINAS)
    FO            FO         FAROE ISLANDS                                         FAROE ISLANDS
    FJ            FJ         FIJI                                                  FIJI
    FI            FI         FINLAND                                               FINLAND
    FR            FR         FRANCE                                                FRANCE
    GF            FG         FRENCH GUIANA                                         FRENCH GUIANA
    PF            FP         FRENCH POLYNESIA                                      FRENCH POLYNESIA
    TF            FS         FRENCH SOUTHERN TERRITORIES                           FRENCH SOUTHERN AND ANTARCTIC LANDS
    GA            GB         GABON                                                 GABON
    GM            GA         GAMBIA                                                GAMBIA, THE
                  GZ         (ISO includes with PALESTINIAN TERRITORY, OCCUPIED)   GAZA STRIP
    GE            GG         GEORGIA                                               GEORGIA
    DE            GM         GERMANY                                               GERMANY
    GH            GH         GHANA                                                 GHANA
    GI            GI         GIBRALTAR                                             GIBRALTAR
                  GO                                                               GLORIOSO ISLANDS
   GR             GR         GREECE                                                GREECE
   GL             GL         GREENLAND                                             GREENLAND
   GD             GJ         GRENADA                                               GRENADA
   GP             GP         GUADELOUPE                                            GUADELOUPE
   GU             GQ         GUAM                                                  GUAM
   GT             GT         GUATEMALA                                             GUATEMALA
   GG             GK         GUERNSEY                                              GUERNSEY
   GN             GV         GUINEA                                                GUINEA
   GW             PU         GUINEA-BISSAU                                         GUINEA-BISSAU
   GY             GY         GUYANA                                                GUYANA
   HT             HA         HAITI                                                 HAITI
   HM             HM         HEARD ISLAND AND MCDONALD ISLANDS                     HEARD ISLAND AND MCDONALD ISLANDS
   VA             VT         HOLY SEE (VATICAN CITY STATE)                         VATICAN CITY
   HN             HO         HONDURAS                                              HONDURAS
   HK             HK         HONG KONG                                             HONG KONG
                  HQ         (ISO includes with US MINOR OUTLYING ISLANDS)         HOWLAND ISLAND
    HU            HU         HUNGARY                                               HUNGARY
    IS            IC         ICELAND                                               ICELAND
    IN            IN         INDIA                                                 INDIA
    ID            ID         INDONESIA                                             INDONESIA
    IR            IR         IRAN, ISLAMIC REPUBLIC OF                             IRAN
    IQ            IZ         IRAQ                                                  IRAQ
    IE            EI         IRELAND                                               IRELAND
    IM            IM         ISLE OF MAN                                           MAN, ISLE OF
     IL           IS         ISRAEL                                                ISRAEL
    IT            IT         ITALY                                                 ITALY
    JM            JM         JAMAICA                                               JAMAICA
                  JN         (ISO includes with SVALBARD)                          JAN MAYEN
    JP            JA         JAPAN                                                 JAPAN
                  DQ         (ISO includes with US MINOR OUTLYING ISLANDS)         JARVIS ISLAND
    JE            JE         JERSEY                                                JERSEY
                  JQ         (ISO includes with US MINOR OUTLYING ISLANDS)         JOHNSTON ATOLL
    JO            JO         JORDAN                                                JORDAN
                  JU                                                               JUAN DE NOVA ISLAND
    KZ            KZ         KAZAKHSTAN                                            KAZAKHSTAN
    KE            KE         KENYA                                                 KENYA
                  KQ         (ISO includes with US MINOR OUTLYING ISLANDS)         KINGMAN REEF
    KI            KR         KIRIBATI                                              KIRIBATI
    KP            KN         KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF                NORTH KOREA
    KR            KS         KOREA, REPUBLIC OF                                    SOUTH KOREA




                                                                      8/8/2011                                                Page 6
                                                                 Country Codes


ISO Country   FIPs Country
   Code           Code                            ISO Country Name                                           FIPS Country Name
    XK             KV        KOSOVO (Temporary Code until ISO assigns permanent Code)   KOSOVO
    KW             KU        KUWAIT                                                     KUWAIT
    KG             KG        KYRGYZSTAN                                                 KYRGYZSTAN
    LA             LA        LAO PEOPLE'S DEMOCRATIC REPUBLIC                           LAOS
    LV             LG        LATVIA                                                     LATVIA
    LB             LE        LEBANON                                                    LEBANON
    LS             LT        LESOTHO                                                    LESOTHO
    LR             LI        LIBERIA                                                    LIBERIA
    LY             LY        LIBYAN ARAB JAMAHIRIYA                                     LIBYA
     LI            LS        LIECHTENSTEIN                                              LIECHTENSTEIN
    LT             LH        LITHUANIA                                                  LITHUANIA
    LU             LU        LUXEMBOURG                                                 LUXEMBOURG
    MO             MC        MACAO                                                      MACAU
    MK             MK        MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF                 MACEDONIA
    MG             MA        MADAGASCAR                                                 MADAGASCAR
    MW             MI        MALAWI                                                     MALAWI
    MY             MY        MALAYSIA                                                   MALAYSIA
    MV             MV        MALDIVES                                                   MALDIVES
    ML             ML        MALI                                                       MALI
    MT             MT        MALTA                                                      MALTA
    MH             RM        MARSHALL ISLANDS                                           MARSHALL ISLANDS
    MQ             MB        MARTINIQUE                                                 MARTINIQUE
    MR             MR        MAURITANIA                                                 MAURITANIA
    MU             MP        MAURITIUS                                                  MAURITIUS
    YT             MF        MAYOTTE                                                    MAYOTTE
    MX             MX        MEXICO                                                     MEXICO
    FM             FM        MICRONESIA, FEDERATED STATES OF                            FEDERATED STATES OF MICRONESIA
                   MQ        (ISO includes with US MINOR OUTLYING ISLANDS)              MIDWAY ISLANDS
    MD             MD        MOLDOVA, REPUBLIC OF                                       MOLDOVA
    MC             MN        MONACO                                                     MONACO
    MN             MG        MONGOLIA                                                   MONGOLIA
    ME             MJ        MONTENEGRO                                                 MONTENEGRO
    MS             MH        MONTSERRAT                                                 MONTSERRAT
    MA             MO        MOROCCO                                                    MOROCCO
    MZ             MZ        MOZAMBIQUE                                                 MOZAMBIQUE
    MM             BM        MYANMAR                                                    BURMA
    NA             WA        NAMIBIA                                                    NAMIBIA
    NR             NR        NAURU                                                      NAURU
                   BQ        (ISO includes with US MINOR OUTLYING ISLANDS)              NAVASSA ISLAND
    NP             NP        NEPAL                                                      NEPAL
    NL             NL        NETHERLANDS                                                NETHERLANDS
                   NT                                                                   NETHERLANDS ANTILLES
   NC              NC        NEW CALEDONIA                                              NEW CALEDONIA
   NZ              NZ        NEW ZEALAND                                                NEW ZEALAND
    NI             NU        NICARAGUA                                                  NICARAGUA
   NE              NG        NIGER                                                      NIGER
   NG              NI        NIGERIA                                                    NIGERIA
   NU              NE        NIUE                                                       NIUE
   NF              NF        NORFOLK ISLAND                                             NORFOLK ISLAND
   MP              CQ        NORTHERN MARIANA ISLANDS                                   NORTHERN MARIANA ISLANDS
   NO              NO        NORWAY                                                     NORWAY
   OM              MU        OMAN                                                       OMAN
   PK              PK        PAKISTAN                                                   PAKISTAN
   PW              PS        PALAU                                                      PALAU
   PS                        PALESTINIAN TERRITORY, OCCUPIED                            (ISO Code includes GAZA STRIP, WEST BANK)
                  LQ         (ISO includes with US MINOR OUTLYING ISLANDS)              PALMYRA ATOLL
    PA            PM         PANAMA                                                     PANAMA
    PG            PP         PAPUA NEW GUINEA                                           PAPUA NEW GUINEA
                  PF                                                                    PARACEL ISLANDS
    PY            PA         PARAGUAY                                                   PARAGUAY
    PE            PE         PERU                                                       PERU
    PH            RP         PHILIPPINES                                                PHILIPPINES
    PN            PC         PITCAIRN                                                   PITCAIRN ISLANDS
    PL            PL         POLAND                                                     POLAND
    PT            PO         PORTUGAL                                                   PORTUGAL
    PR            RQ         PUERTO RICO                                                PUERTO RICO
    QA            QA         QATAR                                                      QATAR
    RE            RE         REUNION                                                    REUNION




                                                                        8/8/2011                                                    Page 7
                                                                Country Codes


ISO Country   FIPs Country
   Code           Code                           ISO Country Name                                  FIPS Country Name
    RO             RO        ROMANIA                                             ROMANIA
    RU             RS        RUSSIAN FEDERATION                                  RUSSIA
    RW             RW        RWANDA                                              RWANDA
    BL             TB        SAINT BARTHLEMY                                     SAINT BARTHELEMY
    SH             SH        SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA        SAINT HELENA, ASCENSION, AND TRISTAN DA CUNHA
    KN             SC        SAINT KITTS AND NEVIS                               SAINT KITTS AND NEVIS
    LC             ST        SAINT LUCIA                                         SAINT LUCIA
    MF             RN        SAINT MARTIN (FRENCH PART)                          SAINT MARTIN
    PM             SB        SAINT PIERRE AND MIQUELON                           SAINT PIERRE AND MIQUELON
    VC             VC        SAINT VINCENT AND THE GRENADINES                    SAINT VINCENT AND THE GRENADINES
    WS             WS        SAMOA                                               SAMOA
    SM             SM        SAN MARINO                                          SAN MARINO
    ST             TP        SAO TOME AND PRINCIPE                               SAO TOME AND PRINCIPE
    SA             SA        SAUDI ARABIA                                        SAUDI ARABIA
    SN             SG        SENEGAL                                             SENEGAL
    RS              RI       SERBIA                                              SERBIA
    SC             SE        SEYCHELLES                                          SEYCHELLES
    SL             SL        SIERRA LEONE                                        SIERRA LEONE
    SG             SN        SINGAPORE                                           SINGAPORE
    SX             NN        SINT MAARTEN (DUTCH PART)                           SINT MAARTEN
    SK             LO        SLOVAKIA                                            SLOVAKIA
     SI             SI       SLOVENIA                                            SLOVENIA
    SB             BP        SOLOMON ISLANDS                                     SOLOMON ISLANDS
    SO             SO        SOMALIA                                             SOMALIA
    ZA             SF        SOUTH AFRICA                                        SOUTH AFRICA
    GS             SX        SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS        SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS
    ES             SP        SPAIN                                               SPAIN
                   PG                                                            SPRATLY ISLANDS
    LK             CE        SRI LANKA                                           SRI LANKA
    SD             SU        SUDAN                                               SUDAN
    SR             NS        SURINAME                                            SURINAME
    SJ             SV        SVALBARD AND JAN MAYEN                              SVALBARD
    SZ             WZ        SWAZILAND                                           SWAZILAND
    SE             SW        SWEDEN                                              SWEDEN
    CH             SZ        SWITZERLAND                                         SWITZERLAND
    SY             SY        SYRIAN ARAB REPUBLIC                                SYRIA
    TW             TW        TAIWAN, PROVINCE OF CHINA                           TAIWAN
    TJ              TI       TAJIKISTAN                                          TAJIKISTAN
    TZ             TZ        TANZANIA, UNITED REPUBLIC OF                        TANZANIA
    TH             TH        THAILAND                                            THAILAND
    TL             TT        TIMOR-LESTE                                         TIMOR-LESTE
    TG             TO        TOGO                                                TOGO
    TK             TL        TOKELAU                                             TOKELAU
    TO             TN        TONGA                                               TONGA
    TT             TD        TRINIDAD AND TOBAGO                                 TRINIDAD AND TOBAGO
                   TE                                                            TROMELIN ISLAND
    TN             TS        TUNISIA                                             TUNISIA
    TR             TU        TURKEY                                              TURKEY
    TM             TX        TURKMENISTAN                                        TURKMENISTAN
    TC             TK        TURKS AND CAICOS ISLANDS                            TURKS AND CAICOS ISLANDS
    TV             TV        TUVALU                                              TUVALU
    UG             UG        UGANDA                                              UGANDA
    UA             UP        UKRAINE                                             UKRAINE
    AE             AE        UNITED ARAB EMIRATES                                UNITED ARAB EMIRATES
    GB             UK        UNITED KINGDOM                                      UNITED KINGDOM
    US             US        UNITED STATES                                       UNITED STATES

                                                                                 (ISO Code includes BAKER ISLAND, HOWLAND ISLAND, JARVIS
    UM                       UNITED STATES MINOR OUTLYING ISLANDS                ISLAND, JOHNSTON ATOLL, KINGMAN REEF, MIDWAY
                                                                                 ISLANDS, NAVASSA ISLAND, PALMYRA ATOLL, WAKE ISLAND)
    UY            UY         URUGUAY                                             URUGUAY
    UZ            UZ         UZBEKISTAN                                          UZBEKISTAN
    VU            NH         VANUATU                                             VANUATU
    VE            VE         VENEZUELA, BOLIVARIAN REPUBLIC OF                   VENEZUELA
    VN            VM         VIET NAM                                            VIETNAM
    VG            VI         VIRGIN ISLANDS, BRITISH                             BRITISH VIRGIN ISLANDS
    VI            VQ         VIRGIN ISLANDS, U.S.                                VIRGIN ISLANDS
                  WQ         (ISO includes with US MINOR OUTLYING ISLANDS)       WAKE ISLAND
    WF            WF         WALLIS AND FUTUNA                                   WALLIS AND FUTUNA




                                                                      8/8/2011                                                  Page 8
                                                                  Country Codes


ISO Country   FIPs Country
   Code           Code                               ISO Country Name                                      FIPS Country Name
                   WE        (ISO includes with PALESTINIAN TERRITORY, OCCUPIED)   WEST BANK
    EH             WI        WESTERN SAHARA                                        WESTERN SAHARA
    YE             YM        YEMEN                                                 YEMEN
    ZM             ZA        ZAMBIA                                                ZAMBIA
    ZW             ZI        ZIMBABWE                                              ZIMBABWE

   XA             XA         Other Africa                                          Other Africa
   XB             XB         Other Caribbean                                       Other Caribbean
   XC             XC         Other Central America                                 Other Central America
   XD             XD         Other South America                                   Other South America
   XE             XE         Other Europe                                          Other Europe
   XG             XG         Other Mideast                                         Other Mideast
   XH             XH         Other Southeast Asia                                  Other Southeast Asia
    XI             XI        Other Pacific                                         Other Pacific
   XW             XW         Unaccompanied                                         Unaccompanied
   XX             XX         Ship FPOs                                             Ship FPOs
   XY             XY         Unknown                                               Unknown




                                                                        8/8/2011                                               Page 9
                            State/Territory Codes as per FIPS PUB 5-2


State Code                          State/Territory Name
    AL       ALABAMA
    AK       ALASKA
    AZ       ARIZONA
    AR       ARKANSAS
    CA       CALIFORNIA
    CO       COLORADO
    CT       CONNECTICUT
    DE       DELAWARE
    DC       DISTRICT OF COLUMBIA
    FL       FLORIDA
    GA       GEORGIA
    HI       HAWAII
    ID       IDAHO
    IL       ILLINOIS
    IN       INDIANA
    IA       IOWA
    KS       KANSAS
    KY       KENTUCKY
    LA       LOUISIANA
    ME       MAINE
    MD       MARYLAND
    MA       MASSACHUSETTS
    MI       MICHIGAN
    MN       MINNESOTA
    MS       MISSISSIPPI
    MO       MISSOURI
    MT       MONTANA
    NE       NEBRASKA
    NV       NEVADA
    NH       NEW HAMPSHIRE
    NJ       NEW JERSEY
    NM       NEW MEXICO
    NY       NEW YORK
    NC       NORTH CAROLINA
    ND       NORTH DAKOTA
    OH       OHIO
    OK       OKLAHOMA
    OR       OREGON
    PA       PENNSYLVANIA
    RI       RHODE ISLAND
    SC       SOUTH CAROLINA
    SD       SOUTH DAKOTA
    TN       TENNESSEE
    TX       TEXAS
    UT       UTAH
    VT       VERMONT
    VA       VIRGINIA
    WA       WASHINGTON
    WV       WEST VIRGINIA
    WI       WISCONSIN
    WY       WYOMING

   AS        AMERICAN SAMOA
   FM        FEDERATED STATES OF MICRONESIA
   GU        GUAM
   MH        MARSHALL ISLANDS
   MP        NORTHERN MARIANA ISLANDS
   PW        PALAU
   PR        PUERTO RICO
    VI       VIRGIN ISLANDS
   UM        US MINOR OUTLYING ISLANDS




                                                    Date 8/8/2011       Page 10

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:56
posted:8/8/2011
language:English
pages:10