Interface Requirements Document Describing the DMIS ID Reference Table to MDR Mod 1

acceptablepeasSecurity

Nov 30, 2013 (3 years and 6 months ago)

278 views

IRD
-
1300
-
6210
-
02


DHSS

PROGRAM MANAGEMENT



Interface
Requirements

Document

Describing the
DMIS ID
Reference Table

to
MDR

Mod 1



Approved

Version


December 11, 2008



DHSS Program Office

5203 Leesburg Pike, Suite 1500

Falls Church, VA 22041

IRD
-
1300
-
6210
-
02


This page
intentionally left blank.


IRD
-
1300
-
6210
-
02


iii

I
RD

Describing the
DMIS ID Reference Table

to
MDR


Approved

Version


November 15, 2007

Approval Page

Approved
by:

Mr. Paul Lindsey

Date

Chair, Configuration Control Board (CCB)

Defense Health Services Systems (DHSS)





DHSS Program Office

5203 Leesburg Pike, Suite 1500

Falls Church, VA 22041

IRD
-
1300
-
6210
-
02


iv


This page intentionally left blank.


IRD
-
1300
-
6210
-
02


v

I
R
D Describing the
DMIS ID Reference Table

to
MDR


Approved

Version


November 15, 2007

Review Page

Submitted by:

Mr. Steve Luhrman

Date

Interfaces Integration Manager

DHSS

Program Office


Reviewed by:

M
r.
Martin Shepherd

Date

Manager
,
DHSS

Data Operations

DHSS

Program Office

Reviewed by:

Mr.
William

Eberhardt

Date

Senior Engineer & Architect

DHSS

Program Office





DHSS Program Office

5203

Leesburg Pike, Suite 1500

Falls Church, VA 22041

IRD
-
1300
-
6210
-
02


vi


This page intentionally left blank.


DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


vii

Preface

This document
describes the interface
s that provide

the
DHSS

Program Office’s MHS
Data Repository (MDR) with the
Defense Medical Information Sy
stem (DMIS)
Identification (DMIS ID)

dataset
.

This document is under
DHSS

project configuration control. Changes to this document
will be made by document change notice (DCN) or by complete revision.

Questions on proposed changes concerning this plan sho
uld be addressed to:

DHSS

Program Office

5
203

Leesburg Pike, Suite

1500

Falls Church, Virginia 22041




DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


viii


This page intentionally left blank.


DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


ix

Abstract

The
Defense Health Services Systems
(DHSS)

Program Office is developing the Military
Health System (MHS) Data Repository (MDR) as the core repository for MHS clinical,
beneficiary population, enrollment, costing and workload data. MDR collects, catalogues
and organizes data files from sever
al systems. This document is the Interface
Requirements

Document (I
R
D) that specifies the
Defense Medical Information System
(DMIS) Identification (DMIS ID)

dataset

that is

p
rovided
to

the MDR
.

Keywords:

Decision Support, Executive Information, Interface

Requirements

Document,
MHS Data Repository,
DMIS ID,
DS, EI,

I
R
D,
MDR



DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


x


This page intentionally left blank.


DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


xi



BASELINE, CHANGE AND REVISION HISTORY PAGE



ISSUE



DATE


PAGES AFFECTED


DESCRIPTION

Baseline

Nov 15
, 2007

All

Baseline

Mod 1

Dec 11, 2008

2
-
13

Corrected definition of
“MEPRS Unit ID” field

M潤 1

a散‱ㄬ ㈰〸

N畭敲潵s

r灤慴敤ato refl散e Efap
w慳敲g敤 i湴n aepp





































































DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


xii


This page intentionally left
blank.


DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


xiii

Contents

Preface


................................
................................
.........................


vii

Abstract


................................
................................
.........................


ix

Section 1: Introduction

................................
................................

1
-
1

1.1

Document Identification

................................
................................
.............

1
-
1

1.2

Scope

................................
................................
................................
........

1
-
1

1.3

Purpose and Objectives

................................
................................
.............

1
-
1

1.4

Background
................................
................................
................................

1
-
1

1.5

Reference Documents

................................
................................
...............

1
-
2

Section 2: Data Flow Descriptions

................................
..............

2
-
1

2.1

Overview

................................
................................
................................
....

2
-
1

2.2

DMIS ID Name

................................
................................
...........................

2
-
1

