Naming conventions

The Reporting and Analysis database uses the following naming conventions for schema objects:

Prefix Schema object type
CV_ Subject data view (clinical view).
DI_ Form and itemset clinical view with date and state information.
DV_ Views used for the Data Viewer.
CD_ Clinical data and metadata for form controls.
CT_ Clinical data table.
IRV_ View.
IRV_MD View of study design metadata.
RT_ Table.
IRI_ Index.
IRC_ Constraint.
PF_ Table replicated from the Oracle InForm database.

The Reporting and Analysis database is closely tied to the Oracle InForm study database. However, many of the items in the Oracle InForm database have different names in the Reporting and Analysis database, as shown in the following table.

Object type MedML type Oracle InForm database name Reporting and Analysis database name
Study N/A Volume Study
Study Version StudyVersion VolumeEdition StudyVersion
Visit FormSet VEChapter StudyVersionVisit
Visit N/A Chapter Visit
Form Form VEChapterPage StudyVersionForm
Form N/A Page Form
Subject N/A Patient Subject
Subject Visit N/A SubjectVEChapter SubjectVisit