|
Name |
Type |
Discontinued? |
|
1 |
RECOMMENDATION_ID |
NUMERIC |
No |
|
|
|
The unique identifier (.1 item) for the recommendation record. |
|
|
2 |
RECORD_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
Stores the record status (hidden, soft-deleted, or both) |
May contain organization-specific values: No |
Category Entries: |
Soft Deleted |
Hidden |
Hidden and Soft Deleted |
|
|
3 |
RECORD_TYPE_CRC_C_NAME |
VARCHAR |
No |
|
|
|
The type of this community resource recommendation record, used to differentiate various implementations of the CRC masterfile. |
May contain organization-specific values: No |
Category Entries: |
Recommendation |
Encounter Level |
|
|
4 |
PAT_ID |
VARCHAR |
No |
|
|
|
The patient this community resource recommendation is for. |
|
|
5 |
CREATING_PAT_ENC_CSN_ID |
NUMERIC |
No |
|
|
|
The patient encounter in which this community resource recommendation was created. |
|
|
6 |
RESOURCE_FACILITY_POS_ID_LOC_NAME |
VARCHAR |
No |
|
|
|
The name of the revenue location. |
|
|
7 |
RECORD_CREATION_DATE |
DATETIME |
No |
|
|
|
Stores the date the record was created |
|
|
8 |
RESOURCE_DEPARTMENT_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
The external name of the department record. This is often used in patient correspondence such as reminder letters. |
|
|
9 |
RESOURCE_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. |
|
|
10 |
RESOURCE_PROV_ADDRESS_ID |
VARCHAR |
No |
|
|
|
The unique address ID associated with the provider record to which the patient was recommended or referred. |
|
|
11 |
DP_COORD_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
The coordination type. |
May contain organization-specific values: Yes |
Category Entries: |
Destination |
Durable Medical Equipment |
Dialysis/Infusion |
Home Medical Care |
Community Resources |
Behavioral Health |
Palliative Care |
|
|
12 |
CREATING_SOURCE_C_NAME |
VARCHAR |
No |
|
|
|
This column contains the source of creation for a community resource recommendation row represented as a number indicating the category value of the creation source. |
May contain organization-specific values: No |
Category Entries: |
Hyperspace |
MyChart |
Healthy Planet Link |
External Portal |
OPA Criteria - Manual |
OPA Criteria - Auto |
|
|
13 |
RESOURCE_SVC_LN_ID |
NUMERIC |
No |
|
|
|
The service line or program ID to which the patient was recommended or referred to receive services. |
|
|
14 |
RESOURCE_SVC_LN_ID_SVC_LN_NAME |
VARCHAR |
No |
|
|
|
The name (.2 item) of the service line record. |
|
|