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
16 | ASSOC_ORDER_ID | NUMERIC | No |
Stores the order ID of the post-discharge referral order that is associated with this service request. Orders are automatically associated with service requests upon selection if the service request's primary service (MAG) matches the primary service on the order's procedure (EAP) record.
17 | SVC_REQ_DESELECT_RSN_C_NAME | VARCHAR | No |
This column is used to document the reason a service request was deselected in CCM CCSC workflows for auditing purposes. Currently, this deselection reason is only documented when deselecting service requests that have an associated referral order, since deselecting a service provider and/or selecting another service provider will affect where the associated referral record is routed to.
May contain organization-specific values: Yes
Category Entries:
Selecting Different Service Provider
Patient Discharge Disposition Changed
Service Request was Selected in Error
Facility No Longer Able to Provide Care
Other (Comment)
18 | DESELECT_REASON_COMMENT | VARCHAR | No |
The comment for a deselection reason of 99999 - Other (Comment). Other deselection reasons should not have a comment specified.