Quarterly Potentials File to EB.xls
XLS spreadsheet 70 KB Posted
- Solicitation number
- RFP 27-87793
- Issued by
- Marion County, Indiana
About this file
This is an Interface Specification document for the Quarterly Potentials File to EB, detailing the data exchange protocol between CoreMMIS (the sender) and EB (the receiver) for the Indiana Title XIX program managed by EDS. The interface transmits quarterly potential HCC member data via secure FTP, with the file generated according to record selection criteria MC_FTS_MGDJQ619. The specification establishes the technical requirements for data formatting, field definitions, and file structure, including 12 detail record fields containing medicaid recipient identification, dates added to potentials, managed care assignments, reason codes, health subprogram codes, and reason codes for removal from potentials. The file layout includes a trailer record that documents physical record counts. The business unit ownership resides with Managed Care, and recent revisions to the specification occurred in April 2022 and May 2021, with updates removing HHW and HIP extract data.
The specification document does not contain pricing terms, contract award dates, project timelines, or funding information. The interface employs standardized field formats including character and numeric data types, with all fields designated as NOT NULL to ensure data integrity. The file naming convention follows the pattern POTENTIAL${run_date}.1619 and is transmitted to the secure FTP directory path ${FTPDIR}/mgd/outbound/eb/. No set-asides, incumbent information, or renewal options are referenced in this technical specification document.
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: Quarterly Potentials File to EB | ||
| Description: This file provides Quarterly potential HCC member data to the EB from CoreMMIS. | ||
| Record Selection Criteria: MC_FTS_MGDJQ619 | ||
| Frequency: Quarterly | ||
| 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}.1619 | ||
| Revision Comments | Revision Date | |
| Reviewed, file layout matches the Potentials File to EB file layout and extract Potential.yyyymmdd.0619 layout | ||
| Was not able to locate a Potential.yyyymmdd.1619 file in File Exchange for layout and file data comparison | 5/19/21 | |
| Updated Interface Spec document - ALM ID 19712 removed HHW and HIP extract data | 4/11/22 |
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
File details come from the government source that posted it. Updated .