Data Dictionary
Selected table: ADA_PROC
- Home
- Data Dictionary
- Table List
- ADA_PROC
| id | Physical Name | Logical Name | Description | Category |
|---|---|---|---|---|
| 1 | ADA_CD | ADA Code | American Dental Association code that designates the type of dental service provided during this encounter. Nationally recognized standard code set. | 19.0000 |
| 1 | ADA_FEE_AMT | ADA Code Fee Amount | Fee for this ADA Code rounded to the nearest dollar. If multiple units are stated for this code entry, fee amount is the total for all units. | 19.0000 |
| 1 | ADA_UNITS | ADA Units | Number of the services identified by the ADA code that were delivered (e.g., if the ADA code is for tooth extraction and there are three ADA units, that means three teeth were extracted). | 19.0000 |
| 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 | 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 |
