B Oracle Health Sciences Cohort Explorer Presentation Catalog

The OHSCE Presentation Catalog displays columns that you can use to create requests.

This appendix contains the following topics:

• Dimensions in the Oracle Health Sciences Cohort Explorer Presentation Catalog

• Facts in the Oracle Health Sciences Cohort Explorer Presentation Catalog

• Measures in the Oracle Health Sciences Cohort Explorer Presentation Catalog

See Also:

Chapter 3, Working with Analyses

Dimensions in the Oracle Health Sciences Cohort Explorer Presentation Catalog

Table B-1 describes the Dimensions displayed in the OHSCE Presentation Catalog. For each column, it shows the name of the Column, its description, and the Dimension containing the column. The table is sorted by Dimension, and by Column within Dimension. This corresponds to how the Dimension columns are organized in the Presentation Catalog. Each Dimension column has an ID number, which is provided for cross-reference to other tables in this appendix.

Table B-1 Presentation Catalog - Dimensions

ID	Dimension	Column	Description
TRC-D01-C01	Diagnosis	Diagnosis Code	Code for Diagnosis (For example, ICD-9 or ICD-10 coding system)
TRC-D01-C01-A01	Diagnosis 1	Diagnosis Code 1	Code for Diagnosis (For example, ICD-9 or ICD-10 coding system) - alias for OBIEE
TRC-D01-C01-A02	Diagnosis 2	Diagnosis Code 2	Code for Diagnosis (For example, ICD-9 or ICD-10 coding system) - alias for OBIEE
TRC-D01-C01-A03	Diagnosis 3	Diagnosis Code 3	Code for Diagnosis (For example, ICD-9 or ICD-10 coding system) - alias for OBIEE
TRC-D01-C01-A04	Diagnosis 4	Diagnosis Code 4	Code for Diagnosis (For example, ICD-9 or ICD-10 coding system) - alias for OBIEE
TRC-D01-C02	Diagnosis	Diagnosis Name	Name for Diagnosis corresponding to Diagnosis Code (For example, Lung Cancer)
TRC-D01-C02-A01	Diagnosis 1	Diagnosis Name 1	Name for Diagnosis corresponding to Diagnosis Code 1 (For example, Lung Cancer) alias for OBIEE
TRC-D01-C02-A02	Diagnosis 2	Diagnosis Name 2	Name for Diagnosis corresponding to Diagnosis Code 2 (For example, Lung Cancer) alias for OBIEE
TRC-D01-C02-A03	Diagnosis 3	Diagnosis Name 3	Name for Diagnosis corresponding to Diagnosis Code 3 (For example, Lung Cancer) alias for OBIEE
TRC-D01-C02-A04	Diagnosis 4	Diagnosis Name 4	Name for Diagnosis corresponding to Diagnosis Code 4 (For example, Lung Cancer) alias for OBIEE
TRC-D01-C03	Diagnosis	Diagnosis Description	Description for Diagnosis corresponding to Diagnosis Code (For example, Lung Cancer)
TRC-D01-C03-A01	Diagnosis 1	Diagnosis Description 1	Description for Diagnosis corresponding to Diagnosis Code 1 (For example, Lung Cancer) alias for OBIEE
TRC-D01-C03-A02	Diagnosis 2	Diagnosis Description 2	Description for Diagnosis corresponding to Diagnosis Code 2 (For example, Lung Cancer) alias for OBIEE
TRC-D01-C03-A03	Diagnosis 3	Diagnosis Description 3	Description for Diagnosis corresponding to Diagnosis Code 3 (For example, Lung Cancer) alias for OBIEE
TRC-D01-C03-A04	Diagnosis 4	Diagnosis Description 4	Description for Diagnosis corresponding to Diagnosis Code 4 (For example, Lung Cancer) alias for OBIEE
TRC-D01-C04	Diagnosis	Onset Date	Onset Date corresponding to Diagnosis Code - when the patient said he remembers having symptoms
TRC-D01-C04-A01	Diagnosis 1	Onset Date 1	Onset Date corresponding to Diagnosis Code 1
TRC-D01-C04-A02	Diagnosis 2	Onset Date 2	Onset Date corresponding to Diagnosis Code 2
TRC-D01-C04-A03	Diagnosis 3	Onset Date 3	Onset Date corresponding to Diagnosis Code 3
TRC-D01-C04-A04	Diagnosis 4	Onset Date 4	Onset Date corresponding to Diagnosis Code 4
TRC-D01-C05	Diagnosis	Reported Date	Date patient was diagnosed corresponding to Diagnosis Code
TRC-D01-C05-A01	Diagnosis 1	Reported Date 1	Date patient was diagnosed corresponding to Diagnosis Code 1
TRC-D01-C05-A02	Diagnosis 2	Reported Date 2	Date patient was diagnosed corresponding to Diagnosis Code 2
TRC-D01-C05-A03	Diagnosis 3	Reported Date 3	Date patient was diagnosed corresponding to Diagnosis Code 3
TRC-D01-C05-A04	Diagnosis 4	Reported Date 4	Date patient was diagnosed corresponding to Diagnosis Code 4
TRC-D01-C06	Diagnosis	End Date	Date disease was reported as in remission corresponding to Diagnosis Code
TRC-D01-C06-A01	Diagnosis 1	End Date 1	Date disease was reported as in remission corresponding to Diagnosis Code 1
TRC-D01-C06-A02	Diagnosis 2	End Date 2	Date disease was reported as in remission corresponding to Diagnosis Code 2
TRC-D01-C06-A03	Diagnosis 3	End Date 3	Date disease was reported as in remission corresponding to Diagnosis Code 3
TRC-D01-C06-A04	Diagnosis 4	End Date 4	Date disease was reported as in remission corresponding to Diagnosis Code 4
TRC-D01-C07	Diagnosis	Diagnosis Status Code	Diagnosis Status Code corresponding to Diagnosis Code
TRC-D01-C07-A01	Diagnosis 1	Diagnosis Status Code 1	Diagnosis Status Code corresponding to Diagnosis Code 1
TRC-D01-C07-A02	Diagnosis 2	Diagnosis Status Code 2	Diagnosis Status Code corresponding to Diagnosis Code 2
TRC-D01-C07-A03	Diagnosis 3	Diagnosis Status Code 3	Diagnosis Status Code corresponding to Diagnosis Code 3
TRC-D01-C07-A04	Diagnosis 4	Diagnosis Status Code 4	Diagnosis Status Code corresponding to Diagnosis Code 4
TRC-D01-C08	Diagnosis	Diagnosis Status Name	Diagnosis Status Name corresponding to Diagnosis Code
TRC-D01-C08-A01	Diagnosis 1	Diagnosis Status Name 1	Diagnosis Status Name corresponding to Diagnosis Code 1
TRC-D01-C08-A02	Diagnosis 2	Diagnosis Status Name 2	Diagnosis Status Name corresponding to Diagnosis Code 2
TRC-D01-C08-A03	Diagnosis 3	Diagnosis Status Name 3	Diagnosis Status Name corresponding to Diagnosis Code 3
TRC-D01-C08-A04	Diagnosis 4	Diagnosis Status Name 4	Diagnosis Status Name corresponding to Diagnosis Code 4
TRC-D01-C09	Diagnosis	Diagnosis Status Description	Diagnosis Status Description corresponding to Diagnosis Code
TRC-D01-C09-A01	Diagnosis 1	Diagnosis Status Description 1	Diagnosis Status Description corresponding to Diagnosis Code 1
TRC-D01-C09-A02	Diagnosis 2	Diagnosis Status Description 2	Diagnosis Status Description corresponding to Diagnosis Code 2
TRC-D01-C09-A03	Diagnosis 3	Diagnosis Status Description 3	Diagnosis Status Description corresponding to Diagnosis Code 3
TRC-D01-C09-A04	Diagnosis 4	Diagnosis Status Description 4	Diagnosis Status Description corresponding to Diagnosis Code 4
TRC-D01-C10	Diagnosis	Age at First Onset (in Years)	Age at First Onset of Diagnosis corresponding to Diagnosis Code
TRC-D01-C10-A01	Diagnosis 1	Age at First Onset 1 (in Years)	Age at First Onset of Diagnosis corresponding to Diagnosis Code 1
TRC-D01-C11	Diagnosis	Anatomical Site Code	Anatomical Site Code corresponding to Diagnosis Code
TRC-D01-C11-A01	Diagnosis 1	Anatomical Site Code 1	Anatomical Site Code corresponding to Diagnosis Code 1
TRC-D01-C11-A02	Diagnosis 2	Anatomical Site Code 2	Anatomical Site Code corresponding to Diagnosis Code 2
TRC-D01-C11-A03	Diagnosis 3	Anatomical Site Code 3	Anatomical Site Code corresponding to Diagnosis Code 3
TRC-D01-C11-A04	Diagnosis 4	Anatomical Site Code 4	Anatomical Site Code corresponding to Diagnosis Code 4
TRC-D01-C12	Diagnosis	Anatomical Site Name	Anatomical Site Name corresponding to Diagnosis Code
TRC-D01-C12-A01	Diagnosis 1	Anatomical Site Name 1	Anatomical Site Name corresponding to Diagnosis Code 1
TRC-D01-C12-A02	Diagnosis 2	Anatomical Site Name 2	Anatomical Site Name corresponding to Diagnosis Code 2
TRC-D01-C12-A03	Diagnosis 3	Anatomical Site Name 3	Anatomical Site Name corresponding to Diagnosis Code 3
TRC-D01-C12-A04	Diagnosis 4	Anatomical Site Name 4	Anatomical Site Name corresponding to Diagnosis Code 4
TRC-D01-C13	Diagnosis	Anatomical Site Description	Anatomical Site Description corresponding to Diagnosis Code
TRC-D01-C13-A01	Diagnosis 1	Anatomical Site Description 1	Anatomical Site Description corresponding to Diagnosis Code 1
TRC-D01-C13-A02	Diagnosis 2	Anatomical Site Description 2	Anatomical Site Description corresponding to Diagnosis Code 2
TRC-D01-C13-A03	Diagnosis 3	Anatomical Site Description 3	Anatomical Site Description corresponding to Diagnosis Code 3
TRC-D01-C13-A04	Diagnosis 4	Anatomical Site Description 4	Anatomical Site Description corresponding to Diagnosis Code 4
TRC-D01-C14	Diagnosis	Diagnosis Level 1 Code	Diagnosis Level 1 Code corresponding to Diagnosis
TRC-D01-C14-A01	Diagnosis 1	Diagnosis Level 1 Code	Diagnosis Level 1 Code corresponding to Diagnosis
TRC-D01-C14-A02	Diagnosis 2	Diagnosis Level 1 Code	Diagnosis Level 1 Code corresponding to Diagnosis
TRC-D01-C14-A03	Diagnosis 3	Diagnosis Level 1 Code	Diagnosis Level 1 Code corresponding to Diagnosis
TRC-D01-C14-A04	Diagnosis 4	Diagnosis Level 1 Code	Diagnosis Level 1 Code corresponding to Diagnosis
TRC-D01-C15	Diagnosis	Diagnosis Level 1 Name	Diagnosis Level 1 Name corresponding to Diagnosis
TRC-D01-C15-A01	Diagnosis 1	Diagnosis Level 1 Name	Diagnosis Level 1 Name corresponding to Diagnosis
TRC-D01-C15-A02	Diagnosis 2	Diagnosis Level 1 Name	Diagnosis Level 1 Name corresponding to Diagnosis
TRC-D01-C15-A03	Diagnosis 3	Diagnosis Level 1 Name	Diagnosis Level 1 Name corresponding to Diagnosis
TRC-D01-C15-A04	Diagnosis 4	Diagnosis Level 1 Name	Diagnosis Level 1 Name corresponding to Diagnosis
TRC-D01-C16	Diagnosis	Diagnosis Level 1 Description	Diagnosis Level 1 Description corresponding to Diagnosis
TRC-D01-C16-A01	Diagnosis 1	Diagnosis Level 1 Description	Diagnosis Level 1 Description corresponding to Diagnosis
TRC-D01-C16-A02	Diagnosis 2	Diagnosis Level 1 Description	Diagnosis Level 1 Description corresponding to Diagnosis
TRC-D01-C16-A03	Diagnosis 3	Diagnosis Level 1 Description	Diagnosis Level 1 Description corresponding to Diagnosis
TRC-D01-C16-A04	Diagnosis 4	Diagnosis Level 1 Description	Diagnosis Level 1 Description corresponding to Diagnosis
TRC-D01-C17	Diagnosis	Diagnosis Level 2 Code	Diagnosis Level 2 Code corresponding to Diagnosis
TRC-D01-C17-A01	Diagnosis 1	Diagnosis Level 2 Code	Diagnosis Level 2 Code corresponding to Diagnosis
TRC-D01-C17-A02	Diagnosis 2	Diagnosis Level 2 Code	Diagnosis Level 2 Code corresponding to Diagnosis
TRC-D01-C17-A03	Diagnosis 3	Diagnosis Level 2 Code	Diagnosis Level 2 Code corresponding to Diagnosis
TRC-D01-C17-A04	Diagnosis 4	Diagnosis Level 2 Code	Diagnosis Level 2 Code corresponding to Diagnosis
TRC-D01-C18	Diagnosis	Diagnosis Level 2 Name	Diagnosis Level 2 Name corresponding to Diagnosis
TRC-D01-C18-A01	Diagnosis 1	Diagnosis Level 2 Name	Diagnosis Level 2 Name corresponding to Diagnosis
TRC-D01-C18-A02	Diagnosis 2	Diagnosis Level 2 Name	Diagnosis Level 2 Name corresponding to Diagnosis
TRC-D01-C18-A03	Diagnosis 3	Diagnosis Level 2 Name	Diagnosis Level 2 Name corresponding to Diagnosis
TRC-D01-C18-A04	Diagnosis 4	Diagnosis Level 2 Name	Diagnosis Level 2 Name corresponding to Diagnosis
TRC-D01-C19	Diagnosis	Diagnosis Level 2 Description	Diagnosis Level 2 Description corresponding to Diagnosis
TRC-D01-C19-A01	Diagnosis 1	Diagnosis Level 2 Description	Diagnosis Level 2 Description corresponding to Diagnosis
TRC-D01-C19-A02	Diagnosis 2	Diagnosis Level 2 Description	Diagnosis Level 2 Description corresponding to Diagnosis
TRC-D01-C19-A03	Diagnosis 3	Diagnosis Level 2 Description	Diagnosis Level 2 Description corresponding to Diagnosis
TRC-D01-C19-A04	Diagnosis 4	Diagnosis Level 2 Description	Diagnosis Level 2 Description corresponding to Diagnosis
TRC-D01-C20	Diagnosis	Diagnosis Level 3 Code	Diagnosis Level 3 Code corresponding to Diagnosis
TRC-D01-C20-A01	Diagnosis 1	Diagnosis Level 3 Code	Diagnosis Level 3 Code corresponding to Diagnosis
TRC-D01-C20-A02	Diagnosis 2	Diagnosis Level 3 Code	Diagnosis Level 3 Code corresponding to Diagnosis
TRC-D01-C20-A03	Diagnosis 3	Diagnosis Level 3 Code	Diagnosis Level 3 Code corresponding to Diagnosis
TRC-D01-C20-A04	Diagnosis 4	Diagnosis Level 3 Code	Diagnosis Level 3 Code corresponding to Diagnosis
TRC-D01-C21	Diagnosis	Diagnosis Level 3 Name	Diagnosis Level 3 Name corresponding to Diagnosis
TRC-D01-C21-A01	Diagnosis 1	Diagnosis Level 3 Name	Diagnosis Level 3 Name corresponding to Diagnosis
TRC-D01-C21-A02	Diagnosis 2	Diagnosis Level 3 Name	Diagnosis Level 3 Name corresponding to Diagnosis
TRC-D01-C21-A03	Diagnosis 3	Diagnosis Level 3 Name	Diagnosis Level 3 Name corresponding to Diagnosis
TRC-D01-C21-A04	Diagnosis 4	Diagnosis Level 3 Name	Diagnosis Level 3 Name corresponding to Diagnosis
TRC-D01-C22	Diagnosis	Diagnosis Level 3 Description	Diagnosis Level 3 Description corresponding to Diagnosis
TRC-D01-C22-A01	Diagnosis 1	Diagnosis Level 3 Description	Diagnosis Level 3 Description corresponding to Diagnosis
TRC-D01-C22-A02	Diagnosis 2	Diagnosis Level 3 Description	Diagnosis Level 3 Description corresponding to Diagnosis
TRC-D01-C22-A03	Diagnosis 3	Diagnosis Level 3 Description	Diagnosis Level 3 Description corresponding to Diagnosis
TRC-D01-C22-A04	Diagnosis 4	Diagnosis Level 3 Description	Diagnosis Level 3 Description corresponding to Diagnosis
TRC-D01-C23	Diagnosis	Diagnosis Level 4 Code	Diagnosis Level 4 Code corresponding to Diagnosis
TRC-D01-C23-A01	Diagnosis 1	Diagnosis Level 4 Code	Diagnosis Level 4 Code corresponding to Diagnosis
TRC-D01-C23-A02	Diagnosis 2	Diagnosis Level 4 Code	Diagnosis Level 4 Code corresponding to Diagnosis
TRC-D01-C23-A03	Diagnosis 3	Diagnosis Level 4 Code	Diagnosis Level 4 Code corresponding to Diagnosis
TRC-D01-C23-A04	Diagnosis 4	Diagnosis Level 4 Code	Diagnosis Level 4 Code corresponding to Diagnosis
TRC-D01-C24	Diagnosis	Diagnosis Level 4 Name	Diagnosis Level 4 Name corresponding to Diagnosis
TRC-D01-C24-A01	Diagnosis 1	Diagnosis Level 4 Name	Diagnosis Level 4 Name corresponding to Diagnosis
TRC-D01-C24-A02	Diagnosis 2	Diagnosis Level 4 Name	Diagnosis Level 4 Name corresponding to Diagnosis
TRC-D01-C24-A03	Diagnosis 3	Diagnosis Level 4 Name	Diagnosis Level 4 Name corresponding to Diagnosis
TRC-D01-C24-A04	Diagnosis 4	Diagnosis Level 4 Name	Diagnosis Level 4 Name corresponding to Diagnosis
TRC-D01-C25	Diagnosis	Diagnosis Level 4 Description	Diagnosis Level 4 Description corresponding to Diagnosis
TRC-D01-C25-A01	Diagnosis 1	Diagnosis Level 4 Description	Diagnosis Level 4 Description corresponding to Diagnosis
TRC-D01-C25-A02	Diagnosis 2	Diagnosis Level 4 Description	Diagnosis Level 4 Description corresponding to Diagnosis
TRC-D01-C25-A03	Diagnosis 3	Diagnosis Level 4 Description	Diagnosis Level 4 Description corresponding to Diagnosis
TRC-D01-C25-A04	Diagnosis 4	Diagnosis Level 4 Description	Diagnosis Level 4 Description corresponding to Diagnosis
TRC-D01-C26	Diagnosis	Diagnosis Level 5 Code	Diagnosis Level 5 Code corresponding to Diagnosis
TRC-D01-C26-A01	Diagnosis 1	Diagnosis Level 5 Code	Diagnosis Level 5 Code corresponding to Diagnosis
TRC-D01-C26-A02	Diagnosis 2	Diagnosis Level 5 Code	Diagnosis Level 5 Code corresponding to Diagnosis
TRC-D01-C26-A03	Diagnosis 3	Diagnosis Level 5 Code	Diagnosis Level 5 Code corresponding to Diagnosis
TRC-D01-C26-A04	Diagnosis 4	Diagnosis Level 5 Code	Diagnosis Level 5 Code corresponding to Diagnosis
TRC-D01-C27	Diagnosis	Diagnosis Level 5 Name	Diagnosis Level 5 Name corresponding to Diagnosis
TRC-D01-C27-A01	Diagnosis 1	Diagnosis Level 5 Name	Diagnosis Level 5 Name corresponding to Diagnosis
TRC-D01-C27-A02	Diagnosis 2	Diagnosis Level 5 Name	Diagnosis Level 5 Name corresponding to Diagnosis
TRC-D01-C27-A03	Diagnosis 3	Diagnosis Level 5 Name	Diagnosis Level 5 Name corresponding to Diagnosis
TRC-D01-C27-A04	Diagnosis 4	Diagnosis Level 5 Name	Diagnosis Level 5 Name corresponding to Diagnosis
TRC-D01-C28	Diagnosis	Diagnosis Level 5 Description	Diagnosis Level 5 Description corresponding to Diagnosis
TRC-D01-C28-A01	Diagnosis 1	Diagnosis Level 5 Description	Diagnosis Level 5 Description corresponding to Diagnosis
TRC-D01-C28-A02	Diagnosis 2	Diagnosis Level 5 Description	Diagnosis Level 5 Description corresponding to Diagnosis
TRC-D01-C28-A03	Diagnosis 3	Diagnosis Level 5 Description	Diagnosis Level 5 Description corresponding to Diagnosis
TRC-D01-C28-A04	Diagnosis 4	Diagnosis Level 5 Description	Diagnosis Level 5 Description corresponding to Diagnosis
TRC-D01-C29	Diagnosis	Diagnosis Level 6 Code	Diagnosis Level 6 Code corresponding to Diagnosis
TRC-D01-C29-A01	Diagnosis 1	Diagnosis Level 6 Code	Diagnosis Level 6 Code corresponding to Diagnosis
TRC-D01-C29-A02	Diagnosis 2	Diagnosis Level 6 Code	Diagnosis Level 6 Code corresponding to Diagnosis
TRC-D01-C29-A03	Diagnosis 3	Diagnosis Level 6 Code	Diagnosis Level 6 Code corresponding to Diagnosis
TRC-D01-C29-A04	Diagnosis 4	Diagnosis Level 6 Code	Diagnosis Level 6 Code corresponding to Diagnosis
TRC-D01-C30	Diagnosis	Diagnosis Level 6 Name	Diagnosis Level 6 Name corresponding to Diagnosis
TRC-D01-C30-A01	Diagnosis 1	Diagnosis Level 6 Name	Diagnosis Level 6 Name corresponding to Diagnosis
TRC-D01-C30-A02	Diagnosis 2	Diagnosis Level 6 Name	Diagnosis Level 6 Name corresponding to Diagnosis
TRC-D01-C30-A03	Diagnosis 3	Diagnosis Level 6 Name	Diagnosis Level 6 Name corresponding to Diagnosis
TRC-D01-C30-A04	Diagnosis 4	Diagnosis Level 6 Name	Diagnosis Level 6 Name corresponding to Diagnosis
TRC-D01-C31	Diagnosis	Diagnosis Level 6 Description	Diagnosis Level 6 Description corresponding to Diagnosis
TRC-D01-C31-A01	Diagnosis 1	Diagnosis Level 6 Description	Diagnosis Level 6 Description corresponding to Diagnosis
TRC-D01-C31-A02	Diagnosis 2	Diagnosis Level 6 Description	Diagnosis Level 6 Description corresponding to Diagnosis
TRC-D01-C31-A03	Diagnosis 3	Diagnosis Level 6 Description	Diagnosis Level 6 Description corresponding to Diagnosis
TRC-D01-C31-A04	Diagnosis 4	Diagnosis Level 6 Description	Diagnosis Level 6 Description corresponding to Diagnosis
TRC-D01-C32	Diagnosis	Diagnosis Level 7 Code	Diagnosis Level 7 Code corresponding to Diagnosis
TRC-D01-C32-A01	Diagnosis 1	Diagnosis Level 7 Code	Diagnosis Level 7 Code corresponding to Diagnosis
TRC-D01-C32-A02	Diagnosis 2	Diagnosis Level 7 Code	Diagnosis Level 7 Code corresponding to Diagnosis
TRC-D01-C32-A03	Diagnosis 3	Diagnosis Level 7 Code	Diagnosis Level 7 Code corresponding to Diagnosis
TRC-D01-C32-A04	Diagnosis 4	Diagnosis Level 7 Code	Diagnosis Level 7 Code corresponding to Diagnosis
TRC-D01-C33	Diagnosis	Diagnosis Level 7 Name	Diagnosis Level 7 Name corresponding to Diagnosis
TRC-D01-C33-A01	Diagnosis 1	Diagnosis Level 7 Name	Diagnosis Level 7 Name corresponding to Diagnosis
TRC-D01-C33-A02	Diagnosis 2	Diagnosis Level 7 Name	Diagnosis Level 7 Name corresponding to Diagnosis
TRC-D01-C33-A03	Diagnosis 3	Diagnosis Level 7 Name	Diagnosis Level 7 Name corresponding to Diagnosis
TRC-D01-C33-A04	Diagnosis 4	Diagnosis Level 7 Name	Diagnosis Level 7 Name corresponding to Diagnosis
TRC-D01-C34	Diagnosis	Diagnosis Level 7 Description	Diagnosis Level 7 Description corresponding to Diagnosis
TRC-D01-C34-A01	Diagnosis 1	Diagnosis Level 7 Description	Diagnosis Level 7 Description corresponding to Diagnosis
TRC-D01-C34-A02	Diagnosis 2	Diagnosis Level 7 Description	Diagnosis Level 7 Description corresponding to Diagnosis
TRC-D01-C34-A03	Diagnosis 3	Diagnosis Level 7 Description	Diagnosis Level 7 Description corresponding to Diagnosis
TRC-D01-C34-A04	Diagnosis 4	Diagnosis Level 7 Description	Diagnosis Level 7 Description corresponding to Diagnosis
TRC-D01-C38	Diagnosis	Diagnosis Hierarchy Name	Diagnosis Hierarchy Name corresponding to Diagnosis
TRC-D01-C38-A01	Diagnosis 1	Diagnosis Hierarchy Name	Diagnosis Hierarchy Name corresponding to Diagnosis
TRC-D01-C38-A02	Diagnosis 2	Diagnosis Hierarchy Name	Diagnosis Hierarchy Name corresponding to Diagnosis
TRC-D01-C38-A03	Diagnosis 3	Diagnosis Hierarchy Name	Diagnosis Hierarchy Name corresponding to Diagnosis
TRC-D01-C38-A04	Diagnosis 4	Diagnosis Hierarchy Name	Diagnosis Hierarchy Name corresponding to Diagnosis
TRC-D01-C39	Diagnosis	Anatomical Site Level 1 Code	Anatomical Site Level 1 Code corresponding to Anatomical Site
TRC-D01-C39-A01	Diagnosis 1	Anatomical Site Level 1 Code	Anatomical Site Level 1 Code corresponding to Anatomical Site
TRC-D01-C39-A02	Diagnosis 2	Anatomical Site Level 1 Code	Anatomical Site Level 1 Code corresponding to Anatomical Site
TRC-D01-C39-A03	Diagnosis 3	Anatomical Site Level 1 Code	Anatomical Site Level 1 Code corresponding to Anatomical Site
TRC-D01-C39-A04	Diagnosis 4	Anatomical Site Level 1 Code	Anatomical Site Level 1 Code corresponding to Anatomical Site
TRC-D01-C40	Diagnosis	Anatomical Site Level 1 Name	Anatomical Site Level 1 Name corresponding to Anatomical Site
TRC-D01-C40-A01	Diagnosis 1	Anatomical Site Level 1 Name	Anatomical Site Level 1 Name corresponding to Anatomical Site
TRC-D01-C40-A02	Diagnosis 2	Anatomical Site Level 1 Name	Anatomical Site Level 1 Name corresponding to Anatomical Site
TRC-D01-C40-A03	Diagnosis 3	Anatomical Site Level 1 Name	Anatomical Site Level 1 Name corresponding to Anatomical Site
TRC-D01-C40-A04	Diagnosis 4	Anatomical Site Level 1 Name	Anatomical Site Level 1 Name corresponding to Anatomical Site
TRC-D01-C41	Diagnosis	Anatomical Site Level 1 Description	Anatomical Site Level 1 Description corresponding to Anatomical Site
TRC-D01-C41-A01	Diagnosis 1	Anatomical Site Level 1 Description	Anatomical Site Level 1 Description corresponding to Anatomical Site
TRC-D01-C41-A02	Diagnosis 2	Anatomical Site Level 1 Description	Anatomical Site Level 1 Description corresponding to Anatomical Site
TRC-D01-C41-A03	Diagnosis 3	Anatomical Site Level 1 Description	Anatomical Site Level 1 Description corresponding to Anatomical Site
TRC-D01-C41-A04	Diagnosis 4	Anatomical Site Level 1 Description	Anatomical Site Level 1 Description corresponding to Anatomical Site
TRC-D01-C42	Diagnosis	Anatomical Site Level 2 Code	Anatomical Site Level 2 Code corresponding to Anatomical Site
TRC-D01-C42-A01	Diagnosis 1	Anatomical Site Level 2 Code	Anatomical Site Level 2 Code corresponding to Anatomical Site
TRC-D01-C42-A02	Diagnosis 2	Anatomical Site Level 2 Code	Anatomical Site Level 2 Code corresponding to Anatomical Site
TRC-D01-C42-A03	Diagnosis 3	Anatomical Site Level 2 Code	Anatomical Site Level 2 Code corresponding to Anatomical Site
TRC-D01-C42-A04	Diagnosis 4	Anatomical Site Level 2 Code	Anatomical Site Level 2 Code corresponding to Anatomical Site
TRC-D01-C43	Diagnosis	Anatomical Site Level 2 Name	Anatomical Site Level 2 Name corresponding to Anatomical Site
TRC-D01-C43-A01	Diagnosis 1	Anatomical Site Level 2 Name	Anatomical Site Level 2 Name corresponding to Anatomical Site
TRC-D01-C43-A02	Diagnosis 2	Anatomical Site Level 2 Name	Anatomical Site Level 2 Name corresponding to Anatomical Site
TRC-D01-C43-A03	Diagnosis 3	Anatomical Site Level 2 Name	Anatomical Site Level 2 Name corresponding to Anatomical Site
TRC-D01-C43-A04	Diagnosis 4	Anatomical Site Level 2 Name	Anatomical Site Level 2 Name corresponding to Anatomical Site
TRC-D01-C44	Diagnosis	Anatomical Site Level 2 Description	Anatomical Site Level 2 Description corresponding to Anatomical Site
TRC-D01-C44-A01	Diagnosis 1	Anatomical Site Level 2 Description	Anatomical Site Level 2 Description corresponding to Anatomical Site
TRC-D01-C44-A02	Diagnosis 2	Anatomical Site Level 2 Description	Anatomical Site Level 2 Description corresponding to Anatomical Site
TRC-D01-C44-A03	Diagnosis 3	Anatomical Site Level 2 Description	Anatomical Site Level 2 Description corresponding to Anatomical Site
TRC-D01-C44-A04	Diagnosis 4	Anatomical Site Level 2 Description	Anatomical Site Level 2 Description corresponding to Anatomical Site
TRC-D01-C45	Diagnosis	Anatomical Site Level 3 Code	Anatomical Site Level 3 Code corresponding to Anatomical Site
TRC-D01-C45-A01	Diagnosis 1	Anatomical Site Level 3 Code	Anatomical Site Level 3 Code corresponding to Anatomical Site
TRC-D01-C45-A02	Diagnosis 2	Anatomical Site Level 3 Code	Anatomical Site Level 3 Code corresponding to Anatomical Site
TRC-D01-C45-A03	Diagnosis 3	Anatomical Site Level 3 Code	Anatomical Site Level 3 Code corresponding to Anatomical Site
TRC-D01-C45-A04	Diagnosis 4	Anatomical Site Level 3 Code	Anatomical Site Level 3 Code corresponding to Anatomical Site
TRC-D01-C46	Diagnosis	Anatomical Site Level 3 Name	Anatomical Site Level 3 Name corresponding to Anatomical Site
TRC-D01-C46-A01	Diagnosis 1	Anatomical Site Level 3 Name	Anatomical Site Level 3 Name corresponding to Anatomical Site
TRC-D01-C46-A02	Diagnosis 2	Anatomical Site Level 3 Name	Anatomical Site Level 3 Name corresponding to Anatomical Site
TRC-D01-C46-A03	Diagnosis 3	Anatomical Site Level 3 Name	Anatomical Site Level 3 Name corresponding to Anatomical Site
TRC-D01-C46-A04	Diagnosis 4	Anatomical Site Level 3 Name	Anatomical Site Level 3 Name corresponding to Anatomical Site
TRC-D01-C47	Diagnosis	Anatomical Site Level 3 Description	Anatomical Site Level 3 Description corresponding to Anatomical Site
TRC-D01-C47-A01	Diagnosis 1	Anatomical Site Level 3 Description	Anatomical Site Level 3 Description corresponding to Anatomical Site
TRC-D01-C47-A02	Diagnosis 2	Anatomical Site Level 3 Description	Anatomical Site Level 3 Description corresponding to Anatomical Site
TRC-D01-C47-A03	Diagnosis 3	Anatomical Site Level 3 Description	Anatomical Site Level 3 Description corresponding to Anatomical Site
TRC-D01-C47-A04	Diagnosis 4	Anatomical Site Level 3 Description	Anatomical Site Level 3 Description corresponding to Anatomical Site
TRC-D01-C48	Diagnosis	Anatomical Site Level 4 Code	Anatomical Site Level 4 Code corresponding to Anatomical Site
TRC-D01-C48-A01	Diagnosis 1	Anatomical Site Level 4 Code	Anatomical Site Level 4 Code corresponding to Anatomical Site
TRC-D01-C48-A02	Diagnosis 2	Anatomical Site Level 4 Code	Anatomical Site Level 4 Code corresponding to Anatomical Site
TRC-D01-C48-A03	Diagnosis 3	Anatomical Site Level 4 Code	Anatomical Site Level 4 Code corresponding to Anatomical Site
TRC-D01-C48-A04	Diagnosis 4	Anatomical Site Level 4 Code	Anatomical Site Level 4 Code corresponding to Anatomical Site
TRC-D01-C49	Diagnosis	Anatomical Site Level 4 Name	Anatomical Site Level 4 Name corresponding to Anatomical Site
TRC-D01-C49-A01	Diagnosis 1	Anatomical Site Level 4 Name	Anatomical Site Level 4 Name corresponding to Anatomical Site
TRC-D01-C49-A02	Diagnosis 2	Anatomical Site Level 4 Name	Anatomical Site Level 4 Name corresponding to Anatomical Site
TRC-D01-C49-A03	Diagnosis 3	Anatomical Site Level 4 Name	Anatomical Site Level 4 Name corresponding to Anatomical Site
TRC-D01-C49-A04	Diagnosis 4	Anatomical Site Level 4 Name	Anatomical Site Level 4 Name corresponding to Anatomical Site
TRC-D01-C50	Diagnosis	Anatomical Site Level 4 Description	Anatomical Site Level 4 Description corresponding to Anatomical Site
TRC-D01-C50-A01	Diagnosis 1	Anatomical Site Level 4 Description	Anatomical Site Level 4 Description corresponding to Anatomical Site
TRC-D01-C50-A02	Diagnosis 2	Anatomical Site Level 4 Description	Anatomical Site Level 4 Description corresponding to Anatomical Site
TRC-D01-C50-A03	Diagnosis 3	Anatomical Site Level 4 Description	Anatomical Site Level 4 Description corresponding to Anatomical Site
TRC-D01-C50-A04	Diagnosis 4	Anatomical Site Level 4 Description	Anatomical Site Level 4 Description corresponding to Anatomical Site
TRC-D01-C51	Diagnosis	Anatomical Site Level 5 Code	Anatomical Site Level 5 Code corresponding to Anatomical Site
TRC-D01-C51-A01	Diagnosis 1	Anatomical Site Level 5 Code	Anatomical Site Level 5 Code corresponding to Anatomical Site
TRC-D01-C51-A02	Diagnosis 2	Anatomical Site Level 5 Code	Anatomical Site Level 5 Code corresponding to Anatomical Site
TRC-D01-C51-A03	Diagnosis 3	Anatomical Site Level 5 Code	Anatomical Site Level 5 Code corresponding to Anatomical Site
TRC-D01-C51-A04	Diagnosis 4	Anatomical Site Level 5 Code	Anatomical Site Level 5 Code corresponding to Anatomical Site
TRC-D01-C52	Diagnosis	Anatomical Site Level 5 Name	Anatomical Site Level 5 Name corresponding to Anatomical Site
TRC-D01-C52-A01	Diagnosis 1	Anatomical Site Level 5 Name	Anatomical Site Level 5 Name corresponding to Anatomical Site
TRC-D01-C52-A02	Diagnosis 2	Anatomical Site Level 5 Name	Anatomical Site Level 5 Name corresponding to Anatomical Site
TRC-D01-C52-A03	Diagnosis 3	Anatomical Site Level 5 Name	Anatomical Site Level 5 Name corresponding to Anatomical Site
TRC-D01-C52-A04	Diagnosis 4	Anatomical Site Level 5 Name	Anatomical Site Level 5 Name corresponding to Anatomical Site
TRC-D01-C53	Diagnosis	Anatomical Site Level 5 Description	Anatomical Site Level 5 Description corresponding to Anatomical Site
TRC-D01-C53-A01	Diagnosis 1	Anatomical Site Level 5 Description	Anatomical Site Level 5 Description corresponding to Anatomical Site
TRC-D01-C53-A02	Diagnosis 2	Anatomical Site Level 5 Description	Anatomical Site Level 5 Description corresponding to Anatomical Site
TRC-D01-C53-A03	Diagnosis 3	Anatomical Site Level 5 Description	Anatomical Site Level 5 Description corresponding to Anatomical Site
TRC-D01-C53-A04	Diagnosis 4	Anatomical Site Level 5 Description	Anatomical Site Level 5 Description corresponding to Anatomical Site
TRC-D01-C57	Diagnosis	Anatomical Site Hierarchy Name	Anatomical Site Hierarchy Name corresponding to Anatomical Site
TRC-D01-C57-A01	Diagnosis 1	Anatomical Site Hierarchy Name	Anatomical Site Hierarchy Name corresponding to Anatomical Site
TRC-D01-C57-A02	Diagnosis 2	Anatomical Site Hierarchy Name	Anatomical Site Hierarchy Name corresponding to Anatomical Site
TRC-D01-C57-A03	Diagnosis 3	Anatomical Site Hierarchy Name	Anatomical Site Hierarchy Name corresponding to Anatomical Site
TRC-D01-C57-A04	Diagnosis 4	Anatomical Site Hierarchy Name	Anatomical Site Hierarchy Name corresponding to Anatomical Site
TRC-D01-C58	Diagnosis	Anatomical Site Hierarchy Version	Anatomical Site Hierarchy Version corresponding to Anatomical Site
TRC-D01-C58-A01	Diagnosis 1	Anatomical Site Hierarchy Version	Anatomical Site Hierarchy Version corresponding to Anatomical Site
TRC-D01-C58-A02	Diagnosis 2	Anatomical Site Hierarchy Version	Anatomical Site Hierarchy Version corresponding to Anatomical Site
TRC-D01-C58-A03	Diagnosis 3	Anatomical Site Hierarchy Version	Anatomical Site Hierarchy Version corresponding to Anatomical Site
TRC-D01-C58-A04	Diagnosis 4	Anatomical Site Hierarchy Version	Anatomical Site Hierarchy Version corresponding to Anatomical Site
TRC-D01-C59	Diagnosis	Diagnosis Hierarchy Version	Diagnosis Hierarchy Version corresponding to Diagnosis
TRC-D01-C59-A01	Diagnosis 1	Diagnosis Hierarchy Version	Diagnosis Hierarchy Version corresponding to Diagnosis 1
TRC-D01-C59-A02	Diagnosis 2	Diagnosis Hierarchy Version	Diagnosis Hierarchy Version corresponding to Diagnosis 2
TRC-D01-C59-A03	Diagnosis 3	Diagnosis Hierarchy Version	Diagnosis Hierarchy Version corresponding to Diagnosis 3
TRC-D01-C59-A04	Diagnosis 4	Diagnosis Hierarchy Version	Diagnosis Hierarchy Version corresponding to Diagnosis 4
TRC-D02-C01	Patient	Patient ID	Patient identifier, not a natural key, cannot identify patient by name or any other sensitive information
TRC-D02-C01-A01	Patient 1	Patient ID	Patient identifier, not a natural key, cannot identify patient by name or any other sensitive information
TRC-D02-C01-A02	Patient 2	Patient ID	Patient identifier, not a natural key, cannot identify patient by name or any other sensitive information
TRC-D02-C01-A03	Patient 3	Patient ID	Patient identifier, not a natural key, cannot identify patient by name or any other sensitive information
TRC-D02-C02	Patient	Gender	Male or Female
TRC-D02-C02-A01	Patient 1	Gender	Male or Female
TRC-D02-C02-A02	Patient 2	Gender	Male or Female
TRC-D02-C03	Patient	Marital Status	Married, Single, Divorced, Widowed
TRC-D02-C03-A01	Patient 1	Marital Status	Married, Single, Divorced, Widowed
TRC-D02-C03-A02	Patient 2	Marital Status	Married, Single, Divorced, Widowed
TRC-D02-C04	Patient	Date of Birth	Can be deidentified if customer chooses so
TRC-D02-C04-A01	Patient 1	Date of Birth	Can be deidentified if customer chooses so
TRC-D02-C04-A02	Patient 2	Date of Birth	Can be deidentified if customer chooses so
TRC-D02-C05	Patient	Age (in Years)	Age in years
TRC-D02-C05-A01	Patient 1	Age (in Years)	Age in years
TRC-D02-C05-A02	Patient 2	Age (in Years)	Age in years
TRC-D02-C06	Patient	Date Deceased	Date patient died, null if patient is not deceased
TRC-D02-C06-A01	Patient 1	Date Deceased	Date patient died, null if patient is not deceased
TRC-D02-C06-A02	Patient 2	Date Deceased	Date patient died, null if patient is not deceased
TRC-D02-C07	Patient	Ethnicity Code	Code for Ethinicity
TRC-D02-C07-A01	Patient 1	Ethnicity Code	Code for Ethinicity
TRC-D02-C08	Patient	Ethnicity Name	Name for Ethinicity
TRC-D02-C08-A01	Patient 1	Ethnicity Name	Name for Ethinicity
TRC-D02-C09	Patient	Ethinicity Description	Description
TRC-D02-C09-A01	Patient 1	Ethinicity Description	Description
TRC-D02-C10	Patient	Race Code	Race Code
TRC-D02-C10-A01	Patient 1	Race Code	Race Code
TRC-D02-C11	Patient	Race Name	Name of race
TRC-D02-C11-A01	Patient 1	Race Name	Name of race
TRC-D02-C12	Patient	Race Description	Description
TRC-D02-C12-A01	Patient 1	Race Description	Description
TRC-D02-C13	Patient	City	Name of City, e.g New York
TRC-D02-C13-A01	Patient 1	City	Name of City, e.g New York
TRC-D02-C14	Patient	State	Name of State, For example, Massachusetts
TRC-D02-C14-A01	Patient 1	State	Name of State, For example, Massachusetts
TRC-D02-C15	Patient	Zipcode	Zipcode For example, 02115
TRC-D02-C15-A01	Patient 1	Zipcode	Zipcode For example, 02115
TRC-D02-C16	Patient	County	County For example, Middlesex
TRC-D02-C16-A01	Patient 1	County	County For example, Middlesex
TRC-D02-C17	Patient	Country	Country For example, USA
TRC-D02-C17-A01	Patient 1	Country	Country For example, USA
TRC-D02-C18	Patient	Consent Type Code	Code for Consent Type
TRC-D02-C18-A01	Patient 1	Consent Type Code	Code for Consent Type
TRC-D02-C19	Patient	Consent Type Name	Name of Consent Type
TRC-D02-C19-A01	Patient 1	Consent Type Name	Name of Consent Type
TRC-D02-C20	Patient	Consent Type Description	Description of Consent Type
TRC-D02-C20-A01	Patient 1	Consent Type Description	Description of Consent Type
TRC-D02-C21	Patient	Consent Status Code	Code for Consent Status
TRC-D02-C21-A01	Patient 1	Consent Status Code	Code for Consent Status
TRC-D02-C22	Patient	Consent Status Name	Name of Consent Status pertaining to a given Consent Status Code
TRC-D02-C22-A01	Patient 1	Consent Status Name	Name of Consent Status pertaining to a given Consent Status Code
TRC-D02-C23	Patient	Consent Status Description	Description of Consent Status pertaining to a given Consent Status Code
TRC-D02-C23-A01	Patient 1	Consent Status Description	Description of Consent Status pertaining to a given Consent Status Code
TRC-D02-C24	Patient	Consent Start Date	Effective date when Consent starts
TRC-D02-C24-A01	Patient 1	Consent Start Date	Effective date when Consent starts
TRC-D02-C25	Patient	Consent End Date	Effective date when Consent ends
TRC-D02-C25-A01	Patient 1	Consent End Date	Effective date when Consent ends
TRC-D03-C01	Procedure	Procedure Code	Code for Procedure
TRC-D03-C01-A01	Procedure 1	Procedure Code 1	Code for Procedure - alias for OBIEE
TRC-D03-C01-A02	Procedure 2	Procedure Code 2	Code for Procedure - alias for OBIEE
TRC-D03-C01-A03	Procedure 3	Procedure Code 3	Code for Procedure - alias for OBIEE
TRC-D03-C01-A04	Procedure 4	Procedure Code 4	Code for Procedure - alias for OBIEE
TRC-D03-C02	Procedure	Procedure Name	Name for Procedure corresponding to Procedure Code
TRC-D03-C02-A01	Procedure 1	Procedure Name 1	Name for Procedure corresponding to Procedure Code 1 alias for OBIEE
TRC-D03-C02-A02	Procedure 2	Procedure Name 2	Name for Procedure corresponding to Procedure Code 2 alias for OBIEE
TRC-D03-C02-A03	Procedure 3	Procedure Name 3	Name for Procedure corresponding to Procedure Code 3 alias for OBIEE
TRC-D03-C02-A04	Procedure 4	Procedure Name 4	Name for Procedure corresponding to Procedure Code 4 alias for OBIEE
TRC-D03-C03	Procedure	Procedure Description	Description for Procedure corresponding to Procedure Code
TRC-D03-C03-A01	Procedure 1	Procedure Description 1	Description for Procedure corresponding to Procedure Code 1 alias for OBIEE
TRC-D03-C03-A02	Procedure 2	Procedure Description 2	Description for Procedure corresponding to Procedure Code 2 alias for OBIEE
TRC-D03-C03-A03	Procedure 3	Procedure Description 3	Description for Procedure corresponding to Procedure Code 3 alias for OBIEE
TRC-D03-C03-A04	Procedure 4	Procedure Description 4	Description for Procedure corresponding to Procedure Code 4 alias for OBIEE
TRC-D03-C04	Procedure	Start Date	Start Date corresponding to Procedure Code - when the procedure/treatment started
TRC-D03-C04-A01	Procedure 1	Start Date 1	Start Date corresponding to Procedure Code 1
TRC-D03-C04-A02	Procedure 2	Start Date 2	Start Date corresponding to Procedure Code 2
TRC-D03-C04-A03	Procedure 3	Start Date 3	Start Date corresponding to Procedure Code 3
TRC-D03-C04-A04	Procedure 4	Start Date 4	Start Date corresponding to Procedure Code 4
TRC-D03-C05	Procedure	End Date	End Date corresponding to Procedure Code - when the procedure/treatment ended
TRC-D03-C05-A01	Procedure 1	End Date 1	End Date corresponding to Procedure Code 1 - when the procedure/treatment ended
TRC-D03-C05-A02	Procedure 2	End Date 2	End Date corresponding to Procedure Code 2 - when the procedure/treatment ended
TRC-D03-C05-A03	Procedure 3	End Date 3	End Date corresponding to Procedure Code 3 - when the procedure/treatment ended
TRC-D03-C05-A04	Procedure 4	End Date 4	End Date corresponding to Procedure Code 4 - when the procedure/treatment ended
TRC-D03-C06	Procedure	Procedure Type Code	Procedure Type Code used to differentiate procedure groupings by code
TRC-D03-C06-A01	Procedure 1	Procedure Type Code 1	Procedure Type Code used to differentiate procedure groupings by code
TRC-D03-C06-A02	Procedure 2	Procedure Type Code 2	Procedure Type Code used to differentiate procedure groupings by code
TRC-D03-C06-A03	Procedure 3	Procedure Type Code 3	Procedure Type Code used to differentiate procedure groupings by code
TRC-D03-C06-A04	Procedure 4	Procedure Type Code 4	Procedure Type Code used to differentiate procedure groupings by code
TRC-D03-C07	Procedure	Procedure Type Name	Procedure Type used to differentiate Surgical, Chemotherapy, Radiation, Gene Therapy
TRC-D03-C07-A01	Procedure 1	Procedure Type Name 1	Procedure Type used to differentiate Surgical, Chemotherapy, Radiation, Gene Therapy
TRC-D03-C07-A02	Procedure 2	Procedure Type Name 2	Procedure Type used to differentiate Surgical, Chemotherapy, Radiation, Gene Therapy
TRC-D03-C07-A03	Procedure 3	Procedure Type Name 3	Procedure Type used to differentiate Surgical, Chemotherapy, Radiation, Gene Therapy
TRC-D03-C07-A04	Procedure 4	Procedure Type Name 4	Procedure Type used to differentiate Surgical, Chemotherapy, Radiation, Gene Therapy
TRC-D03-C08	Procedure	Procedure Type Description	Longer description of Procedure Type and what types of procedures go into it
TRC-D03-C08-A01	Procedure 1	Procedure Type Description 1	Longer description of Procedure Type and what types of procedures go into it
TRC-D03-C08-A02	Procedure 2	Procedure Type Description 2	Longer description of Procedure Type and what types of procedures go into it
TRC-D03-C08-A03	Procedure 3	Procedure Type Description 3	Longer description of Procedure Type and what types of procedures go into it
TRC-D03-C08-A04	Procedure 4	Procedure Type Description 4	Longer description of Procedure Type and what types of procedures go into it
TRC-D04-C01	Medication	Medication Code	Code for Medication
TRC-D04-C01-A01	Medication 1	Medication Code 1	Code for Medication - alias for OBIEE
TRC-D04-C01-A02	Medication 2	Medication Code 2	Code for Medication - alias for OBIEE
TRC-D04-C01-A03	Medication 3	Medication Code 3	Code for Medication - alias for OBIEE
TRC-D04-C01-A04	Medication 4	Medication Code 4	Code for Medication - alias for OBIEE
TRC-D04-C02	Medication	Medication Name	Name for Medication corresponding to Medication Code
TRC-D04-C02-A01	Medication 1	Medication Name 1	Name for Medication corresponding to Medication Code 1 alias for OBIEE
TRC-D04-C02-A02	Medication 2	Medication Name 2	Name for Medication corresponding to Medication Code 2 alias for OBIEE
TRC-D04-C02-A03	Medication 3	Medication Name 3	Name for Medication corresponding to Medication Code 3 alias for OBIEE
TRC-D04-C02-A04	Medication 4	Medication Name 4	Name for Medication corresponding to Medication Code 4 alias for OBIEE
TRC-D04-C03	Medication	Medication Description	Description for Medication corresponding to Medication Code
TRC-D04-C03-A01	Medication 1	Medication Description 1	Description for Medication corresponding to Medication Code 1 alias for OBIEE
TRC-D04-C03-A02	Medication 2	Medication Description 2	Description for Medication corresponding to Medication Code 2 alias for OBIEE
TRC-D04-C03-A03	Medication 3	Medication Description 3	Description for Medication corresponding to Medication Code 3 alias for OBIEE
TRC-D04-C03-A04	Medication 4	Medication Description 4	Description for Medication corresponding to Medication Code 4 alias for OBIEE
TRC-D04-C04	Medication	Start Date	Start Date corresponding to Medication Code - when the patient started taking medication
TRC-D04-C04-A01	Medication 1	Start Date 1	Start Date corresponding to Medication Code 1
TRC-D04-C04-A02	Medication 2	Start Date 2	Start Date corresponding to Medication Code 2
TRC-D04-C04-A03	Medication 3	Start Date 3	Start Date corresponding to Medication Code 3
TRC-D04-C04-A04	Medication 4	Start Date 4	Start Date corresponding to Medication Code 4
TRC-D04-C05	Medication	End Date	End Date corresponding to Medication Code - when the patient ended taking medication
TRC-D04-C05-A01	Medication 1	End Date 1	End Date corresponding to Medication Code 1
TRC-D04-C05-A02	Medication 2	End Date 2	End Date corresponding to Medication Code 2
TRC-D04-C05-A03	Medication 3	End Date 3	End Date corresponding to Medication Code 3
TRC-D04-C05-A04	Medication 4	End Date 4	End Date corresponding to Medication Code 4
TRC-D04-C06	Medication	Dosage	Dosage of medication corresponding to Medication Code
TRC-D04-C06-A01	Medication 1	Dosage 1	Dosage of medication corresponding to Medication Code 1
TRC-D04-C06-A02	Medication 2	Dosage 2	Dosage of medication corresponding to Medication Code 2
TRC-D04-C06-A03	Medication 3	Dosage 3	Dosage of medication corresponding to Medication Code 3
TRC-D04-C06-A04	Medication 4	Dosage 4	Dosage of medication corresponding to Medication Code 4
TRC-D04-C07	Medication	Dosage UoM	Medication Dosage Units corresponding to Medication Code (in g or mg or whatever the unit systems are specified)
TRC-D04-C07-A01	Medication 1	Dosage UoM 1	Medication Dosage Units corresponding to Medication Code (in g or mg or whatever the unit systems are specified)
TRC-D04-C07-A02	Medication 2	Dosage UoM 2	Medication Dosage Units corresponding to Medication Code (in g or mg or whatever the unit systems are specified)
TRC-D04-C07-A03	Medication 3	Dosage UoM 3	Medication Dosage Units corresponding to Medication Code (in g or mg or whatever the unit systems are specified)
TRC-D04-C07-A04	Medication 4	Dosage UoM 4	Medication Dosage Units corresponding to Medication Code (in g or mg or whatever the unit systems are specified)
TRC-D05-C01	Diagnostic Test	Diagnostic Test Code	Code for Diagnostic Test
TRC-D05-C01-A01	Diagnostic Test 1	Diagnostic Test Code 1	Code for Diagnostic Test - alias for OBIEE
TRC-D05-C01-A02	Diagnostic Test 2	Diagnostic Test Code 2	Code for Diagnostic Test - alias for OBIEE
TRC-D05-C01-A03	Diagnostic Test 3	Diagnostic Test Code 3	Code for Diagnostic Test - alias for OBIEE
TRC-D05-C01-A04	Diagnostic Test 4	Diagnostic Test Code 4	Code for Diagnostic Test - alias for OBIEE
TRC-D05-C02	Diagnostic Test	Diagnostic Test Name	Name for Diagnostic Test corresponding to Diagnostic Test Code
TRC-D05-C02-A01	Diagnostic Test 1	Diagnostic Test Name 1	Name for Diagnostic Test corresponding to Diagnostic Test Code 1 alias for OBIEE
TRC-D05-C02-A02	Diagnostic Test 2	Diagnostic Test Name 2	Name for Diagnostic Test corresponding to Diagnostic Test Code 2 alias for OBIEE
TRC-D05-C02-A03	Diagnostic Test 3	Diagnostic Test Name 3	Name for Diagnostic Test corresponding to Diagnostic Test Code 3 alias for OBIEE
TRC-D05-C02-A04	Diagnostic Test 4	Diagnostic Test Name 4	Name for Diagnostic Test corresponding to Diagnostic Test Code 4 alias for OBIEE
TRC-D05-C03	Diagnostic Test	Diagnostic Test Description	Description for Diagnostic Test corresponding to Diagnostic Test Code
TRC-D05-C03-A01	Diagnostic Test 1	Diagnostic Test Description 1	Description for Diagnostic Test corresponding to Diagnostic Test Code 1 alias for OBIEE
TRC-D05-C03-A02	Diagnostic Test 2	Diagnostic Test Description 2	Description for Diagnostic Test corresponding to Diagnostic Test Code 2 alias for OBIEE
TRC-D05-C03-A03	Diagnostic Test 3	Diagnostic Test Description 3	Description for Diagnostic Test corresponding to Diagnostic Test Code 3 alias for OBIEE
TRC-D05-C03-A04	Diagnostic Test 4	Diagnostic Test Description 4	Description for Diagnostic Test corresponding to Diagnostic Test Code 4 alias for OBIEE
TRC-D05-C04	Diagnostic Test	Test Date	Test Date corresponding to Diagnostic Test Code - when the patient had the test
TRC-D05-C04-A01	Diagnostic Test 1	Test Date 1	Test Date corresponding to Diagnostic Test Code 1
TRC-D05-C04-A02	Diagnostic Test 2	Test Date 2	Test Date corresponding to Diagnostic Test Code 2
TRC-D05-C04-A03	Diagnostic Test 3	Test Date 3	Test Date corresponding to Diagnostic Test Code 3
TRC-D05-C04-A04	Diagnostic Test 4	Test Date 4	Test Date corresponding to Diagnostic Test Code 4
TRC-D05-C05	Diagnostic Test	Test Result (numeric)	Numeric Test result corresponding to Diagnostic Test Code
TRC-D05-C05-A01	Diagnostic Test 1	Test Result (numeric) 1	Numeric Test result corresponding to Diagnostic Test Code 1
TRC-D05-C05-A02	Diagnostic Test 2	Test Result (numeric) 2	Numeric Test result corresponding to Diagnostic Test Code 2
TRC-D05-C05-A03	Diagnostic Test 3	Test Result (numeric) 3	Numeric Test result corresponding to Diagnostic Test Code 3
TRC-D05-C05-A04	Diagnostic Test 4	Test Result (numeric) 4	Numeric Test result corresponding to Diagnostic Test Code 4
TRC-D05-C06	Diagnostic Test	Numeric Result UoM	Diagnostic Test Numeric Result Units corresponding to Diagnostic Test Code (in g or mg or whatever the unit systems are specified)
TRC-D05-C06-A01	Diagnostic Test 1	Numeric Result UoM 1	Diagnostic Test Numeric Result Units corresponding to Diagnostic Test Code 1
TRC-D05-C06-A02	Diagnostic Test 2	Numeric Result UoM 2	Diagnostic Test Numeric Result Units corresponding to Diagnostic Test Code 2
TRC-D05-C06-A03	Diagnostic Test 3	Numeric Result UoM 3	Diagnostic Test Numeric Result Units corresponding to Diagnostic Test Code 3
TRC-D05-C06-A04	Diagnostic Test 4	Numeric Result UoM 4	Diagnostic Test Numeric Result Units corresponding to Diagnostic Test Code 4
TRC-D05-C07	Diagnostic Test	Test Result (string)	String Test result corresponding to Diagnostic Test Code
TRC-D05-C07-A01	Diagnostic Test 1	Test Result (string) 1	String Test result corresponding to Diagnostic Test Code 1
TRC-D05-C07-A02	Diagnostic Test 2	Test Result (string) 2	String Test result corresponding to Diagnostic Test Code 2
TRC-D05-C07-A03	Diagnostic Test 3	Test Result (string) 3	String Test result corresponding to Diagnostic Test Code 3
TRC-D05-C07-A04	Diagnostic Test 4	Test Result (string) 4	String Test result corresponding to Diagnostic Test Code 4
TRC-D06-C01	Specimen	Specimen Code	Code for Specimen
TRC-D06-C01-A01	Specimen 1	Specimen Code 1	Code for Specimen - alias for OBIEE
TRC-D06-C01-A02	Specimen 2	Specimen Code 2	Code for Specimen - alias for OBIEE
TRC-D06-C01-A03	Specimen 3	Specimen Code 3	Code for Specimen - alias for OBIEE
TRC-D06-C01-A04	Specimen 4	Specimen Code 4	Code for Specimen - alias for OBIEE
TRC-D06-C02	Specimen	Specimen Name	Name for Specimen corresponding to Specimen Code (For example, Blood)
TRC-D06-C02-A01	Specimen 1	Specimen Name 1	Name for Specimen corresponding to Specimen Code 1 (For example, Blood) alias for OBIEE
TRC-D06-C02-A02	Specimen 2	Specimen Name 2	Name for Specimen corresponding to Specimen Code 2 (For example, Blood) alias for OBIEE
TRC-D06-C02-A03	Specimen 3	Specimen Name 3	Name for Specimen corresponding to Specimen Code 3 (For example, Blood) alias for OBIEE
TRC-D06-C02-A04	Specimen 4	Specimen Name 4	Name for Specimen corresponding to Specimen Code 4 (For example, Blood) alias for OBIEE
TRC-D06-C03	Specimen	Specimen Description	Description for Specimen corresponding to Specimen Code (For example, Blood)
TRC-D06-C03-A01	Specimen 1	Specimen Description 1	Description for Specimen corresponding to Specimen Code 1 (For example, Blood) alias for OBIEE
TRC-D06-C03-A02	Specimen 2	Specimen Description 2	Description for Specimen corresponding to Specimen Code 2 (For example, Blood) alias for OBIEE
TRC-D06-C03-A03	Specimen 3	Specimen Description 3	Description for Specimen corresponding to Specimen Code 3 (For example, Blood) alias for OBIEE
TRC-D06-C03-A04	Specimen 4	Specimen Description 4	Description for Specimen corresponding to Specimen Code 4 (For example, Blood) alias for OBIEE
TRC-D06-C04	Specimen	Collection Date	Collection Date corresponding to Specimen Code - when the patient said he remembers having symptoms
TRC-D06-C04-A01	Specimen 1	Collection Date 1	Collection Date corresponding to Specimen Code 1
TRC-D06-C04-A02	Specimen 2	Collection Date 2	Collection Date corresponding to Specimen Code 2
TRC-D06-C04-A03	Specimen 3	Collection Date 3	Collection Date corresponding to Specimen Code 3
TRC-D06-C04-A04	Specimen 4	Collection Date 4	Collection Date corresponding to Specimen Code 4
TRC-D06-C05	Specimen	Specimen Amount	Specimen Amount corresponding to Specimen Code
TRC-D06-C05-A01	Specimen 1	Specimen Amount 1	Specimen Amount corresponding to Specimen Code 1
TRC-D06-C05-A02	Specimen 2	Specimen Amount 2	Specimen Amount corresponding to Specimen Code 2
TRC-D06-C05-A03	Specimen 3	Specimen Amount 3	Specimen Amount corresponding to Specimen Code 3
TRC-D06-C05-A04	Specimen 4	Specimen Amount 4	Specimen Amount corresponding to Specimen Code 4
TRC-D06-C06	Specimen	Specimen Amount UoM	Specimen Amount Units corresponding to Specimen Code (in g or mg or whatever the unit systems are specified)
TRC-D06-C06-A01	Specimen 1	Specimen Amount UoM 1	Specimen Amount Units corresponding to Specimen Code 1
TRC-D06-C06-A02	Specimen 2	Specimen Amount UoM 2	Specimen Amount Units corresponding to Specimen Code 2
TRC-D06-C06-A03	Specimen 3	Specimen Amount UoM 3	Specimen Amount Units corresponding to Specimen Code 3
TRC-D06-C06-A04	Specimen 4	Specimen Amount UoM 4	Specimen Amount Units corresponding to Specimen Code 4
TRC-D06-C07	Specimen	Anatomical Site Code	Anatomical Site Code corresponding to Specimen Code
TRC-D06-C07-A01	Specimen 1	Anatomical Site Code 1	Anatomical Site Code corresponding to Specimen Code 1
TRC-D06-C07-A02	Specimen 2	Anatomical Site Code 2	Anatomical Site Code corresponding to Specimen Code 2
TRC-D06-C07-A03	Specimen 3	Anatomical Site Code 3	Anatomical Site Code corresponding to Specimen Code 3
TRC-D06-C07-A04	Specimen 4	Anatomical Site Code 4	Anatomical Site Code corresponding to Specimen Code 4
TRC-D06-C08	Specimen	Anatomical Site Name	Anatomical Site Name corresponding to Specimen Code
TRC-D06-C08-A01	Specimen 1	Anatomical Site Name 1	Anatomical Site Name corresponding to Specimen Code 1
TRC-D06-C08-A02	Specimen 2	Anatomical Site Name 2	Anatomical Site Name corresponding to Specimen Code 2
TRC-D06-C08-A03	Specimen 3	Anatomical Site Name 3	Anatomical Site Name corresponding to Specimen Code 3
TRC-D06-C08-A04	Specimen 4	Anatomical Site Name 4	Anatomical Site Name corresponding to Specimen Code 4
TRC-D06-C09	Specimen	Anatomical Site Description	Anatomical Site Description corresponding to Specimen Code
TRC-D06-C09-A01	Specimen 1	Anatomical Site Description 1	Anatomical Site Description corresponding to Specimen Code 1
TRC-D06-C09-A02	Specimen 2	Anatomical Site Description 2	Anatomical Site Description corresponding to Specimen Code 2
TRC-D06-C09-A03	Specimen 3	Anatomical Site Description 3	Anatomical Site Description corresponding to Specimen Code 3
TRC-D06-C09-A04	Specimen 4	Anatomical Site Description 4	Anatomical Site Description corresponding to Specimen Code 4
TRC-D06-C10	Specimen	Specimen Anatomical Site Level 1 Code	Specimen Anatomical Site Level 1 Code
TRC-D06-C10-A01	Specimen 1	Specimen Anatomical Site Level 1 Code	Specimen Anatomical Site Level 1 Code
TRC-D06-C10-A02	Specimen 2	Specimen Anatomical Site Level 1 Code	Specimen Anatomical Site Level 1 Code
TRC-D06-C10-A03	Specimen 3	Specimen Anatomical Site Level 1 Code	Specimen Anatomical Site Level 1 Code
TRC-D06-C10-A04	Specimen 4	Specimen Anatomical Site Level 1 Code	Specimen Anatomical Site Level 1 Code
TRC-D06-C11	Specimen	Specimen Anatomical Site Level 1 Name	Specimen Anatomical Site Level 1 Name
TRC-D06-C11-A01	Specimen 1	Specimen Anatomical Site Level 1 Name	Specimen Anatomical Site Level 1 Name
TRC-D06-C11-A02	Specimen 2	Specimen Anatomical Site Level 1 Name	Specimen Anatomical Site Level 1 Name
TRC-D06-C11-A03	Specimen 3	Specimen Anatomical Site Level 1 Name	Specimen Anatomical Site Level 1 Name
TRC-D06-C11-A04	Specimen 4	Specimen Anatomical Site Level 1 Name	Specimen Anatomical Site Level 1 Name
TRC-D06-C12	Specimen	Specimen Anatomical Site Level 1 Description	Specimen Anatomical Site Level 1 Description
TRC-D06-C12-A01	Specimen 1	Specimen Anatomical Site Level 1 Description	Specimen Anatomical Site Level 1 Description
TRC-D06-C12-A02	Specimen 2	Specimen Anatomical Site Level 1 Description	Specimen Anatomical Site Level 1 Description
TRC-D06-C12-A03	Specimen 3	Specimen Anatomical Site Level 1 Description	Specimen Anatomical Site Level 1 Description
TRC-D06-C12-A04	Specimen 4	Specimen Anatomical Site Level 1 Description	Specimen Anatomical Site Level 1 Description
TRC-D06-C13	Specimen	Specimen Anatomical Site Level 2 Code	Specimen Anatomical Site Level 2 Code
TRC-D06-C13-A01	Specimen 1	Specimen Anatomical Site Level 2 Code	Specimen Anatomical Site Level 2 Code
TRC-D06-C13-A02	Specimen 2	Specimen Anatomical Site Level 2 Code	Specimen Anatomical Site Level 2 Code
TRC-D06-C13-A03	Specimen 3	Specimen Anatomical Site Level 2 Code	Specimen Anatomical Site Level 2 Code
TRC-D06-C13-A04	Specimen 4	Specimen Anatomical Site Level 2 Code	Specimen Anatomical Site Level 2 Code
TRC-D06-C14	Specimen	Specimen Anatomical Site Level 2 Name	Specimen Anatomical Site Level 2 Name
TRC-D06-C14-A01	Specimen 1	Specimen Anatomical Site Level 2 Name	Specimen Anatomical Site Level 2 Name
TRC-D06-C14-A02	Specimen 2	Specimen Anatomical Site Level 2 Name	Specimen Anatomical Site Level 2 Name
TRC-D06-C14-A03	Specimen 3	Specimen Anatomical Site Level 2 Name	Specimen Anatomical Site Level 2 Name
TRC-D06-C14-A04	Specimen 4	Specimen Anatomical Site Level 2 Name	Specimen Anatomical Site Level 2 Name
TRC-D06-C15	Specimen	Specimen Anatomical Site Level 2 Description	Specimen Anatomical Site Level 2 Description
TRC-D06-C15-A01	Specimen 1	Specimen Anatomical Site Level 2 Description	Specimen Anatomical Site Level 2 Description
TRC-D06-C15-A02	Specimen 2	Specimen Anatomical Site Level 2 Description	Specimen Anatomical Site Level 2 Description
TRC-D06-C15-A03	Specimen 3	Specimen Anatomical Site Level 2 Description	Specimen Anatomical Site Level 2 Description
TRC-D06-C15-A04	Specimen 4	Specimen Anatomical Site Level 2 Description	Specimen Anatomical Site Level 2 Description
TRC-D06-C16	Specimen	Specimen Anatomical Site Level 3 Code	Specimen Anatomical Site Level 3 Code
TRC-D06-C16-A01	Specimen 1	Specimen Anatomical Site Level 3 Code	Specimen Anatomical Site Level 3 Code
TRC-D06-C16-A02	Specimen 2	Specimen Anatomical Site Level 3 Code	Specimen Anatomical Site Level 3 Code
TRC-D06-C16-A03	Specimen 3	Specimen Anatomical Site Level 3 Code	Specimen Anatomical Site Level 3 Code
TRC-D06-C16-A04	Specimen 4	Specimen Anatomical Site Level 3 Code	Specimen Anatomical Site Level 3 Code
TRC-D06-C17	Specimen	Specimen Anatomical Site Level 3 Name	Specimen Anatomical Site Level 3 Name
TRC-D06-C17-A01	Specimen 1	Specimen Anatomical Site Level 3 Name	Specimen Anatomical Site Level 3 Name
TRC-D06-C17-A02	Specimen 2	Specimen Anatomical Site Level 3 Name	Specimen Anatomical Site Level 3 Name
TRC-D06-C17-A03	Specimen 3	Specimen Anatomical Site Level 3 Name	Specimen Anatomical Site Level 3 Name
TRC-D06-C17-A04	Specimen 4	Specimen Anatomical Site Level 3 Name	Specimen Anatomical Site Level 3 Name
TRC-D06-C18	Specimen	Specimen Anatomical Site Level 3 Description	Specimen Anatomical Site Level 3 Description
TRC-D06-C18-A01	Specimen 1	Specimen Anatomical Site Level 3 Description	Specimen Anatomical Site Level 3 Description
TRC-D06-C18-A02	Specimen 2	Specimen Anatomical Site Level 3 Description	Specimen Anatomical Site Level 3 Description
TRC-D06-C18-A03	Specimen 3	Specimen Anatomical Site Level 3 Description	Specimen Anatomical Site Level 3 Description
TRC-D06-C18-A04	Specimen 4	Specimen Anatomical Site Level 3 Description	Specimen Anatomical Site Level 3 Description
TRC-D06-C19	Specimen	Specimen Anatomical Site Level 4 Code	Specimen Anatomical Site Level 4 Code
TRC-D06-C19-A01	Specimen 1	Specimen Anatomical Site Level 4 Code	Specimen Anatomical Site Level 4 Code
TRC-D06-C19-A02	Specimen 2	Specimen Anatomical Site Level 4 Code	Specimen Anatomical Site Level 4 Code
TRC-D06-C19-A03	Specimen 3	Specimen Anatomical Site Level 4 Code	Specimen Anatomical Site Level 4 Code
TRC-D06-C19-A04	Specimen 4	Specimen Anatomical Site Level 4 Code	Specimen Anatomical Site Level 4 Code
TRC-D06-C20	Specimen	Specimen Anatomical Site Level 4 Name	Specimen Anatomical Site Level 4 Name
TRC-D06-C20-A01	Specimen 1	Specimen Anatomical Site Level 4 Name	Specimen Anatomical Site Level 4 Name
TRC-D06-C20-A02	Specimen 2	Specimen Anatomical Site Level 4 Name	Specimen Anatomical Site Level 4 Name
TRC-D06-C20-A03	Specimen 3	Specimen Anatomical Site Level 4 Name	Specimen Anatomical Site Level 4 Name
TRC-D06-C20-A04	Specimen 4	Specimen Anatomical Site Level 4 Name	Specimen Anatomical Site Level 4 Name
TRC-D06-C21	Specimen	Specimen Anatomical Site Level 4 Description	Specimen Anatomical Site Level 4 Description
TRC-D06-C21-A01	Specimen 1	Specimen Anatomical Site Level 4 Description	Specimen Anatomical Site Level 4 Description
TRC-D06-C21-A02	Specimen 2	Specimen Anatomical Site Level 4 Description	Specimen Anatomical Site Level 4 Description
TRC-D06-C21-A03	Specimen 3	Specimen Anatomical Site Level 4 Description	Specimen Anatomical Site Level 4 Description
TRC-D06-C21-A04	Specimen 4	Specimen Anatomical Site Level 4 Description	Specimen Anatomical Site Level 4 Description
TRC-D06-C22	Specimen	Specimen Anatomical Site Level 5 Code	Specimen Anatomical Site Level 5 Code
TRC-D06-C22-A01	Specimen 1	Specimen Anatomical Site Level 5 Code	Specimen Anatomical Site Level 5 Code
TRC-D06-C22-A02	Specimen 2	Specimen Anatomical Site Level 5 Code	Specimen Anatomical Site Level 5 Code
TRC-D06-C22-A03	Specimen 3	Specimen Anatomical Site Level 5 Code	Specimen Anatomical Site Level 5 Code
TRC-D06-C22-A04	Specimen 4	Specimen Anatomical Site Level 5 Code	Specimen Anatomical Site Level 5 Code
TRC-D06-C23	Specimen	Specimen Anatomical Site Level 5 Name	Specimen Anatomical Site Level 5 Name
TRC-D06-C23-A01	Specimen 1	Specimen Anatomical Site Level 5 Name	Specimen Anatomical Site Level 5 Name
TRC-D06-C23-A02	Specimen 2	Specimen Anatomical Site Level 5 Name	Specimen Anatomical Site Level 5 Name
TRC-D06-C23-A03	Specimen 3	Specimen Anatomical Site Level 5 Name	Specimen Anatomical Site Level 5 Name
TRC-D06-C23-A04	Specimen 4	Specimen Anatomical Site Level 5 Name	Specimen Anatomical Site Level 5 Name
TRC-D06-C24	Specimen	Specimen Anatomical Site Level 5 Description	Specimen Anatomical Site Level 5 Description
TRC-D06-C24-A01	Specimen 1	Specimen Anatomical Site Level 5 Description	Specimen Anatomical Site Level 5 Description
TRC-D06-C24-A02	Specimen 2	Specimen Anatomical Site Level 5 Description	Specimen Anatomical Site Level 5 Description
TRC-D06-C24-A03	Specimen 3	Specimen Anatomical Site Level 5 Description	Specimen Anatomical Site Level 5 Description
TRC-D06-C24-A04	Specimen 4	Specimen Anatomical Site Level 5 Description	Specimen Anatomical Site Level 5 Description
TRC-D06-C28	Specimen	Specimen Anatomical Site Hierarchy Name	Specimen Anatomical Site Hierarchy Name
TRC-D06-C28-A01	Specimen 1	Specimen Anatomical Site Hierarchy Name	Specimen Anatomical Site Hierarchy Name
TRC-D06-C28-A02	Specimen 2	Specimen Anatomical Site Hierarchy Name	Specimen Anatomical Site Hierarchy Name
TRC-D06-C28-A03	Specimen 3	Specimen Anatomical Site Hierarchy Name	Specimen Anatomical Site Hierarchy Name
TRC-D06-C28-A04	Specimen 4	Specimen Anatomical Site Hierarchy Name	Specimen Anatomical Site Hierarchy Name
TRC-D06-C29	Specimen	Specimen Anatomical Site Hierarchy Version	Specimen Anatomical Site Hierarchy Version corresponding to Specimen Anatomical Site
TRC-D06-C29-A01	Specimen 1	Specimen Anatomical Site Hierarchy Version	Specimen Anatomical Site Hierarchy Version corresponding to Specimen Anatomical Site
TRC-D06-C29-A02	Specimen 2	Specimen Anatomical Site Hierarchy Version	Specimen Anatomical Site Hierarchy Version corresponding to Specimen Anatomical Site
TRC-D06-C29-A03	Specimen 3	Specimen Anatomical Site Hierarchy Version	Specimen Anatomical Site Hierarchy Version corresponding to Specimen Anatomical Site
TRC-D06-C29-A04	Specimen 4	Specimen Anatomical Site Hierarchy Version	Specimen Anatomical Site Hierarchy Version corresponding to Specimen Anatomical Site
TRC-D07-C01	Patient History	Patient History Code	Code for Patient History
TRC-D07-C01-A01	Patient History 1	Patient History Code 1	Code for Patient History - alias for OBIEE
TRC-D07-C01-A02	Patient History 2	Patient History Code 2	Code for Patient History - alias for OBIEE
TRC-D07-C01-A03	Patient History 3	Patient History Code 3	Code for Patient History - alias for OBIEE
TRC-D07-C01-A04	Patient History 4	Patient History Code 4	Code for Patient History - alias for OBIEE
TRC-D07-C02	Patient History	Patient History Name	Name for Patient History corresponding to Patient History Code
TRC-D07-C02-A01	Patient History 1	Patient History Name 1	Name for Patient History corresponding to Patient History Code 1 alias for OBIEE
TRC-D07-C02-A02	Patient History 2	Patient History Name 2	Name for Patient History corresponding to Patient History Code 2 alias for OBIEE
TRC-D07-C02-A03	Patient History 3	Patient History Name 3	Name for Patient History corresponding to Patient History Code 3 alias for OBIEE
TRC-D07-C02-A04	Patient History 4	Patient History Name 4	Name for Patient History corresponding to Patient History Code 4 alias for OBIEE
TRC-D07-C03	Patient History	Patient History Description	Description for Patient History corresponding to Patient History Code
TRC-D07-C03-A01	Patient History 1	Patient History Description 1	Description for Patient History corresponding to Patient History Code 1 alias for OBIEE
TRC-D07-C03-A02	Patient History 2	Patient History Description 2	Description for Patient History corresponding to Patient History Code 2 alias for OBIEE
TRC-D07-C03-A03	Patient History 3	Patient History Description 3	Description for Patient History corresponding to Patient History Code 3 alias for OBIEE
TRC-D07-C03-A04	Patient History 4	Patient History Description 4	Description for Patient History corresponding to Patient History Code 4 alias for OBIEE
TRC-D07-C04	Patient History	Start Date	Start Date corresponding to Patient History Code - when the patient started taking medication
TRC-D07-C04-A01	Patient History 1	Start Date 1	Start Date corresponding to Patient History Code 1
TRC-D07-C04-A02	Patient History 2	Start Date 2	Start Date corresponding to Patient History Code 2
TRC-D07-C04-A03	Patient History 3	Start Date 3	Start Date corresponding to Patient History Code 3
TRC-D07-C04-A04	Patient History 4	Start Date 4	Start Date corresponding to Patient History Code 4
TRC-D07-C05	Patient History	End Date	End Date corresponding to Patient History Code - when the patient ended taking medication
TRC-D07-C05-A01	Patient History 1	End Date 1	End Date corresponding to Patient History Code 1
TRC-D07-C05-A02	Patient History 2	End Date 2	End Date corresponding to Patient History Code 2
TRC-D07-C05-A03	Patient History 3	End Date 3	End Date corresponding to Patient History Code 3
TRC-D07-C05-A04	Patient History 4	End Date 4	End Date corresponding to Patient History Code 4
TRC-D07-C06	Patient History	Amount	Amount corresponding to Patient History Code
TRC-D07-C06-A01	Patient History 1	Amount 1	Amount corresponding to Patient History Code 1
TRC-D07-C06-A02	Patient History 2	Amount 2	Amount corresponding to Patient History Code 2
TRC-D07-C06-A03	Patient History 3	Amount 3	Amount corresponding to Patient History Code 3
TRC-D07-C06-A04	Patient History 4	Amount 4	Amount corresponding to Patient History Code 4
TRC-D07-C07	Patient History	Amount UoM	Patient History Amount Units corresponding to Patient History Code (in g or mg or whatever the unit systems are specified)
TRC-D07-C07-A01	Patient History 1	Amount UoM 1	Patient History Amount Units corresponding to Patient History Code 1
TRC-D07-C07-A02	Patient History 2	Amount UoM 2	Patient History Amount Units corresponding to Patient History Code 2
TRC-D07-C07-A03	Patient History 3	Amount UoM 3	Patient History Amount Units corresponding to Patient History Code 3
TRC-D07-C07-A04	Patient History 4	Amount UoM 4	Patient History Amount Units corresponding to Patient History Code 4
TRC-D07-C08	Patient History	Frequency	Patient History Frequency corresponding to Patient History Code
TRC-D07-C08-A01	Patient History 1	Frequency 1	Patient History Frequency corresponding to Patient History Code 1
TRC-D07-C08-A02	Patient History 2	Frequency 2	Patient History Frequency corresponding to Patient History Code 2
TRC-D07-C08-A03	Patient History 3	Frequency 3	Patient History Frequency corresponding to Patient History Code 3
TRC-D07-C08-A04	Patient History 4	Frequency 4	Patient History Frequency corresponding to Patient History Code 4
TRC-D07-C09	Patient History	Frequency UoM	Patient History Frequency Units corresponding to Patient History Code (in per day or per week or whatever the unit systems are specified)
TRC-D07-C09-A01	Patient History 1	Frequency UoM 1	Patient History Frequency Units corresponding to Patient History Code 1
TRC-D07-C09-A02	Patient History 2	Frequency UoM 2	Patient History Frequency Units corresponding to Patient History Code 2
TRC-D07-C09-A03	Patient History 3	Frequency UoM 3	Patient History Frequency Units corresponding to Patient History Code 3
TRC-D07-C09-A04	Patient History 4	Frequency UoM 4	Patient History Frequency Units corresponding to Patient History Code 4
TRC-D08-C01	Protocol	Protocol Code	Code for Protocol
TRC-D08-C01-A01	Protocol 1	Protocol Code 1	Code for Protocol - alias for OBIEE
TRC-D08-C01-A02	Protocol 2	Protocol Code 2	Code for Protocol - alias for OBIEE
TRC-D08-C01-A03	Protocol 3	Protocol Code 3	Code for Protocol - alias for OBIEE
TRC-D08-C01-A04	Protocol 4	Protocol Code 4	Code for Protocol - alias for OBIEE
TRC-D08-C02	Protocol	Protocol Name	Name for Protocol corresponding to Protocol Code
TRC-D08-C02-A01	Protocol 1	Protocol Name 1	Name for Protocol corresponding to Protocol Code 1 alias for OBIEE
TRC-D08-C02-A02	Protocol 2	Protocol Name 2	Name for Protocol corresponding to Protocol Code 2 alias for OBIEE
TRC-D08-C02-A03	Protocol 3	Protocol Name 3	Name for Protocol corresponding to Protocol Code 3 alias for OBIEE
TRC-D08-C02-A04	Protocol 4	Protocol Name 4	Name for Protocol corresponding to Protocol Code 4 alias for OBIEE
TRC-D08-C03	Protocol	Protocol Description	Description for Protocol corresponding to Protocol Code
TRC-D08-C03-A01	Protocol 1	Protocol Description 1	Description for Protocol corresponding to Protocol Code 1 alias for OBIEE
TRC-D08-C03-A02	Protocol 2	Protocol Description 2	Description for Protocol corresponding to Protocol Code 2 alias for OBIEE
TRC-D08-C03-A03	Protocol 3	Protocol Description 3	Description for Protocol corresponding to Protocol Code 3 alias for OBIEE
TRC-D08-C03-A04	Protocol 4	Protocol Description 4	Description for Protocol corresponding to Protocol Code 4 alias for OBIEE
TRC-D09-C01	Diagnostic Test - Procedure	Diagnostic Test Code	Code for Diagnostic Test
TRC-D09-C02	Diagnostic Test - Procedure	Diagnostic Test Name	Name for Diagnostic Test corresponding to Diagnostic Test Code
TRC-D09-C03	Diagnostic Test - Procedure	Diagnostic Test Description	Description for Diagnostic Test corresponding to Diagnostic Test Code
TRC-D09-C04	Diagnostic Test - Procedure	Test Date	Test Date corresponding to Diagnostic Test Code - when the patient had the test
TRC-D09-C05	Diagnostic Test - Procedure	Test Result (numeric)	Numeric Test result corresponding to Diagnostic Test Code
TRC-D09-C06	Diagnostic Test - Procedure	Numeric Result UoM	Diagnostic Test Numeric Result Units corresponding to Diagnostic Test Code (in g or mg or whatever the unit systems are specified)
TRC-D09-C07	Diagnostic Test - Procedure	Test Result (string)	String Test result corresponding to Diagnostic Test Code
TRC-D09-C08	Diagnostic Test - Procedure	Procedure Code	Code for Procedure
TRC-D09-C09	Diagnostic Test - Procedure	Procedure Name	Name for Procedure corresponding to Procedure Code
TRC-D09-C10	Diagnostic Test - Procedure	Procedure Description	Description for Procedure corresponding to Procedure Code
TRC-D09-C11	Diagnostic Test - Procedure	Procedure Start Date	Start Date corresponding to Procedure Code - when the procedure/treatment started
TRC-D09-C12	Diagnostic Test - Procedure	Procedure End Date	End Date corresponding to Procedure Code - when the procedure/treatment ended
TRC-D09-C13	Diagnostic Test - Procedure	Procedure Type Code	Procedure Type Code used to differentiate procedure groupings by code
TRC-D09-C14	Diagnostic Test - Procedure	Procedure Type Name	Procedure Type used to differentiate Surgical, Chemotherapy, Radiation, Gene Therapy
TRC-D09-C15	Diagnostic Test - Procedure	Procedure Type Description	Longer description of Procedure Type and what types of procedures go into it
TRC-D10-C01	Diagnostic Test - Specimen	Diagnostic Test Code	Code for Diagnostic Test
TRC-D10-C02	Diagnostic Test - Specimen	Diagnostic Test Name	Name for Diagnostic Test corresponding to Diagnostic Test Code
TRC-D10-C03	Diagnostic Test - Specimen	Diagnostic Test Description	Description for Diagnostic Test corresponding to Diagnostic Test Code
TRC-D10-C04	Diagnostic Test - Specimen	Test Date	Test Date corresponding to Diagnostic Test Code - when the patient had the test
TRC-D10-C08	Diagnostic Test - Specimen	Specimen Code	Code for Specimen
TRC-D10-C09	Diagnostic Test - Specimen	Specimen Name	Name for Specimen corresponding to Specimen Code (For example, Blood)
TRC-D10-C10	Diagnostic Test - Specimen	Specimen Description	Description for Specimen corresponding to Specimen Code (For example, Blood)
TRC-D10-C11	Diagnostic Test - Specimen	Specimen Collection Date	Collection Date corresponding to Specimen Code - when the patient said he remembers having symptoms
TRC-D10-C12	Diagnostic Test - Specimen	Specimen Amount	Specimen Amount corresponding to Specimen Code
TRC-D10-C13	Diagnostic Test - Specimen	Specimen Amount UoM	Specimen Amount Units corresponding to Specimen Code (in g or mg or whatever the unit systems are specified)
TRC-D10-C14	Diagnostic Test - Specimen	Specimen Anatomical Site Code	Anatomical Site Code corresponding to Specimen Code
TRC-D10-C15	Diagnostic Test - Specimen	Specimen Anatomical Site Name	Anatomical Site Name corresponding to Specimen Code
TRC-D10-C16	Diagnostic Test - Specimen	Specimen Anatomical Site Description	Anatomical Site Description corresponding to Specimen Code
TRC-D11-C01	Diagnostic Test - Medication	Diagnostic Test Code	Code for Diagnostic Test
TRC-D11-C02	Diagnostic Test - Medication	Diagnostic Test Name	Name for Diagnostic Test corresponding to Diagnostic Test Code
TRC-D11-C03	Diagnostic Test - Medication	Diagnostic Test Description	Description for Diagnostic Test corresponding to Diagnostic Test Code
TRC-D11-C04	Diagnostic Test - Medication	Test Date	Test Date corresponding to Diagnostic Test Code - when the patient had the test
TRC-D11-C08	Diagnostic Test - Medication	Medication Code	Code for Medication
TRC-D11-C09	Diagnostic Test - Medication	Medication Name	Name for Medication corresponding to Medication Code
TRC-D11-C10	Diagnostic Test - Medication	Medication Description	Description for Medication corresponding to Medication Code
TRC-D11-C11	Diagnostic Test - Medication	Medication Start Date	Start Date corresponding to Medication Code - when the patient started taking medication
TRC-D11-C12	Diagnostic Test - Medication	Medication End Date	End Date corresponding to Medication Code - when the patient ended taking medication
TRC-D11-C13	Diagnostic Test - Medication	Medication Dosage	Dosage of medication corresponding to Medication Code
TRC-D11-C14	Diagnostic Test - Medication	Dosage UoM	Medication Dosage Units corresponding to Medication Code (in g or mg or whatever the unit systems are specified)
TRC-D16-C01	Procedure - Medication	Procedure Code	Code for Procedure
TRC-D16-C02	Procedure - Medication	Procedure Name	Name for Procedure corresponding to Procedure Code
TRC-D16-C03	Procedure - Medication	Procedure Description	Description for Procedure corresponding to Procedure Code
TRC-D16-C04	Procedure - Medication	Procedure Start Date	Start Date corresponding to Procedure Code - when the procedure/treatment started
TRC-D16-C05	Procedure - Medication	Procedure End Date	End Date corresponding to Procedure Code - when the procedure/treatment ended
TRC-D16-C06	Procedure - Medication	Procedure Type Code	Procedure Type Code used to differentiate procedure groupings by code
TRC-D16-C07	Procedure - Medication	Procedure Type Name	Procedure Type used to differentiate Surgical, Chemotherapy, Radiation, Gene Therapy
TRC-D16-C08	Procedure - Medication	Procedure Type Description	Longer description of Procedure Type and what types of procedures go into it
TRC-D16-C09	Procedure - Medication	Medication Code	Code for Medication
TRC-D16-C10	Procedure - Medication	Medication Name	Name for Medication corresponding to Medication Code
TRC-D16-C11	Procedure - Medication	Medication Description	Description for Medication corresponding to Medication Code
TRC-D16-C12	Procedure - Medication	Medication Start Date	Start Date corresponding to Medication Code - when the patient started taking medication
TRC-D16-C13	Procedure - Medication	Medication End Date	End Date corresponding to Medication Code - when the patient ended taking medication
TRC-D16-C14	Procedure - Medication	Medication Dosage	Dosage of medication corresponding to Medication Code
TRC-D16-C15	Procedure - Medication	Dosage UoM	Medication Dosage Units corresponding to Medication Code (in g or mg or whatever the unit systems are specified)

