|
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). |
|
| 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 |
| FIRST_NM |
First Name |
First name of the patient; could also be an alias. |
3.0000 |
| LAST_NM |
Last Name |
Last name of the patient; could also be an alias. |
3.0000 |
| MID_NM |
Middle Name |
Middle name of the patient; could also be an alias. |
3.0000 |
| NM_SUFX |
Name Suffix |
Name suffix, such as Sr., Jr., III, etc. |
3.0000 |
| NM_TITLE |
Title |
Title of the patient, such as Mr., Ms., Mrs., Miss, etc. |
3.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 |
|
14 Record(s)
|
|
Click on the Physical Name to display locations