IRV_CUR_SUBJECT_DIM

This view is a subset of IRV_CUR_SUBJECT. It contains the most recent attributes for each subject; it does not contain facts or measures.

Column Name (Key indicator)	Column Description
SUBJECTID (PK)	Numeric identifier for the subject.
SUBJECTREV	Revision number for the subject.
SUBJECTNUMBERSTR	Subject number.
SUBJHIST	Subject HISTORICALORDER.
SUBJTIME	Date and time when the subject was last modified.
USERID	Numeric identifier for the user who last modified the subject information.
TRANSACTIONID	Numeric identifier for the transaction that last modified the subject information.
SITEID	Numeric identifier for the site to which the subject is assigned.
SITEREV	Revision number for the site with which the subject is associated.
STUDYVERSIONID	Numeric identifier for the study version associated with the subject's site.
SUBJECTINITIALS	Subject initials.
SUBJECTDOB	Subject date of birth.
SUBJECTDOBVALIDMAP	Indicates valid date components that comprise the date of birth. Sum of the following values for each valid date part: Year (0x01) 1, Month (0x02) 2, Day (0x04) 4, Hour (0x08) 8, Minute (0x10) 16, Second (0x20) 32.
SUBJECTSCREENINGDATE	Subject screening date.
SUBJECTSCREENINGDATEVALIDMAP	Indicates valid date components that comprise the screening date. Sum of the following values for each valid date part: Year (0x01) 1, Month (0x02) 2, Day (0x04) 4, Hour (0x08) 8, Minute (0x10) 16, Second (0x20) 32.
CURSUBJECTSTATUSTIME	Time the subject state was last changed.
SUBJECTSTATETEXT	Text value description of subject state: Screened Screening Failure Enrollment Failure Enrolled Randomized Completed Dropped Out
SUBJECTSTATE	Numeric value for the subject state: 1 - Screened 2 - Screening Failure 3 - Enrollment Failure 4 - Enrolled 5 - Randomized 6 - Completed 7 - Dropped Out
MINSCREEN	First system screening date for the subject.
MAXSCREEN	Most recent system screening date for the subject.
MINSCREENFAIL	First system screening failure date for the subject.
MAXSCREENFAIL	Most recent system screening failure date for the subject.
SUBJECTSCREENFAILTEXT	Screening failure reason for the subject.
MINENROLLFAIL	First system enrollment failure date for the subject.
MAXENROLLFAIL	Most recent system enrollment failure date for the subject.
SUBJECTENROLLFAILTEXT	Enrollment failure reason for the subject.
SUBJECTENROLLDATE	First system enrollment date for the subject.
MAXENROLLED	Most recent system enrollment date for the subject.
SUBJECTENROLLOVERRIDETEXT	Enrollment override reason for the subject.
MINRANDOMIZED	First system randomization date for the subject.
MAXRANDOMIZED	Most recent system randomization date for the subject.
MINCOMPLETED	System date when the subject was first completed.
MAXCOMPLETED	System date for the most recent time the subject was completed.
MINNOTCOMPLETED	First system dropout date for the subject.
MAXNOTCOMPLETED	Most recent subject dropout date for the subject.
BOOKSIGNED	Date subject CRB was signed.
BOOKFROZEN	Date subject CRB was frozen.
BOOKLOCKED	Date subject CRB was locked.
BOOKSDVREADY	Date subject CRB was ready for source verification.
CREATEDBYUSERID	User ID of the user whose action resulted in the given view row being created.
CREATEDBYDATETIME	Date and time when the view row was created.
MODIFIEDBYUSERID	User ID of the user whose action resulted in the most recent change to data in the given view row.
MODIFIEDDATETIME	Date and time when the data in the view row was most recently updated.