define approval_set field on the RITM form.

[sharley]

Hi,

I am looking for the definition and usage on the approval_set field on the RITM table.

Also, what type of value does it auto-populate and from where is that value being captured from.

Thanks,

[Tanushree Maiti]

Hi @sharley 

approval_set is field of task table and inherited to child table like in RITM table.

This should be populated with a date/time when a record has been approved.

Refer:

https://www.servicenow.com/community/itsm-forum/how-to-report-on-time-to-approve-requests/m-p/739380

[PoonkodiS]

@sharley 

The approval_set field on the RITM table is an inherited Task field used to track the exact moment a request's approval is resolved.

 Details

• Definition: A field that timestamps when an approval is finalized.
• Usage: Used for reporting and calculating approval 
• Value Type: Date/Time (YYYY-MM-DD HH:MM:SS).
• Source: Auto-populated from the system clock the exact second an approval record (sysapproval_approver) switches to Approved or Rejected.
• Trigger: Handled automatically by the out-of-the-box "Stamp Approvals" Business Rule.

[Divya Rajasekar]

Definition: It captures the timestamp of the approval action.

Type: Date/Time

Captured From: The system captures the current Date/Time (gs.nowDateTime() or gs.nowGlideDateTime()) the moment an action is taken on the related approval record (from the sysapproval_approver table).