COMMUNITY_RESOURCE_CNCT
Description:
This table stores updates made to community resource recommendations for a patient. Each update to a CRC record is represented by a new row in this table with a new contact date.

Primary Key
Column Name Ordinal Position
RECOMMENDATION_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 RECOMMENDATION_ID NUMERIC No
The unique identifier (.1 item) for the recommendation record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 DOCUMENTING_INSTANT_UTC_DTTM DATETIME (UTC) No
The instant at which this contact was created.
4 DOCUMENTING_SOURCE_C_NAME VARCHAR No
The source of creation of this contact.
May contain organization-specific values: No
Category Entries:
Hyperspace
MyChart
Healthy Planet Link
External Portal
OPA Criteria - Manual
OPA Criteria - Auto
5 DOCUMENTING_PAT_ENC_CSN_ID NUMERIC No
The patient encounter from which this contact was created.
6 DOCUMENTING_USER_ID VARCHAR No
The user who was responsible for the creation of this contact.
7 DOCUMENTING_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 USAGE_CRC_C_NAME VARCHAR No
The usage of this community resource recommendation.
May contain organization-specific values: No
Category Entries:
Recommended
In Use
Won't Be Used
Completed
Cancelled
9 NOT_USED_REASON_C_NAME VARCHAR No
The reason that this community resource was not utilized by the patient.
May contain organization-specific values: Yes
Category Entries:
CBO Declined
Request Forwarded
Patient Not Eligible
Patient Declined
Does not meet patient's needs
No Longer Needed
10 COMPLETED_OUTCOME_C_NAME VARCHAR No
The outcome of this completed community resource recommendation.
May contain organization-specific values: Yes
Category Entries:
Needs Met
Needs Not Met
No Longer Needed
Can No Longer Use
Request Forwarded
11 COMMENT_NOTE_CSN_ID NUMERIC No
The HNO CSN of the comment associated with this community resource recommendation.
12 HISTORIC_YN VARCHAR No
Whether the community resource is historic (Y) or current (N).
May contain organization-specific values: No
Category Entries:
No
Yes
13 HIST_LINE_OV_IDENT INTEGER No
The historical line for information associated with the community resource's contact (stored in related group EPT 34000). Use this column, in conjunction with column CREATING_PAT_ENC_CSN_ID in table COMMUNITY_RESOURCE, to join to DP_FACILITY, which contains more information on the community resource's contact.
14 DOCUMENTING_MYPT_ID VARCHAR No
The unique ID of the MyChart user who created this contact.
15 IS_SENSITIVITY_OVERRIDDEN_YN VARCHAR No
Whether the user manually updated the sensitivity of the community resource/service request.
The category values for this column were already listed for column: HISTORIC_YN