Previous Topic: View_Act_Log

Next Topic: View_Audit_Group

View_Audit_Assignee

The following is an advanced view of the audit log where assignee is tracked. This view shows the duration of time between assignee changes for every request and change order. Requests or change orders that are changed from a particular assignee to a null assignee, and then from null assignee back to a particular assignee, do not have the duration of the null assignee listed in this view. 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 log object unique id representing the chg.id or the call_req.id.

from_val

audit_log.attr_after_val: The ‘changed from’ assignee value.

to_val

audit_log.attr_after_val: The ‘changed to’ assignee value.

from_time

audit_log.attr_from_time: The beginning time an assignee was assigned (pdmtime).

to_time

audit_log.attr_from_time: The ending time the same assignee was assigned (pdmtime).