SECOND_LEVEL_REVIEWS

Description: |
The SECOND_LEVEL_REVIEWS table is the primary table for secondary review and peer-to-peer review information. Each row contains basic information about second-level review records, including the review type and format type.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REVIEW_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REVIEW_ID | NUMERIC | No |
The unique identifier for the second-level review.
2 | SLR_WORKFLOW_CONTEXT_C_NAME | VARCHAR | No |
The category ID of the functional area that this review was created in.
May contain organization-specific values: No
Category Entries:
Utilization Review
3 | PAT_ID | VARCHAR | No |
ID of the associated patient that the record was created for.
4 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
5 | REFERRAL_ID | NUMERIC | No |
The unique ID of the associated referral.
6 | SLR_REVIEW_TYPE_C_NAME | VARCHAR | No |
The category ID of the overall type of review this second-level review holds (secondary or peer-to-peer).
May contain organization-specific values: No
Category Entries:
Secondary
Peer-to-Peer
7 | SLR_FORMAT_TYPE_C_NAME | VARCHAR | No |
The category ID of the second-level review's message format (stand-alone review or review request).
May contain organization-specific values: No
Category Entries:
With Request
Standalone
8 | RECORD_STATUS_2_C_NAME | VARCHAR | No |
The category ID for the second-level review record status (e.g., hidden or soft-deleted).
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
9 | LAST_EDIT_REVIEW_CSN_ID | NUMERIC | No |
The CSN of the most recent contact for this review.
10 | FIRST_SENT_REVIEW_CSN_ID | NUMERIC | No |
The CSN for the contact where this review was first sent.
11 | REV_COMPLETE_REVIEW_CSN_ID | NUMERIC | No |
The CSN for the contact where this review was completed by the reviewer.
12 | ADDL_NOTE_ID | VARCHAR | No |
The unique ID of the note for the additional comments related to the review.
13 | IN_BASKET_MSG_ID | VARCHAR | No |
The unique ID of the In Basket Message sent containing the second-level review request.
14 | REVIEW_COMPLETED_LOCAL_DTTM | DATETIME (Attached) | No |
The local (patient encounter) date and time when the second-level review was marked as completed.
15 | FOLLOW_UPS_COMP_REVIEW_CSN_ID | NUMERIC | No |
The CSN for the contact where this review had all follow-ups completed.