Approvals

Columns related to approvals are described below. Data includes information about the approval, its surrounding metadata - visible as well as derived - and the involved participants.

Column name Description Value type

Next step recommendation

The approver’s recommendation for the next approval step after the approval was returned.

String

No. of approvers on following step

The number of approvers at the step following the given action.

Number

No. of approvers on previous step

The number of approvers at the step prior to the given action.

Number

Total no. of steps

The total number of steps in the approval process.

Number

Days to approval deadline

Number of days within office hours until the approval deadline expires.

Number

Final approval

Date and time when the approval was finally approved and thus completed.

Date

First received on step

Indicates whether it is the first time an approval has reached the relevant step.

Boolean

Approval created

Date and time when the approval was created.

Date

Approval turnaround time

Number of minutes an approval is placed with a user before they take an action.

Number

Approval turnaround time in days

Number of days within office hours that an approval is placed with a user before they take an action.

Number

Approval process cancelled

Date and time when the approval was cancelled.

Date

Approval deadline

Date and time of the overall deadline for the approval process.

Date

Approval deadline adherence

Indicates whether the approval was finally approved before the deadline expired.

Boolean

Approval type

The selected approval type.

String

Approver

The name of the approver on the relevant step.

String

Approver’s unit

The relevant approver’s unit.

String

Approver’s role

The relevant approver’s job role in their unit.

String

Approved

Indicates whether the approval has been finally approved.

Boolean

Approved without returning

Indicates whether an approval has gone through the process without being returned or withdrawn.

Boolean

Urgent

Indicates whether the "Urgent" box has been ticked on the approval.

Boolean

Minutes to approval deadline

Number of minutes until the deadline for approval expires.

Number

Orig. time to record deadline after record creation

The original time in minutes from record creation to record deadline.

Number

Orig. time to record deadline after approval creation

The original time in minutes from approval creation to record deadline.

Number

Orig. time to record deadline after approval start

The original time in minutes from approval start to record deadline.

Number

Orig. time to approval deadline after record creation

The original time in minutes from record creation to approval deadline.

Number

Orig. time to approval deadline after approval creation

The original time in minutes from approval creation to approval deadline.

Number

Orig. time to approval deadline after approval start

The original time in minutes from approval start to to approval deadline.

Number

On-behalf-of approver

If a user has approved on behalf of another user, the name of the logged-in user is specified.

String

Resulting step

Indicates which step an approval is sent to as a result of an action.

Number

Resulting step unit

The unit with which the resulting step’s approver is associated.

String

Resulting step name

Name of approvers at the step to which the approval is sent.

String

Resulting step role

The job role of the resulting step’s approver in the unit.

String

Latest received on step

Indicates whether this is the last time an approval has reached this step.

Boolean

Step

The current step in the approval process.

Number

Action step

Indicates which step an approver is at when they perform an action.

Number

Step deadline

Date and time of the deadline set for approvers at a given step.

Date