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
Simple Visit Coding
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
ACHI
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
SNOMED CT
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.
15 ADMIT_DATETIME_UTC_DTTM DATETIME (UTC) No
The admission date associated with the hospital account's primary encounter.
16 DISCHARGE_DATETIME_UTC_DTTM DATETIME (UTC) No
The discharge instant associated with the hospital account's primary encounter.
17 ADMIT_CATEGORY_C_NAME VARCHAR No
The admission category for the patient.
May contain organization-specific values: Yes
18 TRANSFER_FROM_C_NAME VARCHAR No
The transfer source of the patient.
May contain organization-specific values: Yes
19 DISCH_DEST_C_NAME VARCHAR No
The discharge destination for the patient.
May contain organization-specific values: Yes
20 HOSP_ADMSN_TYPE_C_NAME VARCHAR No
The admission type for the patient.
May contain organization-specific values: Yes
21 ADMIT_SOURCE_C_NAME VARCHAR No
The point of origin for the patient.
May contain organization-specific values: Yes
22 DISCH_DISP_C_NAME VARCHAR No
The discharge disposition of the patient.
May contain organization-specific values: Yes
23 MEANS_OF_ARRV_C_NAME VARCHAR No
The means of arrival for the patient.
May contain organization-specific values: Yes
24 PRIMARY_HOSP_SERV_C_NAME VARCHAR No
The primary service for the patient.
May contain organization-specific values: Yes
25 SECONDARY_HOSP_SERV_C_NAME VARCHAR No
The secondary service of the patient.
The category values for this column were already listed for column: PRIMARY_HOSP_SERV_C_NAME
26 ADMITTING_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.
27 ATTENDING_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.
28 REFFERING_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.