Skip to content

Get Started With Codeset

The Codeset application is designed to streamline, store, and share DPMs. In this application, you can search for diagnosis, procedure, and drug codes leveraging OMOP, Symphony, and Redbook reference data and to import codes directly into a DPM.

To begin, we need to create a DPM file consisting of information such as Treatment, Diagnosis & Procedure codes along with description, the vocabulary type & Group information as per the requirement of your analysis.

There are two ways by which the DPM file can be created.

  1. Use the "Search Codes" functionality in Codeset to search and add the codes in your market basket. Once all codes are added, the created DPM file can be downloaded. (Documentation)
  2. Create an Excel sheet in your own system manually and use the upload feature to upload these codes to Codeset. (Documentation)

Once created, it will look something like the below example (codes will change based on your requirements):

screenshot1

What data should be added to Codeset columns?

The current version of Codeset supports a maximum of 9 columns in the same order as - ‘Code', 'CodeDesc', 'CodeType', 'TrinityGroup1', 'TrinityGroup2', 'TrinityGroup3', 'TrinityGroup4', 'Cohort' and 'LoT_Treatment’. Below are more details about these columns.

Code

Field for recording the medical code. These can be diagnosis, procedures, treatment etc. codes designed by medical professionals to streamline and standardize medical records.

CodeDesc

Description of the standard codes identified in the “Code” field.

CodeType

Codes can be categorized in any of the options below. Note that the field is limited to drop down options within the cell. Standardization of this field is important to standard coding procedures so limiting the definitions to the drop-down options is imperative.

  1. Diagnosis - ICD-9: International Classification of Diseases version 9 for disease diagnosis. Valid for diagnosis classification prior to October 2015.
  2. Diagnosis - ICD-10: International Classification of Diseases version 10 for disease diagnosis. Valid for diagnosis classification post October 2015.
  3. Procedure - ICD-9: International Classification of Diseases version 9 for procedure identification. Valid for procedure classification prior to October 2015.
  4. Procedure - ICD-10: International Classification of Diseases version 10 for procedure identification. Valid for procedure classification post October 2015.
  5. CPT_HCPCS: Current Procedural Terminology (CPT) for coding medical services and procedures to streamline reporting, increase accuracy and efficiency. The Healthcare Common Procedure Coding System (HCPCS) is a collection of codes that represent procedures, supplies, products and services. HCPCS codes are for basic healthcare services like medical devices, medical supplies, etc. These codes provide a standardized description of the services. CPT codes are for services like surgeries, diagnostic tests, evaluation and management services (E&M), etc
  6. NDC: National Drug Code (NDC) is a unique product identifier used in the United States for drugs intended for human use. The code is comprised of 11 digits, three-segment number (5-4-2) that encodes information on the labeler, product, and package size. FDA publishes the listed NDC numbers in the NDC Directory which is updated daily.

TrinityGroup1-4

Trinity developed grouping to help categorize diagnosis, procedures, or treatment codes depending on analysis needs. The rule of thumb is that groupings should increase in specificity going from TrinityGroup1 to TrinityGroup4. For example, TrinityGroup1 should differentiate diagnosis vs. treatment vs. procedure codes. TrinityGroup2 can add additional specificity such as disease name, treatment class, TrinityGroup3 for diagnosis subgroups, treatment names etc. While there are no imposed rules for the use of Trinity Groups, they should be leveraged to establish a hierarchy between groups of codes as it pertains to the analysis. Possible classifications can include molecule, brand, generic, product name, class names, route of administration etc.

Cohort

It is the highest level of aggregation of codes. This field should be filled with numbers starting with 0,1,2 etc. depending on analytical needs. Codes tagged as “Cohort” 1 is reserved for the codes that will be leveraged to extract the study population. Cohort tags 0,2,3 etc. are used as subsets to describe patients identified as Cohort 1. For Real World Edge MTL and Patient Counts applications, the Cohort column is still used to define codes of interest for cohort identification. Make sure the Cohort column is correctly marking the codes you want to use for cohort identification. Therefore, assign a 1 to codes of interest for those modules.

Below columns are pre-populated when users add codes to the Codeset using "Search Codes" functionality:

LoT_Treatment

This is a flag that identifies treatment codes to be included in the automated line of therapy products developed internally by Trinity. This field is binary 1 for codes included in the analysis, 0 for codes not included in the analyses such as diagnoses codes.