IRV_CUR_SUBJECT
This view contains the most recent information for each subject.
Columns in the IRV_CUR_SUBJECT view
IRV_CUR_SUBJECT |
IRV_CUR_SUBJECT |
---|---|
SUBJECTCOUNT |
Always 1; indicates that the row represents one subject. |
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 |
SDVSELECTEDSTATE |
Form is selected for source verification: 0 - No 1 - Yes |
SUBJECTSCREENED |
Subject is currently Screened: 0 - No 1 - Yes |
SUBJECTEVERSCREENED |
Subject has ever been screened: 0 - No 1 - Yes |
MINSCREEN |
First system screening date for the subject. |
MAXSCREEN |
Most recent system screening date for the subject. |
SUBJECTSCREENFAIL |
Subject is currently Screen Failed: 0 - No 1 - Yes |
SUBJECTEVERSCREENFAIL |
Subject has ever failed screening: 0 - No 1 - Yes |
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. |
SUBJECTENROLLFAIL |
Subject is currently Enrollment Failed: 0 - No 1 - Yes |
SUBJECTEVERENROLLFAIL |
Subject has ever failed enrollment: 0 - No 1 - Yes |
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. |
SUBJECTENROLLED |
Subject is currently Enrolled: 0 - No 1 - Yes |
SUBJECTEVERENROLLED |
Subject has ever been enrolled: 0 - No 1 - Yes |
SUBJECTENROLLDATE |
First system enrollment date for the subject. |
MAXENROLLED |
Most recent system enrollment date for the subject. |
SUBJECTENROLLOVERRIDETEXT |
Enrollment override reason for the subject. |
SUBJECTRAMDOMIZED |
Subject is currently Randomized: 0 - No 1 - Yes |
SUBJECTEVERRAMDOMIZED |
Subject has ever been randomized: 0 - No 1 - Yes |
MINRANDOMIZED |
First system randomization date for the subject. |
MAXRANDOMIZED |
Most recent system randomization date for the subject. |
SUBJECTCOMPLETED |
Subject is currently Complete: 0 - No 1 - Yes |
SUBJECTEVERCOMPLETED |
Subject has ever been complete: 0 - No 1 - Yes |
MINCOMPLETED |
System date when the subject was first completed. |
MAXCOMPLETED |
System date for the most recent time the subject was completed. |
SUBJECTINCOMPLETE |
Subject is currently Not Complete: 0 - No 1 - Yes |
SUBJECTEVERINCOMPLETE |
Subject has ever been Not Complete: 0 - No 1 - Yes |
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. |
COUNTBOOKSIGNED |
Subject CRB has been signed. |
COUNTBOOKFROZEN |
Subject CRB has been frozen. |
COUNTBOOKLOCKED |
Subject CRB has been locked. |
COUNTBOOKSDVREADY |
Subject CRB has been SV Ready. |
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. |