Controller's Division
OUS Logo

Banner Data Standards Information

Purpose of Modification

Summary of Modification forPWPCKPG
Version 8.8.A - This is an OUS process that looks for, and flags, all checks within HRIS that have been printed but not cashed. Running the process in 'audit' mode will produce a list of all uncashed checks; running the process in 'purge' mode will cause all such checks to be flagged within the database. Check rows are cancelled in table PHRDOCM: a `Z? is entered into the Recon Indicator and the PURGE DATE is entered into the Recon Date.Version 5.3.a contained changes to the spraddr SQL selection so that multiple addresses and check numbers are no longer included in the report. Version 5.3.c contains changes to the logic that retrieves the address information to eliminate duplicates and retrieve address information in more than one way. Version 8.5.A adds two new parameters to the process; parameter 04 (Inlcuded States) and parameter 05 (Excluded States). This allows the user to run the report only for one or more specified states, or to run it without one or more specified states. The two parameters are optional; if left blank the report will run for all states as it always has in the past. You can not have values in both of these new parameters for one given run of the report. Modifications made to this process in version 8.8.A to automatically "uppercase" the values entered in parameters 03 (Address Type), 04 (Included States), and 05 (Excluded States). The user can enter either lower or upper case in the parameters, and the process will automatically change them to uppercase (if they are lower) so that they can match up correctly with Address Types and State values in Banner.
OUS Index Contacts
Contact: Controller's Division - (541) 737-3636
©Oregon University System, 2006