OPS_REPORTING_ENTY_STATUS

The Operations Reporting Entity Status table records the state of the data transformation. It indicates the last entity that was transformed and when that transformation took place. This is an essential housekeeping table for the FlexNet Operations reporting database, but is not intended to be queried by users generating reports.

Operations Reporting Entity Status Columns

Columns	Type	Length	Description
ID	numeric	19	A 19-digit unique identifier of the entity status record.
NAME	character	128	A name associated with the entity last updated as part of the data transformation job.
LAST_ENTITY_UPDATED	datetime		The date and time when the entity identified by the LAST_ENTITY_ID value was updated. This value indicates when the data transformation job ended.
LAST_ENTITY_ID	numeric	19	A 19-digit unique identifier of the last entity updated when the data transformation job ran.