PAT_PCP

Description:

This table contains the Primary Care Provider (PCP) information for your patients over time. It can also contain data about providers that are not PCPs but are still on the patients' EpicCare-Ambulatory care teams.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	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.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	PCP_PROV_ID	VARCHAR	No
	The unique ID associated with the provider record for this row. This column is frequently used to link to the CLARITY_SER table.
4	EFF_DATE	DATETIME	No
	The date from which the provider is in effect as the member’s PCP.
5	TERM_DATE	DATETIME	No
	The last date for which the provider was the member’s PCP.
6	PCP_TYPE_C_NAME	VARCHAR	No
	The category value associated with the type of the PCP. This is only populated when the provider is a patient's PCP and is null otherwise. May contain organization-specific values: Yes Category Entries: General
7	SPECIALTY_C_NAME	VARCHAR	No
	The specialty category ID for the patient care team member. May contain organization-specific values: Yes
8	RESULTS_C_NAME	VARCHAR	No
	The results to receive category ID for the patient care team member. May contain organization-specific values: No Category Entries: No results Abnormal results only All results
9	PCP_MESSAGE_YN	VARCHAR	No
	Indicates whether a provider on a patient's care team wishes to be included as a recipient of messages sent to the patient's PCP. A “Y” indicates that the provider wishes to receive messages, a “N” indicates that the provider does not wish to receive the messages. May contain organization-specific values: No Category Entries: No Yes
10	RELATIONSHIP_C_NAME	VARCHAR	No
	The relationship to patient category ID for the patient care team member. May contain organization-specific values: Yes
11	OTHER_NAME	VARCHAR	No
	The name for patient care team members that don't have a provider and resource record.
12	OTHER_ADDRESS	VARCHAR	No
	The address for patient care team members that don't have a provider and resource record. Lines are delimited with character 9s.
13	OTHER_PHONE	VARCHAR	No
	The phone number for patient care team members that don't have a provider and resource record.
14	OTHER_PAGER	VARCHAR	No
	The pager number for patient care team members that don't have a provider and resource record.
15	OTHER_FAX	VARCHAR	No
	The fax number for patient care team members that don't have a provider and resource record.
16	OTHER_EMAIL	VARCHAR	No
	The email address for patient care team members that don't have a provider and resource record.
17	PCP_HX_COMMENTS	VARCHAR	No
	Free text comments that can be entered for a provider that is part of the care team for this patient.
18	PCP_ADDRESS_ID	VARCHAR	No
	The unique ID of the address in the provider record that should be used to contact the patient's PCP. This column is frequently used in conjunction with the PCP_PROV_ID column to link to the CLARITY_SER_ADDR table.