14_Attachment_J-4_M2_Data_Dictionary.xlsx

Cover

Table of Contents The M2 Data Dictionary is organized using tabs that generally correspond to the object classes as named in the M2. The tabs are arranged in the order their data is presented on the M2. Appendices information is presented last, with the tabs in alphabetical order. To move to a specific tab, click on the tab name. Names in blue are for organizational purposes only and are not tabs.

&"MS Sans Serif,Bold"M2 Data Dictionary Table of Contents

&"MS Sans Serif,Bold"M2 Data Dictionary Table of Contents

March 2006 Version Page &P

&"MS Sans Serif,Bold"April 2014 Version &"MS Sans Serif,Bold"Page &P

Summary of Changes

Summary of Changes

Specific Changes (other than those listed above)

Definition & Notes: Risk Score, 100K Truncation

&"MS Sans Serif,Bold"&A

&A

March 2006 Version Page &P

&"MS Sans Serif,Bold"April 2014 Version &"MS Sans Serif,Bold"Page &P

Return to the Table of Contents /xl/drawings/drawing2.xml#'Table%20of%20Contents'!A1http://tricare.mil/tma/dhcape/data/fs.aspx Population Summary

B=5-14 C=15-17 D=18-24 E=25-34 F=35-44 G=45-64 H=65+ Z=Unknown Ben Cat Common Broadest category of beneficiaries. Char (1) 1, 2, 3, 4 1 = Dependents of Active Duty or Guard/Reserve on Active Duty 2 = Retired 3 = All Others 4 = Active Duty and Guard/Reserve on Active Duty Beneficiary Category Category of beneficiary. Char (3) ACT, RET, GRD, IGR, DA, DR, DS, DGR, IDG, OTH, Z ACT=Active Duty RET=Retirees GRD=Guard/Reserve on Active Duty IGR=Inactive Guard/Reserve DA=Dependents of Active Duty DR=Dependents of Retiree DS=Dependent Survivor DGR=Dependent of Guard/Reserve on Active Duty IDG=Dependent of Inactive Guard/Reserve OTH=Other Z=Unknown

S = South W = West

O = OCONUS

A = Alaska Blank = All other, or not defined Beneficiary Region Code indicating region of residence for non-active duty/guard; region of assigned unit for active duty/guard. Char (2) 01-16, AK, XX, UK, 00 01=Northeast 02=Mid-Atlantic 03=Southeast 04=Gulf South 05=Heartland 06=Southwest 07,08=TRICARE Central 09=Southern California 10=Golden Gate 11=Northwest 12=Hawaii 13=Europe 14=TRICARE Pacific 15=TRICARE Latin America 16, XX, 00, UK =Unknown AK=Alaska

See DMIS ID Information for IDs and names.

See DMIS ID Information for IDs and names.

F = Air Force N = Navy P = National Capital Region Medical Directorate (NCRMD) S = No affiliated Service (e.g., Non-Catchment Areas) Blank = Unknown (e.g., No Catchment Area found) Catchment Area MSMA Code indicating multi-service market to which this Catchment Area is assigned. The “e” in the value (eg, 01e) indicates this market is an enhanced Multi-Service Market (eMSM). Char(2) 01e, 02e, 03-06, 07e, 08e, 09, 10e, 11e, 12-14 01e = National Capital Region 02e = Tidewater 03 = Fort Bragg 04 = Charleston 05 = Ft Jackson/Shaw 06 = Mississippi Delta 07e = San Antonio 08e = Colorado Springs 09 = San Diego 10e = Puget Sound 11e = Hawaii 12 = Anchorage, AK 13 = Fairbanks, AK 14 = Jacksonville

Catchment Area ID of Record Assigned in MDR processing, the catchment area surrounding an MTF or noncatchment area based on beneficiary zip code, sponsor service, FY, and FM. Char (4) For historical data, Catchment Area ID derived in MHS Data Repository (MDR) processing by linking to the Catchment Area Directory (CAD).

Results do NOT incorporate any updates/retrofits of data.

See DMIS ID Information for IDs and names.

CM Calendar Month: The numeric code to identify the calendar month in which the data were extracted. Integer 1-12 1 = January 7 = July 2 = February 8 = August 3 = March 9 = September 4 = April 10 = October 5 = May 11 = November 6 = June 12 = December

