Pathways Weekly Eligibility File to EB.xlsx
XLSX spreadsheet 50 KB Posted
- Solicitation number
- RFP 27-87793
- Issued by
- Marion County, Indiana
About this file
Summary
This is an Interface Specification document for the Pathways Weekly Eligibility File to EB, detailing data exchange procedures between the Indiana Medicaid Management Information System (MMIS) and the Enrollment Broker (EB) for the state's Medicaid Pathways program. The interface specification defines the technical requirements for transmitting weekly Pathways member eligibility data to the EB, effective July 1, 2024. The file is transmitted weekly on Mondays via Secure FTP in a compressed format (PEBEligibilityWyyyymmdd.misshh.zip) and is managed by the Managed Care Business Unit. The document was initially prepared on November 28, 2023, by Victor A. and establishes the record layout and field specifications for eligible member data transmission.
The specification defines a detailed record structure containing 3,199 character positions per record, including mandatory fields such as Medicaid ID, Medicare ID, managed care organization information, eligibility dates, aid categories, and authorized representative contact information. The file supports up to six authorized representatives per member record and includes both current and future eligibility information with hard-coded values for the weekly future eligibility extract (future MCE effective date of 20240701 and end date of 22991231). Aid categories include aged (A), blind (B), disabled (D), working disabled through MEDWORKS programs (DI, DW), parent/caretaker (GF), and SSI-related categories (SI), along with waiver categories for aged and disabled HCBS programs. Member type coding identifies new Pathways members as "PM," and the file includes trailer records with physical record counts for validation purposes.
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: Pathway Eligibility File to EB |
| Description: This file provides Potential Eligible Pathways member data to the EB from MMIS that will be eligible for Pathways on 07/01/2024 |
| 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: PEBEligibilityWyyyymmdd.misshh.zip |
| Revision History |
| 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 FIELD | 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 | ID_MEDICAID | 12 | 1 | 12 | CHAR | Yes, Never Null | t_re_base | id_medicaid | Recipient ID | NOT NULL | |
| Detail | Filler | 1 | 13 | 13 | Space | ||||||
| Detail | ID_MEDICARE | 12 | 14 | 25 | CHAR | Yes, Can Be Null | T_RE_HIB | ||||
| Detail | Filler | 1 | 26 | 26 | Newline, "\n". Row by row reading | ||||||
| Detail | NAM_PARTC_PLAN | 55 | 27 | 81 | CHAR | Yes, Can Be Null | T_RE_TBQ | T_RE_TBQ where cycle date is between the T_RE_TBQ_GHO effective and end use sak_re_tbq | |||
| Detail | Filler | 1 | 82 | 82 | |||||||
| Detail | NAM_PARTC_ORG | 55 | 83 | 137 | CHAR | Yes, Can Be Null | T_RE_TBQ | ||||
| Detail | Filler | 1 | 138 | 138 | |||||||
| Detail | PLAN C EFFECTIVE DATE | 8 | 139 | 146 | Yes, Can Be Null | T_RE_TBQ | |||||
| Detail | Filler | 1 | 147 | 147 | |||||||
| Detail | PLAN C END DATE | 8 | 148 | 155 | Yes, Can Be Null | T_RE_TBQ | |||||
| Detail | Filler | 1 | 156 | 156 | |||||||
| Detail | IND_SPECIAL_NEEDS | 1 | 157 | 157 | CHAR | Yes, Can Be Null | T_RE_TBQ_PBP | SELECT SAK_RE_TBQ, IND_SPECIAL_NEEDS FROM T_RE_TBQ_PBP WHERE CDE_STATUS= ' ' | |||
| AND IND_SPECIAL_NEEDS = 'Y' AND CDE_TYPE = 'E' AND TO_CHAR(SYSDATE,'YYYYMMDD')BETWEEN DTE_EFFECTIVE AND DTE_END | Yes or No or Null | ||||||||||
| Detail | Filler | 1 | 158 | 158 | |||||||
| Detail | IND_URGNT_COV | 1 | 159 | 159 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 160 | 160 | |||||||
| Detail | DTE_URGENT_EFFECTIVE | 8 | 161 | 168 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 169 | 169 | |||||||
| Detail | DTE_URGENT_END | 8 | 170 | 177 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 178 | 178 | |||||||
| Detail | CURRENT MCE ID | 2 | 179 | 180 | CHAR | Yes, Never Null | Spaces for the Weekly Future Eligibility Extract | ||||
| Detail | Filler | 1 | 181 | 181 | |||||||
| Detail | CURRENT MCE EFFECTIVE DATE | 8 | 182 | 189 | NUMBER | Yes, Never Null | Spaces for the Weekly Future Eligibility Extract | ||||
| Detail | Filler | 1 | 190 | 190 | |||||||
| Detail | CURRENT MCE END DATE | 8 | 191 | 198 | NUMBER | Yes, Never Null | Spaces for the Weekly Future Eligibility Extract | ||||
| Detail | Filler | 1 | 199 | 199 | |||||||
| Detail | CURRENT RECIP AID CATEGORY | 5 | 200 | 204 | CHAR | Yes, Never Null | |||||
| Detail | Filler | 1 | 205 | 205 | |||||||
| Detail | CURRENT AID ELIG EFFECTIVE DATE | 8 | 206 | 213 | DATE | Yes, Never Null | |||||
| Detail | Filler | 1 | 214 | 214 | |||||||
| Detail | CURRENT AID ELIG END DATE | 8 | 215 | 222 | DATE | Yes, Never Null | |||||
| Detail | Filler | 1 | 223 | 223 | |||||||
| Detail | CURRENT RECIP WAIVER AID CATEGORY | 5 | 224 | 228 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 229 | 229 | |||||||
| Detail | CURRENT WAIVER AID ELIG EFFECTIVE DATE | 8 | 230 | 237 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 238 | 238 | |||||||
| Detail | CURRENT WAIVER AID ELIG END DATE | 8 | 239 | 246 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 247 | 247 | |||||||
| Detail | CURRENT RECIP NFLOC PLAN | 5 | 248 | 252 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 253 | 253 | |||||||
| Detail | CURRENT WAIVER NFLOC PLAN EFFECTIVE DATE | 8 | 254 | 261 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 262 | 262 | |||||||
| Detail | CURRENT NFLOC PLAN ELIG END DATE | 8 | 263 | 270 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 271 | 271 | |||||||
| Detail | CURRENT RECIP HOSPICE PLAN | 5 | 272 | 276 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 277 | 277 | |||||||
| Detail | CURRENT HOSPICE PLAN EFFECTIVE DATE | 8 | 278 | 285 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 286 | 286 | |||||||
| Detail | FUTURE MCE ID | 2 | 287 | 288 | CHAR | Yes, Can Be Null | Spaces for the Weekly Future Elig Extract | ||||
| Detail | Filler | 1 | 289 | 289 | |||||||
| Detail | FUTURE MCE EFFECTIVE DATE | 8 | 290 | 297 | NUMBER | Yes, Can Be Null | Hard coded to be 20240701 for the Weekly Future Elig Extract | ||||
| Detail | Filler | 1 | 298 | 298 | |||||||
| Detail | FUTURE MCE END DATE | 8 | 299 | 306 | NUMBER | Yes, Can Be Null | Hard coded to be 22991231 for the Weekly Future Elig Extract | ||||
| Detail | Filler | 1 | 307 | 307 | |||||||
| Detail | FUTURE RECIP AID CATEGORY | 5 | 308 | 312 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 313 | 313 | |||||||
| Detail | FUTURE AID ELIG EFFECTIVE DATE | 8 | 314 | 321 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 322 | 322 | |||||||
| Detail | FUTURE AID ELIG END DATE | 8 | 323 | 330 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 331 | 331 | |||||||
| Detail | FUTURE RECIP WAIVER AID CATEGORY | 5 | 332 | 336 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 337 | 337 | |||||||
| Detail | FUTURE WAIVER AID ELIG EFFECTIVE DATE | 8 | 338 | 345 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 346 | 346 | |||||||
| Detail | FUTURE WAIVER AID ELIG END DATE | 8 | 347 | 354 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 355 | 355 | |||||||
| Detail | FUTURE RECIP NFLOC PLAN | 5 | 356 | 360 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 361 | 361 | |||||||
| Detail | FUTURE WAIVER NFLOC PLAN EFFECTIVE DATE | 8 | 362 | 369 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 370 | 370 | |||||||
| Detail | FUTURE NFLOC PLAN ELIG END DATE | 8 | 371 | 378 | DATE | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 379 | 379 | |||||||
| Detail | FUTURE RECIP HOSPICE PLAN | 5 | 380 | 384 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 385 | 385 | |||||||
| Detail | FUTURE HOSPICE PLAN EFFECTIVE DATE | 8 | 386 | 393 | DATE | Yes, Can Be Null | |||||
| Filler | 1 | 394 | 394 | ||||||||
| Detail | AUTH_REP_CDE_REP_TYPE (1st) | 1 | 395 | 395 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 396 | 396 | |||||||
| Detail | AUTH_REP NAM_FIRST | 35 | 397 | 431 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 432 | 432 | |||||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 433 | 433 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 434 | 434 | |||||||
| Detail | AUTH_REP_NAM_LAST | 60 | 435 | 494 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 495 | 495 | |||||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 496 | 505 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 506 | 506 | |||||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 507 | 656 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 657 | 657 | |||||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 658 | 665 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 666 | 666 | |||||||
| Detail | AUTH_REP_DTE_END | 8 | 667 | 674 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 675 | 675 | |||||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 676 | 676 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 677 | 677 | |||||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 678 | 687 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 688 | 688 | |||||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 689 | 738 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 739 | 739 | |||||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 740 | 789 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 790 | 790 | |||||||
| Detail | AUTH_REP_ADR_CITY | 25 | 791 | 815 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 816 | 816 | |||||||
| Detail | AUTH_REP_ADR_STATE | 2 | 817 | 818 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 819 | 819 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 820 | 824 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 825 | 825 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 826 | 829 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 830 | 830 | |||||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 831 | 860 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 861 | 861 | |||||||
| Detail | AUTH_REP_CDE_REP_TYPE (2nd) | 1 | 862 | 862 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 863 | 863 | |||||||
| Detail | AUTH_REP NAM_FIRST | 35 | 864 | 898 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 899 | 899 | |||||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 900 | 900 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 901 | 901 | |||||||
| Detail | AUTH_REP_NAM_LAST | 60 | 902 | 961 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 962 | 962 | |||||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 963 | 972 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 973 | 973 | |||||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 974 | 1123 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1124 | 1124 | |||||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 1125 | 1132 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1133 | 1133 | |||||||
| Detail | AUTH_REP_DTE_END | 8 | 1134 | 1141 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1142 | 1142 | |||||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 1143 | 1143 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1144 | 1144 | |||||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 1145 | 1154 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1155 | 1155 | |||||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 1156 | 1205 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1206 | 1206 | |||||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 1207 | 1256 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1257 | 1257 | |||||||
| Detail | AUTH_REP_ADR_CITY | 25 | 1258 | 1282 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1283 | 1283 | |||||||
| Detail | AUTH_REP_ADR_STATE | 2 | 1284 | 1285 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1286 | 1286 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 1287 | 1291 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1292 | 1292 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 1293 | 1296 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1297 | 1297 | |||||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 1298 | 1327 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1328 | 1328 | |||||||
| Detail | AUTH_REP_CDE_REP_TYPE (3rd) | 1 | 1329 | 1329 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1330 | 1330 | |||||||
| Detail | AUTH_REP NAM_FIRST | 35 | 1331 | 1365 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1366 | 1366 | |||||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 1367 | 1367 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1368 | 1368 | |||||||
| Detail | AUTH_REP_NAM_LAST | 60 | 1369 | 1428 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1429 | 1429 | |||||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 1430 | 1439 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1440 | 1440 | |||||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 1441 | 1590 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1591 | 1591 | |||||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 1592 | 1599 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1600 | 1600 | |||||||
| Detail | AUTH_REP_DTE_END | 8 | 1601 | 1608 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1609 | 1609 | |||||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 1610 | 1610 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1611 | 1611 | |||||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 1612 | 1621 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1622 | 1622 | |||||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 1623 | 1672 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1673 | 1673 | |||||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 1674 | 1723 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1724 | 1724 | |||||||
| Detail | AUTH_REP_ADR_CITY | 25 | 1725 | 1749 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1750 | 1750 | |||||||
| Detail | AUTH_REP_ADR_STATE | 2 | 1751 | 1752 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1753 | 1753 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 1754 | 1758 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1759 | 1759 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 1760 | 1763 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1764 | 1764 | |||||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 1765 | 1794 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1795 | 1795 | |||||||
| Detail | AUTH_REP_CDE_REP_TYPE (4th) | 1 | 1796 | 1796 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1797 | 1797 | |||||||
| Detail | AUTH_REP NAM_FIRST | 35 | 1798 | 1832 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1833 | 1833 | |||||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 1834 | 1834 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1835 | 1835 | |||||||
| Detail | AUTH_REP_NAM_LAST | 60 | 1836 | 1895 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1896 | 1896 | |||||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 1897 | 1906 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 1907 | 1907 | |||||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 1908 | 2057 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2058 | 2058 | |||||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 2059 | 2066 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2067 | 2067 | |||||||
| Detail | AUTH_REP_DTE_END | 8 | 2068 | 2075 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2076 | 2076 | |||||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 2077 | 2077 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2078 | 2078 | |||||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 2079 | 2088 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2089 | 2089 | |||||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 2090 | 2139 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2140 | 2140 | |||||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 2141 | 2190 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2191 | 2191 | |||||||
| Detail | AUTH_REP_ADR_CITY | 25 | 2192 | 2216 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2217 | 2217 | |||||||
| Detail | AUTH_REP_ADR_STATE | 2 | 2218 | 2219 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2220 | 2220 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 2221 | 2225 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2226 | 2226 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 2227 | 2230 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2231 | 2231 | |||||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 2232 | 2261 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2262 | 2262 | |||||||
| Detail | AUTH_REP_CDE_REP_TYPE (5th) | 1 | 2263 | 2263 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2264 | 2264 | |||||||
| Detail | AUTH_REP NAM_FIRST | 35 | 2265 | 2299 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2300 | 2300 | |||||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 2301 | 2301 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2302 | 2302 | |||||||
| Detail | AUTH_REP_NAM_LAST | 60 | 2303 | 2362 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2363 | 2363 | |||||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 2364 | 2373 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2374 | 2374 | |||||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 2375 | 2524 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2525 | 2525 | |||||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 2526 | 2533 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2534 | 2534 | |||||||
| Detail | AUTH_REP_DTE_END | 8 | 2535 | 2542 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2543 | 2543 | |||||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 2544 | 2544 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2545 | 2545 | |||||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 2546 | 2555 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2556 | 2556 | |||||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 2557 | 2606 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2607 | 2607 | |||||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 2608 | 2657 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2658 | 2658 | |||||||
| Detail | AUTH_REP_ADR_CITY | 25 | 2659 | 2683 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2684 | 2684 | |||||||
| Detail | AUTH_REP_ADR_STATE | 2 | 2685 | 2686 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2687 | 2687 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 2688 | 2692 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2693 | 2693 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 2694 | 2697 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2698 | 2698 | |||||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 2699 | 2728 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2729 | 2729 | |||||||
| Detail | AUTH_REP_CDE_REP_TYPE (6th) | 1 | 2730 | 2730 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2731 | 2731 | |||||||
| Detail | AUTH_REP NAM_FIRST | 35 | 2732 | 2766 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2767 | 2767 | |||||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 2768 | 2768 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2769 | 2769 | |||||||
| Detail | AUTH_REP_NAM_LAST | 60 | 2770 | 2829 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2830 | 2830 | |||||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 2831 | 2840 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2841 | 2841 | |||||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 2842 | 2991 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 2992 | 2992 | |||||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 2993 | 3000 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3001 | 3001 | |||||||
| Detail | AUTH_REP_DTE_END | 8 | 3002 | 3009 | NUMBER | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3010 | 3010 | |||||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 3011 | 3011 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3012 | 3012 | |||||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 3013 | 3022 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3023 | 3023 | |||||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 3024 | 3073 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3074 | 3074 | |||||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 3075 | 3124 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3125 | 3125 | |||||||
| Detail | AUTH_REP_ADR_CITY | 25 | 3126 | 3150 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3151 | 3151 | |||||||
| Detail | AUTH_REP_ADR_STATE | 2 | 3152 | 3153 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3154 | 3154 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 3155 | 3159 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3160 | 3160 | |||||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 3161 | 3164 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3165 | 3165 | |||||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 3166 | 3195 | CHAR | Yes, Can Be Null | |||||
| Detail | Filler | 1 | 3196 | 3196 | |||||||
| Detail | MEMBER_TYPE | 2 | 3197 | 3198 | CHAR | Yes, Never Null | Hard Code PM for the Weekly Eligibility Extract | ||||
| Detail | New Line | 1 | 3199 | 3199 |
| Trailer | Record Type | 3 | 1 | 3 | TRL' constant | |
| Trailer | Record Count | 11 | 4 | 14 | NUMBER | Physical Record count (not including trailer), right justify the number |
| Trailer | Filler | 3184 | 15 | 3198 | Spaces. To fill out the rest of the record | |
| Trailer | New line | 1 | 3199 | 3199 | newline character |
&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
Member Type Code
| Member Type | Description |
| PM | Member is new to Pathways |
Aid Category
| CDE_AID_CATEGORY | DSC_AID_CATEGORY |
| A | Aged |
| B | Blind |
| D | Disabled |
| DI | Working Disabled MEDWORKS Improved |
| DW | Working Disabled MEDWORKS |
| GF | Parent/Caretaker of Relative |
| SI | SSI Related |
| MEE | 1115 Medicaid Expedited Eligibility |
Waiver Categories
| CDE_AID_CATEGORY | DSC_AID_CATEGORY |
| WA00 | Aged and Disabled Waiver; (HCBS) |
| WA60 | A&D Waiver; Transition from NF (Non-MFP) (HCBS) |
| WA63 | A&D Waiver; Post MFP (HCBS) |
| WA71 | A&D Waiver; Transition from CHOICE Program (HCBS) |
| WEE | 1115 Waiver Expedited Eligiblity |
image1.png
File details come from the government source that posted it. Updated .