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.