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 the database table to filter the list.
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 surgery: Stores data on surgery done
Database Table Field ID Field Type Data Stored in Field Allowed Values
surgery min_invasive Boolean

If surgery was performed using a mininally invasive technique

 1, 0
Data Base Table Name diagnosis: Links to patient information and has information on the diagnosed disease. All treatment data and recurrence data links to the diagnosis table.
Database Table Field ID Field Type Data Stored in Field Allowed Values
diagnosis laterality Boolean

Laterality of the disease

 Left, Right, Midline, Bilateral, Not Applicable
diagnosis recurrence Boolean

Yes / No field indicating if the diagnosis is of a recurrent cancer

 0, 1
Data Base Table Name habits: This table has information on the substance abuse related habits the patient may have or had in the past. The table is linked again to patientinfo table.
Database Table Field ID Field Type Data Stored in Field Allowed Values
habits currentuseofsubstance Boolean

Is the patient a current user of the substance as on the date of assessment

 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 Data Stored in Field Allowed Values
tumorpathology tumor_deposites Boolean

If tumor deposits are present

 1, 0
tumorpathology necrosis Boolean

If necrosis is observed in the tumor

 1, 0
Data Base Table Name chemotherapy: Stores data on chemotherapy received
Database Table Field ID Field Type Data Stored in Field Allowed Values
chemotherapy chemotherapgiven Boolean

If chemotherapy was given to the patient

 1, 0
Data Base Table Name endocrinetherapy: Stores data on hormones / endocrine therapy received
Database Table Field ID Field Type Data Stored in Field Allowed Values
endocrinetherapy endocrinegiven Boolean

If endocrine therapy was given to the patient

 1, 0
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 Field Type Data Stored in Field Allowed Values
nodalstatus extra_nodal_extension Boolean

If extranodal extension is present

 1, 0
Data Base Table Name radiotherapy: Stores data on radiotherapy received
Database Table Field ID Field Type Data Stored in Field Allowed Values
radiotherapy concurrentchemotherapy Boolean

If concurrent chemotherapy was used 

 1, 0