Facts in the Oracle Health Sciences Cohort Explorer Presentation Catalog

Table B-2 describes the Facts displayed in the OHSCE Presentation Catalog, and their Columns. For each Column, it shows the name of the Column, its description, and the Fact and Group within the Fact that contain the Column. The table is sorted by Group and Column, within Fact. This corresponds to how the Fact columns are organized in the Presentation Catalog, within the Fact folder. Each Fact Column has an ID number, which is provided for cross-reference.

Table B-2 Presentation Catalog - Facts

ID	Topic	Group	Column	Description
TRC-CEF-001	Query Patients	Counts	Count of Patients	Count Patients without any filtering criteria in dashboard prompt 2 (TRC-CEP-002)
TRC-CEF-002	Query Patients	Counts	Count of Specimen	Count of Specimen after Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication, Diagnostic Test, "Filter Patients with specific combinations of Medication-Procedure, Diagnostic Test-Procedure…", Exclusion, Specimen Filtering Criteria
TRC-CEF-003	Summary	Counts	Number of Diagnosed Patients	Count of patients where Diagnosis_reported_date to Diagnosis_End_date overlap “from-to” dashboard prompt period
TRC-CEF-004	Summary	Statistics	% Total Patients	TRC-CEF-003 divided by (count of unique patients where Diagnosis_reported_date to Diagnosis_end_date overlap "from-to" dashboard prompt)
TRC-CEF-005	Summary	Counts	Number of Patients who Consented	Count patients who have Consent Type Name = 'TCC' and (Consent _Start_Date to Consent_End_Date overlap time period specified in prompt)
TRC-CEF-006	Summary	Counts	Number of Patients Successfully Treated	Count of patients who have Diagnosis_End_Date during the time period specified in prompt
TRC-CEF-007	Summary	Counts	Number of Patients Undergoing Treatment	Count of patients where procedure_start_date should happen before the "to" in period specified in prompt, end date after the time period or null
TRC-CEF-008	Summary	Counts	Number of Patients on Medication	Count of patients with a specific diagnosis in 1st column where subadmin_start_date to subadmin_end_date overlap time period specified in prompt
TRC-CEF-009	Summary	Counts	Number of Deceased Patients	Count of patients where Deceased_date is within time period specified in prompt
TRC-CEF-010	Summary	Counts	Surgery Treatment Count	Count of treatments where procedure start date to procedure end date overlaps time period specified in prompt and procedure type name = 'Surgery'
TRC-CEF-011	Summary	Counts	Chemotherapy Treatment Count	Count of treatments where procedure start date to procedure end date overlaps time period specified in prompt and procedure type name = 'Chemotherapy'
TRC-CEF-012	Summary	Counts	Radiation Treatment Count	Count of treatments where procedure start date to procedure end date overlaps time period specified in prompt and procedure type name = 'Radiation'
TRC-CEF-013	Summary	Counts	Targeted (Gene Therapy) Treatment Count	Count of treatments where procedure start date to procedure end date overlaps time period specified in prompt and procedure type name = 'Gene Therapy'
TRC-CEF-014	Summary	Counts	Number of Patients with Ethnicity/Race Demographics Criteria	Count of patients of a given Gender and Age where Diagnosis_Reported_Date is within specified time period; Age should be computed as: Age_in_years - (current date - TOprompt) for patients who have diagnosis reported date in the specified time period
TRC-CEF-015	Summary	Statistics	% Patients with Ethnicity/Race Demographics Criteria	TRC-CEF-014 divided by (count of patients where Diagnosis_Reported_Date is within specified time period)
TRC-CEF-016	Summary	Counts	Number of Patients with Age/Gender Demographics Criteria	Count of patients of a given Gender and Age at the time of Diagnosis_Reported_Date where Diagnosis_Reported_Date is within specified time period; Age can be obtained by Diagnosis_Reported_Date - Birthdate)
TRC-CEF-017	Summary	Statistics	% Patients with Age/Gender Demographics Criteria	TRC-CEF-016 divided by (count of patients where Diagnosis_Reported_Date is within specified time period)
TRC-CEF-018	Summary	Counts	Number of Specimen Collected in Facility	Count of specimen for a given anatomical site and specimen type (1st, 2nd column respectively) where Specimen_Collection_Date is within time period specified in dashboard prompt
TRC-CEF-019	Summary	Counts	Number of Patients Corresponding to Collected Specimen	Count of unique patients who provided specimen in TRC-CEF-018
TRC-CEF-020	Summary	Counts	Number of Patients providing Specimen who Consented	Count of patients from TRC-CEF-019 who have Consent_Type_Name = 'TCC' and Consent_Status_Name = 'Active'
TRC-CEF-021	Query Patients	Counts	Count of patients satisfying selected criteria in the Patient Information tab.	Count of patients satisfying selected criteria in the Patient Information tab.
TRC-CEF-022	Query Patients	Counts	Count of patients satisfying selected criteria in the Patient Information and Protocol tabs.	Count of patients satisfying selected criteria in the Patient Information and Protocol tabs.
TRC-CEF-023	Query Patients	Counts	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History tabs.
TRC-CEF-024	Query Patients	Counts	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis tabs.
TRC-CEF-025	Query Patients	Counts	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment tabs.
TRC-CEF-026	Query Patients	Counts	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication tabs.
TRC-CEF-027	Query Patients	Counts	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test tabs.
TRC-CEF-028	Query Patients	Counts	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure... tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure tabs.
TRC-CEF-029	Query Patients	Counts	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure..., Exclusions tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedureor Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure, Exclusions tabs.
TRC-CEF-030	Query Patients	Counts	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure..., Exclusions, Specimen tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure, Exclusions, Specimen tabs.
TRC-CEF-031	Patient Timelines	Transactional Data	Ongoing Event	Yes or No flag describing whether a given Patient Event is ongoing or not at the present time. Patient Events are any of the following: Procedures or Treatments patient has undergone, Diagnosis, Medications taken, Diagnostic Tests performed, Patient History or Risk Factors, patient Consent, patient Specimen.
TRC-CEF-032	Patient Timelines	Intervals	Duration (days) of Patient Event	How long (in days) Patient Event is going or has gone based on the difference between start and end dates for Procedures/Treatments, Diagnosis, Medications taken, Patient History or Risk Factors (if end date is not specified than current date is used). In case of Diagnostic Tests, Specimen duration is 1 day.
TRC-CEF-033	Patient Timelines	Intervals	Event Timeline Bar Plot	Bar plot showing the Duration (months) on a time scale determined by time range specified in the dashboard prompt in Graph Patient page.
TRC-CEF-034	Patient Timelines	Intervals	Patient Event overlaps Time Period	Whether the from-to time period specified by end user overlaps time ranges for patient events such as: Diagnosis Reported Date through End Date (or present time if End Date is null), Medication Start through End Date (or present time if End Date is null), Procedure Start through End date (or present time if End Date is null), Patient History Start through End Date (or present if null), Patient Consent Start through End date (or present if null), Diagnostic Test Date within time period, Specimen Collection date within time period

