DOCS_RCVD_COM_RSRC
Description:
This table contains information about community resources received by external document records (DXR) on the Cosmos host.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
The unique identifier (.1 item) for the document 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 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 COM_RSRC_CREATION_UTC_DTTM DATETIME (UTC) No
The UTC instant at which the community resource was created.
5 COM_RSRC_SENT_UTC_DTTM DATETIME (UTC) No
The UTC instant at which the community resource request was sent.
6 COM_RSRC_ACCEPTED_UTC_DTTM DATETIME (UTC) No
The UTC instant at which the community resource request was accepted.
7 COM_RSRC_DECLINED_UTC_DTTM DATETIME (UTC) No
The UTC instant at which the community resource request was declined.
8 COM_RSRC_SELECTED_UTC_DTTM DATETIME (UTC) No
The UTC instant at which the community resource request was selected.
9 COM_RSRC_END_DATE DATETIME No
The date on which the community resource ended.
10 DP_FAC_STATUS_C_NAME NUMERIC No
The request status for the community resource.
May contain organization-specific values: Yes
Category Entries:
Accepted
Declined
Pending - No Request Sent
Pending - Request Sent
Removed
Considering
Processing
11 USAGE_CRC_C_NAME NUMERIC No
The usage status of the community resource.
May contain organization-specific values: No
Category Entries:
Recommended
In Use
Won't Be Used
Completed
Cancelled
12 COM_RSRC_NAME VARCHAR No
The name of the facility or department for the community resource.
13 COM_RSRC_SVC_LINE_NAME VARCHAR No
The name of the service line at the community resource organization being referred to.
14 DP_COORD_TYPE_C_NAME NUMERIC No
The coordination type of the community resource.
May contain organization-specific values: Yes
Category Entries:
Destination
Durable Medical Equipment
Dialysis/Infusion
Home Medical Care
Community Resources
Behavioral Health
Palliative Care
15 CREATING_SOURCE_C_NAME NUMERIC No
The source that created the community resource.
May contain organization-specific values: No
Category Entries:
Hyperspace
MyChart
Healthy Planet Link
External Portal
OPA Criteria - Manual
OPA Criteria - Auto
Emmie
16 DP_COMM_MODE_C_NAME NUMERIC No
Method by which the community resource request was sent.
May contain organization-specific values: No
Category Entries:
Fax
In Basket
Care Everywhere
External Portal
17 IS_SENSITIVE_YN VARCHAR No
Whether the community resource is considered sensitive based on the services offered/chosen or the SDOH domains that are addressed.
May contain organization-specific values: No
Category Entries:
No
Yes
18 COMPLETED_OUTCOME_C_NAME NUMERIC No
The outcome of the completed community resource.
May contain organization-specific values: Yes
Category Entries:
Needs Met
Needs Not Met
No Longer Needed
Can No Longer Use
Request Forwarded
19 NOT_USED_REASON_C_NAME NUMERIC No
The reason the community resource will not be used 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