ALT_ORD_PROV_SINGL
Description:
This table contains single response items for alternate ordering providers.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
3 ALT_ORD_PRV_NAME VARCHAR No
The name of the alternate ordering provider.
4 ALT_ORD_PRV_CITY VARCHAR No
The city for alternate ordering providers.
5 ALT_ORD_PRV_ZIP VARCHAR No
The zipcode for alternate ordering providers.
6 ALT_ORD_PRV_PHONE VARCHAR No
The phone number for alternate ordering providers.
7 ALT_ORD_PRV_FAX VARCHAR No
The fax number for alternate ordering providers.
8 ALT_ORD_PRV_EMAIL VARCHAR No
The email address for alternate ordering providers.
9 ALT_ORD_PRV_UPIN VARCHAR No
The Unique physician identification number (UPIN) for alternate ordering providers.
10 ALT_ORD_PRV_TAX_ID VARCHAR No
The tax identification number for alternate ordering providers.
11 ALT_ORD_PRV_TITLE_NAME VARCHAR No
The title of the alternate ordering provider.
May contain organization-specific values: Yes
12 ALT_ORD_PRV_RVW_C_NAME VARCHAR No
The last reviewed status of the alternate ordering provider.
May contain organization-specific values: Yes
Category Entries:
Needs Review
Reviewed
13 ALT_ORD_PRV_HOUSE_N VARCHAR No
The house number for alternate ordering providers.
14 ALT_ORD_PRV_DIST_C_NAME VARCHAR No
The district for alternate ordering providers.
May contain organization-specific values: Yes