Data Dictionary
Selected table: TEETH
| id | Physical Name | Logical Name | Description | Category |
|---|---|---|---|---|
| 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 | OPSITE_CD | Dental Operative Site | Code used to identify the tooth, range of teeth, or other location for which the ADA procedure was performed. | 19.0000 |
| 1 | OPSITE_SURF_NBR | Dental Tooth Surface | Sequence number that ties an opsite code/tooth surface combination (set) to a particular ADA code. The sequence number associated with the ADA code matches the opsite surface number. | 19.0000 |
| 1 | REGION_ABBR_CD | Region Abbreviation Code | Alpha (3-char) designator indicating the IHS region (e.g. ALB for Albuquerque). | 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 |
| 1 | TOOTH_SURF_CD | Tooth Surface | Tooth surface. | N/A |
