DOCS_RCVD_COM_RESRC_USAGE
Description:
Contains information about a member/patient's community resource usages, as received from an outside organization over Care Everywhere or Payer Platform.

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 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 COMM_RESRC_USAGE_REF_IDENT VARCHAR No
This column stores the unique reference ID of a discrete community resource usage.
6 COMM_RESRC_USAGE_STATUS_C_NAME VARCHAR No
Stores the status of if a member/patient is currently using this community resource.
May contain organization-specific values: No
Category Entries:
Recommended
In Use
Won't Be Used
Completed
Cancelled
7 COMM_RESRC_REQ_STATUS_C_NAME VARCHAR No
This column stores the request status. The request status answers the question of "was the request to use this community resource sent to that community resource and did they receive it, did it get canceled, etc.?"
May contain organization-specific values: Yes
Category Entries:
Accepted
Declined
Pending - No Request Sent
Pending - Request Sent
Removed
Considering
Processing
8 COMM_RESRC_STREET_ADDR VARCHAR No
This column stores the street address of the community resource being used.
9 COMM_RESRC_COUNTY_C_NAME VARCHAR No
This column stores the county for the community resource being used.
May contain organization-specific values: Yes
10 COMM_RESRC_CITY VARCHAR No
This column stores the city of the community resource being used.
11 COMM_RESRC_ADDR_STATE_C_NAME VARCHAR No
This column stores the state of the community resource being used.
May contain organization-specific values: Yes
12 COMM_RESRC_POSTAL_CODE VARCHAR No
This column stores the postal code of the community resource being used.
13 COMM_RESRC_COUNTRY_C_NAME VARCHAR No
This column stores the country of the community resource being used.
May contain organization-specific values: Yes
14 COMM_RESRC_REFERRED_UTC_DTTM DATETIME (UTC) No
Stores the instant that the community resource was first documented or referred to the member or patient.