Attachment J-1 DMDC Eligibility File Layout TMEP 002.xlsx
XLSX spreadsheet 25 KB Posted
- Solicitation number
- HT940226R0001
- Issued by
-
Defense Health Agency
About this file
This file is a technical data layout specification for the Defense Manpower Data Center (DMDC) Eligibility File used in the TRICARE Medicare Eligible Program Second Generation (TMEP2) contract. The document defines the structure and format requirements for Medicare crossover eligibility data exchanges between DMDC and the Centers for Medicare & Medicaid Services (CMS).
The file layout consists of three record types: Header records, Transaction records, and Trailer records. Header records contain a file indicator and file date in YYYYMMDD format. Transaction records contain 153 character positions with beneficiary and eligibility data, including DEERS Person ID, Social Security Number (SSN) as the only acceptable ID type, sex code, birth date, sponsor information, service code (with values ranging from Army to Unknown), Medicare Beneficiary ID, name fields, and multiple entitlement data fields. These entitlement fields include Part A and Part B start and termination dates, entitlement status codes (such as "Free Part A Entitlement," "Currently Entitled with Payable Premium," or various termination reasons including disability cessation and non-payment), entitlement reason change dates, and beneficiary entitlement reason codes indicating whether eligibility is due to age, disability, end-stage renal disease, or a combination thereof. Trailer records contain a trailer indicator, file date, record count (excluding header and trailer), and filler space. This standardized layout ensures proper data formatting for the ongoing claims processing and administrative services required to support dual-eligible Medicare and TRICARE beneficiaries across specified U.S. territories.
View the file
Other files
Show all 31
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
Medicare Crossover File Layout
| SECTION J ATTACHMENT J-1 | |||||||
| DEFENSE MANPOWER DATA CENTER ELIGIBILITY FILE LAYOUT | |||||||
| DEFENSE MANPOWER DATA CENTER (DMDC) CROSSOVER ELIGIBILITY FILE LAYOUT HEADER | |||||||
| Header Record | Business Name | Length | Start | End | Comments | ||
| Header Indicator | 1 | 1 | 1 | Default to 'H' | |||
| File Date | 8 | 2 | 9 | YYYYMMDD | |||
| Filler | 144 | 10 | 153 | Blanks | |||
| Transaction Record | Business Name | Field Name | Length | Start | End | Comments | Reference |
| Patient ID | DoD_EDI_PN_ID | 10 | 1 | 10 | DEERS | ||
| Person ID | PN_ID | 9 | 11 | 19 | DEERS | ||
| Person ID Type Code | PN_ID_TYP_CD | 1 | 20 | 20 | CMS only uses PN_ID_TYP_CD = 'S' (Social Security Number/SSN) Note: No other ID types are used | DEERS | |
| Person Sex Code | PN_SEX_CD | 1 | 21 | 21 | DEERS | ||
| Person Birth Date | PN_BRTH_DT | 8 | 22 | 29 | YYYYMMDD | DEERS | |
| Sponsor Person ID | SPN_PN_ID | 9 | 30 | 38 | DEERS | ||
| Sponsor Person ID Type Code | SPN_PN_ID_TYP_CD | 1 | 39 | 39 | DEERS | ||
| Service Code | SVC_CD | 1 | 40 | 40 | Acceptable values: |
1 - Foreign Army 2 - Foreign Navy 3 - Foreign Marine Corps 4 - Foreign Air Force 6 - Foreign Coast Guard A - Army C - Coast Guard
D - OSD
F - Air Force H - Public Health Service M - Marine Corps N - Navy
O - NOAA
S - Space Force X - Other
| Z - Unknown | DEERS | |||||||
| Finder Status Code | 1 | 41 | 41 | Default to 1 | ||||
| '1' = Beneficiary Claim Number Match | CMS | Additional info: This field used to be on the Response File but CMS took it off because they made a change to only send back records that matched. DHA contractor didn't want the layout to change so we default the field to '1'. | ||||||
| Medicare Beneficiary ID | MBI_ID | 11 | 42 | 52 | MBI_ID will use the Beneficiary Health Insurance Claim Number field | CMS | ||
| Filler | Filler | 1 | 53 | 53 | Blanks | |||
| Person First Name | PN_1ST_NM | 20 | 54 | 73 | DEERS | |||
| Person Middle Name (initial only) | PN_MID_NM | 1 | 74 | 74 | DEERS | |||
| Person Last Name | PN_LST_NM | 24 | 75 | 98 | DEERS | |||
| Person Cadency | PN_CDNCY_NM | 4 | 99 | 102 | DEERS | |||
| Beneficiary Birth Date | BENE_BRTH_DT | 8 | 103 | 110 | YYYYMMDD | CMS | ||
| Beneficiary Part A Entitlement Start Date | BENE_PTA_ENTLMT_STRT_DT | 8 | 111 | 118 | YYYYMMDD | CMS | ||
| Beneficiary Part A Entitlement Termination Date | BENE_PTA_ENTLMT_STOP_DT | 8 | 119 | 126 | YYYYMMDD | CMS | ||
| Beneficiary Part A Entitlement Status Code | BENE_PTA_ENTLMT_STUS_CD | 1 | 127 | 127 | The reason for Entitlement or Termination of a Beneficiary's Part A Benefits during a period of coverage. |
The following code(s) apply when the Part A Entitlement Date is present and the Part A Termination Date is blank:
'E' = FREE PART A ENTITLEMENT
'G' = ENTITLED DUE TO GOOD CAUSE
'Y' = CURRENTLY ENTITLED, PREMIUM IS PAYABLE.
The following code(s) apply when both the Part A Entitlement Date and the Part A Termination Date are present:
'C' =NO LONGER ENTITLED DUE DISABILITY CESSATION
'S' = TERMINATED, NO LONGER ENTITLED UNDER END-STAGE RENAL DISEASE PROVISION
'T' = TERMINATED FOR NON-PAYMENT OF PREMIUMS
'W' = VOLUNTARILY WITHDRAWAL FROM PREMIUM COVERAGE
| 'X' = FREE PART A TERMINATED OR REFUSED | CMS | |||||||
| Beneficiary Part B Entitlement Start Date | BENE_PTB_ENTLMT_STRT_DT | 8 | 128 | 135 | YYYYMMDD | CMS | ||
| Beneficiary Part B Entitlement Termination Date | BENE_PTB_ENTLMT_STOP_DT | 8 | 136 | 143 | YYYYMMDD | CMS | ||
| Beneficiary Part B Entitlement Status Code | BENE_PTB_ENTLMT_STUS_CD | 1 | 144 | 144 | The reason for Entitlement or Termination of a Beneficiary's Part B benefits during a current period of coverage. |
The following code(s) apply when the Part B Entitlement Date is present and the Part B Termination Date is blank:
'G' = ENTITLED DUE TO GOOD CAUSE
'Y' = CURRENTLY ENTITLED, PREMIUM IS PAYABLE.
The following code(s) apply when both the Part B Entitlement Date and the Part B Termination Date are present:
'C' =NO LONGER ENTITLED DUE TO CESSATION OF DISABILITY
'F' = TERMINATED DUE TO INVALID ENROLLMENT OR ENROLLMENT VOIDED
'S' = TERMINATED, NO LONGER ENTITLED UNDER END-STAGE RENAL DISEASE PROVISION
'T' = TERMINATED FOR NON-PAYMENT OF PREMIUMS
| 'W' = VOLUNTARILY WITHDRAWAL FROM COVERAGE | CMS | |||||||
| Beneficiary Entitlement Reason Code Change Date | BENE_ENTLMT_RSN_CHG_DT | 8 | 145 | 152 | YYYYMMDD | CMS | ||
| Beneficiary Entitlement Reason Code | BENE_ENTLMT_RSN_CD | 1 | 153 | 153 | The reason for a Beneficiary's Entitlement to Medicare Benefits: |
'0' = BENEFICIARY INSURED DUE TO AGE (OASI)
'1' = BENEFICIARY INSURED DUE TO DISABILITY
'2' = BENEFICIARY INSURED DUE TO END STAGE RENAL DISEASE (ESRD)
| '3' = BENEFICIARY INSURED DUE TO DISABILITY AND CURRENT ESRD | CMS | |||||
| Trailor Record | Business Name | Length | Start | End | Comments | |
| Trailer Indicator | 1 | 1 | 1 | Default to 'T' | ||
| File Date | 8 | 2 | 9 | YYYYMMDD | ||
| Record Count | 9 | 10 | 18 | w/o Header and Trailer | ||
| Filler | 135 | 19 | 153 | Blanks |
File details come from the government source that posted it. Updated .