2.3

MEPRS Parent Files

................................
................................
..................

2
-
2

2.4

PPS Market Value

................................
................................
.....................

2
-
3

2.5

PPS Earnings Factor

................................
................................
.................

2
-
3

2.6

PPS Parent File

................................
................................
.........................

2
-
4

2.7

Non DHP DMIS ID Reference Table

................................
..........................

2
-
4

2.8

Norms

................................
................................
................................
........

2
-
5

2.9

Peer Group

................................
................................
................................

2
-
5

2.10

TFL Parent

................................
................................
................................
.

2
-
6

2.11

TFL LOE

................................
................................
................................
....

2
-
7

2.12

TF
L Unit Price Table

................................
................................
..................

2
-
8

2.13

BPA (Bid Price Adjustment)

................................
................................
.......

2
-
9

2.14

Cost Parent

................................
................................
................................

2
-
9

2.15

Invoice

................................
................................
................................
.....

2
-
10

2.16

MSMA (Multi
-
Service Market Area)

................................
.........................

2
-
10

2.17

MTF Master (Years Prior to FY01)

................................
...........................

2
-
11

2.18

MTF Master (Years FY01
-
FY03)

................................
.............................

2
-
12

2.19

MTF Master (Years FY04
-
FY06)

................................
.............................

2
-
13

2.20

MTF Master (Year FY07
-
Present)

................................
...........................

2
-
14

2.21

CHCS Parent Table

................................
................................
.................

2
-
15

2.22

MEPRS/CHCS Alias File

................................
................................
.........

2
-
15

2.23

ADS Parent Table

................................
................................
....................

2
-
16


Appendix A: Acronyms

................................
................................
......................

1



Figures

Figure 2
-
1 DMIS ID Overview

................................
................................
...........

2
-
1

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


xiv


DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


1
-
1



Section 1:
Introduction

1.1

Document Identification

This document describes th
e
external
interface
s to support the development of the
Defense Medical Information System (DMIS) Identification (DMIS ID) table. The DMIS
ID table is stored in the Military Health System (
MHS
)

Data Repository (MDR)
, and used
in all
DHSS

applications (e.g
., M2).

1.2

Scope

This document describes and identifies
all external interfaces used by
DHSS

contractors
to develop the DMIS ID reference table that resides on MDR and is used by all
DHSS

applications
.

Consistent referential data is necessary for putting data from disparate
sources in context.


DMIS ID table identifies Medical Treatment Facilities (MTF), other
sources of medical care services available to TRICARE beneficiaries, and their
relationships

with regards to financing, administration, information technology
architecture, etc.

1.3

Purpose

and Objectives

This document is written to formalize the raw data interfaces that are used to develop
the DMIS ID reference table. There are
2
3

inputs that are u
sed to create the DMIS ID
table. The objective is to identify the inputs, and associate the data interface provider,
the expected interface periodicity, and stipulate the data feed layout. The objective of
this IRD is to pre
-
coordinate a rather complex t
ask into specified processes, some of
which lend themselves to automation when under structured controls.

1.4

Background

The Defense Health Services Systems (DHSS)

Program Office (
PO
)
provides decision
support information and tools used by MHS managers, clinic
ians, and analysts to
manage the business of healthcare within the MHS. To facilitate providing complete,
accurate information, upon which to make decisions,
DHSS

manages the receipt,
processing, and storage of tremendous volumes of data that characterize
MHS
operations and performance. The data, which include beneficiary, provider, financial and
healthcare use information, are processed to improve data quality, integrated and then
made available to MHS users through a variety of
DHSS

products and specializ
ed data
sets developed to meet business requirements.

DHSS

provides the centralized data store for the MHS with active interfaces to more
than 260 systems around the globe.
DHSS

is currently comprised of a
two
data
warehouse
s

and
thirteen

operational data
marts supporting
over

3000 users and
providing an exceptionally robust database and suite of decision support tools to
empower the effective management of MHS healthcare operations.

The MDR is the
DHSS

PO's centralized data repository. The MDR adds value t
o
enterprise data marts in multiple ways.



Captures the data only once

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


1
-
2



Lessens the impact on source systems



Controls access to privacy protected data



Reduces cost/complexity of data mart development



Data is cleaned only once (efficiency)



Data Quality is managed at the MDR so focus can be made on Data Mart
functionality