2 = November 8 = May 3 = December 9 = June 4 = January 10 = July 5 = February 11 = August 6 = March* 12 = September*

F =Female Z =Unknown

See DMIS ID Information for IDs and names.

Market Area ID TRO-defined market area based on Beneficiary ZIP code. Use in conjunction with Beneficiary Region. Char (3) 001-999 See Regional Staff for more information.

Note: populated October 2002 and later.

See DMIS ID Information for IDs and names.

F = Air Force N = Navy P = National Capital Region Medical Directorate (NCRMD) S = No affiliated Service (e.g., Non-Catchment Areas) Blank = Unknown (e.g., No Catchment Area found) PRISM Area MSMA Code indicating multi-service market to which this PRISM Area is assigned. The “e” in the value (eg, 01e) indicates this market is an enhanced Multi-Service Market (eMSM). Char(2) 01e, 02e, 03-06, 07e, 08e, 09, 10e, 11e, 12-14 01e = National Capital Region 02e = Tidewater 03 = Fort Bragg 04 = Charleston 05 = Ft Jackson/Shaw 06 = Mississippi Delta 07e = San Antonio 08e = Colorado Springs 09 = San Diego 10e = Puget Sound 11e = Hawaii 12 = Anchorage, AK 13 = Fairbanks, AK 14 = Jacksonville

PRISM Area ID of Record Assigned in MDR processing, the code indicating PRISM (Provider Requirement Integrated Specialty Model) Area of residence. The PRISM area represents roughly a 20-mile area surrounding stand-alone MTFs. Records area assigned to PRISM areas based on beneficiary zip code, sponsor service, FY, and FM. Char (4) e.g., 0039 PRISM Area ID derived in MHS Data Repository (MDR) processing by linking to the Catchment Area Directory (CAD).

See DMIS ID Information for IDs and names.

Privilege Code Code indicating type of eligibility for medical benefits. Char (1) 1, 2, 4, 5, 6, 7, A, B, C, M, U 1=Direct Care Only 2=Direct Care and MHS Purchased Care 4=Transitional Direct Care Only 5=Transitional Direct Care and MHS Purchased Care 6=Transitional Direct Care and Medicare A, not MHS Purchased Care Eligible 7=Direct Care and Medicare A, not MHS Purchased Care Eligible A=Direct Care and MHS Purchased Care and Medicare A B=Transitional Direct Care and MHS Purchased Care and Medicare A C=MHS Purchased Care Only M=Medicare A Only U=USFHP/USTF Enrollee R=TRICARE Reserve Select Sponsor Service, Aggregate The military branch of service of the sponsor. Char (1) A, C, F, M, N, V, X, Z A=Army C=Coast Guard F=Air Force M=Marine Corps N=Navy V=Navy Afloat X=Other Z=Unknown TPR Flag Indicates whether the Beneficiary Zip Code is in a TRICARE Prime Remote area. Char(1) N=No Y=Yes

&"MS Sans Serif,Bold"&14&A

March 2006 Version &A Page &P of &N

&"MS Sans Serif,Bold"April 2014 Version &A &"MS Sans Serif,Bold"Page &P of &N]

Return to the Table of Contents /xl/drawings/drawing3.xml#'Table%20of%20Contents'!A1 DEERS Person Detail

A=Active Duty TRICARE Prime B=TRICARE Global Remote Overseas Prime Active Duty C=CHAMPUS Eligible D=TRICARE Senior Prime E=CHAMPUS Eligible TRICARE Prime F=TRICARE Global Remote Overseas Prime Active Duty Family Member G=TRICARE Plus (with civilian healthcare) H=TRICARE Overseas Prime Active Duty J=TRICARE Overseas Prime Active Duty Family Member L=TRICARE Plus, DC Entitlement Only (No Private Sector Coverage, No TFL) M=AD not reported as enrolled N=Not CHAMPUS Eligible

P=CRI

Q=Active Duty enrolled to Op Forces R=TRICARE Reserve Select

S=CHCBP

U=USFHP/USTF

V=TRICARE Retired Reserve W=TRICARE Senior Supplement Z=Not enrolled in an alternate care program/unknown ACV Group Alternate Care Value Group: based on the ACV, indicates the enrollment status of the beneficiary. Char(10) Prime, Overseas, Plus, Reliant, Desig Prov, Other Prime = ACV A, E, H, or J Overseas Remote = ACV B or F Plus = ACV G or L Desig Prov = ACV U Reliant = ACV M or Q; or ACV is any other value (including blanks) and Ben Cat Common = 4 then Reliant Other = All others

