SUBJHIST

Historical order in a transaction

SUBJTIME

Date when subject change happened

USERID

User ID who made the change

TRANSACTIONID

Transaction ID of this transaction

REASON

Reason for change

SUBJECTID

Subject ID

SUBJECTREV

Subject revision number

FIRSTSUBJECTREV

If the record is the first revision. 1 yes, 0 no

CURRENTSUBJECTREV

If the record is the current revision. 1 yes, 0 no

SITEID

Site ID

SUBJECTINITIALS

Subject Initial

SUBJECTDOB

Subject Date of Birth

SUBJECTDOBVALIDMAP

Internal reserved field

SUBJECTSCREENINGDATE

When subject was screened

SUBJECTSCREENINGDATEVALIDMAP

Internal reserved field

SUBJECTSTATE

Subject State.

1: screened

2: screen failed

3: enrollment failed

4: enrolled

5: randomized

6: complete

7: not complete

SUBJECTSCREENED

If subject is screened. 1 yes, 0 no

SUBJECTSCREENFAIL

If subject is screen failed. 1 yes, 0 no

SUBJECTENROLLFAIL

If subject is enrollment failed. 1 yes, 0 no

SUBJECTENROLLED

If subject is enrolled. 1 yes, 0 no

SUBJECTRANDOMIZED

If subject is randomized. 1 yes, 0 no

SUBJECTCOMPLETED

If subject is complete. 1 yes, 0 no

SUBJECTINCOMPLETE

If subject is incomplete. 1 yes, 0 no

SUBJECTSCREENFAILTEXT

Subject screen failed text

SUBJECTENROLLFAILTEXT

Subject enrollment failed text

SUBJECTENROLLOVERRIDETEXT

Subject enrollment override text

SUBJECTNUMBERREV

Subject Number revision number

SUBJECTNUMBERSTR

Subject number.

CREATEDDATETIME

Date and time when the view row was created.

CREATEDBYUSERID

User ID of the user whose action resulted in the given view row being created.

MODIFIEDDATETIME

Date and time when the data in the view row was most recently updated.

MODIFIEDBYUSERID

User ID of the user whose action resulted in the most recent change to data in the given view row.