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.