Controller's Division
OUS Logo

Banner Data Standards Information

Purpose of Modification

Summary of Modification for PEFORGL
Version 4.1.a - This is an SCT Banner baseline stored function, used in job submission report PERORGC. The function returns a numeric value, indicating the seniority level of an employee's job as it relates to the organizational chart. The function is associated with the nbrjobs_supervisor field, and returns the value based on a pidm, posn, suffix and effective date. OUS has modified this function as follows: 1) Added 'prev_' variables to hold pidm, posn and suff values of the previous row retrieved. 2) Added test to see if current row and prior row are the same values. If so, Oracle found the same row a second time (due to the row containing a supervisor pidm that is the same as the employee pidm). Modified code to ensure exit in this situation to avoid infinite looping.
OUS Index Contacts
Contact: Controller's Division - (541) 737-3636
©Oregon University System, 2006