Instills confidence in use of system (cleansed, qualified data sets)

Among the deployed applications supported by
DHSS

are the Managed Care
Forecasting and Analysis System

(MCFAS), M2 (MHS Management Analysis and
Reporting Tool; formerly ARS Bridge),
Electronic Surveillance System for Early
Notification of Community
-
based Epidemics (ESSENCE),
and the TMA Reporting Tools
(
P
CDIS,
P
C
DW
,
P
CURES).
DHSS

consolidates and integrate
s data from multiple
sources within the MHS to allow users to access data from a corporate perspective in
support of their decision processes. These sources include Military Treatment Facilities,
Managed Care Support Contractors, the Defense Manpower Data
Center, and the

Medical Expense and Performance Reporting System

(
MEPRS
)

Executive Query
System as well as multiple reference files.

1.5

Reference Documents

1.

EIDS

Program Office,
CEIS Operational Requirements Document (ORD)
, Falls
Church,
VHA
, December 1997.


2.

EIDS Program Office,
Initial Capabilities Document (ICD),

dated March 2006
(pending JROC approval)



DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
1


Section 2:
Data
Flow Descriptions

2.1

Overview

Figure 2.1 provides an overview of the inputs that the
DHSS

contractor (currently TMCI
)
uses to create the DMIS ID Table for MDR. The following sections describe each
interface in terms of date file provider, periodicity, layout and delimitation method. The
expectation is that file providers will adhere to these descriptions.

The inputs t
o create the DMIS ID table, and the DMIS ID table itself do not contain any
personal level identifiable information. Therefore, they can be delivered in the clear. On
the other hand, the MDR does contain sensitive data and is protected in accordance with

the C2
-
level protection standards mandated for all "Sensitive Unclassified Systems" by
the requirements of DoD Directive 5200.28. Likewise, all
DHSS

applications (e.g., M2)
contain sensitive information and must be protected.



Figure
2
-
1

DMIS ID Overview

2.2

DMIS ID Name

Responsible TMA Organization:
DHSS

DHSS
(TMCI)
DMIS ID Processing
And Preparation
RITPO
(EAS IV Contractors)
-
MEPRS Parent Files
HB&FP
(Mr. Atkinson)
-
PPS Market/Cap
-
PPS Earnings Factor
-
PPS Parent File
BEA
(SRA)
-
Norms
-
Peer Group
-
TFL Parent
-
TFL LOE
-
TFL Unit Price
-
Cost Parent
BEA
(
Kennell
)
-
Non DHP
-
MSMA
BEA
(LMGS)
-
MTF Master DMIS ID
MDR
DMIS ID Tables
DHSS
(TMCI)
-
DMIS ID Name
RM
(
Kennell
)
-
Invoice
RM
(Ron Gordon)
-
BPA
DHIMS
(SAIC)
-
CHCS Parent
-
MEPRS/CHCS Alias
-
ADS Parent
DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
2

Responsible TMA Organization:
DHSS

Responsible Contractor:
TMCI


(Ms.

Teri Clegg



tclegg@tmci
-
international.com
)

Periodicity:
As required


File Type: Flat File

Delimiter:
Tab delimited

DMIS ID Name (
from
Raw Master File) File Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMIS ID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

NAME

40

Character

DMIS facility name.

BRIDGEBC

1

Character

EBC Flag.


2.3

MEPRS Parent
Files

Responsible TMA Organization: RITPO


(Ms. Audrey Heil



Audrey.Heil.ctr@tma.osd.mil
)

Responsible Contractor: EAS IV Operations Contractor

Periodicity: As required



Monthly as part of the EAS

IV feed

File Type: Flat File

Delimiter: “!”

MEPRS
Parent File Layout (FY01 to present):

Field Name

Field
Length

Data
Type

Functional Description

FY

4

Character

Fiscal year.

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

MEPR_PAR

4

Character

DMIS ID of MEPRS parent.


DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
3

2.4

Prospective Payment
System (
PPS
)

Market
Value

Responsible TMA Organization: HB&FP

(
Gregory.Atkinson@ha.osd.mil
)

Responsible Contractor: None

Periodicity: Annually (October)

File Type: Flat File

Delimiter: Tab delimited

Prospective Payment System (PPS) Market
Value/Capitation Rate File Layout
:

Field Name

Field
Length

Data
Type

Functional Description

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

