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