SLR_P2P
Description:
This table stores peer-to-peer review data for second-level reviews.

Primary Key
Column Name Ordinal Position
REVIEW_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 REVIEW_ID NUMERIC No
The unique identifier for the second-level review.
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 P2P_OUTCOME_C_NAME VARCHAR No
The category ID of the outcome of the phone call between this organization's physician and the payer. For peer-to-peer reviews only.
May contain organization-specific values: No
Category Entries:
Overturned
Partially Overturned
Upheld, Needs Appeal
Incomplete
Deferred
Other
Upheld, No Appeal
P2P Not Recommended
4 P2P_APPOINTMENT_PHONE VARCHAR No
The phone number the physician or case manager should call to schedule an appointment. For peer-to-peer reviews only.
5 P2P_PAYER_REVIEWER_NAME VARCHAR No
The name of the person that this organization's physician will be speaking to. For peer-to-peer reviews only.
6 P2P_AUTH_ACUTE_LEVEL_OF_CARE_C_NAME VARCHAR No
The category ID of the acute level of care authorized by the payer for the encounter specified in the peer-to-peer review. Used in acute level of care reviews only.
May contain organization-specific values: Yes
7 P2P_AUTH_POST_ACUTE_CLASS_C_NAME VARCHAR No
The category ID of the post-acute class authorized by the payer for the encounter specified in the peer-to-peer review. Used in post-acute level of care reviews only.
May contain organization-specific values: No
Category Entries:
Long-Term Acute Care
Inpatient Rehabilitation
Skilled Nursing
Unskilled Nursing
Home Health
Outpatient Therapy
Palliative
Hospice
None
Other
8 P2P_AUTH_ACUITY_LEVEL_C_NAME VARCHAR No
The category ID of the acuity level authorized by the payer for the encounter specified in the peer-to-peer review. Used in acuity level reviews only.
May contain organization-specific values: Yes
9 P2P_AUTH_BASE_CLASS_C_NAME VARCHAR No
The category ID of the base patient-class authorized by the payer for the encounter specified in the peer-to-peer review. Used in patient class reviews only.
May contain organization-specific values: No
Category Entries:
Direct
Inpatient
Outpatient
Emergency
Observation
10 P2P_ACTUAL_CALL_DATE DATETIME No
The date when the peer-to-peer call for the peer-to-peer review actually occurred.
11 P2P_ACTUAL_CALL_INSTANT_DTTM DATETIME (Attached) No
The instant when the peer-to-peer call for the peer-to-peer review actually occurred.