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 tumordescription:** *This table stores information on the gross description of the tumor as noted in the surgical pathology. The table is also linked to the following tables: diagnosis*
Database Table	Field ID	Field Type	Data Stored in Field	Allowed Values
tumordescription	perforation	Boolean	If the tumor has perforated the viscus from which it has originated	1, 0
tumordescription	tumor_focality	Character	The focality of the tumor - unifocal or multifocal	Unifocal, Multifocal, Multicentric
tumordescription	tumor_maxsize	Float	Maximum size of the tumor - to be recorded in millimeters (mm)	NA
tumordescription	tumor_maxsize_unit	Character	Unit of the measured size	mm
tumordescription	tumor_site	Character	The site of the tumor.	NA

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

**Data Base Table Name fishprofile:** *Stores data on FISH / ISH / CISH done on the tumor*
Database Table	Field ID	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
fishprofile	type_genetic_abnormality	Character	The type of genetic abnormality being tested for example HER2neu gene overexpression	NA