U.S. Department of Health and Human Services
Indian Health Service: The Federal Health Program for American Indians and Alaska Natives
A - Z Index:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
#
Meta Data Information Resource  

Meta Data Dictionary

By Category  |  Table List
HOME / TABLE LIST / CHART
Down Arrow Pointing to Physical NameClick on the Physical Name to display locations
Physical Name Logical Name Description Order
REG_ID NDW Registration Record Identifier This identifier is generated internally by the NDW and is used to uniquely identify a registration record.
REGION_ABBR_CD Region Abbreviation Code Alpha (3-char) designator indicating the IHS region (e.g. ALB for Albuquerque).
CHART_FAC_CD Chart Facility Code Code to designate the facility where this chart is located. 2.0000
CHART_NBR Chart Number A patient's record number at the specified facility. Preferred format is right-justified and zero filled. 2.0000
CHART_STATUS_CD Chart Status Code Status of the specified chart at the local facility. (A = Active, D = Deleted, I = Inactive) 2.0000
DATE_LAST_MOD_TS Date of Last Update Date this record was last modified by the local registration/encounter system. Date format is CCYYMMDD. 2.0000
SRC_SYS_CD Source System Code Source System Codes will be unique across all source systems that feed the DW. Therefore, a particular code will also implicitly identify the source system that generated a particular record. For non-RPMS sites, the value will be assigned by the NDW; contact the NPIRS help desk. 2.0000
UNIQ_REG_CODE Unique Registration Code This identifier is generated by the source system. Preferred format is a unique 5-digit database identifier assigned by IHS, concatenated with a unique, right justified, zero filled 10-char registration identifier from the source system. 2.0000
EXPORT_ID Export ID Each export file that is received by the DW will be assigned a unique export ID number. This will allow us to track each record back to the "raw data file" if necessary. It also allows us to track certain information specific to each export such as number of records, date received, etc. 100.0000
REC_CD Record Code A code of up to four characters that identifies the record format that defines that particular record. This field is populated by the integration engine. This column may not be populated for non-HL7 formats. 100.0000
ROW_CREATE_TS Row Creation Date and Time stamp Date/Time that this row was created in the data warehouse. 100.0000
SEQ_NBR Sequence Number For the first occurrence, the sequence number is 1; for the second occurrence, the sequence number is 2, and so on. 100.0000
 12 Record(s)