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

Type of staging system followed. e.g. AJCC stage, FIGO stage

stageinformation stagingtype Character

Type of staging performed. For example is it clinical / pathological

clinical, pathological, postnact-pathological, recurrent, others
stageinformation tstage Character

T stage without the t prefix (and with the additional suffix after number)


Data Base Table Name familyhistory: This table stores information on family history
Database Table Field ID Field Type Data Stored in Field Allowed Values
familyhistory affectedfammember Character

The relationship of the affected family member with malignancy e.g. father or mother

familyhistory ageatdiagnosis Integer

Age of the family member at the diagnosis of his/her cancer

familyhistory currentvitalstatus Character

Whether a patient is alive or dead. 

Alive, Dead, Unknown
familyhistory famcancertype Character

The type of cancer the family member had. Typically this would include the site as well as the pathology if available


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

Date on which comorbidity was diagnosed.

comorbidity comorbidity_duration Character

Duration for which comorbidity was present in months

comorbidity comorbidity_present Boolean

If comorbidity type is present

1, 0