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 Auto-Suggested Review
Simple Visit Coding
Health Plan Coding Review
Health Plan Coding Agents Suggestion
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.
29 HEALTH_PLAN_TASK_ID VARCHAR No
The task being performed when this contact was created.
30 LATEST_DOCUMENT_CSN_ID NUMERIC No
The latest DXR contact that was available for the associated encounter when this record was coded.
31 LATEST_CLAIM_ID NUMERIC No
The ID of the latest claim in the adjustment sequence available for the associated original claim when this contact was coded. If the claim had never been adjusted at the point that this contact was coded, then this will be the original claim.
32 CDI_START_USER_ID VARCHAR No
This item stores the user ID of the CDI specialist who started the CDI review. This will only be different from item 600 (CDI User) when the start user pends a review and a seperate user later finishes the review.
33 CDI_START_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
34 UNLINKED_VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
35 UNLINK_TYPE_OF_BILL VARCHAR No
The type of bill that is associated with the coding session
36 UNLINK_CRR_FORMAT_C_NAME VARCHAR No
The electronic claim format (CMS or UB) to use for the associated chart review.
May contain organization-specific values: No
Category Entries:
CMS
UB