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:
  • 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

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.