Pathways EB Pending File to EB.xlsx
XLSX spreadsheet 47 KB Posted
- Solicitation number
- RFP 27-87793
- Issued by
- Marion County, Indiana
About this file
This is an interface specification document for the Pathway Pending File to EB (Eligibility and Benefits) system, managed by the State of Indiana's Medicaid Management Information System (MMIS) and the Eligibility and Benefits division. The document provides technical specifications for data exchange of pending Pathways member information between MMIS and the EB system. The file transfer occurs Monday through Friday via Secure FTP using compressed zip file format (PEBPendyyyymmdd.nnnn.zip), with records selected based on pending member data criteria. The interface specification includes detailed layout requirements for 93 data fields organized into detail and trailer records, with field sizes ranging from 1 to 150 characters and total record lengths extending to position 3107. Key data elements include Medicaid and Medicare identifiers, Part C plan information, special needs indicators, application status details, authorized representative information (up to six representatives per record with contact and address details), member type classification, pending aid category codes, pending waiver codes, and pending level of care codes. The specification document has undergone multiple revisions since its initial release on March 30, 2023, with the most recent updates in June 2024 adding ID_AUTH_REP fields and incorporating MLTSS 6G requirements.
The interface specification does not contain pricing terms, set-asides, incumbent contractor information, or funding requirements, as it is a technical documentation file establishing data transmission standards rather than a procurement solicitation. Member type classifications include "NP" for new pending records and "EM" for updated pending records. All detail record fields are designated as required and nullable unless otherwise specified, with Medicaid ID being designated as never null. The document specifies that records must include newline characters at designated positions and maintain specific spacing and formatting standards to ensure proper system integration between MMIS and the EB system.
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 Pending File to EB |
| Description: This file provides Pening Pathways member data to the EB from MMIS. |
| 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: PEBPendyyyymmdd.nnnn.zip |
| Revision History |
| Initial Document, 20230330- Lee, J |
| Added Medicare Plan C Effective and End Dates 4/28//2023 |
| 5/18/2023: New value of 2983 for filler field size |
| 08/03/2023: Added Member Type in the Interface Layout and Member Type tab |
| 10/23/2023 added .zip in the file name |
| 12/20/2023 Added : |
Pending Aid Category Pending Waiver Pending LOC Modified the Trailer Record length Filler
| 04/26/2024: Added Num Contract and Num Plan (MLTSS 6G Requirements) |
| 06/14/2024: Added ID_AUTH_REP |
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, Nevery Nul | 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
| Detail | Filler | 1 | 158 | 158 | ||||
| Detail | ID_APPLICATION | 12 | 159 | 170 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 171 | 171 | Space | |||
| Detail | CDE_APPLICATION_STATUS | 1 | 172 | 172 | CHAR | Yes, Can Be Null | t_re_cde_appln_status | |
| Detail | Filler | 1 | 173 | 173 | Space | |||
| Detail | DTE_APPLICATION | 8 | 174 | 181 | NUMBER | Yes, Nevery Nul | ||
| Detail | Filler | 1 | 182 | 182 | Space | |||
| Detail | DTE_APP_STATUS | 8 | 183 | 190 | NUMBER | Yes, Nevery Nul | ||
| Detail | Filler | 1 | 191 | 191 | Space | |||
| Detail | IND_URGNT_COV | 1 | 192 | 192 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 193 | 193 | ||||
| Detail | MCE ID | 2 | 194 | 195 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 196 | 196 | ||||
| Detail | AUTH_REP_CDE_REP_TYPE (1st) | 1 | 197 | 197 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 198 | 198 | ||||
| Detail | AUTH_REP NAM_FIRST | 35 | 199 | 233 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 234 | 234 | ||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 235 | 235 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 236 | 236 | ||||
| Detail | AUTH_REP_NAM_LAST | 60 | 237 | 296 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 297 | 297 | ||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 298 | 307 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 308 | 308 | ||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 309 | 458 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 459 | 459 | ||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 460 | 467 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 468 | 468 | ||||
| Detail | AUTH_REP_DTE_END | 8 | 469 | 476 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 477 | 477 | ||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 478 | 478 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 479 | 479 | ||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 480 | 489 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 490 | 490 | ||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 491 | 540 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 541 | 541 | ||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 542 | 591 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 592 | 592 | ||||
| Detail | AUTH_REP_ADR_CITY | 25 | 593 | 617 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 618 | 618 | ||||
| Detail | AUTH_REP_ADR_STATE | 2 | 619 | 620 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 621 | 621 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 622 | 626 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 627 | 627 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 628 | 631 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 632 | 632 | ||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 633 | 662 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 663 | 663 | ||||
| Detail | AUTH_REP_CDE_REP_TYPE (2nd) | 1 | 664 | 664 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 665 | 665 | ||||
| Detail | AUTH_REP NAM_FIRST | 35 | 666 | 700 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 701 | 701 | ||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 702 | 702 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 703 | 703 | ||||
| Detail | AUTH_REP_NAM_LAST | 60 | 704 | 763 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 764 | 764 | ||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 765 | 774 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 775 | 775 | ||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 776 | 925 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 926 | 926 | ||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 927 | 934 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 935 | 935 | ||||
| Detail | AUTH_REP_DTE_END | 8 | 936 | 943 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 944 | 944 | ||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 945 | 945 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 946 | 946 | ||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 947 | 956 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 957 | 957 | ||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 958 | 1007 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1008 | 1008 | ||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 1009 | 1058 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1059 | 1059 | ||||
| Detail | AUTH_REP_ADR_CITY | 25 | 1060 | 1084 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1085 | 1085 | ||||
| Detail | AUTH_REP_ADR_STATE | 2 | 1086 | 1087 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1088 | 1088 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 1089 | 1093 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1094 | 1094 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 1095 | 1098 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1099 | 1099 | ||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 1100 | 1129 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1130 | 1130 | ||||
| Detail | AUTH_REP_CDE_REP_TYPE (3rd) | 1 | 1131 | 1131 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1132 | 1132 | ||||
| Detail | AUTH_REP NAM_FIRST | 35 | 1133 | 1167 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1168 | 1168 | ||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 1169 | 1169 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1170 | 1170 | ||||
| Detail | AUTH_REP_NAM_LAST | 60 | 1171 | 1230 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1231 | 1231 | ||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 1232 | 1241 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1242 | 1242 | ||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 1243 | 1392 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1393 | 1393 | ||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 1394 | 1401 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1402 | 1402 | ||||
| Detail | AUTH_REP_DTE_END | 8 | 1403 | 1410 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1411 | 1411 | ||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 1412 | 1412 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1413 | 1413 | ||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 1414 | 1423 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1424 | 1424 | ||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 1425 | 1474 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1475 | 1475 | ||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 1476 | 1525 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1526 | 1526 | ||||
| Detail | AUTH_REP_ADR_CITY | 25 | 1527 | 1551 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1552 | 1552 | ||||
| Detail | AUTH_REP_ADR_STATE | 2 | 1553 | 1554 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1555 | 1555 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 1556 | 1560 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1561 | 1561 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 1562 | 1565 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1566 | 1566 | ||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 1567 | 1596 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1597 | 1597 | ||||
| Detail | AUTH_REP_CDE_REP_TYPE (4th) | 1 | 1598 | 1598 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1599 | 1599 | ||||
| Detail | AUTH_REP NAM_FIRST | 35 | 1600 | 1634 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1635 | 1635 | ||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 1636 | 1636 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1637 | 1637 | ||||
| Detail | AUTH_REP_NAM_LAST | 60 | 1638 | 1697 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1698 | 1698 | ||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 1699 | 1708 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1709 | 1709 | ||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 1710 | 1859 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1860 | 1860 | ||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 1861 | 1868 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1869 | 1869 | ||||
| Detail | AUTH_REP_DTE_END | 8 | 1870 | 1877 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1878 | 1878 | ||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 1879 | 1879 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1880 | 1880 | ||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 1881 | 1890 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1891 | 1891 | ||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 1892 | 1941 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1942 | 1942 | ||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 1943 | 1992 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 1993 | 1993 | ||||
| Detail | AUTH_REP_ADR_CITY | 25 | 1994 | 2018 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2019 | 2019 | ||||
| Detail | AUTH_REP_ADR_STATE | 2 | 2020 | 2021 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2022 | 2022 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 2023 | 2027 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2028 | 2028 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 2029 | 2032 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2033 | 2033 | ||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 2034 | 2063 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2064 | 2064 | ||||
| Detail | AUTH_REP_CDE_REP_TYPE (5th) | 1 | 2065 | 2065 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2066 | 2066 | ||||
| Detail | AUTH_REP NAM_FIRST | 35 | 2067 | 2101 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2102 | 2102 | ||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 2103 | 2103 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2104 | 2104 | ||||
| Detail | AUTH_REP_NAM_LAST | 60 | 2105 | 2164 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2165 | 2165 | ||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 2166 | 2175 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2176 | 2176 | ||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 2177 | 2326 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2327 | 2327 | ||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 2328 | 2335 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2336 | 2336 | ||||
| Detail | AUTH_REP_DTE_END | 8 | 2337 | 2344 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2345 | 2345 | ||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 2346 | 2346 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2347 | 2347 | ||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 2348 | 2357 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2358 | 2358 | ||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 2359 | 2408 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2409 | 2409 | ||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 2410 | 2459 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2460 | 2460 | ||||
| Detail | AUTH_REP_ADR_CITY | 25 | 2461 | 2485 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2486 | 2486 | ||||
| Detail | AUTH_REP_ADR_STATE | 2 | 2487 | 2488 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2489 | 2489 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 2490 | 2494 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2495 | 2495 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 2496 | 2499 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2500 | 2500 | ||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 2501 | 2530 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2531 | 2531 | ||||
| Detail | AUTH_REP_CDE_REP_TYPE (6th) | 1 | 2532 | 2532 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2533 | 2533 | ||||
| Detail | AUTH_REP NAM_FIRST | 35 | 2534 | 2568 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2569 | 2569 | ||||
| Detail | AUTH_REP_NAM_MID_INIT | 1 | 2570 | 2570 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2571 | 2571 | ||||
| Detail | AUTH_REP_NAM_LAST | 60 | 2572 | 2631 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2632 | 2632 | ||||
| Detail | AUTH_REP_NAM_SUFFIX | 10 | 2633 | 2642 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2643 | 2643 | ||||
| Detail | AUTH_REP_NAM_ORGANIZATION_REP | 150 | 2644 | 2793 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2794 | 2794 | ||||
| Detail | AUTH_REP_DTE_EFFECTIVE | 8 | 2795 | 2802 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2803 | 2803 | ||||
| Detail | AUTH_REP_DTE_END | 8 | 2804 | 2811 | NUMBER | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2812 | 2812 | ||||
| Detail | AUTH_REP_CDE_PHONE_TYPE | 1 | 2813 | 2813 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2814 | 2814 | ||||
| Detail | AUTH_REP_NUM_PHONE | 10 | 2815 | 2824 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2825 | 2825 | ||||
| Detail | AUTH_REP_ADR_STREET_1 | 50 | 2826 | 2875 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2876 | 2876 | ||||
| Detail | AUTH_REP_ADR_STREET_2 | 50 | 2877 | 2926 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2927 | 2927 | ||||
| Detail | AUTH_REP_ADR_CITY | 25 | 2928 | 2952 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2953 | 2953 | ||||
| Detail | AUTH_REP_ADR_STATE | 2 | 2954 | 2955 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2956 | 2956 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE | 5 | 2957 | 2961 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2962 | 2962 | ||||
| Detail | AUTH_REP_ADR_ZIP_CODE_4 | 4 | 2963 | 2966 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2967 | 2967 | ||||
| Detail | AUTH_REP_MSG_IN_CARE_TEXT | 30 | 2968 | 2997 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 2998 | 2998 | ||||
| Detail | MEMBER_TYPE | 2 | 2999 | 3000 | CHAR | Yes, Never Null | ||
| Detail | Filler | 1 | 3001 | 3001 | CHAR | SPACE | ||
| Detail | Pending Aid Category Code | 5 | 3002 | 3006 | CHAR | |||
| Detail | Filler | 1 | 3007 | 3007 | CHAR | SPACE | ||
| Detail | Pending Waiver Code | 5 | 3008 | 3012 | CHAR | |||
| Detail | Filler | 1 | 3013 | 3013 | CHAR | SPACE | ||
| Detail | Pending LOC Code | 5 | 3014 | 3018 | CHAR | |||
| Detail | Filler | 1 | 3019 | 3019 | newline character | newline character | ||
| Detail | PARTC_NUM_CONTRACT | 5 | 3020 | 3024 | CHAR | Yes, Can Be Null | T_RE_TBQ_GHO | |
| Detail | Filler | 1 | 3025 | 3025 | ||||
| Detail | PARTC_NUM_PLAN | 3 | 3026 | 3028 | CHAR | Yes, Can Be Null | T_RE_TBQ_PBP | |
| Detail | Filler | 1 | 3029 | 3029 | ||||
| Detail | ID_AUTH_REP (1st) | 12 | 3030 | 3041 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 3042 | 3042 | ||||
| Detail | ID_AUTH_REP (2nd) | 12 | 3043 | 3054 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 3055 | 3055 | ||||
| Detail | ID_AUTH_REP (3rd) | 12 | 3056 | 3067 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 3068 | 3068 | ||||
| Detail | ID_AUTH_REP (4th) | 12 | 3069 | 3080 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 3081 | 3081 | ||||
| Detail | ID_AUTH_REP (5th) | 12 | 3082 | 3093 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 3094 | 3094 | ||||
| Detail | ID_AUTH_REP (6th) | 12 | 3095 | 3106 | CHAR | Yes, Can Be Null | ||
| Detail | Filler | 1 | 3107 | 3107 |
| 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 | 3092 | 15 | 3106 | Spaces. To fill out the rest of the record | |
| Trailer | New line | 1 | 3107 | 3107 | 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
| Member Type | Description |
| NP | New Pending Record for the Member |
| EM | Pending Record is not a new Pending Record for the record (i.e., record updated) |
image1.png
File details come from the government source that posted it. Updated .