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 stageinformation: Has information on the staging performed. Links to diagnosis
Database Table Field ID Field Type Data Stored in Field Allowed Values
stageinformation recurrentdisease Boolean

Is the staging for recurrent disease. 

 1, 0
stageinformation stagingdone Boolean

Is the staging done for this diagnosis.

 1, 0
stageinformation neoadjuvanttherapygiven Boolean

If neoadjuvant therapy has been given before staging is done

 1, 0
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 mensthistory: Stores data on menstrual history
Database Table Field ID Field Type Data Stored in Field Allowed Values
mensthistory pain_with_periods Boolean

If patient had pain with menstrual periods

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

If necrosis is observed in the tumor

 1, 0
tumorpathology angioinvasion Boolean

If angioinvasion is observed in the tumor

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