B=5 to 14 C=15 to 17 D=18 to 24 E=25 to 34 F=35 to 44 G=45 to 64 H=65 and over Z=Unknown AGR Service Legal Authority The code that represents the source of the legal authority for Active Guard and Reserve service. Char (1) 1,2,3,9,A,B,C,D,E,F,G,H,I,J,K,L,X,Z 1=6-year obligation (10 USC 651) 2=Other obligation (not 10 USC 651) 3=8-year obligation (10 USC 651) 9=Unknown A=AGR under 10 USC 10301 (reference (b)) B=AGR under 10 USC 10211 (reference (b)) C=AGR under 10 USC 12301(d) (reference (b)) D=AGR under 10 USC 12310 (reference (b)) E=AGR under 10 USC 12501 (reference (b)) F=AGR under 10 USC 3015/3019/8019 (reference (b)) G=AGR under 10 USC 3033/8033 (reference (b)) H=AGR under 10 USC 3496/8496 (reference (b))

I=AGR:14 USC 276

J=AGR under 32 USC 502(f) (reference (m)) K=AGR under 32 USC 503 (reference (m)) L=AGR under 32 USC 708 (reference (m)) X=AGR: Other Z=Unknown/Not Applicable Assigned UIC Code indicating sponsor's unit of assignment. Char (8) The following UIC conventions are used by the Service branches:

Army: WPPPDDZZ, where:

W - Service Designator (nearly always W for Army UICs);

PPP - Parent Unit Designator;

DD - Descriptive Designator (e.g., these positions could be used to distinguish companies having the same Parent Unit Designator); and ZZ - Major Command.

Navy: NnnnnXCC, where:

N - Service Designator (nearly always N for Navy UICs);

nnnnX - Unit Designator (n positions are numeric, X position is alphanumeric); and CC - Command Code.

Marine Corps: rrrrrCCC, where:

rrrrr - Reporting Unit Code (RUC) (this is the unit designator); and CCC - Monitored Command Code (MCC).

Air Force: BBCCXXXX; where:

BB - Consolidated Base Personnel Office (CBPO);

CC - Command Code;

XXXX - Personnel Accounting Symbol (PAS) (alphanumeric - this is the unit designator) Coast Guard: DDPPPPPB, where:

DD - District Code;

PPPPP - unit code (also called OPFAC); and B - Blank Attached UIC Code indicating unit that sponsor is attached to. Char (8) The following UIC conventions are used by the Service branches:

Army: WPPPDDZZ, where:

W - Service Designator (nearly always W for Army UICs); PPP - Parent Unit Designator;

DD - Descriptive Designator (e.g., these positions could be used to distinguish companies having the same Parent Unit Designator); and ZZ - Major Command.

Navy: NnnnnXCC, where: N - Service Designator (nearly always N for Navy UICs);

nnnnX - Unit Designator (n positions are numeric, X position is alphanumeric); and CC - Command Code.

Marine Corps: rrrrrCCC, where:

rrrrr - Reporting Unit Code (RUC) (this is the unit designator); and CCC - Monitored Command Code (MCC).

Air Force: BBCCXXXX; where:

BB - Consolidated Base Personnel Office (CBPO);

CC - Command Code;

XXXX - Personnel Accounting Symbol (PAS) (alphanumeric - this is the unit designator) Coast Guard: DDPPPPPB, where:

DD - District Code;

PPPPP - unit code (also called OPFAC); and B - Blank Ben Cat Common Broadest category of beneficiaries. Char (1) 1, 2, 3, 4 1 = Dependents of Active Duty or Guard/Reserve on Active Duty 2 = Retired 3 = All Others 4 = Active Duty and Guard/Reserve on Active Duty

RET=Retirees GRD=Guard/Reserve on Active Duty IGR=Inactive Guard/Reserve DA=Dependents of Active Duty DR=Dependents of Retiree DS=Dependent Survivor DGR=Dependent of Guard/Reserve on Active Duty IDG=Dependent of Inactive Guard/Reserve OTH=Other Z=Unknown

S = South W = West

O = OCONUS

