Data Dictionary
Selected table: PROVIDER_CODE
- Home
- Data Dictionary
- Table List
- PROVIDER_CODE
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 | PROV_AFFL_CD | Provider Affiliation Code | The affiliation of the provider. If multiple affiliations are sent, the first occurrence listed is considered to be the affiliation of the primary provider. | 7.0000 |
1 | PROV_DISC_CD | Provider Discipline Code | The discipline of the provider. If multiple disciplines are sent, the first occurrence listed is considered to be the discipline of the primary provider. | 7.0000 |
1 | PROV_LOCAL_TEXT | Provider Local Code | Code used at the site to identify the provider. Usually, but not always the provider's initials. | 7.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 |