Hub Electronic Data Interchange (EDI) File Naming Conventions

Transcription

HubElectronic Data Interchange (EDI) File NamingConventionsSeptember 2019Version 35.1Quality Software Services, Inc.10480 Little Patuxent Parkway, Suite 1100Columbia, MD 21044Main: 301-977-7884Fax: 410-740-4281Hub Style Template - May 2018

HubEDI File Naming ConventionsTable of Contents1Introduction . 11.123Purpose . 1Filename Sections . 22.1Trading Partner Identifier . 22.2Application Identifier . 22.3Function Code . 22.4Date . 22.5Time . 22.6Environment Code . 32.7Direction . 3Filename Formats . 43.1Filename Format for Files Received by External Entities (Outbound from CMS) . 43.2Filename Format for Files Sent by External Entities (Inbound to CMS) . 44Filename Restrictions . 55Function Codes and Application IDs for EDI Transactions. 65.1Issuer-Related Transactions . 65.2SBE-Related Transactions .20Appendix A - Glossary of Terms, Acronyms, and Definitions.23Appendix B - Referenced Documents .28Appendix C - Record of Changes .29List of TablesTable 1 - Filename Format for Files Received by External Entities. 4Table 2 - Filename Format for Files Sent by External Entities . 4Table 3 - Length Restrictions . 5Table 4 - Issuer-Related Transactions . 6Table 5 - Sample Filenames - Inbound to CMS from Issuers . 9Table 6 - Sample Filenames - Outbound from CMS to Issuers.13Table 7 - SBE-Related Transactions .20Table 8 - Sample Filenames - Inbound to CMS from SBEs .20Table 9 - Sample Filenames - Outbound from CMS to SBEs .21Table 10 - Glossary of Terms, Acronyms, and Definitions .23Table 11 - Referenced Documents.28Table 12 - Record of Changes .29September 2019iiUse or disclosure of data in this document is subject to restriction.

