Banner Data Standards Information
Purpose of Modification
|Summary of Modification for GWPZIPL|
This process is run by the Chancellor's Office (Banner Standards Management group) in OSBA only. It reads a file of zip code information from a file that is downloaded from the Zip List 5 vendor's website. The vendor will send ECS programmers new download location and password at the beginning of each quarter. Each quarter, Banner Standards Management (BSM) will contact ECS and request the file to be placed on the target server. ECS will provide BSM with the exact name and directory location of the vendor file because this information is passed to the program via parameters.
GWPZIPL inserts all rows from the vendor file into a collector table (GWRZIPC) and adds a column to each row containing the month and year of the file. This allows historical information to be kept and reviewed.
GWPZIPL then updates GTVZIPC according to the following conditions:
There is an audit and update mode. Audit mode will rollback all database changes and leave the database unchanged.