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