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 drugtable:** *Stores data on drugs received by patient. This can include drugs which are anti-neoplastic as well as other drugs but are linked to a specific diagnosis and stage.*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
drugtable	drug_dose_unit	Character	Unit in which drug dose is measured. Please convert all doses to mg or ml for standardization.	milligram, millilitre
drugtable	drug_end_date	Date	Date when drug was stopped or cycles ended.	NA
drugtable	drug_name	Character	Name of the drug used. Please use the generic name.	NA
drugtable	drug_start_date	Date	Date on which the drug was started	NA

**Data Base Table Name recurrence:** This table details the recurrences experienced by the patient for each diagnosis. This table allows the user to store data on tumor responses to therapy also. Since recurrence may occur independently for each diagnosis, the recurrence table is linked to the diagnosis table. The table is linked to the following tables: diagnosis. In this table, recurrence or progression can be entered.
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
recurrence	durationrecurrencefree	Float	Duration of time which the patient was recurrence free. This should be entered in days	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	durationsubstanceusestop	Integer	Duration in years since when substance was last used. Would be 0 in case it is being currently used	NA

**Data Base Table Name imagingfeature:** *Feature related to the image noted*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
imagingfeature	edema	Boolean	Presence of edema in the image	1, 0

**Data Base Table Name endocrinetherapy:** *Stores data on hormones / endocrine therapy received*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
endocrinetherapy	endocrineend_date	Date	End date of endocrine therapy regimen	NA
endocrinetherapy	endocrinegiven	Boolean	If endocrine therapy was given to the patient	1, 0
endocrinetherapy	endocrineintent	Character	Intent of endocrine therapy treatment	Curative, Palliative