DOCS_RCVD_SUPG_PROV_INFO
Description:
This table contains information about the supervising provider of the e-prescription.

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 SUPG_PROV_ID VARCHAR No
The unique identifier for the supervising provider record.
5 SUPG_PROV_NAME VARCHAR No
Name for the supervising provider
6 SUPG_PROV_WORK_PH VARCHAR No
Work phone number for the supervising provider
7 SUPG_PROV_FAX VARCHAR No
Fax number for the supervising provider
8 SUPG_PROV_EMAIL VARCHAR No
E-mail address for the supervising provider
9 SUPG_PROV_ADD_STREE VARCHAR No
Street address for the supervising provider
10 SUPG_PROV_ADDR_CITY VARCHAR No
City for the supervising provider work address
11 SUPG_PROV_ADDR_ST_C_NAME VARCHAR No
The specialties ID for the supervising provider work address
May contain organization-specific values: Yes
12 SUPG_PROV_ADDR_ZIP VARCHAR No
Zip code for the supervising provider work address
13 SUPG_PROV_SPEC_NAME VARCHAR No
Free text list of supervising provider specialty names
14 SUPG_PROV_SPEC_C_NAME VARCHAR No
The state category ID for the supervising provider.
May contain organization-specific values: Yes
15 SUPG_PROV_DEA_NUM VARCHAR No
DEA number of the supervising provider
16 SUPG_PROV_ST_LIC_NU VARCHAR No
State license number of the supervising provider
17 SUPG_PROV_NPI VARCHAR No
National Provider Identifier (NPI) number of the supervising provider
18 SUPG_PROV_CLINIC_NM VARCHAR No
Clinic name where the supervising provider practices
19 ERX_IS_REFILL_FOLLOWUP_YN VARCHAR No
Identifies whether the provider on this line of the group is a refill follow-up provider.
May contain organization-specific values: No
Category Entries:
No
Yes
20 SUPG_PROV_NAME_SUFFIX VARCHAR No
Stores suffixes for the supervising provider's name.