Measures in the Oracle Health Sciences Cohort Explorer Presentation Catalog

Table B-3 describes the Measures displayed in the OHSCE Presentation Catalog, and their Columns. For each Measure, it shows the ID, name of the Measure, and its description. The table is sorted by Measure ID. Each Measure Column has an ID number, which is provided for cross-reference.

Table B-3 Presentation Catalog - Measures

Measure ID	Measure Name	Measure Description
TRC-CEM-001	Count of Patients	Count Patients without any filtering criteria in DP-2
TRC-CEM-002	Count of Specimen	Count of Specimen after Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test, "Filter Patients with specific combinations of Medication-Procedure, Diagnostic Test-Procedure…", Exclusion, Specimen Filtering Criteria
TRC-CEM-003	Number of Diagnosed Patients	Count of patients where Diagnosis_reported_date to Diagnosis_End_date overlap “from-to” dashboard prompt period
TRC-CEM-004	% Total Patients	TRC-CEM-003 divided by (count of unique patients where Diagnosis_reported_date to Diagnosis_end_date overlap "from-to" dashboard prompt)
TRC-CEM-005	Number of Patients who Consented	Count patients who have Consent Type Name = 'TCC' and (Consent _Start_Date to Consent_End_Date overlap time period specified in prompt)
TRC-CEM-006	Number of Patients Successfully Treated	Count of patients who have Diagnosis_End_Date during the time period specified in prompt
TRC-CEM-007	Number of Patients Undergoing Treatment	Count of patients where procedure_start_date should happen before the "to" in period specified in prompt, end date after the time period or null
TRC-CEM-008	Number of Patients on Medication	Count of patients with a specific diagnosis in 1st column where subadmin_start_date to subadmin_end_date overlap time period specified in prompt
TRC-CEM-009	Number of Deceased Patients	Count of patients where Deceased_date is within time period specified in prompt
TRC-CEM-010	Surgery Treatment Count	Count of treatments where procedure start date to procedure end date overlaps time period specified in prompt and procedure type name = 'Surgery'
TRC-CEM-011	Chemotherapy Treatment Count	Count of treatments where procedure start date to procedure end date overlaps time period specified in prompt and procedure type name = 'Chemotherapy'
TRC-CEM-012	Radiation Treatment Count	Count of treatments where procedure start date to procedure end date overlaps time period specified in prompt and procedure type name = 'Radiation'
TRC-CEM-013	Targeted (Gene Therapy) Treatment Count	Count of treatments where procedure start date to procedure end date overlaps time period specified in prompt and procedure type name = 'Gene Therapy'
TRC-CEM-014	Number of Patients with Ethnicity/Race Demographics Criteria	Count of patients with a given Ethnicity (or Race if toggled into the 2nd view) where Diagnosis_Reported_Date is within specified time period.
TRC-CEM-015	% Patients with Ethnicity/Race Demographics Criteria	TRC-CEM-014 divided by (count of patients where Diagnosis_Reported_Date is within specified time period)
TRC-CEM-016	Number of Patients with Age/Gender Demographics Criteria	Count of patients of a given Gender and Age where Diagnosis_Reported_Date is within specified time period; Age should be computed as: Age_in_years - (current date - TOprompt) for patients who have diagnosis reported date in the specified time period
TRC-CEM-017	% Patients with Age/Gender Demographics Criteria	TRC-CEM-016 divided by (count of patients where Diagnosis_Reported_Date is within specified time period)
TRC-CEM-018	Number of Specimen Collected in Facility	Count of specimen for a given anatomical site and specimen type (1st, 2nd column respectively) where Specimen_Collection_Date is within time period specified in dashboard prompt
TRC-CEM-019	Number of Patients Corresponding to Collected Specimen	Count of unique patients who provided specimen in TRC-CEM-018
TRC-CEM-020	Number of Patients providing Specimen who Consented	Count of patients from TRC-CEM-019 who have Consent_Type_Name = 'TCC' and Consent_Status_Name = 'Active'
TRC-CEM-021	Count of patients satisfying selected criteria in the Patient Information tab.	Count of patients satisfying selected criteria in the Patient Information tab.
TRC-CEM-022	Count of patients satisfying selected criteria in the Patient Information and Protocol tabs.	Count of patients satisfying selected criteria in the Patient Information and Protocol tabs.
TRC-CEM-023	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History tabs.
TRC-CEM-024	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis tabs.
TRC-CEM-025	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment tabs.
TRC-CEM-026	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication tabs.
TRC-CEM-027	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication, Diagnostic Test tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication, Diagnostic Test tabs.
TRC-CEM-028	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure... tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure... tabs.
TRC-CEM-029	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure..., Exclusions tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure..., Exclusions tabs.
TRC-CEM-030	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure..., Exclusions, Specimen tabs.	Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure/Treatment, Medication, Diagnostic Test, Combinations of Medication-Procedure..., Exclusions, Specimen tabs.
TRC-CEM-031	Ongoing Event	Yes or No flag describing whether a given Patient Event is ongoing or not at the present time. Patient Events are any of the following: Procedures/Treatments patient has undergone, Diagnosis, Medications taken, Diagnostic Tests performed, Patient History/Risk Factors, patient Consent, patient Specimen.
TRC-CEM-032	Duration (days) of Patient Event	How long (in days) Patient Event is going/has gone based on the difference between start and end dates for Procedures/Treatments, Diagnosis, Medications taken, Patient History/Risk Factors (if end date is not specified than current date is used). In case of Diagnostic Tests, Specimen duration is 1 day.
TRC-CEM-033	Event Timeline Bar Plot	Bar plot showing the Duration (months) on a time scale determined by time range specified in the dashboard prompt in Graph Patient page.
TRC-CEM-034	Patient Event overlaps Time Period	Whether the from-to time period specified by end user overlaps time ranges for patient events such as: Diagnosis Reported Date through End Date (or present time if End Date is null), Medication Start through End Date (or present time if End Date is null), Procedure Start through End date (or present time if End Date is null), Patient History Start through End Date (or present if null), Patient Consent Start through End date (or present if null), Diagnostic Test Date within time period, Specimen Collection date within time period. For the purposes of testing functionality, it means that the Start date for each event has to fall within FROM-TO date range.