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 endocrinetherapy:** *Stores data on hormones / endocrine therapy received*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
endocrinetherapy	endocrineregimen	Character	Regimen of the endocrine therapy used	NA
endocrinetherapy	endocrinesetting	Character	Setting in which endocrine therapy was given	Neoadjuvant, Adjuvant, Definitive, Palliative
endocrinetherapy	endocrinestart_date	Date	Start date of endocrine therapy regimen	NA

**Data Base Table Name imagingfeature:** *Feature related to the image noted*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
imagingfeature	enhancement	Boolean	Presence of contrast enhancement	1, 0

**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	epigenetic_result	Character	The result of the test performed as free text	NA

**Data Base Table Name radiotherapy:** *Stores data on radiotherapy received*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
radiotherapy	equipment	Character	Name of equipment in which radiation was delivered	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	expression_result	Character	The result of the test performed as free text	NA

**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 Sort descending	Field Type	Data Stored in Field	Allowed Values
tumordescription	extent	Character	500 character description of the tumor extent. Free text field that allows 500 characters (approx 100 -150 words)	NA

**Data Base Table Name surgery:** *Stores data on surgery done*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
surgery	extent_resection	Character	Extent of resection done	R0, R1, R2, Others

**Data Base Table Name nodalstatus:** The nodal status table has information on the nodal involvement noted in pathology. Please note that this table is not capturing information obtained in radiological evaluation. The table is linked to diagnosis to allow situations where patient has unknown primary with neck nodes. The table is linked to the following tables: diagnosis
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
nodalstatus	extra_nodal_extension	Boolean	If extranodal extension is present	1, 0