COD_CONTACT_INFO

Description:

The table COD_CONTACT_INFO contains information about coding records (records in the COD master file). A row in this table contains information about each individual contact for coding records. Coding records store information from Clinical Documentation Improvement (CDI) reviews. A single coding record is created for the hospital account, with each contact (or row) containing information from a separate CDI review of the account.

Primary Key

Column Name	Ordinal Position
CONTACT_SERIAL_NUM	1

Column Information

	Name	Type	Discontinued?
1	CODING_RECORD_ID	NUMERIC	No
	The unique identifier for the coding record.
2	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
3	CONTACT_SERIAL_NUM	NUMERIC	No
	The contact serial number (CSN) of the contact.
4	CONTACT_NUM	INTEGER	No
	The contact number of the contact.
5	CNCT_TYPE_C_NAME	VARCHAR	No
	The contact type of the contact. May contain organization-specific values: No Category Entries: Record Creation CDI Working Review CDI Baseline Review CDI Forecast Review
6	CDI_USER_ID	VARCHAR	No
	The user ID of the clinical documentation improvement (CDI) specialist who performed the CDI review.
7	CDI_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	CDI_NEXT_REVIEW_DT	DATETIME	No
	The next review date for a clinical documentation improvement (CDI) review.
9	CDI_PX_CODE_SET_C_NAME	VARCHAR	No
	The procedure code set in a clinical documentation improvement (CDI) review. May contain organization-specific values: Yes Category Entries: ICD-9-CM Volume 3 ICD-10-PCS OPCS-4 A&E Investigation/Treatment
10	CDI_DX_CODE_SET_C_NAME	VARCHAR	No
	The diagnosis code set in a clinical documentation improvement (CDI) review. May contain organization-specific values: Yes Category Entries: ICD-9-CM ICD-10-CM ICD-10-CA ICD-10-UK DBC ICD-10 Dutch ICD-10-AM A&E Diagnoses SKS ICD-10-THL ICPC-2 ICD-O-3 ICD-10-GM ICD-9-CM Supplemental ICD-10-BE ICD-10-NO Apache DSM-5 KinCor ORPHA
11	CONTACT_STAT_C_NAME	VARCHAR	No
	This item stores the current status of a contact on the coding record. May contain organization-specific values: Yes Category Entries: Active Restored Combined Deleted
12	CDI_REVIEW_LOC_DTTM	DATETIME (Attached)	No
	The date and time that a clinical documentation improvement (CDI) review took place, relative to the timezone of the location in which the review took place.
13	LINKED_QUERY_ID	NUMERIC	No
	This column is reserved for future development.
14	SOURCE_CSN_ID	NUMERIC	No
	This item contains the contact serial number from the source coding record associated with this coding contact. This item is set when a coding contact is merged from another coding record.