CRITERIA_REVIEW_HX

Description:

This table contains history about guideline reviews. The records included in this table are Criteria Review Records (CRR) records.

Primary Key

Column Name	Ordinal Position
CRITERIA_REVIEW_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CRITERIA_REVIEW_ID	NUMERIC	No
	The unique identifier (.1 item) for the review record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	HX_UPDATE_DTTM	DATETIME (Local)	No
	Stores history of update instants in local time zone.
4	HX_UPDATE_USER_ID	VARCHAR	No
	Stores history of update reviewers.
5	HX_UPDATE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	HX_UPDATE_SOURCE_C_NAME	VARCHAR	No
	Stores history of update sources. May contain organization-specific values: No Category Entries: Utilization Management Provider
7	HX_CRITERIA_STATUS_C_NAME	VARCHAR	No
	Stores history of guideline status. May contain organization-specific values: No Category Entries: Not Met Met In Progress Completed Acute Met Critical Met Observation Met Alternate Met Intermediate Met Not Applicable Neonatal Intensive Care Level III Met Special Care Level II Met Newborn Level I Met Transitional Care Met Neonatal Intensive Care Level IV Met Variance Partially Met Ambulatory Detoxification Met Home Care Met Inpatient Met Inpatient Detoxification Met Intensive Community-Based Treatment Met Intensive Outpatient Program Met Outpatient Met Partial Hospital Program Met Subacute Care Met Residential Crisis Program Met Residential Treatment Center Met Supervised Living Met Inpatient Rehabilitation Met Not Met (Not Selected) Not Met (Selected) Met (Not Selected) Met (Selected) Level I Met Level II Met Level III Met Subacute Met Hospital in the Home Met Day Treatment Program Met Neutral Skilled Nursing Facility Met Behavioral Health Observation Met SNF Met Supplemental Medicare Criteria Met
8	HX_REVIEW_STATUS_C_NAME	VARCHAR	No
	Stores history of review completion status. May contain organization-specific values: No Category Entries: Pending Primary In Primary Pending Secondary Pending Secondary-Medical Pending Appeal Completed In Progress Waiting For Info Primary Completed Secondary Completed Deleted
9	HX_UPDATE_UTC_DTTM	DATETIME (UTC)	No
	Stores history of update instants in UTC time zone.
10	HX_NOTE_ID	VARCHAR	No
	Stores history of associated notes.