Previous Topic: View_Audit_Priority

Next Topic: View_Change_Act_Log

View_Audit_Status

The following is an advanced view of the audit log where status is tracked. This view shows the duration of time between status changes for every request and change order. This view lists the following fields for both requests and change orders. There may be more than one entry for each audobj_uniqueid (request or change order).

Field

Remarks

audobj_uniqueid

audit_log.audobj_uniqueid: The audit object unique id, which represents a request call_req.id or change order chg.id.

from_val

audit_log.attr_after_val: The ‘changed from’ value of priority.

to_val

audit_log.attr_after_val: The ‘changed to’ value of priority.

from_time

audit_log.attr_after_time: The beginning time status was in a particular state (pdmtime).

to_time

audit_log.attr_after_time: The ending time status was in the same state (pdmtime).