A = Alaska Blank = All other, or not defined Beneficiary ID Type Code The code that represents a specific kind of person identifier. Char (1) D, F, I, M, N, P, R, S, T D=Special 9-digit created for individuals (i.e. babies) who do not have or have not provided an SSN when the record is added to DEERS (dependents only). Known as a TIN, Temporary Identifier Number.

F=Special 9-digit code created for foreign military and nationals. Known as a FIN, Foreign Identifier Number.

I=Tax identification number M=Patient Identifier N=9-digit code that looks like a Social Security Number, but is not in a valid SSN range P=Special 9-digit code created for U.S. military personnel from Service Numbers before the switch to Social Security Numbers R=Special 9-digit code created for a DoD contractor who refused to give his or her SSN to RAPIDS. The associated PN_ID will begin with 99 S=Social Security Number T=Test (858 series)

02=Mid-Atlantic 03=Southeast 04=Gulf South 05=Heartland 06=Southwest 07,08=TRICARE Central 09=Southern California 10=Golden Gate 11=Northwest 12=Hawaii 13=Europe 14=TRICARE Pacific 15=TRICARE Latin America 16, XX, 00, UK =Unknown AK=Alaska

D=Dependent O=Other S=Sponsor X=Prior Sponsor Y=Prior Dependent

2=A- 3=B+ 4=B-

5=AB+

6=AB-

7=O+ 8=O- 9=Unknown

See DMIS ID Information for IDs and names.

See DMIS ID Information for IDs and names.

F = Air Force N = Navy P = National Capital Region Medical Directorate (NCRMD) S = No affiliated Service (e.g., Non-Catchment Areas) Blank = Unknown (e.g., No Catchment Area found) Catchment Area MSMA Code indicating multi-service market to which this Catchment Area is assigned. The “e” in the value (eg, 01e) indicates this market is an enhanced Multi-Service Market (eMSM). Char(2) 01e, 02e, 03-06, 07e, 08e, 09, 10e, 11e, 12-14 01e = National Capital Region 02e = Tidewater 03 = Fort Bragg 04 = Charleston 05 = Ft Jackson/Shaw 06 = Mississippi Delta 07e = San Antonio 08e = Colorado Springs 09 = San Diego 10e = Puget Sound 11e = Hawaii 12 = Anchorage, AK 13 = Fairbanks, AK 14 = Jacksonville

Catchment Area ID of Record Assigned in MDR processing, the catchment area surrounding an MTF or noncatchment area based on beneficiary zip code, sponsor service, FY and FM. Char (4) e.g., 0039 Catchment Area ID derived in MHS Data Repository (MDR) processing by linking to the Catchment Area Directory (CAD). Results do NOT incorporate any updates/retrofits of data.

See DMIS ID Information for IDs and names.

Civilian Health Care Benefit Code Code indicating civilian health care entitlement. Char (1) F, M, T F=Outpatient Only/ Reimbursable (Foreign military)

M=CHAMPUS

T=TRICARE for Life Empty=Not eligible for MHS Purchased Care benefits solely by virtue of status, but may have purchased the benefits (e.g., through TRICARE Reserve Select -- see ACV), and thus be eligible.

CM Calendar Month: Numeric code to identify the calendar month. Derived from the service date. Char(2) 1-12 1 = January 7 = July 2 = February 8 = August 3 = March 9 = September 4 = April 10 = October 5 = May 11 = November 6 = June 12 = December

mm/dd/yyyy

F=Outpatient at no charge & inpatient care at full reimbursable E = Early Alert for Guard/Reserve Service Members L=Limited direct care based on documentation empty=Not eligible for Direct Care benefits solely by virtue of status, but may have purchased the benefits (e.g., through TRICARE Reserve Select -- see ACV), and thus be eligible.

O=Outpatient only P=Outpatient only reimbursable R=Reimbursable direct care S=Direct care

0=Ineligible 1=Eligible Enrollment MEPRS Code Assigned MEPRS code of Primary Care Manager. Char(4) e. g AAAA Currently blank. Data expected to be available in Dec12/Jan13.

Populated FY11+.

Enrollment Site The DMIS ID of the facility where the member is enrolled. Char (4) e.g., 0036 Enrollment data was problematic, but matured to be the official data by February 2004. It will not agree with the official enrollment data of the Enrollment file from all earlier months.

See DMIS ID Information for IDs and names.

