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  |