Pathways EB Pending File to EB.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
RFP 27-87793 FSSA OMPP Enrollment Broker ServicesBid Documents
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

File Type Posted
Att K (Addendum #1) SoW.docx DOCX document
RFP 27-87793 - Addendum #1 - Summary of Changes.docx DOCX document
HIP EB Assignment File to MMIS.xls XLS spreadsheet
HHW HCC EB Assignment File to MMIS.xls XLS spreadsheet
Att F (Addendum #1) - Technical Proposal - Enrollment Broker RFP 27-87793.docx DOCX document
Outbound dialer Details 2024-Present.xlsx XLSX spreadsheet
EB Notice Count by Type (2023-2026) updated.xlsx XLSX spreadsheet
Att D (Addendum #1) - Cost Proposal - Enrollment Broker RFP 27-87793.xlsx XLSX spreadsheet
Att G - Q&A (State Responses) (October 14, 2026).xlsx XLSX spreadsheet
RFP 27-87793 (Addendum #1) Main Document.pdf PDF
Att N (Addendum #1) - Performance Exhibit.docx DOCX document
Att_I_-_Pre-Proposal_Network_Form-Indiana Little Big Health Solutions.docx DOCX document
RFP 27-87793 - FSSA OMPP Enrollment Broker Services.docx DOCX document
RFP 27-87793 - Attachment I - ClinEfficiency Pro LLC.docx DOCX document
Att I - Pre-Proposal Network Form_Maximus.docx DOCX document
Att I - Pre-Proposal Network Form - Axon Advisors - IVOSB.docx DOCX document
Att I - Pre-Proposal Network Form - Vespa Group (IVOSB).docx DOCX document
Att I - Pre-Proposal Network Form_InclusiveStrategies.docx DOCX document
Att D - Cost Proposal - Enrollment Broker RFP 27-87793.xlsx XLSX spreadsheet
Att B1 - IOT-IaaS.docx DOCX document
Pathways Weekly Eligibility File to EB.xlsx XLSX spreadsheet
2024 - INEB Ongoing Notices Summary - Pathways.xlsx XLSX spreadsheet
2025 INEB Member Services.xlsx XLSX spreadsheet
Att E - Business Proposal.docx DOCX document
Att J - Attestation Form.docx DOCX document
Att H - Reference Check Form.docx DOCX document
Att B3 - IOT-SaaS.docx DOCX document
Att G - Q&A Template.xlsx XLSX spreadsheet
RFP 27-87793 Main Document.pdf PDF
2026 INEB Dashboard.xlsx XLSX spreadsheet
HHW HCC HIP Member Assignment File Update to EB.xlsx XLSX spreadsheet
Att M - Infrastructure Overview.docx DOCX document
HIP Member Demographic File to EB.xlsx XLSX spreadsheet
Att F - Technical Proposal - Enrollment Broker RFP 27-87793.docx DOCX document
Quarterly Potentials File to EB.xls XLS spreadsheet
Pathways EB Selection Assign Response File to EB.xlsx XLSX spreadsheet
Att L - AI - Technical Proposal Questions.docx DOCX document
2024 INEB Dashboard.xlsx XLSX spreadsheet
Potentials File to EB.xls XLS spreadsheet
Att I - Pre-Proposal Network Form.docx DOCX document
2024 INEB Member Services.xlsx XLSX spreadsheet
Level Of Care File to EB.xls XLS spreadsheet
Pre-Proposal Conference RFP 87793.pptx PPTX presentation
EB- Permanent Pathway Exclusion Report.xls XLS spreadsheet
Att A - IVOSB Commitment Form.docx DOCX document
MCE Provider File to EB.xlsx XLSX spreadsheet
2026 - INEB Ongoing Notices Summary - Pathways.xlsx XLSX spreadsheet
Att B2 - IOT-PaaS.docx DOCX document
Pathways EB Recipient File to EB.xlsx XLSX spreadsheet
2025 - INEB Ongoing Notices Summary - Pathways.xlsx XLSX spreadsheet
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 TypeFIELDFIELD SIZEFIELD STARTFIELD ENDFORMATREQUIRED FIELDTABLE NAMECOLUMNDESCRIPTIONNOTES
Record TypeField namenumber of charactersStart PositionEnd Positionfield typetable of origin/destinationcolumn nameAny relevant information such as where field originated, unique or identifying information, acronymns speeled out.
DetailID_MEDICAID12112CHARYes, Nevery Nult_re_baseid_medicaidRecipient IDNOT NULL
DetailFiller11313Space
DetailID_MEDICARE121425CHARYes, Can Be NullT_RE_HIB
DetailFiller12626Newline, "\n". Row by row reading
DetailNAM_PARTC_PLAN552781CHARYes, Can Be NullT_RE_TBQT_RE_TBQ where cycle date is between the T_RE_TBQ_GHO effective and end use sak_re_tbq
DetailFiller18282
DetailNAM_PARTC_ORG5583137CHARYes, Can Be NullT_RE_TBQ
DetailFiller1138138
DetailPLAN C EFFECTIVE DATE8139146Yes, Can Be NullT_RE_TBQ
DetailFiller1147147
DetailPLAN C END DATE8148155Yes, Can Be NullT_RE_TBQ
DetailFiller1156156
DetailIND_SPECIAL_NEEDS1157157CHARYes, Can Be NullT_RE_TBQ_PBPSELECT 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

DetailFiller1158158
DetailID_APPLICATION12159170CHARYes, Can Be Null
DetailFiller1171171Space
DetailCDE_APPLICATION_STATUS1172172CHARYes, Can Be Nullt_re_cde_appln_status
DetailFiller1173173Space
DetailDTE_APPLICATION8174181NUMBERYes, Nevery Nul
DetailFiller1182182Space
DetailDTE_APP_STATUS8183190NUMBERYes, Nevery Nul
DetailFiller1191191Space
DetailIND_URGNT_COV1192192CHARYes, Can Be Null
DetailFiller1193193
DetailMCE ID2194195CHARYes, Can Be Null
DetailFiller1196196
DetailAUTH_REP_CDE_REP_TYPE (1st)1197197CHARYes, Can Be Null
DetailFiller1198198
DetailAUTH_REP NAM_FIRST35199233CHARYes, Can Be Null
DetailFiller1234234
DetailAUTH_REP_NAM_MID_INIT1235235CHARYes, Can Be Null
DetailFiller1236236
DetailAUTH_REP_NAM_LAST60237296CHARYes, Can Be Null
DetailFiller1297297
DetailAUTH_REP_NAM_SUFFIX10298307CHARYes, Can Be Null
DetailFiller1308308
DetailAUTH_REP_NAM_ORGANIZATION_REP150309458CHARYes, Can Be Null
DetailFiller1459459
DetailAUTH_REP_DTE_EFFECTIVE8460467NUMBERYes, Can Be Null
DetailFiller1468468
DetailAUTH_REP_DTE_END8469476NUMBERYes, Can Be Null
DetailFiller1477477
DetailAUTH_REP_CDE_PHONE_TYPE1478478CHARYes, Can Be Null
DetailFiller1479479
DetailAUTH_REP_NUM_PHONE10480489CHARYes, Can Be Null
DetailFiller1490490
DetailAUTH_REP_ADR_STREET_150491540CHARYes, Can Be Null
DetailFiller1541541
DetailAUTH_REP_ADR_STREET_250542591CHARYes, Can Be Null
DetailFiller1592592
DetailAUTH_REP_ADR_CITY25593617CHARYes, Can Be Null
DetailFiller1618618
DetailAUTH_REP_ADR_STATE2619620CHARYes, Can Be Null
DetailFiller1621621
DetailAUTH_REP_ADR_ZIP_CODE5622626CHARYes, Can Be Null
DetailFiller1627627
DetailAUTH_REP_ADR_ZIP_CODE_44628631CHARYes, Can Be Null
DetailFiller1632632
DetailAUTH_REP_MSG_IN_CARE_TEXT30633662CHARYes, Can Be Null
DetailFiller1663663
DetailAUTH_REP_CDE_REP_TYPE (2nd)1664664CHARYes, Can Be Null
DetailFiller1665665
DetailAUTH_REP NAM_FIRST35666700CHARYes, Can Be Null
DetailFiller1701701
DetailAUTH_REP_NAM_MID_INIT1702702CHARYes, Can Be Null
DetailFiller1703703
DetailAUTH_REP_NAM_LAST60704763CHARYes, Can Be Null
DetailFiller1764764
DetailAUTH_REP_NAM_SUFFIX10765774CHARYes, Can Be Null
DetailFiller1775775
DetailAUTH_REP_NAM_ORGANIZATION_REP150776925CHARYes, Can Be Null
DetailFiller1926926
DetailAUTH_REP_DTE_EFFECTIVE8927934NUMBERYes, Can Be Null
DetailFiller1935935
DetailAUTH_REP_DTE_END8936943NUMBERYes, Can Be Null
DetailFiller1944944
DetailAUTH_REP_CDE_PHONE_TYPE1945945CHARYes, Can Be Null
DetailFiller1946946
DetailAUTH_REP_NUM_PHONE10947956CHARYes, Can Be Null
DetailFiller1957957
DetailAUTH_REP_ADR_STREET_1509581007CHARYes, Can Be Null
DetailFiller110081008
DetailAUTH_REP_ADR_STREET_25010091058CHARYes, Can Be Null
DetailFiller110591059
DetailAUTH_REP_ADR_CITY2510601084CHARYes, Can Be Null
DetailFiller110851085
DetailAUTH_REP_ADR_STATE210861087CHARYes, Can Be Null
DetailFiller110881088
DetailAUTH_REP_ADR_ZIP_CODE510891093CHARYes, Can Be Null
DetailFiller110941094
DetailAUTH_REP_ADR_ZIP_CODE_4410951098CHARYes, Can Be Null
DetailFiller110991099
DetailAUTH_REP_MSG_IN_CARE_TEXT3011001129CHARYes, Can Be Null
DetailFiller111301130
DetailAUTH_REP_CDE_REP_TYPE (3rd)111311131CHARYes, Can Be Null
DetailFiller111321132
DetailAUTH_REP NAM_FIRST3511331167CHARYes, Can Be Null
DetailFiller111681168
DetailAUTH_REP_NAM_MID_INIT111691169CHARYes, Can Be Null
DetailFiller111701170
DetailAUTH_REP_NAM_LAST6011711230CHARYes, Can Be Null
DetailFiller112311231
DetailAUTH_REP_NAM_SUFFIX1012321241CHARYes, Can Be Null
DetailFiller112421242
DetailAUTH_REP_NAM_ORGANIZATION_REP15012431392CHARYes, Can Be Null
DetailFiller113931393
DetailAUTH_REP_DTE_EFFECTIVE813941401NUMBERYes, Can Be Null
DetailFiller114021402
DetailAUTH_REP_DTE_END814031410NUMBERYes, Can Be Null
DetailFiller114111411
DetailAUTH_REP_CDE_PHONE_TYPE114121412CHARYes, Can Be Null
DetailFiller114131413
DetailAUTH_REP_NUM_PHONE1014141423CHARYes, Can Be Null
DetailFiller114241424
DetailAUTH_REP_ADR_STREET_15014251474CHARYes, Can Be Null
DetailFiller114751475
DetailAUTH_REP_ADR_STREET_25014761525CHARYes, Can Be Null
DetailFiller115261526
DetailAUTH_REP_ADR_CITY2515271551CHARYes, Can Be Null
DetailFiller115521552
DetailAUTH_REP_ADR_STATE215531554CHARYes, Can Be Null
DetailFiller115551555
DetailAUTH_REP_ADR_ZIP_CODE515561560CHARYes, Can Be Null
DetailFiller115611561
DetailAUTH_REP_ADR_ZIP_CODE_4415621565CHARYes, Can Be Null
DetailFiller115661566
DetailAUTH_REP_MSG_IN_CARE_TEXT3015671596CHARYes, Can Be Null
DetailFiller115971597
DetailAUTH_REP_CDE_REP_TYPE (4th)115981598CHARYes, Can Be Null
DetailFiller115991599
DetailAUTH_REP NAM_FIRST3516001634CHARYes, Can Be Null
DetailFiller116351635
DetailAUTH_REP_NAM_MID_INIT116361636CHARYes, Can Be Null
DetailFiller116371637
DetailAUTH_REP_NAM_LAST6016381697CHARYes, Can Be Null
DetailFiller116981698
DetailAUTH_REP_NAM_SUFFIX1016991708CHARYes, Can Be Null
DetailFiller117091709
DetailAUTH_REP_NAM_ORGANIZATION_REP15017101859CHARYes, Can Be Null
DetailFiller118601860
DetailAUTH_REP_DTE_EFFECTIVE818611868NUMBERYes, Can Be Null
DetailFiller118691869
DetailAUTH_REP_DTE_END818701877NUMBERYes, Can Be Null
DetailFiller118781878
DetailAUTH_REP_CDE_PHONE_TYPE118791879CHARYes, Can Be Null
DetailFiller118801880
DetailAUTH_REP_NUM_PHONE1018811890CHARYes, Can Be Null
DetailFiller118911891
DetailAUTH_REP_ADR_STREET_15018921941CHARYes, Can Be Null
DetailFiller119421942
DetailAUTH_REP_ADR_STREET_25019431992CHARYes, Can Be Null
DetailFiller119931993
DetailAUTH_REP_ADR_CITY2519942018CHARYes, Can Be Null
DetailFiller120192019
DetailAUTH_REP_ADR_STATE220202021CHARYes, Can Be Null
DetailFiller120222022
DetailAUTH_REP_ADR_ZIP_CODE520232027CHARYes, Can Be Null
DetailFiller120282028
DetailAUTH_REP_ADR_ZIP_CODE_4420292032CHARYes, Can Be Null
DetailFiller120332033
DetailAUTH_REP_MSG_IN_CARE_TEXT3020342063CHARYes, Can Be Null
DetailFiller120642064
DetailAUTH_REP_CDE_REP_TYPE (5th)120652065CHARYes, Can Be Null
DetailFiller120662066
DetailAUTH_REP NAM_FIRST3520672101CHARYes, Can Be Null
DetailFiller121022102
DetailAUTH_REP_NAM_MID_INIT121032103CHARYes, Can Be Null
DetailFiller121042104
DetailAUTH_REP_NAM_LAST6021052164CHARYes, Can Be Null
DetailFiller121652165
DetailAUTH_REP_NAM_SUFFIX1021662175CHARYes, Can Be Null
DetailFiller121762176
DetailAUTH_REP_NAM_ORGANIZATION_REP15021772326CHARYes, Can Be Null
DetailFiller123272327
DetailAUTH_REP_DTE_EFFECTIVE823282335NUMBERYes, Can Be Null
DetailFiller123362336
DetailAUTH_REP_DTE_END823372344NUMBERYes, Can Be Null
DetailFiller123452345
DetailAUTH_REP_CDE_PHONE_TYPE123462346CHARYes, Can Be Null
DetailFiller123472347
DetailAUTH_REP_NUM_PHONE1023482357CHARYes, Can Be Null
DetailFiller123582358
DetailAUTH_REP_ADR_STREET_15023592408CHARYes, Can Be Null
DetailFiller124092409
DetailAUTH_REP_ADR_STREET_25024102459CHARYes, Can Be Null
DetailFiller124602460
DetailAUTH_REP_ADR_CITY2524612485CHARYes, Can Be Null
DetailFiller124862486
DetailAUTH_REP_ADR_STATE224872488CHARYes, Can Be Null
DetailFiller124892489
DetailAUTH_REP_ADR_ZIP_CODE524902494CHARYes, Can Be Null
DetailFiller124952495
DetailAUTH_REP_ADR_ZIP_CODE_4424962499CHARYes, Can Be Null
DetailFiller125002500
DetailAUTH_REP_MSG_IN_CARE_TEXT3025012530CHARYes, Can Be Null
DetailFiller125312531
DetailAUTH_REP_CDE_REP_TYPE (6th)125322532CHARYes, Can Be Null
DetailFiller125332533
DetailAUTH_REP NAM_FIRST3525342568CHARYes, Can Be Null
DetailFiller125692569
DetailAUTH_REP_NAM_MID_INIT125702570CHARYes, Can Be Null
DetailFiller125712571
DetailAUTH_REP_NAM_LAST6025722631CHARYes, Can Be Null
DetailFiller126322632
DetailAUTH_REP_NAM_SUFFIX1026332642CHARYes, Can Be Null
DetailFiller126432643
DetailAUTH_REP_NAM_ORGANIZATION_REP15026442793CHARYes, Can Be Null
DetailFiller127942794
DetailAUTH_REP_DTE_EFFECTIVE827952802NUMBERYes, Can Be Null
DetailFiller128032803
DetailAUTH_REP_DTE_END828042811NUMBERYes, Can Be Null
DetailFiller128122812
DetailAUTH_REP_CDE_PHONE_TYPE128132813CHARYes, Can Be Null
DetailFiller128142814
DetailAUTH_REP_NUM_PHONE1028152824CHARYes, Can Be Null
DetailFiller128252825
DetailAUTH_REP_ADR_STREET_15028262875CHARYes, Can Be Null
DetailFiller128762876
DetailAUTH_REP_ADR_STREET_25028772926CHARYes, Can Be Null
DetailFiller129272927
DetailAUTH_REP_ADR_CITY2529282952CHARYes, Can Be Null
DetailFiller129532953
DetailAUTH_REP_ADR_STATE229542955CHARYes, Can Be Null
DetailFiller129562956
DetailAUTH_REP_ADR_ZIP_CODE529572961CHARYes, Can Be Null
DetailFiller129622962
DetailAUTH_REP_ADR_ZIP_CODE_4429632966CHARYes, Can Be Null
DetailFiller129672967
DetailAUTH_REP_MSG_IN_CARE_TEXT3029682997CHARYes, Can Be Null
DetailFiller129982998
DetailMEMBER_TYPE229993000CHARYes, Never Null
DetailFiller130013001CHARSPACE
DetailPending Aid Category Code530023006CHAR
DetailFiller130073007CHARSPACE
DetailPending Waiver Code530083012CHAR
DetailFiller130133013CHARSPACE
DetailPending LOC Code530143018CHAR
DetailFiller130193019newline characternewline character
DetailPARTC_NUM_CONTRACT530203024CHARYes, Can Be NullT_RE_TBQ_GHO
DetailFiller130253025
DetailPARTC_NUM_PLAN330263028CHARYes, Can Be NullT_RE_TBQ_PBP
DetailFiller130293029
DetailID_AUTH_REP (1st)1230303041CHARYes, Can Be Null
DetailFiller130423042
DetailID_AUTH_REP (2nd)1230433054CHARYes, Can Be Null
DetailFiller130553055
DetailID_AUTH_REP (3rd)1230563067CHARYes, Can Be Null
DetailFiller130683068
DetailID_AUTH_REP (4th)1230693080CHARYes, Can Be Null
DetailFiller130813081
DetailID_AUTH_REP (5th)1230823093CHARYes, Can Be Null
DetailFiller130943094
DetailID_AUTH_REP (6th)1230953106CHARYes, Can Be Null
DetailFiller131073107
TrailerRecord Type313TRL' constant
TrailerRecord Count11414NUMBERPhysical Record count (not including trailer), right justify the number
TrailerFiller3092153106Spaces. To fill out the rest of the record
TrailerNew line131073107newline 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 TypeDescription
NPNew Pending Record for the Member
EMPending 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 .