Add Approval History to Email Notification

 4 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member

One of our medical center presidents asked if he could see who has approved a requisition before him in the email notification.  He's at the top level (level 5) so he would like to see who approved at levels 1-4.  I've been able to add the history to the notification email by adding this...

 

 

 


 

Which looks like this

APPROVER ACTIONS
Level 1 approved by M123450
Level 2 approved by A95687
Level 3 approved by O159757
Level 4 approved by J76213

But the problem is that our user id format is [First character of birth month] + [Employee number] so it doesn't really tell who that person is.  How do I pull in the first and last name of the approvers?

Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
kflores01
Veteran Member Send Private Message
Posts: 43
Veteran Member
Assuming the IDs exist in LSF, use the Resource Node to retrieve First and Last Name. We retrieve a variety of LSF information for multiple processes and reports.
Charlotte
Basic Member Send Private Message
Posts: 6
Basic Member
This sounds similar to an IPA tip given by RPI Consultants in one of their webinars. ....consider checking out http://www.rpic.com/webinars/
kflores01
Veteran Member Send Private Message
Posts: 43
Veteran Member
If the approval information was processed by IPA and not purged, then the history is in the various Process Flow tables / files.
Kat V
Veteran Member Send Private Message
Posts: 1020
Veteran Member
User Name should be in the ipa user table. We're pulling ours to make comments like "Approved by Kat Vila on 12/5/2017 14:37:59" - it has my name not "kvila" We are not deliberately bringing it in as a variable as far as I can see.