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 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 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 Data Stored in Field Allowed Values
comorbidity comorbidity_present Boolean

If comorbidity type is present

 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 recurrence Boolean

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

 0, 1
Data Base Table Name personalhistory: Stores data on personal history
Database Table Field ID Field Type Data Stored in Field Allowed Values
personalhistory immunizationstatus Boolean

If patient has been immunized

 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 perineural_invasion Boolean

If perineural invasion has been seen in the pathology

 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 immunotherapy: Stores data on immunothterapy received.
Database Table Field ID Field Type Data Stored in Field Allowed Values
immunotherapy immunotherapgiven Boolean

If immunotherapy was given to the patient

 1, 0
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 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
Data Base Table Name targetedtherapy: Stores data on targeted therapy received
Database Table Field ID Field Type Data Stored in Field Allowed Values
targetedtherapy targetedtherapgiven Boolean

If targeted therapy was given to the patient

 1, 0