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.
Columns in the IRV_CUR_SUBJECT_DIM view
IRV_CUR_SUBJECT_DIM |
IRV_CUR_SUBJECT_DIM |
---|---|
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:
|
SUBJECTSTATE |
Numeric value for the subject state: 1 - Screened |
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. |