RVUMKTVL

12(8,4)

Numeric

PPS RVU Market Value

RWPMKTVL

12(8,4)

Numeric

PPS RWP Market Value

RXMKTVL

12(8,4)

Numeric

PPS Pharmacy Script Market Value

DAYMKTVL

13(9,4)

Numeric

PPS Day Market Value

PCAPRATE

13(9,4)

Numeric

Capitation Rate

RVUFACT

13(8,5)

Numeric

RVU Factor

DERMITOLOGY

13(9,4)

Numeric

Dermatology market value.

ENT

13(9,4)

Numeric

Ear,
Nose and Throat (ENT) market value.

ER

13(9,4)

Numeric

Emergency Room (ER) market value.

IM SUB

13(9,4)

Numeric

Internal Medicine (IM) subspecialties (SUB)
market value.

MH

13(9,4)

Numeric

Mental Health (MH) market value.

OB

13(9,4)

Numeric

Obstetrics
market value.

OPTOMETRY

13(9,4)

Numeric

Optometry market value.

ORTHOPEDIC

13(9,4)

Numeric

Orthopedic market value.

OTHER

13(9,4)

Numeric

Other market value.

PURCHASED CARE

13(9,4)

Numeric

Purchased care market value.

SURGERY

13(9,4)

Numeric

Surgery
market value.

SURGERY SUB

13(9,4)

Numeric

Surgery subspecialties market value.

GRAND TOTAL

13(9,4)

Numeric

Grand total market value.

RWP

13(9,4)

Numeric

Relative Weighted Product (RWP) cost.

BED DAY

13(9,4)

Numeric

Bed day cost.

2.5

PPS Earnings Factor

Responsible TMA Organization: HB&FP (Mr. Greg Atkinson)

(Gregory.Atkinson@ha.osd.mil)

Responsible Contractor: None

Periodicity: Annually (October)

File Type: Flat File

Delimiter: Tab delimited

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
4

Responsible TMA Organization: HB&FP (Mr. Greg Atkinson)

(Gregory.Atkinson@ha.osd.mil)

Prospective Payment System (PPS) Earnings Factor File
Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

P
RSPEARN

19(15.4)

Numeric

PPS Prospective Earnings

PAMBEARN

19(15.4)

Numeric

PPS Prospective Ambulatory Earnings

PINPEARN

19(15.4)

Numeric

PPS Prospective Inpatient Earnings

PRXEARN

19(15.4)

Numeric

PPS Prospective Pharmacy Earnings

PANCEARN

19(15.4)

Numeric

PPS Prospective Ancillary Earnings

POTHEARN

19(15.4)

Numeric

PPS Prospective Other Earnings


2.6

PPS Parent File

Responsible TMA Organization: HB&FP (Mr. Greg Atkinson)

(Gregory.Atkinson@ha.osd.mil)

Responsible Contractor: None

Periodicity: Monthly

File Type: Flat File

Delimiter: Tab delimited

Prospective Payment System (PPS) Parent File Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

PPS_PAR

4

Character

DMIS ID of the PPS parent.

2.7

Non DHP

DMIS ID Reference Table

Responsible TMA Organization:
BEA

Responsible Contractor: Kennel
l

(Wendy Funk)

(
wfunk@kennellinc.com
)

Periodicity:
As required

File Type: Flat File

Delimiter:
Non
-
Delimited

Non Defense Health Program (DHP) DMIS ID Reference Table File Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

UBU_SVC

1

Character

UBU Service.

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
5

2.8

Norms

Responsible TMA Organization:
BEA

Responsible Contractor: SRA
(Mark Perry)

(
Mark_Perry@sra.com
)

Periodicity: Annually (October)

File Type: SAS Dataset

Delimiter:

N/A

MHS DMIS ID Norm File Layout:

Field Name

Field
Length

Data
Type

Functional Description

PGP

1

Character

PEER Group identification.

APGPEER

10(8,2)

Numeric

Cost Per Ambulatory Procedure Group (APG)
Weight

MTF Peer Norm.

RVUPEER

10(8,2)

Numeric

Cost Per Relative Value Unit (RVU)
Weight

MTF Peer Norm.

RWPPEER

10(8,2)

Numeric

Cost Per Relative Weighted Product (RWP)
Weight

MTF Peer Norm.

APGMTF

10(8,2)

Numeric

