Potentials File to EB.xls

XLS spreadsheet 68 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 prepared by EDS - Indiana for the Title XIX program, detailing the technical requirements for a data exchange interface called the Potentials File to EB (Enrollment Broker). The interface facilitates the transfer of potential HCC (Health Care Cooperative) member data from CoreMMIS to the EB system on a Monday through Friday frequency using secure FTP transmission. The system processes recipient identification data, managed care assignment indicators, reason codes for enrollment determinations, and health subprogram classifications. The file structure includes detail records containing 12-character Medicaid IDs, date-added timestamps, managed care assignment indicators, reason codes categorized from A-Z and 1-9, and reason code determination fields, with each record formatted to specific character positions and field lengths. A trailer record provides the physical record count for validation purposes.

The interface specification includes comprehensive reason code definitions that categorize recipients into various enrollment scenarios, including autoassignment determinations, pending manual assignments, Medicare beneficiaries, voluntary and mandatory managed care plan enrollments, newborn assignments, and disenrollment processing. The document reflects revisions dating from February 2020 through April 2022, indicating ongoing system updates and logo changes reflecting vendor transitions from DXC to Gainwell. The specification maintains alignment with current operational file layouts and includes removal of HHW and HIP processes as of the April 2022 revision. The managed care process is owned by the Managed Care Business Unit, with no special error handling protocols noted beyond standard interface validation procedures.

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
Pathways EB Pending File to EB.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
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: Potentials File to EB
Description: This file provides potential HCC member data to the EB from CoreMMIS.
Record Selection Criteria: MC_FTS_MGDJS619
Frequency: Monday - Friday
Sender: CoreMMIS
Receiver: EB
Business Unit Ownership: Managed Care
Error Handling/Special Processing: N/A
Interface Exchange Method: Secure FTP
File Name: ${FTPDIR}/mgd/outbound/eb/POTENTIAL${run_date}.0619
Revison History:

2/26/2020 - Victor Arellanes - Added DXC Logo, Changed frequency and Added Reason Codes Tab

5/19/2021 - JAHeady Reviewd for Interfance Spces Layout match to actual file created
4/11/2022 - Victor A. Added Gainwell Logo, updated specs ALM ID 19712 removed HHW and HIP from the process

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 EndFORMATTABLE 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_MEDICAID12112CHARt_re_baseid_medicaidRecipient IDNOT NULL
DetailFiller11313Space
DetailDTE_ADDED81421NUMBERt_re_mc_recipdte_addedData added to potentials. "YYYYMMDD"NOT NULL
DetailFiller12222Space
DetailIND_MC_ASSIGN12323CHARManaged Care indicator. N. HPES sends SPACENOT NULL
DetailFiller12424Space
DetailCDE_REASON12525CHARt_re_mc_recipcde_reasonReason Code added to potentials. A-Z, Space, 1-9. See Reason TabNOT NULL
DetailFiller12626Space
DetailCDE_RSN_MC_DET12727CHARManaged Care Reason Code determination. A,D,K,L,M,R. HPES sends SPACENOT NULL
DetailFiller12828Space
DetailCDE_HEALTH_SUBPGM12929CHARt_pub_hlth_pgm (through t_re_mc_recip.sak_pub_hlth)cde_pgm_health**Code health subprogram. HH->R, CS->C, HIPMC->H, HCC->ANOT NULL
DetailFiller13030Space
DetailCDE_RSN_DEL13131CHARCDE_RSN_DELReason Code removed from potentials. HPES sends SPACENOT NULL
DetailFiller13232Newline, "\n". Row by row reading
TrailerRecord Type313TRL' constant
TrailerRecord Count11414NUMBERPhysical Record count (not including trailer), right justify the number
TrailerFiller141531Spaces. To fill out the rest of the record
TrailerNew line13232newline character

&L&G&C&"Arial,Bold"&12Interface Specification Document&R&8&D &L&8&F&C&8&P of &N &R&8EDS - Indiana Title XIX 950 N. Meridian St., Suite 1150 Indianapolis, IN 46204

Reason Codes

CDE_REASONDSC_REASON_MC
Autoassignment -AA-W
AImmed default Auto-Assgmt
BPending For Manual Asgnmt
CBA Assistance Maybe Required
DNewborn Auto Assgnmt-AA-I
ERedet dte>30 day ago-AA-I
FRecipient has Medicare
GPCCM Voluntary DSNRL-AA-W
HMCE Voluntary DSNRL-AA-W
IPCCM Mandatory DSNRL-AA-I
JMCE Mandatory DSNRL-AA-I
KDisabled
LMCE dsnrl-PMP to PCCM
MMCE dsnrl-PMP dsnrl
NMCE DSNRL-PMP NoResponse
OCHIPS -AA-W
RMCE PMP moving to oth MCE
SMCE PMP moving to PCCM
TPCCM PMP moving to MCE
PPackage C -AA-W
QMCE dsnrl-PMP to oth MCE
UPMP individ to group-AA-I
VPMP group to individ-AA-I
WPMP individ/individ -AA-I
XPMP group to group -AA-I
9Tried Immediate AA -AA-W
ZIneligible for AA
1Re-eligible for AA
YLockin -AA-I
5HCC Opt In for AA
6Opt Out - No AA
MSMember App Selection
EBEnrollment Broker Assist
3QHP Dsnrl- MCE PMP Loc
3RHP Dsnrl- Prov. Med Term
3SHP Dsnrl- Grp Med Term
3THP Dsnrl- PMP Loc
3UHP Dsnrl- PMP Grp Loc
3VHP Dsnrl- PMP not Loc
3WMCE Dsnrl- PMP not Loc
3XMCE Dsnrl- PMP not MCE
3YMCE Dsnrl- PMP no mc Loc
3ZMCE Dsnrl- PMP deceased
GSHIP GTW SUSPENSION

File details come from the government source that posted it. Updated .