Pathways EB Recipient File to EB.xlsx
XLSX spreadsheet 61 KB Posted
- Solicitation number
- RFP 27-87793
- Issued by
- Marion County, Indiana
About this file
This is an interface specification document for the Pathways Member Recipient File to EB, a data exchange mechanism managed by the Indiana Title XIX program (EDS - Indiana) located at 950 N. Meridian St., Suite 1150, Indianapolis, IN 46204. The interface facilitates the transmission of demographic data for Medicaid members from the MMIS (Medicaid Management Information System) to the EB (Eligibility/Benefits) Business Unit. The file exchange occurs on a Monday through Friday frequency via secure FTP, with files named using the format PEBRecipyyyymmdd.nnnn.zip. The specification was initially documented on March 30, 2023, with subsequent modifications through October 23, 2023, including additions for phone contact information, tribal status indicators, and enhanced data field definitions. The system contains detailed record layouts specifying 383 character positions across detail records and trailer records, with each field precisely defined for proper data mapping and processing.
The interface specification defines mandatory and optional data fields encompassing recipient identification, demographic information, address details, contact information, and administrative codes. Required fields include Medicaid ID, last name, first name, city, state, zip code, Social Security number, birth date, sex, marital status, county, language, active status indicator, and case number, all mapped to the t_re_base and related tables within the database. Optional fields include death date, alien verification status, ward type, middle initial, zip code extension, and second phone number. The specification includes comprehensive lookup tables for county codes (all 92 Indiana counties plus unknown and out-of-state designations), language codes (supporting over 180 languages), marital status codes, living arrangement codes, and phone type codes. Trailers include a physical record count and proper newline character formatting to ensure accurate file processing and validation.
View the file
Other files
Show 40 more
Latest 50 of 63 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Interface Spec Overview
| Interface Specification Overview |
| Interface name: Pathways Member Recipient File to EB |
| Description: This file contains demographic data for Members sent in the Pathways Pending, Eligibile or Potential EB Files. |
| Record Selection Criteria: |
| Frequency: Monday- Friday |
| Sender: MMIS |
| Receiver: EB |
| Business Unit Ownership: Managed Care |
| Error Handling/Special Processing: N/A |
| Interface Exchange Method: Secure FTP |
| File Name: PEBRecipyyyymmdd.nnnn.zip |
| Modification Log |
| Initial Document, 20230330- Lee, J |
| Adding Phone 1 and Phone 2 with Phone Types, 20230412 |
| Added Required field column 20230426 |
| Modified filler field size to 380 05/18/2023 |
| Modified table name and column to t_re_base and ind_tribal for the Native American field |
| 10/23/2023 Added .zip to the filename |
Interface Specs Layout
| Enter one line for each field on the table. All columns must be completed for all rows. Add lines as needed. Add tables as needed. Only related subsystem tables should be in the same spreadsheet. | See Interface Spec Process & Interface Spec Documentation Instructions | |||||||||
| Record Type | FIELD | FIELD SIZE | Field Start | Field End | FORMAT | REQUIRED | TABLE NAME | COLUMN | DESCRIPTION | NOTES |
| Record Type | Field name | number of characters | Start Position | End Position | field type | table of origin/destination | column name | Any relevant information such as where field originated, unique or identifying information, acronymns speeled out. | ||
| Detail | Recipient Medicaid ID | 12 | 1 | 12 | CHAR | Yes, Never Null | t_re_base | id_medicaid | Unique Identifier for the recipient. This is the number assigned by ICES. | |
| Detail | Filler | 1 | 13 | 13 | Space | |||||
| Detail | Recip Last Name | 60 | 14 | 73 | CHAR | Yes, Never Null | t_re_base | nam_last | The last name of a recipient. | |
| Detail | Filler | 1 | 74 | 74 | Space | |||||
| Detail | Recip First Name | 35 | 75 | 109 | CHAR | Yes, Never Null | t_re_base | nam_first | The first name of a recipient. | |
| Detail | Filler | 1 | 110 | 110 | Space | |||||
| Detail | Recip Middle Initial | 1 | 111 | 111 | CHAR | Yes, Can Be Null | t_re_base | nam_mid_init | The middle initial of the recipient. | |
| Detail | Filler | 1 | 112 | 112 | Space | |||||
| Detail | Recip Addr City | 30 | 113 | 142 | CHAR | Yes, Never Null | t_re_base | adr_city | The city where the recipient resides. | |
| Detail | Filler | 1 | 143 | 143 | Space | |||||
| Detail | Recip Addr State | 2 | 144 | 145 | CHAR | Yes, Never Null | t_re_base | adr_state | The state where the recipient resides. | |
| Detail | Filler | 1 | 146 | 146 | Space | |||||
| Detail | Recip Addr Zip Code | 5 | 147 | 151 | CHAR | Yes, Never Null | t_re_base | adr_zip_code | The five character zip code for the recipient. | |
| Detail | Filler | 1 | 152 | 152 | Space | |||||
| Detail | Recip Addr Zip Code Ext | 4 | 153 | 156 | CHAR | Yes, Can Be Null | t_re_base | adr_zip_code_4 | The zip plus four of the recipient. | |
| Detail | Filler | 1 | 157 | 157 | Space | |||||
| Detail | Recip SSN | 9 | 158 | 166 | CHAR | Yes, Never Null | t_re_base | num_ssn | The social security number for the recipient. | |
| Detail | Filler | 1 | 167 | 167 | Space | |||||
| Detail | Recip Birth Date | 8 | 168 | 175 | DATE | Yes, Never Null | t_re_base | dte_birth | The date of birth for the recipient. | |
| Detail | Filler | 1 | 176 | 176 | Space | |||||
| Detail | Recip Death Date | 8 | 177 | 184 | DATE | No, Can Be Null | t_re_base | dte_death | The date of death for the recipient. | |
| Detail | Filler | 1 | 185 | 185 | Space | |||||
| Detail | Recip Sex | 1 | 186 | 186 | CHAR | Yes, Never Null | t_re_base | cde_sex | Indicates the sex of the recipient. | |
| Detail | Filler | 1 | 187 | 187 | Space | |||||
| Detail | Illegal Indicator | 1 | 188 | 188 | CHAR | No, Can Be Null | t_re_alien | cde_alien_verif | Indicates the alien status of the recipient | "0" No, "1" = Yes, "9" = Unknown |
| Detail | Filler | 1 | 189 | 189 | Space | |||||
| Detail | Recip Marital Code | 1 | 190 | 190 | CHAR | Yes, Never Null | t_re_base | cde_marital | Indicates the marital status of a recipient. | See Maritial Status Code tab for valid values |
| Detail | Filler | 1 | 191 | 191 | Space | |||||
| Detail | Recip County | 10 |
tc={6484C423-0917-4977-8B31-713D882014C3}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| This field is 10 characters in our databsase. However it is typically 3 char but because it can be 10, we have to leave it as 10. | 192 | 201 | CHAR | Yes, Never Null | t_re_base | cde_county | Indicates the county where the recipient resides. | See County Codes tab | |||
| Detail | Filler | 1 | 202 | 202 | Space | ||||||
| Detail | Recip Language | 3 | 203 | 205 | CHAR | Yes, Never Null | t_re_base | cde_language | Indicates language for the recipient. | See Language Code tab | |
| Detail | Filler | 1 | 206 | 206 | Space | ||||||
| Detail | Recip Ward Type | 1 | 207 | 207 | CHAR | No, Can Be Null | t_re_base | cde_ward_type | This is the code that represents the type of ward.'Y' - yes, 'N' - no, 'C' - chins, 'D' - court order, 'P' - parent term | ||
| Detail | Filler | 1 | 208 | 208 | Space | ||||||
| Detail | Recip Ind Active | 1 | 209 | 209 | CHAR | Yes, Never Null | t_re_base | ind_active | Indicates if the recipient Medicaid ID is active or purged because of a link. When two Medicaid IDs are linked one of them is no longer valid an will have an 'N' - no. All others are active and will have a 'Y' - yes or a 'P' - RID has changed. | Y = Current ID, N=Inactive ID, P= Had a Prior ID which has been purged. |
MAXIMUS - Treat Y and P as the same - they are valid to select assignments to PMP.
| Detail | Filler | 1 | 210 | 210 | Space | ||||||
| Detail | Case Number | 12 | 211 | 222 | CHAR | Yes, Never Null | t_re_case | num_case | The ICES case number assigned to the recipient. | ||
| Detail | Filler | 1 | 223 | 223 | Space | ||||||
| Detail | Street Address 1 | 55 | 224 | 278 | CHAR | Yes, Never Null | t_re_base | adr_street_1 | First street address for recipient | ||
| Detail | Filler | 1 | 279 | 279 | Space | ||||||
| Detail | Street Address 2 | 55 | 280 | 334 | CHAR | Yes, Can Be Null | t_re_base | adr_street_2 | Second street address for recipient | ||
| Detail | Filler | 1 | 335 | 335 | Space | ||||||
| Detail | Native American | 1 | 336 | 336 | CHAR | Yes, Never Null | t_re_base | ind_tribal | Identifies whether the member is a Native American. | Y = Yes, N = No | |
| Detail | Filler | 1 | 337 | 337 | |||||||
| Detail | CDE_LIV_ARNG | 3 | 338 | 340 | CHAR | Yes, Never Null | |||||
| Detail | Filler | 1 | 341 | 341 | newline character | ||||||
| Detail | LINKED RECIPIENT ID | 12 | 342 | 353 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 354 | 354 | |||||||
| Detail | CDE_ETHNIC | 2 | 355 | 356 | CHAR | Yes, Can Be Null | 00 | Non-Hispanic | |||
| 01 | Hispanic | ||||||||||
| 09 | Unknown | ||||||||||
| Detail | Filler | 1 | 357 | 357 | |||||||
| Detail | PHONE 1 | 10 | 358 | 367 | CHAR | Yes, Can Be Null | t_re_base | num_phone | |||
| Detail | Filler | 1 | 368 | 368 | |||||||
| Detail | PHONE 1 TYPE | 1 | 369 | 369 | CHAR | Yes, Can Be Null | t_cde_phone | cde_phone | |||
| Detail | Filler | 1 | 370 | 370 | |||||||
| Detail | PHONE 2 | 10 | 371 | 380 | CHAR | Yes, Can Be Null | t_re_base | num_add_phone | |||
| Detail | Filler | 1 | 381 | 381 | |||||||
| Detail | PHONE 2 TYPE | 1 | 382 | 382 | CHAR | Yes, Can Be Null | t_cde_phone | cde_phone | |||
| Detail | Filler | 1 | 383 | 383 |
| Trailer | Filler | 3 | 1 | 3 | TRL' constant | |
| Trailer | Record Count | 11 | 4 | 14 | NUMBER | Physical Record count (not including trailer), right justify the number |
| Trailer | Filler | 368 | 15 | 382 | Spaces. To fill out the rest of the record | |
| Trailer | Filler | 1 | 383 | 383 | newline character |
This field is 10 characters in our databsase. However it is typically 3 char but because it can be 10, we have to leave it as 10.
&G &"Arial,Bold"&12Interface Specification Document &8&D
&8&F &8&P of &N &8EDS - Indiana Title XIX 950 N. Meridian St., Suite 1150 Indianapolis, IN 46204
Lang Codes
| CDE_LANGUAGE | DSC_LANGUAGE |
| CAR | CARIB |
| CAT | CATALAN |
| SOM | SOMALI |
| SON | SONGHAI |
| WEN | SORBIAN LANGUAGES |
| NSO | SOTHO NORTHERN |
| SOT | SOTHO SOUTHERN |
| SAI | SOUTH AMERICAN INDIAN (OTHER) |
| SPA | SPANISH |
| SUK | SUKUMA |
| SUX | SUMERIAN |
| SUN | SUDANESE |
| SUS | SUSU |
| SWA | SWAHILI |
| SWE | SWEDISH |
| SYR | SYRIAC |
| TGL | TAGALOG |
| TAH | TAHITIAN |
| TGK | TAJIK |
| TMH | TAMASHEK |
| TAM | TAMIL |
| TAT | TATAR |
| TEL | TELUGU |
| TER | TERENO |
| THA | THAI |
| TIB | TIBETAN |
| TIG | TIGRE |
| TIR | TIGRINYA |
| TEM | TIMNE |
| TIV | TIVI |
| TLI | TLINGIT |
| TOG | TONGA (NYASA) |
| TON | TONGA (TONGA ISLANDS) |
| TSI | TSIMSHIAN |
| TSO | TSONGA |
| TSN | TSWANA |
| TUM | TUMBUKA |
| TUR | TURKISH |
| OTA | TURKISH OTTOMAN (1500 - 1928) |
| TUK | TURKMEN |
| TYV | TUVINIAN |
| TWI | TWI |
| UGA | UGARITIC |
| UIG | UIGHUR |
| UKR | UKRAINIAN |
| UMB | UMBUNDU |
| UND | UNDETERMINED |
| URD | URDU |
| UZB | UZBEK |
| VAI | VAI |
| VEN | VENDA |
| VIE | VIETNAMESE |
| VOL | VOLAPUK |
| VOT | VOTIC |
| WAK | WAKASHAN LANGUAGES |
| WAL | WALAMO |
| WAR | WARAY |
| WAS | WASHO |
| WEL | WELSH |
| WOL | WOLOF |
| XHO | XHOSA |
| SAH | YAKUT |
| YAO | YAO |
| YAP | YAP |
| YID | YIDDISH |
| YOR | YORUBA |
| ZAP | ZAPOTEC |
| SAT | SANTALI |
| SCN | SICILIAN |
| SGN | SIGN LANGUAGES |
| SMA | SOUTHERN SAMI |
| SME | NORTHERN SAMI |
| SMJ | LULE SAMI |
| SMN | INARI SAMI |
| SMS | SKOLT SAMI |
| ZEN | ZENAGA |
| ZHA | ZHUANG |
| ZUL | ZULU |
| ZUN | ZUNI |
| FIN | FINNISH |
| FIU | FINNO-UGRIAN (OTHER) |
| FON | FON |
| FRE | FRENCH |
| FRM | FRENCH MIDDLE (CA. 1400-1600) |
| FRO | FRENCH OLD (842- CA. 1400) |
| FRY | FRISIAN |
| FUL | FULAH |
| GAA | GA |
| GLG | GALLEGAN |
| LUG | GANDA |
| GAY | GAYO |
| GEZ | GEEZ |
| GEO | GEORGIAN |
| GER | GERMAN |
| SOG | SOGDIAN |
| CHA | CHAMORRO |
| CHE | CHECHEN |
| CHR | CHEROKEE |
| CHY | CHEYENNE |
| CHB | CHIBCHA |
| CHI | CHINESE |
| CHN | CHINOOK JARGON |
| CHO | CHOCTAW |
| CHU | CHURCH SLAVIC |
| CHV | CHUVASH |
| COP | COPTIC |
| COR | CORNISH |
| COS | CORSICAN |
| CRE | CREE |
| MUS | CREEK |
| CRP | CREOLES AND PIDGINS (OTHER) |
| CPE | CREOLES AND PIDGINS ENGLISH-BASED (OTHER) |
| CPF | CREOLES AND PIDGINS FRENCH-BASED (OTHER) |
| CPP | CREOLES AND PIDGINS PORTUGUESE-BASED (OTHER) |
| CUS | CUSHITIC (OTHER) |
| CZE | CZECH |
| DAK | DAKOTA |
| DAN | DANISH |
| DEL | DELAWARE |
| DIN | DINKA |
| DIV | DIVEHI |
| DOI | DOGRI |
| DRA | DRAVIDIAN (OTHER) |
| DUA | DUALA |
| DUT | DUTCH |
| DUM | DUTCH MIDDLE (CA. 1050-1350) |
| DYU | DYULA |
| DZO | DZONGKHA |
| EFI | EFIK |
| EGY | EGYPTIAN (ANCIENT) |
| EKA | EKAJUK |
| ELX | ELAMITE |
| ENG | ENGLISH |
| ENM | ENGLISH MIDDLE (CA. 1100-1500) |
| ANG | ENGLISH OLD (CA. 450-1100) |
| EPO | ESPERANTO |
| EST | ESTONIAN |
| EWE | EWE |
| EWO | EWONDO |
| FAN | FANG |
| FAT | FANTI |
| SNK | SONINKE |
| SRN | SRANAN TONGO |
| SRP | SERBIAN |
| SYC | CLASSICAL SYRIAC |
| TAI | TAI (OTHER) |
| TET | TETUM |
| TKL | TOKELAU |
| TLH | KLINGON; TLHINGAN-HOL |
| TPI | TOK PISIN |
| TUP | TUPI LANGUAGES |
| TVL | TUVALU |
| UDM | UDMURT |
| WLN | WALLOON |
| XAL | KALMYK; OIRAT |
| YPK | YUPIK LANGUAGES |
| ZBL | BLISSYMBOLS; BLISSYMBOLICS; BLISS |
| ZND | ZANDE LANGUAGES |
| ZXX | NO LINGUISTIC CONTENT; NOT APPLICABLE |
| ZZA | ZAZA; DIMILI; DIMLI; KIRDKI; KIRMANJKI; ZAZAKI |
| CAU | CAUCASIAN (OTHER) |
| CEB | CEBUANO |
| CEL | CELTIC (OTHER) |
| CAI | CENTRAL AMERICAN INDIAN (OTHER) |
| CHG | CHAGATAI |
| NAI | NORTH AMERICAN INDIAN (OTHER) |
| NOR | NORWEGIAN |
| NNO | NORWEGIAN (NYNORSK) |
| NUB | NUBIAN LANGUAGES |
| NYM | NYAMWEZI |
| NYA | NYANJA |
| NYN | NYANKOLE |
| NYO | NYORO |
| NZI | NZIMA |
| OJI | OJIBWA |
| ORI | ORIYA |
| ORM | OROMO |
| OSA | OSAGE |
| OSS | OSSETIC |
| OTO | OTOMIAN LANGUAGES |
| PAL | PAHLAVI |
| PAU | PALAUAN |
| PLI | PALI |
| PAM | PAMPANGA |
| PAG | PANGASINAN |
| PAN | PANJABI |
| PAP | PAPIAMENTO |
| PAA | PAPUAN-AUSTRALIAN (OTHER) |
| PER | PERSIAN |
| PEO | PERSIAN OLD (CA 600 - 400 B.C.) |
| PHN | PHOENICIAN |
| POL | POLISH |
| PON | PONAPE |
| POR | PORTUGUESE |
| PRA | PRAKRIT LANGUAGES |
| PRO | PROVENCAL OLD (TO 1500) |
| PUS | PUSHTO |
| QUE | QUECHUA |
| ROH | RHAETO-ROMANCE |
| RAJ | RAJASTHANI |
| RAR | RAROTONGAN |
| ROA | ROMANCE (OTHER) |
| ROM | ROMANY |
| RUN | RUNDI |
| RUS | RUSSIAN |
| SAL | SALISHAN LANGUAGES |
| SAM | SAMARITAN ARAMAIC |
| SMI | SAMI LANGUAGES |
| SMO | SAMOAN |
| SAD | SANDAWE |
| SAG | SANGO |
| SAN | SANSKRIT |
| SRD | SARDINIAN |
| SCO | SCOTS |
| SEL | SELKUP |
| SEM | SEMITIC (OTHER) |
| SRR | SERER |
| SHN | SHAN |
| SNA | SHONA |
| SID | SIDAMO |
| BLA | SIKSIKA |
| SND | SINDHI |
| SIN | SINGHALESE |
| SIT | SINO-TIBETAN (OTHER) |
| SIO | SIOUAN LANGUAGES |
| SLA | SLAVIC (OTHER) |
| SSW | SISWANT/SWAZI |
| SLO | SLOVAK |
| SLV | SLOVENIAN |
| ADY | ADYGHE; ADYGEI |
| AIN | AINU |
| ALT | SOUTHERN ALTAI |
| ANP | ANGIKA |
| ARG | ARAGONESE |
| AST | ASTURIAN; BABLE; LEONESE; ASTURLEONESE |
| AUS | AUSTRALIAN LANGUAGES |
| BOS | BOSNIAN |
| BTK | BATAK LANGUAGES |
| BYN | BLIN; BILIN |
| CHK | CHUUKESE |
| CHP | CHIPEWYAN; DENE SULINE |
| CMC | CHAMIC LANGUAGES |
| CRH | CRIMEAN TATAR; CRIMEAN TURKISH |
| CSB | KASHUBIAN |
| DAR | DARGWA |
| DAY | LAND DAYAK LANGUAGES |
| DEN | SLAVE (ATHAPASCAN) |
| DGR | DOGRIB |
| DSB | LOWER SORBIAN |
| FIL | FILIPINO; PILIPINO |
| FRR | NORTHERN FRISIAN |
| FRS | EASTERN FRISIAN |
| FUR | FRIULIAN |
| GBA | GBAYA |
| GLA | GAELIC; SCOTTISH GAELIC |
| GLE | IRISH |
| GLV | MANX |
| GOR | GORONTALO |
| GSW | SWISS GERMAN; ALEMANNIC; ALSATIAN |
| GWI | GWICH'IN |
| HAT | HAITIAN; HAITIAN CREOLE |
| HIT | HITTITE |
| HMN | HMONG |
| HRV | CROATIAN |
| HSB | UPPER SORBIAN |
| IDO | IDO |
| III | SICHUAN YI; NUOSU |
| ILE | INTERLINGUE; OCCIDENTAL |
| INH | INGUSH |
| JBO | LOJBAN |
| KBD | KABARDIAN |
| KMB | KIMBUNDU |
| KOS | KOSRAEAN |
| KRC | KARACHAY-BALKAR |
| KRL | KARELIAN |
| LIM | LIMBURGAN; LIMBURGER; LIMBURGISH |
| LUA | LUBA-LULUA |
| LUS | LUSHAI |
| MDF | MOKSHA |
| MDR | MANDAR |
| MNC | MANCHU |
| MWL | MIRANDESE |
| MYV | MAYAN LANGUAGES |
| NAP | NEAPOLITAN |
| NDS | LOW GERMAN; LOW SAXON; GERMAN, LOW; SAXON, LOW |
| NIA | NIAS |
| NOB | BOKM?L, NORWEGIAN; NORWEGIAN BOKM?L |
| NOG | NOGAI |
| NQO | N'KO |
| NWC | CLASSICAL NEWARI; OLD NEWARI; CLASSICAL NEPAL BHASA |
| PHI | PHILIPPINE (OTHER) |
| RAP | RAPANUI |
| RUM | ROMANIAN; MOLDAVIAN; MOLDOVAN |
| RUP | AROMANIAN; ARUMANIAN; MACEDO-ROMANIAN |
| SAS | SASAK |
| ASE | AMERICAN SIGN LANGUAGE |
| CLD | CHALDEAN NEO-ARAMAIC |
| PRS | DARI |
| NLD | FLEMISH |
| GAD | GADDANG |
| CNH | HAKA CHIN |
| GEX | GARRE |
| HAK | HAKKA CHINESE |
| MNK | MANDINKA |
| MYI | MINA (INDIA) |
| FUV | NIGERIAN FULFULDE |
| FUC | PULAAR |
| IUM | LU MIEN |
| KYU | WESTERN KAYAH |
| NAN | MIN NAN CHINESE |
| FAO | FAROESE |
| FIJ | FIJIAN |
| KRO | KRU |
| KUA | KUANYAMA |
| KUM | KUMYK |
| KUR | KURDISH |
| KRU | KURUKH |
| KUT | KUTENAI |
| LAD | LADINO |
| LAH | LAHNDA |
| LAM | LAMBA |
| OCI | LANGUE D'OC (POST 1500) |
| LAO | LAO |
| LAT | LATIN |
| LAV | LATVIAN |
| LTZ | LETZEBURGESCH |
| LEZ | LEZGHIAN |
| LIN | LINGALA |
| LIT | LITHUANIAN |
| LOZ | LOZI |
| LUB | LUBA-KATANGA |
| LUI | LUISENO |
| LUN | LUNDA |
| LUO | LUO (KENYA AND TANZANIA) |
| MAC | MACEDONIAN |
| MAD | MADURESE |
| MAG | MAGAHI |
| MAI | MAITHILI |
| MAK | MAKASAR |
| MLG | MALAGASY |
| MAY | MALAY |
| MAL | MALAYALAM |
| MLT | MALTESE |
| MAN | MANDINGO |
| MNI | MANIPURI |
| MNO | MANOBO LANGUAGES |
| MAO | MAORI |
| MAR | MARATHI |
| CHM | MARI |
| MAH | MARSHALL |
| MWR | MARWARI |
| MAS | MASAI |
| MYN | MAYAN LANGUAGES |
| MEN | MENDE |
| MIC | MICMAC |
| MIN | MINANGKABAU |
| MIS | MISCELLANEOUS (OTHER) |
| MOH | MOHAWK |
| MKH | MON-KMER (OTHER) |
| LOL | MONGO |
| MON | MONGOLIAN |
| MOS | MOSSI |
| MUL | MULTIPLE LANGUAGES |
| MUN | MUNDA LANGUAGES |
| NAU | NAURU |
| NAV | NAVAJO |
| NDE | NDEBELE NORTH |
| NBL | NDEBELE SOUTH |
| NDO | NDONGO |
| NEP | NEPALI |
| NEW | NEWARI |
| NIC | NIGER-KORDOFANIAN (OTHER) |
| SSA | NILO-SAHARAN (OTHER) |
| NIU | NIUEAN |
| NON | NORSE OLD |
| GMH | GERMAN MIDDLE HIGH (CA. 1050-1500) |
| GOH | GERMAN OLD HIGH (CA. 750-1050) |
| GEM | GERMANIC (OTHER) |
| GIL | GILBERTESE |
| GON | GONDI |
| GOT | GOTHIC |
| GRB | GREBO |
| GRC | GREEK ANCIENT (TO 1453) |
| GRE | GREEK MODERN (1453-) |
| KAL | GREENLANDIC |
| GRN | GUARANI |
| GUJ | GUJARATI |
| HAI | HAIDA |
| HAU | HAUSA |
| HAW | HAWAIIAN |
| HEB | HEBREW |
| HER | HERERO |
| HIL | HILIGAYNON |
| HIM | HIMACHALI |
| HIN | HINDI |
| HMO | HIRI MOTU |
| HUN | HUNGARIAN |
| HUP | HUPA |
| IBA | IBAN |
| ICE | ICELANDIC |
| IBO | IGBO |
| IJO | IJO |
| ILO | ILOKO |
| INC | INDIC (OTHER) |
| INE | INDO-EUROPEAN (OTHER)/INTERLINGUE |
| IND | INDONESIAN |
| INA | INTERLINGUA (INTERNATIONAL AUXILIARY LANGUAGE ASSOCIATION) |
| IKU | INUKTITUT |
| IPK | INUPIAK |
| IRA | IRANIAN (OTHER) |
| SGA | IRISH OLD (TO 900) |
| MGA | IRISH MIDDLE (900 - 1200) |
| IRO | IROQUOIAN LANGUAGES |
| ITA | ITALIAN |
| JPN | JAPANESE |
| JAV | JAVANESE |
| JRB | JUDEO-ARABIC |
| JPR | JUDEO-PERSIAN |
| KAB | KABYLE |
| KAC | KACHIN |
| KAM | KAMBA |
| KAN | KANNADA |
| KAU | KANURI |
| KAA | KARA-KALPAK |
| KAR | KAREN |
| KAS | KASHMIRI |
| KAW | KAWI |
| KAZ | KAZAKH |
| KHA | KHASI |
| KHM | KHMER |
| KHI | KHOISAN (OTHER) |
| KHO | KHOTANESE |
| KIK | KIKUYU |
| KIN | KINYARWANDA |
| KIR | KIRGHIZ |
| KOM | KOMI |
| KON | KONGO |
| KOK | KONKANI |
| KOR | KOREAN |
| KPE | KPELLE |
| ABK | ABKHAZIAN |
| ACE | ACHINESE |
| ACH | ACOLI |
| ADA | ADANGME |
| AAR | AFAR |
| AFH | AFRIHILI |
| AFR | AFRIKAANS |
| AFA | AFRO-ASIATIC (OTHER) |
| AKA | AKAN |
| AKK | AKKADIAN |
| ALB | ALBANIAN |
| ALE | ALEUT |
| ALG | ALGONQUIAN LANGUAGES |
| TUT | ALTAIC (OTHER) |
| AMH | AMHARIC |
| APA | APACHE LANGUAGES |
| ARA | ARABIC |
| ARC | ARAMAIC |
| ARP | ARAPAHO |
| ARN | ARAUCANIAN |
| ARW | ARAWAK |
| ARM | ARMENIAN |
| ART | ARTIFICIAL (OTHER) |
| ASM | ASSAMESE |
| ATH | ATHAPASCAN LANGUAGES |
| MAP | AUSTRONESIAN (OTHER) |
| AVA | AVARIC |
| AVE | AVESTAN |
| AWA | AWADHI |
| AYM | AYMARA |
| AZE | AZERBAIJANI |
| NAH | AZTEC |
| BAN | BALINESE |
| BAT | BALTIC (OTHER) |
| BAL | BALUCHI |
| BAM | BAMBARA |
| BAI | BAMILEKE LANGUAGES |
| BAD | BANDA |
| BNT | BANTU (OTHER) |
| BAS | BASA |
| BAK | BASHKIR |
| BAQ | BASQUE |
| BEJ | BEJA |
| BEM | BEMBA |
| BEN | BENGALI |
| BER | BERBER (OTHER) |
| BHO | BHOJPURI |
| BIH | BIHARI |
| BIK | BIKOL |
| BIN | BINI |
| BIS | BISLAMA |
| BRA | BRAJ |
| BRE | BRETON |
| BUG | BUGINESE |
| BUL | BULGARIAN |
| BUA | BURIAT |
| BUR | BURMESE |
| BEL | BYELORUSSIAN |
| CAD | CADDO |
Martial Stat Code
| CDE_MARITAL | DSC_MARITAL |
| A | COMMON LAW |
| B | REGISTERED DOMESTIC PARTNER |
| C | NOT APPLICABLE |
| D | DIVORCED |
| I | SINGLE |
| K | UNKNOWN |
| M | MARRIED |
| R | UNREPORTED |
| S | SEPARATED |
| U | UNMARRIED (SINGLE, DIVORCED OR WIDOWED) |
| W | WIDOWED |
| X | LEGALLY SEPARATED |
Living Arrangement Codes
| CDE_LIV_ARNG | DSC_LIV_ARNG |
| MH | COMMUNITY MENTAL HEALTH CENTER |
| SS | STATE SCHOOL FOR MENTALLY RETARDED |
| XX | UNSPECIFIED |
| AL | ASSISTED LIVING |
| TC | DRUG AND ALCOHOL TREATMENT CENTER |
| NF | COMMUNITY OR MEDICAL FACILITY |
| BC | DOMESTIC VIOLENCE SHELTER |
| CH | DORMITORY (COLLEGE HOUSING) |
| CR | COMMERCIAL BOARDING HOUSE |
| FO | FOSTER CARE |
| GL | GROUP HOME |
| HH | HALFWAY HOUSE |
| HS | HOMELESS/HOMELESS SHELTER |
| HO | IN HOME |
| JA | JAIL |
| JC | JOB CORP |
| JL | INCARCERATED |
| IC | INCARCERATED CARE |
| LH | LONG-TERM HOSPITALIZATION |
| ME | MEDICAL FACILITY |
| PH | PIONEER HOME |
| PI | PUBLIC INSTITUTION |
| PR | PRE-RELEASE CENTER |
| SC | SKILLED NURSING CARE |
| U3 | LIVE-IN-ATTENDANT |
| U5 | DEATH |
| U0 | SPONSOR NOT IN HOUSEHOLD |
| U2 | SPONSOR'S SPOUSE NOT IN HOUSEHOLD |
| U4 | NEWBORN HOSPITALIZED |
| RH | RELATIVES HOMES |
Phone Codes
| Phone Code | Description |
| R | RELATIVE |
| H | HOME |
| C | CELL |
| W | WORK |
| N | NO PHONE |
| F | FAX |
| O | OTHER |
| P | PAGER |
| E | EMPLOYER |
| M | MESSAGE |
County Codes
| CDE_COUNTY | DSC_COUNTY |
| 01 | ADAMS |
| 02 | ALLEN |
| 03 | BARTHOLOMEW |
| 04 | BENTON |
| 05 | BLACKFORD |
| 06 | BOONE |
| 07 | BROWN |
| 08 | CARROLL |
| 09 | CASS |
| 10 | CLARK |
| 11 | CLAY |
| 12 | CLINTON |
| 13 | CRAWFORD |
| 14 | DAVIESS |
| 15 | DEARBORN |
| 16 | DECATUR |
| 17 | DEKALB |
| 18 | DELAWARE |
| 19 | DUBOIS |
| 20 | ELKHART |
| 21 | FAYETTE |
| 22 | FLOYD |
| 23 | FOUNTAIN |
| 24 | FRANKLIN |
| 25 | FULTON |
| 26 | GIBSON |
| 27 | GRANT |
| 28 | GREENE |
| 29 | HAMILTON |
| 30 | HANCOCK |
| 31 | HARRISON |
| 32 | HENDRICKS |
| 33 | HENRY |
| 34 | HOWARD |
| 35 | HUNTINGTON |
| 36 | JACKSON |
| 37 | JASPER |
| 38 | JAY |
| 39 | JEFFERSON |
| 40 | JENNINGS |
| 41 | JOHNSON |
| 42 | KNOX |
| 43 | KOSCIUSKO |
| 44 | LAGRANGE |
| 45 | LAKE |
| 46 | LAPORTE |
| 47 | LAWRENCE |
| 48 | MADISON |
| 49 | MARION |
| 50 | MARSHALL |
| 51 | MARTIN |
| 52 | MIAMI |
| 53 | MONROE |
| 54 | MONTGOMERY |
| 00 | UNKNOWN |
| 55 | MORGAN |
| 56 | NEWTON |
| 57 | NOBLE |
| 58 | OHIO |
| 59 | ORANGE |
| 60 | OWEN |
| 61 | PARKE |
| 62 | PERRY |
| 63 | PIKE |
| 64 | PORTER |
| 65 | POSEY |
| 66 | PULASKI |
| 67 | PUTNAM |
| 68 | RANDOLPH |
| 69 | RIPLEY |
| 70 | RUSH |
| 71 | ST. JOSEPH |
| 72 | SCOTT |
| 73 | SHELBY |
| 74 | SPENCER |
| 75 | STARKE |
| 76 | STEUBEN |
| 77 | SULLIVAN |
| 78 | SWITZERLAND |
| 79 | TIPPECANOE |
| 80 | TIPTON |
| 81 | UNION |
| 82 | VANDERBURGH |
| 83 | VERMILLION |
| 84 | VIGO |
| 85 | WABASH |
| 86 | WARREN |
| 87 | WARRICK |
| 88 | WASHINGTON |
| 89 | WAYNE |
| 90 | WELLS |
| 91 | WHITE |
| 92 | WHITLEY |
| 94 | IFSSA |
| 98 | OOS-WARD CRT |
| 99 | OUT OF STATE |
image1.png
File details come from the government source that posted it. Updated .