Cost Per Ambulatory Procedure Group (APG)
Weight

MTF Norm.

RVUMTF

10(8,2)

Numeric

Cost

Per Relative Value Unit (RVU)
Weight

MTF Norm.

RWPMTF

10(8,2)

Numeric

Cost Per Relative Weighted Product (RWP)
Weight

MTF Norm.

RVUCIV

Variable

Numeric

Cost Per RVU Civilian Norm.

RVUMC

Variable

Numeric

Cost per RVU
Weight

Civ
ilian

MC Norm

RWPCIV

Variable

Numeric

Cost Per RWP
Weight

Civilian Norm.

RWPMC

Variable

Numeric

Cost Per RWP
Weight

Civilian
MC Norm.


2.9

Peer Group

Responsible TMA Organization:
BEA

Responsible Contractor: SRA (Mark Perry)

(Mark_Perry@sra.com)

Periodicity: Annually
(October)

File Type:
Flat file

Delimiter:
“|”

Peer Group

File Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

PEERGRP

1

Character

Peer Group identification
.

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
6



2.10


TRICARE For
Life (
TFL
)

Parent

Responsible TMA Organization:
BEA

Responsible Contractor: SRA
(John Coventry)

(
John_Coventry@sra.com
)

Periodicity: Annually (October)

File Type: Flat file

Delimiter: Tab delimited

TRICARE For Life (TFL)
Parent Fi
le Layout:

Field
Name

Field
Length

Data
Type

Functional Description

Treatment DMIS

4

Character

Treatment DMIS ID (Reporting DMIS ID).

MEPRS Parent

4

Character

DMIS ID of the TFL parent.




DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
7

2.11


TFL LOE

Responsible TMA Organization:
BEA

Responsible Contractor: SRA (John
Coventry)

(John_Coventry@sra.com)

Periodicity: Annually (October)

File Type: Flat file

Delimiter: Tab delimited

TFL Level Of Effort (LOE) Table File Layout:

Field Name

Field
Length

Data
Type

Functional Description

Year

4

Character

Fiscal Year.

Parent

4

Character

TFL
Parent

DMIS ID.

MILPAY

Variable

Numeric

TFL Level of Effort (LOE) military pay.

OM

Variable

Numeric

TFL LOE

Operations & Maintenance (O&M).
Includes everything that is not MILPERS.
Pharmacy costs are not included.

PHARMCOSTS

Variable

Numeric

TFL LOE pharmacy.

RWP

Variable

Numeric

TFL LOE Relative Weighted Product (RWP).

WWU

Variable

Numeric

TFL LOE Ambulatory Patient Group (APG)

weighted workload.

Scripts

Variable

Numeric

TFL LOE prescription.

Total LOE

Variable

Numeric

TFL LOE total

(MILPAY + OM +
PHARMCOSTS).




DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
8

2.12


TFL Unit Price Table

Responsible TMA Organization:
BEA

Responsible Contractor: SRA (John Coventry)

(John_Coventry@sra.com)

Periodicity: Annually (October)

File Type: Flat file

Delimiter: Tab delimited

TFL Unit Price Table File Layout:

Field Name

Field
Length

Data
Type

Functional Description

Year

4

Character

Fiscal year
.

Parent

4

Character

DMIS ID of the TFL parent.

RWPMIL

Variable

Numeric

TFL RWP military pay

unit price.

RWPOM

Variable

Numeric

TFL RWP
O&M unit price. Includes everything
that is not MILPERS. Pharmacy costs are not
included.

APGMILPY

Variable

Numeric

TFL APG military pay

unit price.

APGOTH

Variable

Numeric

TFL APG other

unit price.

RXMILPY

Variable

Numeric

TFL prescription
military pay

unit price.

RXOTH

Variable

Numeric

TFL prescription other

unit price.


DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
9

2.13


BPA

(Bid Price Adjustment)

Responsible TMA Organization:
Resource Management (RM)

Responsible Contractor:
Kennell/Altarum


(Ron Gordon)

(
ron.gordon@altarum.org
)

Periodicity: As required

File Type: Flat file

Delimiter: Comma delimited

Bid Price Adjustment (BPA) DMIS ID Table File Layout:

Field Name

Field
Length

Data
Type

Functional Description

BPA_REG

2

Character

BPA region.

SERVICE

1

Character

