|
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 |
|
|