IRV_CUR_SUBJECT
This view contains the most recent information for each subject.
Column Name (Key indicator) | Column Description |
---|---|
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 2 - Screening Failure 3 - Enrollment Failure 4 - Enrolled 5 - Randomized 6 - Completed 7 - Dropped Out |
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. |
Parent topic: Study objects and administrative data