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 VARCHAR No
This item stores the provider's mapped internal ID.
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.