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 familyhistory:** *This table stores information on family history*
Database Table	Field ID Sort descending	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	NA
familyhistory	ageatdiagnosis	Integer	Age of the family member at the diagnosis of his/her cancer	NA

**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 Sort descending	Field Type	Data Stored in Field	Allowed Values
patientinfo	age	Integer	Age of the patient in years.	NA

**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	ageatmenopause	Integer	Age at which patient become postmenopausal	NA

**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 Sort descending	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

**Data Base Table Name tumorpathology:** *This table stores information on the pathological information on the tumor. The table is linked to the following table: diagnosis*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
tumorpathology	angioinvasion	Boolean	If angioinvasion is observed in the tumor	1, 0

**Data Base Table Name brachytherapy:** *This table has the data regardiing brachytherapy received by the patient.*
Database Table	Field ID Sort descending	Field Type	Data Stored in Field	Allowed Values
brachytherapy	brachy_is_reirradiation	Boolean	If this schedule of radiation was re-irradiation	1, 0
brachytherapy	brachyapplicator	Character	Applicator used for brachytherapy	NA
brachytherapy	brachyequipment	Character	Name of equipment in which radiation was delivered	NA
brachytherapy	brachyherapy_fractions	Integer	Number of fractions given	NA