IRV_SUBJECT_STATE_CHANGES
This view contains a history of subject state changes.
Columns in the IRV_SUBJECT_STATE_CHANGES view
IRV_SUBJECT_STATE_CHANGES |
IRV_SUBJECT_STATE_CHANGES |
---|---|
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. |