Y = the Enrollment Site is a Defense Health Program DMISID Enrollment Site HSSC Region Health Services and Support Contract region of the Enrollment Site. Char(1) N, S, W, A, O, Blank N = North S = South W = West

O = OCONUS

A = Alaska Blank = All other, or not defined Enrollment Site Military Service Enrollment Military Department: military service performing the enrollment function. Derived from the DMIS Table, based on the enrollment DMIS ID. Char (1) A, B, C, D, F, G, I, J, L, M, N, O,P, Q, R, S, T, V, X, Blank A = Army DHP B = Army Civilian Resource Sharing C = Coast Guard D = Army Line Unit F = Air Force DHP G = AF Civilian Resource Sharing I = Inactive J = US Defense Attaché Office (USDAO) L = AF Line Unit M = Managed Care Support Contractor N = Navy DHP P = National Capital Region Medical Directorate (NCRMD) O = Other Q = Navy Line Unit R = Navy Civilian Resource Sharing S = Non-catchment T = US Family Health Plan (USFHP), FY 1998-2001, 2007-2009 U = US Family Health Plan (USFHP), FY 2002-2006 V = Veterans Admin X = Administrative Blank = Unknown Enrollment Site MSMA Code indicating multi-service market to which this enrollment site is assigned. The “e” in the value (eg, 01e) indicates this market is an enhanced Multi-Service Market (eMSM). Char(2) 01e, 02e, 03-06, 07e, 08e, 09, 10e, 11e, 12-14 01e = National Capital Region 02e = Tidewater 03 = Fort Bragg 04 = Charleston 05 = Ft Jackson/Shaw 06 = Mississippi Delta 07e = San Antonio 08e = Colorado Springs 09 = San Diego 10e = Puget Sound 11e = Hawaii 12 = Anchorage, AK 13 = Fairbanks, AK 14 = Jacksonville Enrollment Site Region Code that identifies the DoD Region associated with the enrollment site. Char (2) 01-15, AK, 16, 00, UK, XX 01=Northeast 02=Mid-Atlantic 03=Southeast 04=Gulf South 05=Heartland 06=Southwest 07,08=TRICARE Central 09=Southern California 10=Golden Gate 11=Northwest 12=Hawaii 13=TRICARE Europe 14=TRICARE Pacific 15=TRICARE Latin America AK=Alaska UK, XX, 00, 16=Unknown

2=2-11 3=12-17 4=18-44 for single females or 18-37 single males 5=18-44 married females or 18-37 married males 6=45-54 females or 38-54 male 7=55-64 8=65-74 9=75 and up Ethnicity The code that represents the ethnic group or national origin of the person. Char (1) 0-9, D, E, G, H, J, K, L, Q, S, V, W, X, Y, Z 1=Other Hispanic 2=US or Canadian Indian Tribe 3=Other Asian 4=Puerto Rican 5=Filipino 6=Mexican 7=Eskimo 8=Aleut 9=Cuban D=Indian E=Melanesian G=Chinese H=Guamanian J=Japanese K=Korean L=Polynesian Q=Pacific Islander NEC S=Latin American with Hispanic descent V=Vietnamese W=Micronesian X=Other Y=None Z=Unknown

2 = November 8 = May 3 = December 9 = June 4 = January 10 = July 5 = February 11 = August 6 = March 12 = September

F=Female Z=Unknown HCDP Code The Health Care Delivery Program Plan Coverage Code: the code that represents the plan coverage a family member or sponsor has within a health care delivery program type. Char (3) e.g., 108 See HCDP Codes for list of values and meanings.

B = The person was flagged as a high cost user on both the Rolling 12-month basis and on the Fiscal Year to Date basis T = The person was flagged as a high cost user only on the Rolling 12-month basis N = The person was not flagged as a high cost user

IIW Flag Indicates whether the member was identified as potentially having a war related medical condition. Char(1) Y, N Y = Yes N = No Marital Status Code indicating the marital status of the sponsor. Char (1) A, D, I, L, M, N, W, Z, blank A=Annulled D=Divorced I=Interlocutory Decree L=Legally Separated M=Married N=Never married W=Widow or Widower Z=Unknown blank=unknown Market Area ID TRO-defined market area based on Beneficiary ZIP code. Use in conjunction with Beneficiary Region. Char (3) 001-999 See Regional Staff for more information.

