Pathways Weekly 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 Weekly Recipient File to EB (Eligibility and Benefits), a data exchange interface managed by the Indiana Title XIX program (EDS - Indiana) between the MMIS (Medicaid Management Information System) as sender and EB as receiver. The file specifies the technical requirements for a weekly demographic data file containing member information, transmitted securely via FTP every Monday in a compressed ZIP format with filename convention PEBRecipWyyyymmdd.nnnn.zip. The interface contains detailed record layout specifications for 34 data fields organized into Detail and Trailer record types, including recipient identifiers, personal information, address data, contact information, and status indicators. The specification document includes comprehensive reference tables for valid code values, including Language Codes (providing translations for 184 language options), Marital Status Codes, Living Arrangement Codes, Phone Type Codes, and County Codes representing all 92 Indiana counties plus special designations for unknown and out-of-state recipients.
The specification establishes mandatory data requirements for critical fields such as Medicaid ID, recipient names, birth dates, Social Security numbers, and addresses, while allowing null values for optional fields including death dates, ward type designations, middle initials, and ethnic codes. The document was initially created on November 28, 2023, by Victor A. and is managed under the Managed Care Business Unit. The interface supports linked recipient ID tracking, indicating system capability to manage cases where multiple Medicaid IDs are consolidated or purged. No specific pricing, set-asides, incumbent information, or funding requirements are specified in this technical specification document, as it serves solely to define data structure and field requirements for the weekly recipient file exchange between state systems.
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 Weekly Recipient File to EB |
| Description: This file contains demographic data for Members sent in the Pathways Weekly Eligibile File. |
| Record Selection Criteria: |
| Frequency: Weekly Monday |
| Sender: MMIS |
| Receiver: EB |
| Business Unit Ownership: Managed Care |
| Error Handling/Special Processing: N/A |
| Interface Exchange Method: Secure FTP |
| File Name: PEBRecipWyyyymmdd.nnnn.zip |
| Modification Log |
| Initial Document, 20231128 - Victor A. |
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 .