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
Smart Code Capture
Health Plan Coding Review
Health Plan Coding Agents Suggestion
Coding Over Time
Coding Assistant
Auto Coding Result
Auto Coding Exploratory
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
MONDO
EPD Short List
Preferred Ancillary Code Sets
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 COD_CAP_ACCT_TYPE_C_NAME VARCHAR No
The Smart Code Capture account type.
May contain organization-specific values: No
Category Entries:
Emergency
Surgery
General
Diagnostic
Lab
Inpatient
Recurring Series Parent
Recurring Series Child
35 UNLINKED_VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
36 UNLINK_TYPE_OF_BILL VARCHAR No
The type of bill that is associated with the coding session
37 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
38 CDI_REVIEW_PAT_ENC_CSN_ID NUMERIC No
The encounter the CDI review was documented in. If the review was done in the chart (not in an encounter) this item will not be populated.
39 AC_IS_PAT_PREGNANT_YN VARCHAR No
Determines whether the patient is pregnant on the encounter being coded.
May contain organization-specific values: No
Category Entries:
No
Yes
40 AC_ACCT_BASECLS_HA_C_NAME NUMERIC No
Contains the account base class for the account being coded.
May contain organization-specific values: No
Category Entries:
Inpatient
Outpatient
Emergency
41 AC_FINANCIAL_CLASS_C_NAME VARCHAR No
Contains the account financial class for the account being coded.
May contain organization-specific values: Yes
Category Entries:
Commercial
Medicare
Medicaid
Self-Pay
Worker's Comp
Tricare
Champva
Group Health Plan
FECA Black Lung
Blue Shield
Medigap
Other
DK Regional
Client
Received Self-Pay
Sent to Consolidated Self-Pay
Patient Assistance Program
42 AC_REV_SPEC_GROUPER_ID_GROUPER_NAME VARCHAR No
Record name
43 AC_GESTATIONAL_AGE VARCHAR No
Stores the patient's gestational age in weeks as of discharge date or today if the patient was pregnant on the encounter being coded. The value is stored as a string and will not be stored if the calculated value is out of bounds.
44 AC_CODING_EFF_DATE DATETIME No
Stores the coding effective date used to determine whether specific codes can be used.
45 AC_EXECUTION_RUN VARCHAR No
Stores the execution id from the code list synthesis run. The execution id can be used to look up the relevant LLM record using I LLM 2000.
46 EXT_RESULT_SOURCE_C_NAME NUMERIC No
Indicates the coding results for this coding session are from an external source, not from internal review.
May contain organization-specific values: No
Category Entries:
External Chart Review File