Data Dictionary
Selected table: ENCTRSS_DENTAL
- Home
- Data Dictionary
- Table List
- ENCTRSS_DENTAL
| id | Physical Name | Logical Name | Description | Category |
|---|---|---|---|---|
| 1 | DEN_COST_AMT | Dental Cost | Dental Total Cost rounded to the nearest dollar. | 19.0000 |
| 1 | DEN_DELIVERY_CD | Dental Delivery Code | The dental delivery modes designate whether this was a contracted or direct dental service. (D = Direct, K = Contract) | 19.0000 |
| 1 | DEN_PAT_TP_CD | Dental Patient Type Code | Indian status of dental patient. Obsolete, no longer used to determine Indian status for DDO (Dental Data Owner) dental workload reporting. | 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 | RPT_DENTIST_SSN | Dentist's SSN | SSN for the dental provider. (format 999999999, no dashes.) | 19.0000 |
