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