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 projectpatientmap: Stores project mapping data for the patient
Database Table Field ID Field Type Data Stored in Field Allowed Values
projectpatientmap patiententrydate Date

Date of patient entry into the project


Data Base Table Name patientinfo: Patient basic demographic information is captured here. Diagnosis data is linked to this. Also links to habits table, familyhistory,mensthistory and survival tables.
Database Table Field ID Field Type Data Stored in Field Allowed Values
patientinfo age Integer

Age of the patient in years.

patientinfo centercode Character

Code of the center in which patient originates

patientinfo date_registered_center Date

De-identified date of registration at the center

patientinfo gender Character

The gender of the patient.

patientinfo mr_number Character

Patient ID corresponding to de-identified id corresponding to imaging dicom ID

patientinfo patientdob Date

De-identified patient date of birth

patientinfo performance_status Character

ECOG Performance Status of the patient. If KPS or another analogous scale used then ideally should be converted to ECOG or added as a separate variable

0, 1, 2, 3, 4, 5

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

This is a field that allows values from a list of anatomic sites.

From Lookup table
diagnosis diagnosis_date Date

Date on which the diagnosis was done. Usually the date when the pathology was obtained first