IRV_SUBJECT_STATE_CHANGES

This view contains a history of subject state changes.

Column Name (Key indicator)	Column Description
SUBJECTID (PK)	Numeric identifier for the subject.
SUBJECTREV (PK)	Revision number for the subject.
SUBJECTSTATE	Current subject state.
SUBJECTSTATETIME	Time when the subject state was changed to the current state.
PREVSUBJECTSTATE	Previous subject state.
PREVSUBJECTSTATETIME	Time of previous state change for the subject (NULL if first revision).
NEXTSUBJECTSTATE	Next subject state for the subject.
NEXTSUBJECTSTATETIME	Time of next state change for the subject (NULL if current revision).
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.