CHAVI Data Dictionary

This page has the list of all fields in the CHAVI database.

CHAVI hosts a wealth of clinical data related to the patients from whom the images have been obtained. This data is available in a relational database which allows you to construct complex queries to search the image data. Thus not only can you access this data of the dataset as a whole but you can also access data across different projects. The database architecture is described in the database page. This page has the list of all available database fields for which clinical data may be available. Please note that data in all fields may not be available for all patients.

Please note that this is the data dictionary and to search the available data you need credentials for the CHAVI repository

You can filter the list by the database table, field type as well as search for text keywords related to the field.

Select Database Table

Select the database table to filter the list.

Field Type

Choose the field type to filter the list.

Data Stored

Please enter one or more keywords to search and filter the list

**Data Base Table Name familyhistory:** *This table stores information on family history*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
familyhistory	famcancertype	Character	The type of cancer the family member had. Typically this would include the site as well as the pathology if available	NA

**Data Base Table Name fishprofile:** *Stores data on FISH / ISH / CISH done on the tumor*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
fishprofile	fish_result	Character	The result of the test performed as free text	NA
fishprofile	gene_tested	Character	The name of the gene tested with FISH	NA

**Data Base Table Name patientinfo:** *Patient basic demographic information is captured here. Diagnosis data is linked to this. Also links to habits table, familyhistory,mensthistory and survival tables.*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
patientinfo	gender	Character	The gender of the patient.	FEMALE, MALE, TRANSGENDER

**Data Base Table Name mutationprofile:** *Stores data on mutations in the genes in the tumor*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
mutationprofile	gene_tested	Character	The name of the gene tested for mutation	NA

**Data Base Table Name epigeneticprofile:** *Stores data on epigenetic alteration profile of the tumor*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
epigeneticprofile	gene_tested	Character	The name of the gene tested for epigenetic abnormalities	NA

**Data Base Table Name expressionprofile:** *Stores data on gene expression profile of the tumor*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
expressionprofile	gene_tested	Character	The name of the gene tested for expression changes	NA

**Data Base Table Name tumorpathology:** *This table stores information on the pathological information on the tumor. The table is linked to the following table: diagnosis*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
tumorpathology	grade	Character	The grade of the tumor	NA
tumorpathology	histological_type	Character	The histological type of the tumor. Typically has additional information as compared to the pathology field in diagnosis.	NA

**Data Base Table Name ihcprofile:** *Stores data on IHC profile of the tumor*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
ihcprofile	ihc_result	Character	The result of the test performed as free text	NA