CHAVI Data Dictionary

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

Select the database table to filter the list.

Field Type

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 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 Sort descending	Field Type	Data Stored in Field	Allowed Values
comorbidity	comorbidity_severity	Character	Severity of the comorbidity	NA
comorbidity	comorbidity_type	Character	Type of comorbidity. The name of the comorbidity is expected	NA

**Data Base Table Name radiotherapy:** *Stores data on radiotherapy received*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
radiotherapy	concurrentchemotherapy	Boolean	If concurrent chemotherapy was used	1, 0
radiotherapy	concurrentmedication	Character	Names of concurrent medication if any used	NA

**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 Sort descending	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 familyhistory:** *This table stores information on family history*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
familyhistory	currentvitalstatus	Character	Whether a patient is alive or dead.	Alive, Dead, Unknown

**Data Base Table Name mensthistory:** *Stores data on menstrual history*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
mensthistory	cycle_duration	Integer	Duration of time each menstrual period lasts in days	NA
mensthistory	cycle_length	Integer	Duration of each menstrual cycle in days	NA
mensthistory	cycle_regularity	Boolean	If the menstrual cycle is regular	1, 0
mensthistory	date_lmp	Date	Date of last menstrual period	NA