Branch of
Service code.

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

FACNAME

45

Character

Facility name.

BPA_PAR

4

Character

DMIS ID of the parent facility.

BEG_DATE

10

Character

Beginning date of this record. Format: YYYY
-
MM
-
DD.

END_DATE

10

Character

Ending date of this record. Format: YYYY
-
MM
-
DD.

BIFCAFLG

1

Character

BRAC Impacted Former Catchment Area

SBCS

3

Character


STATUS

5

Character

Status of the BPA.

MTFPCM

1

Character

MTF Primary Care Manager (PCM)


2.14


Cost

Parent

Responsible TMA Organization:
BEA

Responsible Contractor: SRA
(Sandy Rogers)

(
sandy_rogers@sra.com
)

Periodicity: A
nnually (normally sometime between April and September)

File Type: Flat file

(a separate file for each fiscal year)

Delimiter: “!”

Cost
Parent Table File Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

COST_PAR

4

Character

DMIS ID of the parent accumulating the costs.


DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
10

2.15


Invoice

Responsible TMA Organization: RM

Responsible Contractor: Kennell (Wendy Funk)

(wfunk@kennellinc.com)

Periodicity:
Frozen

as of FY2001

File Type: Flat file

Delimiter: “|


Invoicing Parent Table File Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

INV_PAR

4

Character

DMIS ID of the parent that processes the
invoices.


2.16


MSMA

(Multi
-
Service Market Area)

Responsible TMA Organization: HB&FP

Responsible Contractor:
Kennel
l

(Wendy Funk)

(wfunk@kennellinc.com)

Periodicity: As required

File Type: Flat file

Delimiter: “!


Multi
-
Service Market Area (MSMA) Table File Layout:

Field Name

Field
Length

Data
Type

Functional Description

MSMA

3

Character

MSMA identifier.

DMISID

4

Character

Treatment DMIS ID
(Reporting DMIS ID).

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
11

2.17


MTF
Master

(Years Prior to FY01)

Responsible TMA Organization:
BEA

Responsible Contractor:

None

Periodicity:
Frozen

File Type: Flat File

Delimiter: “!”

MTF Master
DMIS ID File Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMIS ID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

FACNME

42

Character

Facility name.

DMISNME

30

Character

DMIS facility name.

UBU_REG

2

Character

TRICARE region code as defined by UBU.

FACLOCCD

2

Character

Facility
location code.

FACCITY

32

Character

Facility city location.

FACZIP

5

Character

Facility postal region zip code.

USFLAG

1

Character

Indicator that DMIS ID is in the United States.

INSTALNM

35

Character

Installation name.

UBU_PAR

4

Character

DMIS ID for

parent facility as defined by UBU.

FACTYPE

6

Character

Facility type code.

RAW_SVC

1

Character

Military service of the DMIS ID.

MEPRUNIT

6

Character

DMIS ID of MEPRS unit.

DCWID

5

Character

Direct Care Workload (DCW) identification code
of a MTF that
reports biometrics data.

MEPRSPAR

4

Character

DMIS ID of MEPRS parent.


DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
12

2.18


MTF Master (Years FY01
-
FY03)

Responsible TMA Organization:
BEA

Responsible Contractor:
None

Periodicity:
Frozen

File Type: Flat File

Delimiter: “|


MTF Master DMIS ID File
Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMIS ID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

DCWID

5

Character

Direct Care Workload (DCW) identification code
of a MTF that reports biometrics data.

MEPRUNIT

6

Character

DMIS ID of MEPRS unit.

RAW_SVC

1

Character

Service area code as defined by Unified
Biostatistical Utility (UBU).

FACTYPE

6

Character

Facility type code.

DMISNME

30

Character

DMIS facility name.

FACNME

42

Character

Facility name.

INSTALNM

35

Character

Installation name.

FACCNTRY

2

Character

Facility country location code.

FACSTATE

2

Character

Facility state location code.

FACCITY

32

Character

Facility city location.

FACZIP

5

Character

Facility postal region zip code.

FACZIP4

4

Character

The
extension to the facility’s postal region zip
identifier.

UBU_REG

2

Character

TRICARE region code as defined by UBU.

USFLAG

1

Character

Indicator that DMIS ID is in the United States.

UBU_PAR

4

Character

DMIS ID for parent facility as defined by UBU.

MEPRSPAR

4

Character

