SLR_SECONDARY
Description:
This table stores secondary review data from 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 SEC_GENERIC_DETERM_C_NAME VARCHAR No
The category ID of the reviewer's determination. For "other" reviews only.
May contain organization-specific values: No
Category Entries:
Satisfactory
Unsatisfactory
Other
4 SEC_NECESSITY_DETERM_C_NAME VARCHAR No
The category ID of the reviewer's determination of how necessary a procedure is. For medical necessity reviews only.
May contain organization-specific values: No
Category Entries:
Necessary
Unnecessary
Other
5 SEC_LOS_DETERM_C_NAME VARCHAR No
The category ID of the reviewer's determination of the patient's length of stay. For length of stay reviews only.
May contain organization-specific values: No
Category Entries:
Stay Appropriate
Shorter Stay Appropriate
Longer Stay Appropriate
Stay Unnecessary
Other
6 SEC_DISCHARGE_DETERM_C_NAME VARCHAR No
The category ID of the reviewer's determination of the patient's readiness for discharge. For discharge reviews only.
May contain organization-specific values: No
Category Entries:
Ready for Discharge
Not Ready for Discharge
Other
7 SEC_SUG_ACUTE_LEVEL_OF_CARE_C_NAME VARCHAR No
The category ID of the acute level of care suggested in the secondary review request. Used in acute level of care reviews only.
May contain organization-specific values: Yes
8 SEC_SUG_POST_ACUTE_CLASS_C_NAME VARCHAR No
The category ID of the post-acute class suggested in the secondary review request. 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
9 SEC_SUG_ACUITY_LEVEL_C_NAME VARCHAR No
The category ID of the acuity level suggested in the secondary review request. Used in acuity level reviews only.
May contain organization-specific values: Yes
10 SEC_REC_ACUTE_LEVEL_OF_CARE_C_NAME VARCHAR No
The category ID of the patient's acute level of care recommended by the secondary reviewer. Used in acute level of care reviews only.
The category values for this column were already listed for column: SEC_SUG_ACUTE_LEVEL_OF_CARE_C_NAME
11 SEC_REC_POST_ACUTE_CLASS_C_NAME VARCHAR No
The category ID of the patient's post-acute class recommended by the secondary reviewer. Used in post-acute level of care reviews only.
The category values for this column were already listed for column: SEC_SUG_POST_ACUTE_CLASS_C_NAME
12 SEC_REC_ACUITY_LEVEL_C_NAME VARCHAR No
The category ID of the patient's acuity level recommended by the secondary reviewer. Used in acuity level reviews only.
The category values for this column were already listed for column: SEC_SUG_ACUITY_LEVEL_C_NAME
13 SEC_SUG_BASE_CLASS_C_NAME VARCHAR No
The category ID of the base patient class suggested in the secondary review request. Used in patient class reviews only.
May contain organization-specific values: No
Category Entries:
Direct
Inpatient
Outpatient
Emergency
Observation
14 SEC_REC_BASE_CLASS_C_NAME VARCHAR No
The category ID of the base patient class recommended by the secondary reviewer. Used in patient class reviews only.
The category values for this column were already listed for column: SEC_SUG_BASE_CLASS_C_NAME