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