Potentials File to EB.xls
XLS spreadsheet 68 KB Posted
- 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
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 Type | FIELD | FIELD SIZE | Field Start | Field End | FORMAT | 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 | t_re_base | id_medicaid | Recipient ID | NOT NULL |
| Detail | Filler | 1 | 13 | 13 | Space | ||||
| Detail | DTE_ADDED | 8 | 14 | 21 | NUMBER | t_re_mc_recip | dte_added | Data added to potentials. "YYYYMMDD" | NOT NULL |
| Detail | Filler | 1 | 22 | 22 | Space | ||||
| Detail | IND_MC_ASSIGN | 1 | 23 | 23 | CHAR | Managed Care indicator. N. HPES sends SPACE | NOT NULL | ||
| Detail | Filler | 1 | 24 | 24 | Space | ||||
| Detail | CDE_REASON | 1 | 25 | 25 | CHAR | t_re_mc_recip | cde_reason | Reason Code added to potentials. A-Z, Space, 1-9. See Reason Tab | NOT NULL |
| Detail | Filler | 1 | 26 | 26 | Space | ||||
| Detail | CDE_RSN_MC_DET | 1 | 27 | 27 | CHAR | Managed Care Reason Code determination. A,D,K,L,M,R. HPES sends SPACE | NOT NULL | ||
| Detail | Filler | 1 | 28 | 28 | Space | ||||
| Detail | CDE_HEALTH_SUBPGM | 1 | 29 | 29 | CHAR | t_pub_hlth_pgm (through t_re_mc_recip.sak_pub_hlth) | cde_pgm_health* | *Code health subprogram. HH->R, CS->C, HIPMC->H, HCC->A | NOT NULL |
| Detail | Filler | 1 | 30 | 30 | Space | ||||
| Detail | CDE_RSN_DEL | 1 | 31 | 31 | CHAR | CDE_RSN_DEL | Reason Code removed from potentials. HPES sends SPACE | NOT NULL | |
| Detail | Filler | 1 | 32 | 32 | Newline, "\n". Row by row reading | ||||
| 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 | 14 | 15 | 31 | Spaces. To fill out the rest of the record | ||||
| Trailer | New line | 1 | 32 | 32 | newline 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_REASON | DSC_REASON_MC |
| Autoassignment -AA-W | |
| A | Immed default Auto-Assgmt |
| B | Pending For Manual Asgnmt |
| C | BA Assistance Maybe Required |
| D | Newborn Auto Assgnmt-AA-I |
| E | Redet dte>30 day ago-AA-I |
| F | Recipient has Medicare |
| G | PCCM Voluntary DSNRL-AA-W |
| H | MCE Voluntary DSNRL-AA-W |
| I | PCCM Mandatory DSNRL-AA-I |
| J | MCE Mandatory DSNRL-AA-I |
| K | Disabled |
| L | MCE dsnrl-PMP to PCCM |
| M | MCE dsnrl-PMP dsnrl |
| N | MCE DSNRL-PMP NoResponse |
| O | CHIPS -AA-W |
| R | MCE PMP moving to oth MCE |
| S | MCE PMP moving to PCCM |
| T | PCCM PMP moving to MCE |
| P | Package C -AA-W |
| Q | MCE dsnrl-PMP to oth MCE |
| U | PMP individ to group-AA-I |
| V | PMP group to individ-AA-I |
| W | PMP individ/individ -AA-I |
| X | PMP group to group -AA-I |
| 9 | Tried Immediate AA -AA-W |
| Z | Ineligible for AA |
| 1 | Re-eligible for AA |
| Y | Lockin -AA-I |
| 5 | HCC Opt In for AA |
| 6 | Opt Out - No AA |
| MS | Member App Selection |
| EB | Enrollment Broker Assist |
| 3Q | HP Dsnrl- MCE PMP Loc |
| 3R | HP Dsnrl- Prov. Med Term |
| 3S | HP Dsnrl- Grp Med Term |
| 3T | HP Dsnrl- PMP Loc |
| 3U | HP Dsnrl- PMP Grp Loc |
| 3V | HP Dsnrl- PMP not Loc |
| 3W | MCE Dsnrl- PMP not Loc |
| 3X | MCE Dsnrl- PMP not MCE |
| 3Y | MCE Dsnrl- PMP no mc Loc |
| 3Z | MCE Dsnrl- PMP deceased |
| GS | HIP GTW SUSPENSION |
File details come from the government source that posted it. Updated .