Attachment J-1 DMDC Eligibility File Layout TMEP 002.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
TRICARE Medicare Eligible Program Second Generation (TMEP2)
Solicitation number
HT940226R0001
Issued by

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

File Type Posted
Attachment J-5b QASP Matrix TMEP2 DRAFT 002.xlsx XLSX spreadsheet
Attachment J-3 CDRLs 002.pdf PDF
Exhibit L-7 - TMEP2 Pricing Template_Revised 20261102 002.xlsx XLSX spreadsheet
Amendment 002 signed.pdf PDF
Attachment J-4 TMEP 2 Chapter 20 Clean Draft Copy 20260730 002.pdf PDF
Exhibit L-3 - RFP-Cross-reference Matrix 002.xlsx XLSX spreadsheet
Exhibit L-2 - Workload Volumes 002.pdf PDF
QandA Before Receipt of Proposals.pdf PDF
HT940226R0001-20260923.pdf PDF
Exhibit L-8 - Small Business Participation Commitment.docx DOCX document
HT940226R0001 Amd 0001 20260924.pdf PDF
Exhibit L-9 - TMEP CY24_25_26 Manual Changes Modification Log.xlsx XLSX spreadsheet
HT940226R0001-20260923.pdf PDF
Attachment J-5b QASP Matrix TMEP2 DRAFT.xlsx XLSX spreadsheet
Exhibit L-7 - TMEP2 Pricing Template.xlsx XLSX spreadsheet
Exhibit L-3 - RFP-Cross-reference Matrix.xlsx XLSX spreadsheet
Exhibit L-8 - Small Business Participation Comittment.docx DOCX document
Exhibit L-1 - Beneficiary Data.pdf PDF
Exhibit L-4 - Past Performance Questionnaire.pdf PDF
Attachment J-5a QASP TMEP2 DRAFT.pdf PDF
Attachment J-2 Beneficiary Satisfaction Survey.pdf PDF
Exhibit L-2 - Historical Data.pdf PDF
Attachment J-4 TMEP 2 Chapter 20 Clean Draft Copy 20260730.pdf PDF
Attachment J-5b QASP Matrix TMEP2 DRAFT.xlsx XLSX spreadsheet
Exhibit L-7 - TMEP2 Pricing Template.xlsx XLSX spreadsheet
Attachment J-1 DMDC Eligibility File Layout TMEP.pdf PDF
Exhibit L-6 - Subcontractor Consent Letter.pdf PDF
Exhibit L-9 - TMEP CY24_25_26 Manual Changes Modification Log.xlsx XLSX spreadsheet
HT940226R0001-20260923.pdf PDF
Attachment J-3 CDRLs.pdf PDF
Exhibit L-5 - Sample Client Authorization Letter.pdf PDF
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 RecordBusiness NameLengthStartEndComments
Header Indicator111Default to 'H'
File Date829YYYYMMDD
Filler14410153Blanks
Transaction RecordBusiness NameField NameLengthStartEndCommentsReference
Patient IDDoD_EDI_PN_ID10110DEERS
Person IDPN_ID91119DEERS
Person ID Type CodePN_ID_TYP_CD12020CMS only uses PN_ID_TYP_CD = 'S' (Social Security Number/SSN) Note: No other ID types are usedDEERS
Person Sex CodePN_SEX_CD12121DEERS
Person Birth DatePN_BRTH_DT82229YYYYMMDDDEERS
Sponsor Person IDSPN_PN_ID93038DEERS
Sponsor Person ID Type CodeSPN_PN_ID_TYP_CD13939DEERS
Service CodeSVC_CD14040Acceptable 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 - UnknownDEERS
Finder Status Code14141Default to 1
'1' = Beneficiary Claim Number MatchCMSAdditional 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 IDMBI_ID114252MBI_ID will use the Beneficiary Health Insurance Claim Number fieldCMS
FillerFiller15353Blanks
Person First NamePN_1ST_NM205473DEERS
Person Middle Name (initial only)PN_MID_NM17474DEERS
Person Last NamePN_LST_NM247598DEERS
Person CadencyPN_CDNCY_NM499102DEERS
Beneficiary Birth DateBENE_BRTH_DT8103110YYYYMMDDCMS
Beneficiary Part A Entitlement Start DateBENE_PTA_ENTLMT_STRT_DT8111118YYYYMMDDCMS
Beneficiary Part A Entitlement Termination DateBENE_PTA_ENTLMT_STOP_DT8119126YYYYMMDDCMS
Beneficiary Part A Entitlement Status CodeBENE_PTA_ENTLMT_STUS_CD1127127The 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 REFUSEDCMS
Beneficiary Part B Entitlement Start DateBENE_PTB_ENTLMT_STRT_DT8128135YYYYMMDDCMS
Beneficiary Part B Entitlement Termination DateBENE_PTB_ENTLMT_STOP_DT8136143YYYYMMDDCMS
Beneficiary Part B Entitlement Status CodeBENE_PTB_ENTLMT_STUS_CD1144144The 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 COVERAGECMS
Beneficiary Entitlement Reason Code Change DateBENE_ENTLMT_RSN_CHG_DT8145152YYYYMMDDCMS
Beneficiary Entitlement Reason CodeBENE_ENTLMT_RSN_CD1153153The 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 ESRDCMS
Trailor RecordBusiness NameLengthStartEndComments
Trailer Indicator111Default to 'T'
File Date829YYYYMMDD
Record Count91018w/o Header and Trailer
Filler13519153Blanks

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