DMIS ID of MEPRS parent.

SVCAREA

4

Character

Service area code.

MAJCMND

8

Character

Major command of Service reporting parent.

AUTHENRL

1

Character

Indicator that DMIS ID is an authorized TRICARE
enrollment site.



DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
13

2.19


MTF Master
(Years FY04
-
FY06
)


Responsible TMA Organization:
BEA

Responsible Contractor:
None

Periodicity:
Frozen

File Type: Flat File

Delimiter: “
!


MTF Master DMIS ID File Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMIS ID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

DCW

ID

5

Character

Direct Care Workload (DCW) identification
code of a MTF that reports biometrics data.

MEPR
S
UNIT

ID

6

Character

Unit Identification Code (UIC)
of MEPRS
reporting site
.

FACILITY SERVICE
CODE

1

Character

Service area code as defined by Unified
Biostatistical Utility (UBU).

FACILITY TYPE CODE

6

Character

Facility type code.

DMIS

FACILITY NAME

30

Character

DMIS facility name.

FACILITY NAME

42

Character

Facility name.

INSTAL
LATION NAME

35

Character

Installation name.

FAC
ILITY COUNTRY
CODE

2

Character

Facility country location code.

FAC
ILITY
STATE

CODE

2

Character

Facility state location code.

FAC
ILITY

CITY

NAME

32

Character

Facility city location.

FAC
ILITY 5
-
DIGIT
ZIP

CODE

5

Character

Facility postal region zip code.

FAC
ILITY 4
-
DIGIT ZIP
CODE

4

Character

The extension to the facility’s postal region
zip identifier.

HEALTH SERVICE
REGION

2

Character

Health Service Support Contractor (HSSC)
region.

US

FLAG

CODE

1

Character

Indicator
that DMIS ID is in the United
States.

DMIS PARENT ID

4

Character

DMIS ID for parent facility as defined by
UBU.

MEPRS PARENT ID

4

Character

DMIS ID of MEPRS parent.

SERVICE AREA CODE

4

Character

Service area code.

FACILITY COMMAND
CODE

8

Character

Major command of Service reporting parent.

AUTHORIZED TRICARE
ENROLLMENT SITE

1

N, Y

Indicator that DMIS ID is an authorized
TRICARE enrollment site.

N

No

Y

Yes

NON
-
TNEX HEALTH
SERVICE REGION

2

Character

TRICARE region code as defined by UBU.

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
14

2.20


MTF
Master (Year FY07
-
Present)

Responsible TMA Organization:
BEA

Responsible Contractor:
Altarum (Nancy Austin)

(
Nancy.Austin@altarum.org
)

Periodicity: Monthly

File Type: Flat File

Delimiter: “
!


MTF Master DMIS ID File Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMIS ID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

DCW ID

5

Character

Direct Care Workload (DCW) identification
code of a MTF that reports biometrics data.

MEPRS UNIT ID

6

Character

DMIS ID of MEPRS unit.

FACILITY SERVICE
CODE

1

Character

Service area code as defined by Unified
Biostatistical Utility (UBU).

FACILITY TYPE CODE

6

Character

Facility type code.

DMIS FACILITY NAME

30

Character

DMIS facility name.

FACILITY NAME

42

Character

Facility name.

INSTALLATION NAME

35

Character

Installation name.

FACILITY COUNTRY
CODE

2

Character

Facility country location code.

FACILITY STATE CODE

2

Character

Facility state location code.

FACILITY CITY NAME

32

Character

Facility city location.

FACILITY 5
-
DIGIT
ZIP
CODE

5

Character

Facility postal region zip code.

FACILITY 4
-
DIGIT ZIP
CODE

4

Character

The extension to the facility’s postal region
zip identifier.

HEALTH SERVICE
REGION

2

Character

Health Service Support Contractor (HSSC)
region.

US FLAG CODE

1

Character

Indicator that DMIS ID is in the United
States.

DMIS PARENT ID

4

Character

DMIS ID for parent facility as defined by
UBU.

MEPRS PARENT ID

4

Character

DMIS ID of MEPRS parent.

SERVICE AREA CODE

4

Character

Service area code.

FACILITY COMMAND
CODE

8

Character

Major command of Service reporting parent.

AUTHORIZED TRICARE
ENROLLMENT SITE

1

N, Y

Indicator that DMIS ID is an authorized
TRICARE enrollment site.

