HSP_ACCT_CDI_QUERY

Description:

This table stores the queries sent to physicians as part of the Clinical Documentation Improvement (CDI) process.

Primary Key

Column Name	Ordinal Position
ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ACCT_ID	NUMERIC	No
	The unique identifier for the hospital account 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	CDI_QUERY_TYPE_C_NAME	VARCHAR	No
	Stores the type of the query sent to the provider. May contain organization-specific values: Yes No Entries Defined
4	CDI_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
5	CDI_QUERY_RESP_YN	VARCHAR	No
	Indicates whether a response was received from the provider for the clinical documentation improvement (CDI) query. May contain organization-specific values: No Category Entries: Yes No
6	CDI_DRG_CHNG_RSN_C_NAME	VARCHAR	No
	Stores the reason for the DRG change caused by the query. May contain organization-specific values: Yes No Entries Defined