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