With the onset of the Training Reconciliation application, SAP is now the list of record for all PI/Supervisors with regards to training affiliation. Each PI/Supervisor has a corresponding PI work area object in SAP.Each PI work area is linked to a parent DLC work area. If a PI/Supervisor is affiliated with multiple DLCs, there will be multiple PI work areas for that PI/Supervisor. A PI work area is created for every Roomset PI/Supervisor or Roomset Secondary PI/Supervisor relationship in SAP. If there is a need for a PI/Supervisor who has absolutely no relationship to a roomset (this is rare) a PI work area can manually be created within the SAP GUI.

Before the Training Reconciliation app was in place, EHS Web was the system of record for PI/Supervisors with regards to training affiliation. EHS Web included room secondary PIs on its PI lists for  training reports, leading to a discrepancy between the PI/Supervisor lists between SAP and EHS Web. The root of this bug was in the database view ehs_short_pi_list. This database view has been modified to use the ehs_sap_pi_list, which is fed from the PI workarea list in SAP. This test script shows that the PI/Supervisor lists are now in sync between the two systems.

777499 PI List on Training Reports Test Script 

List of PI/Supervisors in Brain & Cognitive Services in SAP (production)

 

PI/Supervisor list from Training Report 3 in test before the database change. Note that Carlos Lois, a room secondary PI for B & CS, is listed as a PI in the dev system, but is not listed under Training Reconciliation. 

 

PI/Supervisor list from Training Report 3 in test after the database view has been modified. Note that Carlos Lois does not appear in this list.

 

  • No labels