Add Approval History to Email Notification

 4 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
JonA
Veteran Member
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
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
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
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
Posts: 1020
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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.