DOCS_RCVD_PROV_INFO

Description: |
This table contains the external provider information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
DOCUMENT_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | DOCUMENT_ID | NUMERIC | No |
The unique identifier (.1 item) for the document record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | PROV_IDENT | VARCHAR | No |
Identifier to link provider with other related groups
5 | PROV_WORK_PH | VARCHAR | No |
Work phone number for the provider
6 | PROV_FAX | VARCHAR | No |
Fax number for the provider
7 | PROV_EMAIL | VARCHAR | No |
E-mail address for the event provider
8 | PROV_ADD_STREET | VARCHAR | No |
Street address for the provider
9 | PROV_ADDR_CITY | VARCHAR | No |
City for the provider work address
10 | PROV_ADDR_STATE_C_NAME | VARCHAR | No |
State for the provider work address
May contain organization-specific values: Yes
11 | PROV_ADDR_ZIP | VARCHAR | No |
Zip code for the provider work address
12 | PROV_SPEC_NAME | VARCHAR | No |
Free text list of provider specialty names
13 | PROV_SPEC_C_NAME | VARCHAR | No |
List of specialties for the provider
May contain organization-specific values: Yes
14 | PROV_DEA_NUM | VARCHAR | No |
DEA number of the provider
15 | PROV_ST_LIC_NUM | VARCHAR | No |
State license number of the provider
16 | PROV_NPI | VARCHAR | No |
National Provider Identifier (NPI) number of the provider
17 | PROV_EXT_ID | VARCHAR | No |
External vendor identifier of the provider
18 | PROV_CLINIC_NAME | VARCHAR | No |
Clinic name where the provider practices
19 | PRESC_AGENT_NAME | VARCHAR | No |
The name of the prescriber agent who enters the prescription on behalf of the provider.
20 | PROV_SER_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
21 | PROV_CRED | VARCHAR | No |
Contains external provider credentials.
22 | PROV_ADDR_RELATED_YN | VARCHAR | No |
If this item is set to 1, then the address information in the provider related group (DXR 9000) is related. This includes items for Address - Street, City, State, Zip Code as well as Phone, Fax, Email. This means that for one line in the provider related group (DXR 9000) it can be safely assumed that the Address, Phone, Fax, and Email are all related and can be grouped and displayed together.
May contain organization-specific values: No
Category Entries:
No
Yes
23 | PROV_TYPE_NAME | VARCHAR | No |
The name of the external provider's provider type.
24 | PROV_TYPE_C_NAME | VARCHAR | No |
The internal category ID of the external provider's type.
May contain organization-specific values: Yes
Category Entries:
Resource
Physician
25 | PROV_PREFIX | VARCHAR | No |
Prefix of Provider's Name
26 | PROV_SUFFIX | VARCHAR | No |
Suffix of Provider's Name
27 | PROV_NADEA_NUM | VARCHAR | No |
This column contains the narcotic addiction DEA number of the provider on this line.