Data Dictionary
Selected table: DX_OTH
- Home
- Data Dictionary
- Table List
- DX_OTH
id | Physical Name | Logical Name | Description | Category |
---|---|---|---|---|
1 | APC_RECODE_CD | APC Recode | APC Recode. IHS-specific code set utilized prior to being able to process ICD9 diagnosis code. | N/A |
1 | 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 |
1 | 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 |
1 | INP_RECODE_CD | Inpatient Recode | Inpatient Recode. IHS-specific code set utilized prior to being able to process ICD9 diagnosis code. | N/A |
1 | OLD_INJ_PLACE_CD | Old Injury Place Code | Injury Place Code values, obsolete value set. Captured in case the site has not converted to the new value set. The NDW converts the old value set to the new series and populates INJ_PLACE_CD. | N/A |
1 | REGION_ABBR_CD | Region Abbreviation Code | Alpha (3-char) designator indicating the IHS region (e.g. ALB for Albuquerque). | N/A |
1 | REVISIT_FG | Revisit flag | Code representing first visit or revisit. ARCHIVE colname is CFI_REVISIT_FG, loaded to target colname REVISIT_FG. (1 = First visit, 2 = Revisit) | N/A |
1 | 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 |