Note: Only populated for FY 2002 and later.

Medicare Eligibility Code Medicare Eligibility Code. Char (1) A, B A=Medicare A only B=Medicare B only C=Medicare A and B N=No Medicare Medicare Pharmacy Indicator A flag indicating whether the person has Medicare Pharmacy eligibility. Char(1) N, Y N=No Y=Yes

Populated FY06 forward.

Medical Home Flag Indicates if the patient is enrolled in medical home. Char(1) Y, N Currently blank. Data expected to be available in Dec12/Jan13.

Populated FY11+.

Y=Yes OHI Medical Flag The code that indicates whether or not medical care is covered by the Other Health Insurance (OHI) policy (derived). Char (1) N, Y N=No Y=Yes OHI Mental Health Flag The code that indicates whether or not mental health care is covered by the Other Health Insurance (OHI) policy (derived). Char (1) N, Y N=No Y=Yes OHI Pharmacy Flag The code that indicates whether or not pharmacy care is covered by the Other Health Insurance (OHI) policy (derived). Char (1) N, Y N=No Y=Yes

D=DEA Number E=DoD Electronic Data Interchange Person Identifier (EDI_PN) H=HIPAA Provider ID L=Legacy Value P=CHCS created Pseudo PCM Identifier

S=SSN

T=Tax ID Number Enrollment data was problematic, but matured to be the official data by February 2004. It will not agree with the official enrollment data of the Enrollment file from all earlier months.

PCM Provider Type The code identifying the type of network provider. Char(1) C, D, N, R, U C=Civilian network D=Direct Care network N=None R=Resource Sharing network U=Uniformed Services Family Health Plan (USFHP)

AB=Child AC=Foster Child AD=Parent AE=Parent-in-law AF=Stepchild AH=Stepparent AI=In loco parentis AX=Emergency Contact BB=Ward BC=Former Spouse (not assignable after RAPIDS 6.3) BD=Self (i.e., the person and the other person are the same person) BE=Joint marriage spouse BF=Other health insurance subscriber BG=Pre-adoptive child CA=Member of household headed by sponsor's former spouse (child, stepchild, or ward only) ZZ=Unknown

000=No coverage 602=Direct Care and TRICARE Mail Order Pharmacy (TMOP) and Retail Pharmacies 603=Direct Care only 604=TRICARE Mail Order Pharmacy Population Sector Represents the broad population class to which the person belongs. Char (1) 1, 2, 3, 4, Z 1=Active Duty 2=Active Duty Dependents less than 65 3=Non Active Duty Dependent less than 65 4=Non Active Duty Greater than 65 (includes all beneficiary categories other than Active Duty who are age 65+) Z=Unknown Prime Service Area Code indicating whether or not beneficiary resides in a Tnex Prime Service Area. Char(1) Y, N Y=lives in a PSA N=does not live in a PSA PRISM Area ID Assigned by the M2, the code indicating PRISM (Provider Requirement Integrated Specialty Model) Area of residence. The PRISM area represents roughly a 20-mile area surrounding stand-alone MTFs. Records area assigned to PRISM areas based on beneficiary zip code, sponsor service, FY, and FM. Char (4) e.g., 0039 PRISM Area ID derived in M2 processing by linking to the Market Area Table.

See DMIS ID Information for IDs and names.

F = Air Force N = Navy P = National Capital Region Medical Directorate (NCRMD) S = No affiliated Service (e.g., Non-Catchment Areas) Blank = Unknown (e.g., No Catchment Area found) PRISM Area MSMA Code indicating multi-service market to which this PRISM Area is assigned. The “e” in the value (eg, 01e) indicates this market is an enhanced Multi-Service Market (eMSM). Char(2) 01e, 02e, 03-06, 07e, 08e, 09, 10e, 11e, 12-14 01e = National Capital Region 02e = Tidewater 03 = Fort Bragg 04 = Charleston 05 = Ft Jackson/Shaw 06 = Mississippi Delta 07e = San Antonio 08e = Colorado Springs 09 = San Diego 10e = Puget Sound 11e = Hawaii 12 = Anchorage, AK 13 = Fairbanks, AK 14 = Jacksonville

