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 imagingfeature:** *Feature related to the image noted*
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
imagingfeature	edema	Boolean	Presence of edema in the image	1, 0

**Data Base Table Name stageinformation:** *Has information on the staging performed. Links to diagnosis*
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
stageinformation	stagingdone	Boolean	Is the staging done for this diagnosis.	1, 0
stageinformation	recurrentdisease	Boolean	Is the staging for recurrent disease.	1, 0

**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	Field Type Sort descending	Data Stored in Field	Allowed Values
tumorpathology	perineural_invasion	Boolean	If perineural invasion has been seen in the pathology	1, 0
tumorpathology	grade	Character	The grade of the tumor	NA

**Data Base Table Name immunotherapy:** *Stores data on immunothterapy received.*
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
immunotherapy	immunotherapgiven	Boolean	If immunotherapy was given to the patient	1, 0

**Data Base Table Name comorbidity:** This table allows storage of information on comorbidities that the patient has. As comorbidity grading and classification is variable the table allows multiple comorbidities to be coded separately. The table is linked to the patientinfo table.
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
comorbidity	comorbidity_date_diagnosed	Character	Date on which comorbidity was diagnosed.	NA
comorbidity	comorbidity_duration	Character	Duration for which comorbidity was present in months	NA
comorbidity	comorbidity_severity	Character	Severity of the comorbidity	NA
comorbidity	comorbidity_type	Character	Type of comorbidity. The name of the comorbidity is expected	NA