Banner Standards Management
Purpose of Modification


Summary of Modification for PWPBXFR

PWPBXFR (8.5.A) - This OUS-developed process extracts employee biographic information from OUS Banner instances so that these changes can then be transferred to the OWAG Payroll Aggregate data warehouse (FYI - the process used to make this actual transfer is called PWPGRAB). The program selects the employee address from SPRADDR based on the Address Type hierarchy as defined in Banner form GTVSDAX. The Address Type information in GTVSDAX is grouped by a field called Internal Code. Within the Internal Code of GTVSDAX you can store multiple Address Types where each Address Type gets assigned a priority sequence number (i.e. 1, 2, 3 etc.). The PWPBXFR program will look for the Internal Code CHECKADDR in GTVSDAX and will select the Address Type assigned to sequence 1 first. It will take the Address Type assigned to sequence 1 and will search for an employee address in SPRADDR that has that Address Type. Whatever it retrieves will be transferred to the OWAG Payroll Aggregate data warehouse. If it does not find an address in SPRADDR for that employee with that Address Type then it will go to sequence 2 in CHECKADDR and will go through the same process of searching for an address in SPRADDR for that employee that has that Address Type. Whatever it finds will be be transferred to the OWAG Payroll Aggregate data warehouse. The program will continue to cycle through this process by sequence number until it finds an employee address in SPRADDR that has an Address Type that matches an Address Type in the CHECKADDR Internal Code hierarchy of GTVSDAX.

[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