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