Banner Standards Management
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.

[Return to All Modifications List]

[Return to Banner Standards Management Main Page]

[
Return to Controller's Division Table of Contents]


Contact: Controller's Division Barb_Childers@ous.edu
URL: http://www.ous.edu/cont-div/bsfs/hrvermgt.htm

Page Top