CDI_STAT_HX

Description:

This table contains information about the status and assigned user change history for the Clinical Documentation Improvement (CDI) reviews in a hospital account.

Primary Key

Column Name	Ordinal Position
CODING_RECORD_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CODING_RECORD_ID	NUMERIC	No
	The unique identifier of the coding record associated with the hospital account.
2	LINE	INTEGER	No
	The line number for the information associated with this account. Each line represents a change in clinical documentation improvement (CDI) status or assigned user.
3	CDI_HX_ASGN_USER_ID	VARCHAR	No
	This item stores what the clinical documentation improvement (CDI) assigned user is changed to for this account.
4	CDI_HX_ASGN_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	CDI_HX_STAT_C_NAME	VARCHAR	No
	This item stores the clinical documentation improvement (CDI) status changes for this account. May contain organization-specific values: Yes Category Entries: Not Started In Progress Physician Query All Reviews Completed
6	CDI_HX_CHNG_USER_ID	VARCHAR	No
	This item stores the user who makes the change of clinical documentation improvement (CDI) assigned user or status for this account.
7	CDI_HX_CHNG_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	CDI_HX_CHNG_UTC_DTTM	DATETIME (UTC)	No
	This item stores the instant when the clinical documentation improvement (CDI) status or assigned user was changed based on the UTC timezone. Data retrieval should generally occur by using the column CDI_HX_CHG_DTTM, which will return the change instant in local time.
9	CDI_HX_CHNG_DTTM	DATETIME (Local)	No
	This item shows the instant when the clinical documentation improvement (CDI) status or assigned user was changed based on the system local timezone.
10	CDI_HX_CHNG_CMT	VARCHAR	No
	The comment associated with the status change in the clinical documentation improvement (CDI) status history.