|
Physical Name
|
Logical Name
|
Description
|
Order
|
| REGION_ABBR_CD |
Region Abbreviation Code |
Alpha (3-char) designator indicating the IHS region (e.g. ALB for Albuquerque). |
|
| SECURITY_TAG |
|
|
|
| HLTH_FACTR_CAT |
Health Factor Category |
Health factor category. (e.g., Tobacco) |
14.0000 |
| HLTH_FACTR_CAT_CODE |
Health Factor Category Code |
Health factor category code. |
14.0000 |
| HLTH_FACTR_CD |
Health Factor Code |
Health Factor code. |
14.0000 |
| HLTH_FACTR_NM |
Health Factor Name |
Name of Health Factor. (e.g., previous smoker) |
14.0000 |
| ENCTRSS_ID |
NDW Encounter Record Identifier |
This identifier is generated internally by the NDW and is used to uniquely identify an encounter record. |
100.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 |
| 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 |
|
9 Record(s)
|
|
Click on the Physical Name to display locations