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

**Data Base Table Name radiotherapy:** *Stores data on radiotherapy received*
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
radiotherapy	radiotherapy_fractions	Integer	Number of fractions of radiotherapy given	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	ageatdiagnosis	Integer	Age of the family member at the diagnosis of his/her cancer	NA

**Data Base Table Name brachytherapy:** *This table has the data regardiing brachytherapy received by the patient.*
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
brachytherapy	brachyherapy_fractions	Integer	Number of fractions given	NA

**Data Base Table Name nodalstatus:** The nodal status table has information on the nodal involvement noted in pathology. Please note that this table is not capturing information obtained in radiological evaluation. The table is linked to diagnosis to allow situations where patient has unknown primary with neck nodes. The table is linked to the following tables: diagnosis
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
nodalstatus	nodes_positive	Integer	Number of nodes found positive in the pathology specimen	NA
nodalstatus	nodes_itc	Integer	Number of nodes with isolated tumor cells found in pathology	NA
nodalstatus	nodes_micromets	Integer	Number of nodes with micrometastases in pathology	NA

**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	radionuclidecycles	Integer	Number of time when radionuclide therapy was delivered	NA

**Data Base Table Name immunotherapy:** *Stores data on immunothterapy received.*
Database Table	Field ID	Field Type Sort descending	Data Stored in Field	Allowed Values
immunotherapy	immunotherapycycles	Integer	Number of cycles of immunotherapy received	NA