Identifying keys
The following table describes the identifying keys in the InForm database and their corresponding names in the Reporting and Analysis database.
Object type, InForm key name, Reporting and Analysis key name, and originating view for identifying keys
Object type |
InForm key name |
Reporting and Analysis key name |
Originating view |
---|---|---|---|
Sponsor |
SponsorID |
SponsorID |
IRV_CUR_SPONSOR |
Study |
VolumeID |
StudyID |
IRV_STUDYVERSIONS |
Study version |
VolumeEditionID |
StudyVersionID |
IRV_STUDYVERSIONS |
Site |
SiteID |
SiteID |
IRV_CUR_SITE |
User |
UserID |
UserID |
IRV_CUR_USER |
Visit |
ChapterID |
VisitID |
IRV_VISIT_REVS |
Visit instance |
ChapterIndex |
VisitIndex |
IRV_SV_SUBJECTVISIT |
Form |
PageID |
FormID |
IRV_FORM_REVS |
Form instance |
PageIndex |
FormIndex |
IRV_AF_SUBJECT_FORMS |
Section |
SectionID |
SectionID |
IRV_SECTION_REVS |
Item |
ItemID |
ItemID |
IRV_ITEM_REVS |
Itemset |
ItemsetID |
ItemsetID |
IRV_ITEMSET_REVS |
Itemset instance |
SetItemOrder |
ItemsetIndex |
IRV_FORM_ITEMS |
Control |
ControlID |
ControlID |
IRV_CONTROL_REVS |
Subject |
PatientID |
SubjectID |
IRV_CUR_SUBJECT |
Subject visit |
SubjectChapterID |
SubjectVisitID |
IRV_SV_SUBJECTVISIT |
Subject form item |
ContextID |
ContextID |
IRV_FORM_ITEMS |
Query |
QueryID |
QueryID |
IRV_CUR_QUERY |
Comment |
CommentID |
CommentID |
IRV_CUR_COMMENT |
Rule |
RuleID |
RuleID |
IRV_CUR_RULE |
Rule item |
RuleItemID |
RuleItemID |
IRV_CUR_RULEITEM |