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_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of 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 additional results
Yes. All abnormal results
Yes. 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.