COMMUNITY_RESOURCE
Description:
This table stores details about the recommendation of a community resource for a patient. This table can be joined with the COMMUNITY_RESOURCE_CNCT table on COMMUNITY_RESOURCE__LAST_UPDATE_RECOM_CSN_ID and COMMUNITY_RESOURCE_CNCT__RECOMMENDATION_CSN_ID in order to form a resulting table that includes all current information about the community resource recommendation.

Primary Key
Column Name Ordinal Position
RECOMMENDATION_ID 1

Column Information
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 NUMERIC No
The community based organization to which the patient was recommended or referred.
7 RECORD_CREATION_DATE DATETIME No
Stores the date the record was created
8 RESOURCE_DEPARTMENT_ID NUMERIC No
The department to which the patient was recommended or referred.
9 RESOURCE_PROV_ID VARCHAR No
The provider to which the patient was recommended or referred.
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
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.