IRV_SUBJECT_REVS

This view contains subject revision information.

Column Name	Description
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.