PRISM Area ID of Record Assigned in MDR processing, the code indicating PRISM (Provider Requirement Integrated Specialty Model) Area of residence. The PRISM area represents roughly a 20-mile area surrounding stand-alone MTFs. Records area assigned to PRISM areas based on beneficiary zip code, sponsor service, FY, and FM. Char (4) e.g., 0039 PRISM Area ID derived in MHS Data Repository (MDR) processing by linking to the Catchment Area Directory (CAD). Results do NOT incorporate any updates/retrofits of data.

See DMIS ID Information for IDs and names.

Privilege Code Code indicating type of eligibility for medical benefits. Char (1) 1, 2, 4, 5, 6, 7, A, B, C, M, U 1=Direct Care Only 2=Direct Care and MHS Purchased Care 4=Transitional Direct Care Only 5=Transitional Direct Care and MHS Purchased Care 6=Transitional Direct Care and Medicare A, not MHS Purchased Care Eligible 7=Direct Care and Medicare A, not MHS Purchased Care Eligible A=Direct Care and MHS Purchased Care and Medicare A B=Transitional Direct Care and MHS Purchased Care and Medicare A C=MHS Purchased Care Only M=Medicare A Only U=USFHP/USTF Enrollee

M=Asian or Pacific Islander N=Black R=American Indian or Alaskan native X=Other Z=Unknown Race / Ethnicity Race and ethnicity of beneficiary. Char (1) A, B, C, D, E, X, Z A=American Indian/Alaskan Native B=Asian or Pacific Islander C=Black, not Hispanic D=white, not Hispanic E=Hispanic X=Other Z=Unknown Reservist Status Code Code indicating status of guard/reserve member. Char(1) A, E, O, M, T, I, L A = Early Alert for Guard/Reserve E = TAMP extended for Guard/Reserve O = TAMP original for Guard/Reserve M = Mobilization for Guard/Reserve T = TAMP for Guard/Reserve I = TAMP for involuntary separation from Active Duty L = TAMP for stop/loss from Active Duty Special HCDP Code The code describing the special insured health care delivery program plan coverage a family member or sponsor has. Char(3) 400, 403, 404, 415, 416 Populated FY06 forward.

400 = TRICARE Extended Care Health Option (ECHO) Program 403 = Tobacco Cessation Demonstration Program 404 = Weight Management Demonstration Program 415 = Warrior Transition Unit 416 = Community Based Healthcare Organization Special Operations Code Indicates the contingency operation for which a Guard or Reserve member is activated or receiving TAMP benefits through at the time of care. Populated on both sponsor and family member records. This data element does not indicate that the guard or reserve member went to theater, rather, that the orders that activated the member indicated a contingency operation. Use with Reservist Status Code to indicate the status of the Guard/Reserve member. Char(2) 00= Not Applicable 01= Operation Desert Storm 02= Los Angeles Riots 03=Haiti 04=Somalia 05=Bosnia 06=Kosovo 07=Southern Watch 08=Noble Eagle 09=Enduring Freedom 10=Iraqi Freedom 98=Not a special operation 99=Other (Take caution with these values. It is often evident that Iraqi Freedom records are miscoded as 08 or 09.)

WW=N/A

Other numeric codes indicate grade associated with pay plan.

Available in the restricted universe only.

Sponsor ID Type Code The code that represents the type of sponsor person identifier. Char (1) D, F, I, P, R, S, T D=Special 9-digit code created for individuals (i.e., babies) who do not have or have not provided an SSN when the record is added to DEERS (dependents only) F=Special 9-digit code created for foreign military and nationals. Known as FIN, Foreign Identifier Number.

I=Tax identification number P=Special 9-digit code created for U.S. military personnel before the switch to Social Security Numbers R=Special 9-digit code created for a DoD contractor who refused to give his or her SSN to RAPIDS. The associated PN_ID will begin with 99.

