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 radionucleidetherapy:** *This table has data on the radionuclide therapy received by the patient*
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
radionucleidetherapy	radionuclidetype	Character	Type of radionuclide isotope therapy used	NA

**Data Base Table Name familyhistory:** *This table stores information on family history*
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
familyhistory	famcancertype	Character	The type of cancer the family member had. Typically this would include the site as well as the pathology if available	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	Field Type Sort descending	Data Stored in Field	Allowed Values
habits	substance_unit	Character	Unit in which the quantity is measured	Pack-hours, milligram, millilitre, number
habits	substance_used	Character	Type of substance used	NA

**Data Base Table Name personalhistory:** *Stores data on personal history*
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
personalhistory	marital_status	Character	If patient has been married or not	Married, Widowed, Unmarried

**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	Field Type Sort descending	Data Stored in Field	Allowed Values
recurrence	response	Character	Response to treatment	Complete Response, Partial Response, Stable Disease, Progressive Disease
recurrence	responselocation	Character	Location where response was assessed	Local, Regional, Nodal, Distant, Locoregional
recurrence	responsesystem	Character	Response assessment criteria being used e.g. RECIST, PERCIST	NA
recurrence	recurrencetype	Character	Type of recurrence being documented.	Recurrent disease, Stable Disease, Progressive Disease

**Data Base Table Name epigeneticprofile:** *Stores data on epigenetic alteration profile of the tumor*
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
epigeneticprofile	type_epigenetic_abnormality	Character	The type of epigenetic abnormality being tested for example methylation	NA