N

No

Y

Yes

NON
-
TNEX HEALTH
SERVICE REGION

2

Character

TRICARE region code as defined by

UBU.

DHPFLAG

1

Character

Defense Health Program Flag

UBU_SVC

1

Character

DMIS ID Branch of Service

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
15

Responsible TMA Organization:
BEA

NEEDNPI

1

Character

NPI Required Flag

NPI2

10

Character

NPI Type 2

NPITAX

10

Character

NPI Taxonomy


2.21


Composite Health Care System (
CHCS
)

Parent Table

Responsible TMA Organization: CITPO

Responsible Contractor: SAIC

Periodicity: Frozen as of FY2001

File Type: Flat file

Delimiter: “!”

CHCS Parent Table File Layout:

Field Name

Field
Length

Data
Type

Functional Description

FY

4

Character

Fiscal Year.

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

CHCS_PAR

4

Character

DMIS ID of the parent CHCS site.


2.22


MEPRS/CHCS Alias File

Responsible TMA Organization: CITPO

Responsible Contractor: SAIC

Periodicity: Frozen as of

FY2000

File Type: Flat file

Delimiter: “!”

MEPRS/CHCS Alias Table File Layout:

Field Name

Field
Length

Data
Type

Functional Description

FY

4

Character

Fiscal Year.

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

ALIAS

4

Character

Alias.

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1


2
-
16

2.23


Ambulatory Data System (
ADS
)

Parent Table

Responsible TMA Organization: CITPO

Responsible Contractor: SAIC

Periodicity: Frozen FY1999
-

FY2001

File Type: Flat file

Delimiter: “!”

Ambulatory Data System (ADS) Parent Table File Layout:

Field Name

Field
Length

Data
Type

Functional Description

DMISID

4

Character

Treatment DMIS ID (Reporting DMIS ID).

ADS_PAR

4

Character

DMIS ID of the parent ADS site.

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1



1

Appendix A:
Acronyms


ADS

Ambulatory Data System

APG

Ambulatory Procedure
Group

ARS

All Region Server

BEA

Business Economic Analysis Division

BIFCA

BRAC Impacted Former Catchment Area

BPA

Bid Price Adjustment

BRAC

Base Realignment and Closure

CCB

Configuration Management Board

CEIS

Corporate Executive Information System

CHCS

Composite Health Care System

CITPO

Clinical Information Technology Program Office

DCN

Document Change Notice

DCW

Direct Care Workload

DHIMS

Defense Health Information Management System

DHP

Defense Health Program

DHSS

Defense Health Services
Systems

DMIS

Defense Medical Information System

DMIS ID

DMIS Identification

EAS IV

Expense Assignment System IV

EIDS

Executive Information/Decision Support

ENT

Ear, Nose and Throat

ER

Emergency Room

ESSENCE

Electronic Surveillance System for Early
Notification of Community
-
based Epidemics

HB&FP

Health Budgets and Financial Policy

HSSC

Health Service Support Contractor

ICD

Initial Capabilities Document

IM

Internal Medicine

IRD

Interface

Requirements

Document

JROC

Joint Requirements Oversight
Council

LOE

Level Of Effort

M2

MHS Management Analysis and Reporting Tool

(MHS MART)

MCFAS

Managed Care Forecasting and Analysis System

MDR

MHS Data Repository

MEPRS

Medical Expense and Performance Reporting System

MH

Mental Health

MHS

Military
Health System

MSMA

Multi
-
Service Market Area

MTF

Medical Treatment Facility

NPI

National Provider Identifier

O&M

Operations & Maintenance

OB

Obstetrics

ORD

Operational Requirements Document

PCDIS

Purchased Care Detail Information System

PCDW

Purchased Care Data Warehouse

PCM

Primary Care Manager

PCURES

Purchased Care Utilization Reporting and Evaluation System

DMIS ID IRD

APPROVED

Document No.:
IRD
-
1300
-
6210
-
02


December 11, 2008

Mod 1



2

PPS

Prospective Payment System

RITPO

Resources Information Technology Program Office

RM

Resource Management

RVU

Relative Value
Unit

RWP

Relative Weighted Product

SAS

Statistical Analysis System

TFL

TRICARE For Life

TMA

TRICARE Management Activity

UBU

Unified Biostatistical Utility (UBU)