The date and time the record change, addition, or deletion was made.
TimestampModified
datetime
Timestamp Modified
Same information as the TimestampCreated field.
Version
int(11)
Version
Internal number, always = 0. No reporting value.
Action
tinyint(4)
Action
The addition, update, or deletion action that was taken on the data field.
ParentRecordId
int(11)
Parent Record Id
The unique record ID of the record in the parent table to which the changed record is linked.
ParentTableNum
smallint(6)
Parent Table Num
The number ID or name of the parent table of the record that has been modified. For example if the changed record is in the Collection Object table, this value points to the 'Collection' table.
RecordId
int(11)
Record Id
The unique record ID of the record that was created, changed, or deleted.
RecordVersion
int(11)
Record Version
The internal number used by Hibernate within Specify to keep track of the version of the changed record.