HubEDI File Naming Conventions1 IntroductionOn March 23, 2010, the President signed into law the Patient Protection and Affordable CareAct (PPACA) (P.L. 111-148). On March 30, 2010, the President signed into law the Healthcareand Education Reconciliation Act (HCERA) of 2010 (P.L. 111-152. These two laws comprise theAffordable Care Act (ACA).The ACA creates new competitive private health insurance markets, or Exchanges, whichprovide millions of Americans and small businesses access to affordable coverage. Exchangeshelp individuals and small employers shop for, select, and enroll in high quality, private healthplans that fit their needs. Exchanges are required to incorporate interoperable and securestandards and protocols the Secretary of the Department of Health and Human Services (HHS)developed in accordance with § 3021 of the Public Health Service (PHS) Act.This is a living document that evolves, and that the Quality Software Services, Incorporated(QSSI) Hub Team, or the Team, updates upon identification of more timely and effectiveprocedures.See Appendix B - Referenced Documents for a list and description of documents this documentreferences or that are applicable to the development and use of this document.1.1 PurposeThe ACA requires the use of a single, streamlined application to determine eligibility forenrollment in a qualified health plan (QHP), and for insurance affordability programs, includingadvance payment of the premium tax credit (APTC), Cost-Sharing Reductions (CSRs),Medicaid, Children’s Health Insurance Program (CHIP), and the Basic Health Program (BHP)where applicable. As part of the eligibility determination process, the system may also use thisdata to identify Applicants who qualify for an exemption from the individual responsibilityrequirement. The ability of an individual to access the appropriate coverage across multipleinsurance affordability programs through a single, streamlined application and coordinatedeligibility process means that no matter how an individual submits an application, or whichinsurance affordability program the Applicant may be eligible for, an individual experiences aconsistent process and receives a consistent eligibility determination, without the need to submitinformation to multiple entities.An Issuer provides, or issues, insurance to an Applicant. The Issuer and the Exchange transferdata through ASC X12 files. An Enterprise File Transfer (EFT) solution facilitates thiscommunication of data. To make the movement of files easier, the filenames of the filestransferred must be easy to understand and have a common format.This document explains formats for the filenames that external entities (like Issuers) receive andsend through EFT.September 20191Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming Conventions2 Filename SectionsThe filenames proposed for usage by external entities consist of the following sections: Trading Partner (TP) Identifier (ID)Application IDFunction CodeDateTimeEnvironment CodeDirection2.1 Trading Partner IdentifierThe TP ID section of the filename is the identification number assigned to the TP.2.2 Application IdentifierThe Application ID section of the filename is an ID for the application that processes the files.This section specifies the target application where the system routes the file. This is a staticvalue in most cases.For Hub-related files, use DSH as the Application ID.See Section 5 - Function Codes and Application IDs for EDI Transactions for the Application IDlist. See Section 4 - Filename Restrictions for field restrictions.2.3 Function CodeThe Function Code section of the filename is an alphanumeric code indicating the functionalpurpose of the file within the application. This also helps identify specific processing once thesystem routes the file to the application. Application owners work with their Partners and definethese codes for the various files exchanged.See Section 5 - Function Codes and Application IDs for EDI Transactions for the function codeslist. See Section 4 - Filename Restrictions for field restrictions.2.4 DateThe Date section of the filename specifies the date the file transferred in DYYMMDD formatwhere YY is the last two digits of the year, MM is the month, and DD is the day of the month.The first D is static text.2.5 TimeThe Time section of the filename specifies the time created (timestamp) for the file inTHHMMSSmmm format where HH is hours, MM is minutes, SS is seconds, and mmm ismilliseconds. The T is static text and exactly nine numerals must follow.September 20192Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming Conventions2.6 Environment CodeThe Environment Code section of the filename is a single character code indicating theenvironment to which the system transfers the file. Permitted values are as follows: P for Production Environment (PROD)T for Test Environment (TEST) and Implementation Environment (IMP)1AI for IMP22.7 DirectionThe Direction section of the filename indicates the direction in which the data flows, towards theCenters for Medicare & Medicaid Services (CMS) or away from CMS: IN for to CMSOUT for from CMSSee Section 4 - Filename Restrictions for field restrictions.September 20193Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming Conventions3 Filename FormatsThis section presents the format filenames must follow to allow Hub processing.3.1 Filename Format for Files Received by ExternalEntities (Outbound from CMS)The files sent from CMS to Partners must follow the format in Table 1 - Filename Format forFiles Received by External Entities.Table 1 - Filename Format for Files Received by External D130214T145543452POUTFormat: ionExample: 1234567890.999.D130223.T145543411.P.OUTNote: A period (.) is the separator for file segments.3.2 Filename Format for Files Sent by ExternalEntities (Inbound to CMS)The files sent to CMS from Partners must follow the format in Table 2 - Filename Format forFiles Sent by External Entities.Table 2 - Filename Format for Files Sent by External EntitiesItemSection Section SectionSectionFieldTPIDLength/ Format 1-10ExampleSectionAppIdFuncCode Date31-6DYYMMDD THHMMSSmmm 12IC834D130215IN1234567890 DSHTimeSection SectionT145543453EnvPDirectionFormat: DirectionExample: 1234567890.DSH.IC834.D130223.T145543452.P.INNote: A period (.) is the separator for file segments.September 20194Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming Conventions4 Filename RestrictionsTable 3 - Length Restrictions presents length restrictions for filename sections.Table 3 - Length RestrictionsSectionLengthCommentsApplication ID3Hub, Federally Facilitated Exchange (FFE), Multidimensional InsuranceData Analytics System (MIDAS), etc.Date7DYYMMDD where first character D is static text and remaining charactersare date in YYMMDD formatDirection2-3IN for files coming into CMS and OUT for files going out of CMSEnvironmentCode1P for PROD, T for TEST or IMP1A, I for IMP2Function Code3-6I834, 999, S820, etc.Time10THHMMSSmmm where character T is static text and remainingcharacters are time in HHMMSSmmm formatTP ID5-10Identifies TP transmitting/receiving files with CMSSeptember 20195Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming Conventions5 Function Codes and Application IDs for EDITransactionsThis section presents function codes and Application IDs for EDI transactions.5.1 Issuer-Related TransactionsTable 4 - Issuer-Related Transactions presents a list of function codes related to the Issuercommunity including State-Based Exchange (SBE) Issuers, both inbound to CMS and outboundfrom CMS.Table 4 - Issuer-Related TransactionsInbound D9September 20196Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming N/AMOIPA0N/AMSWTCHN/AOP834TN/AORPHN7September 20197Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming FLN/ARI834TSeptember 20198Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTable 5 - Sample Filenames - Inbound to CMS from Issuers presents a list of sample filenames for files inbound to CMS fromIssuers.Table 5 - Sample Filenames - Inbound to CMS from IssuersTransactionFile TypeTransaction CodeFunction CodeApplication IDExample (Issuers with TP ID as 1234567890)1A Workbooks Sent toCMSZIP 001023.P.INAcknowledgement(ACK) FileEDI[TA1] .INBusiness ApplicationAcknowledgement(BAA) for BenefitEnrollmentMaintenance (834Transaction) forIndividual MarketExtensible BA.D130223.T145543452.P.INBAA for BenefitEnrollmentMaintenance (834Transaction) for SmallBusiness HealthOptions Program(SHOP) .T145543452.P.INBAA for PaymentOrder/RemittanceAdvice (820Transaction) forIndividual Market(Initial and .T145543452.P.IN[999]005010X231A1September 20199Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTransactionFile TypeTransaction CodeFunction CodeApplication IDExample (Issuers with TP ID as 1234567890)BAA for PaymentOrder/RemittanceAdvice (820Transaction) for SHOPMarket (Initial 223.T145543452.P.INBenefit Enrollment andMaintenance (834Transaction) ConfirmationTransaction forIndividual D130223.T145543452.P.INBenefit Enrollment andMaintenance (834Transaction) ConfirmationTransaction for 834.D130223.T145543452.P.INBenefit Enrollment andMaintenance (834Transaction) - MonthlyInbound Audit file forIndividual 67890.DSH.IA834.D130223.T145543452.P.INBenefit Enrollment andMaintenance (834Transaction) - MonthlyInbound Audit file forSHOP 67890.DSH.SA834.D130223.T145543452.P.INSeptember 201910Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTransactionFile TypeTransaction CodeFunction CodeApplication IDExample (Issuers with TP ID as 1234567890)CSR ReconciliationAttestation File for2014 and 2015ZIP 543452.P.INCSR ReconciliationData File for 2014 and2015Text 52.P.INEmployee RosterSpreadsheetMicrosoftExcel 45543452.P.INEnrollment DataBaseline/Reconciliation File for 2014Text 52.P.INEnrollment DataReconciliation File for2015Text 543452.P.INEnrollment DataReconciliation File for2016Text 543452.P.INEnrollment DataReconciliation File for2017Text 001023.P.INEnrollment DataReconciliation File for2018Text 3452.P.INEnrollment DataReconciliation File for2019Text 3452.P.INSeptember 201911Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTransactionFile TypeTransaction CodeFunction CodeApplication IDExample (Issuers with TP ID as 1234567890)Enrollment DataReconciliation File for2020Text 3452.P.INEnrollmentReconciliation DisputeForm for IndividualMarketText File/MicrosoftExcel 70001023.P.INInbound SHOPEnrollmentReconciliation FileText 3452.P.INPayment DisputeCommunication toCMSText File/MicrosoftExcel 70001023.P.INResponse to EmployerGroup D130223.T145543452.P.INSHOP EnrollmentReconciliation DisputeResolution Form(Issuer to FederallyFacilitated SmallBusiness HealthOptions Program (FFSHOP))Text 543452.P.INSeptember 201912Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTransactionResponse files sentback by issuers toCMS for theUnauthorizedEnrollment Finder File(UEFF) files confirmingif a policy should berescinded due to fraudFile TypeText FileTransaction CodeN/AFunction CodeRESOFLApplication IDMIDExample (Issuers with TP ID as 2.P.INTable 6 - Sample Filenames - Outbound from CMS to Issuers presents a list of sample filenames for files outbound from CMS toIssuers.Table 6 - Sample Filenames - Outbound from CMS to IssuersTransactionTransactionFile TypeCodeFunctionCodeExample (Issuers with TP ID as 1234567890)1095A Files to Issuers for 20*4Text P.OUT1095A Files to Issuers for 20*5Text P.OUT1095A Files to Issuers for 20*6Text P.OUT1095A Files to Issuers for 20*7Text P.OUT1095A Files to Issuers for 2018Text P.OUT1095A Files to Issuers for 2019Text P.OUT1095A Files to Issuers for 2020Text P.OUTMicrosoftExcel 1.P.OUT1095A Workbooks to Issuers834 FFE Update Transactions toIssuersText P.OUT834 Mismatch Transactions to IssuersText P.OUTSeptember 201913Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTransactionFile TypeTransactionCodeFunctionCodeExample (Issuers with TP ID as 1234567890)EDI/XML/Text TBAA for Benefit EnrollmentMaintenance (834 Transaction) Confirmation transaction for 223.T145543411.P.OUTBAA For Benefit EnrollmentMaintenance (834 Transaction) Confirmation Transaction for 45543411.P.OUTBenefit Enrollment And Maintenance(834 Transaction) - Auto Re-EnrollmentTransaction for Individual 23.T145543411.P.OUTBenefit Enrollment and Maintenance(834 Transaction) - Change inCircumstances 23.T145543452.P.OUTBenefit Enrollment and Maintenance(834 Transaction) - Monthly Update filefor Individual Market 34.D130223.T145543411.P.OUTBenefit Enrollment and Maintenance(834 Transaction) - Monthly Update filefor SHOP Market 34.D130223.T145543411.P.OUTBenefit Enrollment and Maintenance(834 Transaction) for Individual 145543411.P.OUTBenefit Enrollment and Maintenance(834 Transaction) for SHOP 145543411.P.OUTBenefit Enrollment and Maintenance(834 Transaction) - TransactionsResent for Individual 23.T145543411.P.OUTAny Miscellaneous TransactionSeptember 201914Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTransactionFile TypeTransactionCodeFunctionCodeExample (Issuers with TP ID as 1234567890)Benefit Enrollment and Maintenance(834) - Transaction Resent for 130223.T145543411.P.OUTData file with list of members and theircontact information for Issuers toconduct outreach to listed membersText P.OUTEligibility Data Matching Issues FileText OUTEmployer Group Business 1.P.OUTEnrollment DataBaseline/Reconciliation File for 2014Text TEnrollment Data Reconciliation File for2015Text P.OUTEnrollment Data Reconciliation File for2016Text P.OUTEnrollment Data Reconciliation File for2017Text P.OUTEnrollment Data Reconciliation File for2018Text OUTEnrollment Data Reconciliation File for2019Text OUTEnrollment Data Reconciliation File for2020Text OUTEnrollment extract provides financialinformation for SBEs and SBE Issuersto give insight into payments forupcoming payment 411.P.OUTEnrollment Pre-Audit File for 2014Text P.OUTSeptember 201915Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTransactionFile TypeTransactionCodeFunctionCodeExample (Issuers with TP ID as 1234567890)Enrollment Pre-Audit File for 2015Text OUTEnrollment Pre-Audit File for 2016Text OUTEnrollment Pre-Audit File for 2017Text OUTEnrollment Pre-Audit File for 2018Text TEnrollment Pre-Audit File for 2019Text TEnrollment Pre-Audit File for 2020Text TEnrollment Reconciliation DisputeResolution Form for Individual MarketText TImplementation Acknowledgment 130223.T145543411.P.OUTIncremental Pre-audit File to IssuersText P.OUTIncremental Pre-Audit File to Issuers for2017Text P.OUTIncremental Pre-audit File to Issuers for2018Text P.OUTIncremental Pre-audit File to Issuers for2019Text P.OUTIncremental Pre-audit File to Issuers for2020Text P.OUTIssuer Switch FileText OUTMiscellaneous files to Issuers for 2017Text OUTMiscellaneous files to Issuers for 2018Text OUTMiscellaneous files to Issuers for 2019Text OUTMiscellaneous files to Issuers for 2020Text OUTSeptember 201916Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTransactionFile TypeTransactionCodeFunctionCodeExample (Issuers with TP ID as 1234567890)Missing Outbound 834 Finder file toIssuers for 2017Text P.OUTMissing Outbound 834 Incremental PreAudit file to Issuers for 2018Text P.OUTMissing Outbound 834 Incremental PreAudit file to Issuers for 2019Text P.OUTMissing Outbound 834 Incremental PreAudit file to Issuers for 2020Text P.OUTMonthly Payee Information Report sentto all Issuer PayeesText utbound file to send CSRReconciliation Error File for 2014 and2015Text TOutbound Group Switch file sent toIssuers for terminating groups who didnot renew SHOP Coverage with sameIssuer PlansText P.OUTOutbound Member Switch file sent toIssuers for terminating members whodid not renew SHOP Coverage withsame Issuer PlansText P.OUTOutbound SHOP EnrollmentReconciliation FileText OUTOverlaps file to Issuers for 2017Text P.OUTPassive Cancel or Carry-ForwardCancel Incremental Pre-Audit files toIssuers 2018Text P.OUTSeptember 201917Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTransactionFile TypeTransactionCodeFunctionCodeExample (Issuers with TP ID as 1234567890)Passive Cancel Incremental Pre-Auditfiles to Issuers 2019Text P.OUTPassive Cancel Incremental Pre-Auditfiles to Issuers 2020Text P.OUTText File/MicrosoftExcel 45543411.P.OUTPayment Order/Remittance Advice (820Transaction) for SHOP 5543411.P.OUTPreliminary Payment Reporting file forIndividual 1.P.OUTPreliminary Payment Reports (PPRs) toIssuers of SBE - Federal Platform toreport user fee payments collected fromtheir SBE - Federal PlatformText TResponse for 1A Workbooks CMSSendsZIP P.OUTMicrosoftExcel 1.P.OUTPayment Dispute Response to IssuersPayment Order/Remittance Advice (820Transaction) - Final File for IndividualMarketNote: Although this transaction appliesto the Individual Exchange, SHOP userfee information will transmit with this fileto Issuers. This also applies to SHOPExchange-only users.Semi-Monthly Detailed Report toIssuersSeptember 201918Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming ConventionsTransactionFile TypeTransactionCodeFunctionCodeExample (Issuers with TP ID as 1234567890)SHOP Enrollment ReconciliationDispute Resolution Form (FF-SHOP toIssuer)Text P.OUTTechnical Acknowledgment 3411.P.OUTMicrosoftExcel 43411.P.OUTPayment Updates Semi-MonthlyReports send to Issuers fromEnrollment Resolution & Reconciliation(ER&R) ContractorText TUEFF files sent to the issuers toconfirm if a policy should be rescindeddue to fraudText P.OUTReport providing information on theinbound individual marketplacereinstatement transactions sent by theissuers on the IC834Text P.OUTUnaffiliated I Record (UIR) Reports toIssuersSeptember 201919Use or disclosure of data in this document is subject to restriction .

HubEDI File Naming Conventions5.2 SBE-Related TransactionsTable 7 - SBE-Related Transactions presents a list of function codes related to the SBE community, both inbound to CMS andoutbound from CMS.Table 7 - SBE-Related TransactionsInbound 4TA1N/AEPSEXTN/ASI820N/AWBKO1AWBKI1AFE0001Table 8 - Sample Filenames - Inbound to CMS from SBEs presents a list of sample filenames for files inbound to CMS from SBEs.Table 8 - Sample Filenames - Inbound to CMS from SBEsTransactionFile TypeTransaction CodeFunctionCodeApplicationIDExample (SBEs with TP ID as SBE0002)1A Workbooks Sentto T145543452.P.INACK FileEDI[TA1] IN[999]005010X231A1September 201920Use or disclosure of data in this document is subject to restriction.

HubEDI File Naming ConventionsTransactionFile TypeTransaction CodeFunctionCodeApplicationIDExample (SBEs with TP ID as SBE0002)BAA for PaymentOrder/RemittanceAdvice (820T

EDI File Naming Conventions September 2019 3 Use or disclosure of data in this document is subject to restriction. 2.6 Environment Code The Environment Code section of the filename is a single character code indicating the environment to which the system transfers the file. Permitted values are as follows: P for Production Environment (PROD)