Naming conventions
The Reporting and Analysis database uses the following naming conventions for schema objects:
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 InForm database. |
The Reporting and Analysis database is closely tied to the InForm study database. However, many of the items in the InForm database have different names in the Reporting and Analysis database, as shown in the following table.
Object name correspondence between InForm and Reporting and Analysis
Object type |
MedML type |
InForm database name |
Reporting and Analysis database name |
---|---|---|---|
Study |
|
Volume |
Study |
Study Version |
StudyVersion |
VolumeEdition |
StudyVersion |
Visit |
FormSet |
VEChapter |
StudyVersionVisit |
Visit |
|
Chapter |
Visit |
Form |
Form |
VEChapterPage |
StudyVersionForm |
Form |
|
Page |
Form |
Subject |
|
Patient |
Subject |
Subject Visit |
|
SubjectVEChapter |
SubjectVisit |