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.