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