S=Social Security Number T=Test (858 series) Sponsor Rank Group Sponsor Pay Grade mapped to a more generic level. Char (2) EJ, ES, OJ, OS, WO, XX CD = Cadets EJ = Enlisted, Junior (E1-E4) ES = Enlisted, Senior (E5-E9) OJ = Officer, Junior (O1-O3) OS = Officer, Senior (O4-O9, 10, 11) WO = Warrant Officer (W1-W5) XX = All Others See Pay Plan Codes Sponsor Service DEERS Specific code indicating service of sponsor. Char (1) A, C, D, F, H, M, N, O, X, Z, 1, 2, 3, 4 A=Army C=Coast Guard D=Office of the Secretary of Defense F=Air Force H=The Commissioned Corps of the Public Health Service M=Marine Corps N=Navy O=The Commissioned Corps of the National Oceanic and Atmospheric Administration X=Not Applicable Z=Unknown 1=Foreign Army 2=Foreign Navy 3=Foreign Marine Corps 4=Foreign Air Force Sponsor Service, Aggregate Code indicating service of sponsor. Char (1) A, C, F, M, N, V, X, Z A=Army C=Coast Guard F=Air Force M=Marine Corps N=Navy V=Navy Afloat X=Other Z=Unknown Sponsor Status The code that represents how the DoD personnel and/or finance center views the sponsor based on accountability and reporting strengths. Char (1) A, B, C, D, E, F, H, I, J, K, L, M, N, O, Q, R, T, U, V, W, Z A=Active duty member B=Presidential Appointee C=DoD civil service employee, except Presidential appointee D=Disabled American veteran E=DoD contract employee F=Former member (Reserve service, discharged from the Ready Reserve or Standby Reserve following notification of retirement eligibility) H=Medal of Honor recipient I=Non-DoD civil service employee, except Presidential appointee J=Academy student K=Non-Appropriated Fund DoD employees L=Lighthouse service M=Non-government agency personnel N=National Guard member O=Non-DoD contract employee Q=Reserve retiree not yet eligible for retired pay ( gray area retiree ) R=Retired military member eligible for retired pay T=Foreign military U=Authorized foreign national civilian V=Reserve member W=DoD Beneficiary, a person who receives benefits from the DoD based on prior association, condition or authorization, an example is a former spouse Z=Unknown TPR Eligibility Flag The code that identifies whether the beneficiary is located in a TRICARE Prime Remote ZIP code and generally meets the basic demographic requirements for TPR Eligibility (e.g., sponsors are Active Duty/ Guard/ Reserve, dependents are Active Duty/Guard/ Reserve Family Members and located in same ZIP Code as sponsor's residence. Note that not all criteria for TPR are reflected in the algorithm for this flag (e.g., family member residence at time of Guard/Reserve activation. Char(1) Y, N Y=TPR Eligible N=Not TPR Eligible TPR Flag Indicates whether the Beneficiary Zip Code is in a TRICARE Prime Remote area. Char (1) N=No Y=Yes Underwritten Region Code indicating whether contractor is at risk. (Not yet populated for FY2005 and FY2006 data). Char (1) N, S, W, blank Populated starting in FY04.

N, S, W: CONUS Managed Care Support contractor (North, South, West) at risk for the payments Blank: No contractor is at risk.

&"MS Sans Serif,Bold"&14&A

&"MS Sans Serif,Bold"April 2014 Version &A &"MS Sans Serif,Bold"Page &P of &N]

Return to the Table of Contents /xl/drawings/drawing4.xml#'Table%20of%20Contents'!A1 Longitudinal Eligibility

B=TRICARE Global Remote Overseas Prime Active Duty D=TRICARE Senior Prime E=Non-Active Duty Prime F=TRICARE Global Remote Overseas Prime Active Duty Family Member G=TRICARE Plus, (Includes Private Sector Coverage, TFL) H=TRICARE Overseas Prime Active Duty J=TRICARE Overseas Prime Active Duty Family Member L=TRICARE Plus, DC Entitlement Only (No Private Sector Coverage, No TFL) M=AD not reported enrolled (added FY05) Q=AD enrolled to Op Forces R=TRICARE Reserve Select

U=USTF/USFHP

V=TRICARE Retired Reserve ACV November Alternate Care Value: Code that indicates the enrollment status of the beneficiary, as reported in DEERS at the time of the extract, for November. Char (1) A, B, D, E, F, G, H, J, L, M, Q, R, U, V A=Active Duty Prime B=TRICARE Global Remote Overseas Prime Active Duty D=TRICARE Senior Prime E=Non-Active Duty Prime F=TRICARE Global Remote Overseas Prime Active Duty Family Member G=TRICARE Plus, (Includes Private Sector Coverage, TFL) H=TRICARE Overseas Prime Active Duty J=TRICARE Overseas Prime Active Duty Family Member L=TRICARE Plus, DC Entitlement Only (No Private Sector Coverage, No TFL) M=AD not reported…