Intermediate Table

Cohort Builder Intermediate Tables –

Cohort Analytics Data – This is the main table that gets written back whenever we run a cohort. Below is the screenshot of the table –

Fields/Columns present in the Cohort Analytics Data –

• PATIENT_ID – Unique patient key identifier.

• Index_Date – Index_date is the minimum of all the activity dates for a patient in that data time period after applying all the business rules.

• Age – Age of the patient with respect to the period of study.

• Gender – Gender

• Code – Would include Diagnosis/Treatment/Procedure codes as per the events the patient has gone through in that data time period.

• Code_Type – Code type based on the event. (Diagnosis – ICD-9/ICD-10, Treatment – NDC, Procedure – CPT4/HCPCS/ICD9Proc/ICD10Proc)

• Data_Source – Data source that you are running your Cohort on.

• Data_Set – Based on the place of service information and data source we get Data_set information which includes – Facility/Inpatient/Professional/Pharmacy setting.

• Days_Supply – Days of supply as per the Rx filled for each NDC code.

• HCP_Name – Name of the HCP/Provider.

• Payer_Type – Type of plan the patient is currently opted for. (Commercial/Government/Medicare/Medicaid/Cash/Others)

• Address - Current address of the HCP

• City – Current city of the HCP where he’s based out of.

• State – State of the HCP where he’s based out of.

• HCP_ZIP – Zip code of the area where HCP is based out of.

• Specialty_Code – Specialty of the HCP

• Specialty_Desc – Overall description of the specialty of the HCP.

• Specialty_Group – Same as Specialty description

• Provider_Type – Type of provider be it rendering/referring/others etc.

• Org_Name – Organisation/Account information where the HCP is practising.

• NPI_Number – Unique identification of the HCP.

• Code_Flag – Dx/Rx/Px

• Source – Dx/PRESCRIPTIONS/PROCEDURE

• TRINITYGROUP1 – Identifies the main event – Diagnosis/Treatment/Procedure/Custom Comorbidity

• TRINITYGROUP2 – These are user defined values & specifies the Drug name/Procedure name/Diagnosis condition.

• TRINITYGROUP3 – Either blank or either contains the class of drugs at an overall level

• TRINITYGROUP4 - Either blank or either contains the class of drugs at an overall level

• DPM_FLAG – Flag to identify whether the code corresponding to that record is present in DPM file or not.

• NEW_TRINITYGROUP_1 – Specifies the main event of that record – DIAGNOSIS/PRESCRIPTIONS

• AGE_RANGE – Age bracket in which the patient is included.

• YEAR_MONTH_ACTIVITY_DATE – Year & month information of the activity date.

• YEAR_ACTIVITY_DATE – Year of the activity date.

• QUARTER_ACTIVITY_YEAR – Quarter of the activity date

• YEAR_MONTH_INDEX_DATE - Year & month information of the index date.

• QUARTER_INDEX_DATE – Quarter of the index date.

• YEAR_INDEX_DATE – Year of the index date.

• PATIENT_STATE – State where the patient is residing.

• PATIENT_DIVISION – Division where the patient is residing.

• PATIENT_REGION – Region where the patient is residing.

• P_DATA_SOURCE – Data Source on which the cohort ran.

• CODE_FLAG_DESC – Event description - Diagnosis/Procedure/Treatment

• VISIT_ID – A unique calculated field identifying each visit/activity for a patient.

• Provider_Flag – It is used to identify provider specific information. For symphony it is hard-coded “1”. For CMS/Marketscan its calculated based on the specialty code range.

• Sub_Cohort_Group – It is to identify the patients who are a part of different subgroups as part of our analysis.

• Patient_Treatment_Flag – Diagnosis/Treatment/Diagnosis+Treatment