EREZLIFE - Banner Interface Program Notes

Problem Description : 

Notes on how to manually run EREZLIFE/BANNER interface

 Resolution : 

DO NOT run the EREZLIFE/BANNER interface program at the top of the hour. The erezlife data table loader scripts runs every hour from 8am to 6pm. Allow time for the table load from erezlife to complete before you run the program.

Run command below as BANINST1 user in Toad or SQL*PLUS....

EXECUTE EREZUSR.P_PROCESS_EREZLIFE_FILE('Y', 'Y', 'Y');

If you want to run it as a test first where it does not actually update Banner, run with the 'T' switches...

EXECUTE EREZUSR.P_PROCESS_EREZLIFE_FILE('T', 'T', 'T');

Parameter Description:

'T' -- will produce report, but not update Banner

'Y' -- will produce report and update Banner

- First switch is Applications

- Second switch is Assignments

- Third switch is Meal Plans

The process will produce 4 reports on Pebbles at /home/oracle/erezlife (login as oracle and cd to location). You can do a more on the files to view them or FTP them down to your PC and open in notepad++.

Reports:

PROCESS_EREZLIFE_status_prod.txt - shows the start and end time of the script and any errors that may have occurred during the run.

SZREREZLIFEAP.txt - student housing applications that were inserted/updated in Banner. Action column will show: 'I' - meaning insert - or 'U' - meaning update - for each record.

SZREREZLIFEAS.txt - student room assignments that were inserted/updated in Banner. For cases where the student had a room plan change, it should show two records for the student - one 'U' status showing the existing record was marked as a 'WR' status and a record right below it with a 'I' status showing the new room plan (with a 'AR' status).

SZREREZLIFEMP.txt - student meal plans that were inserted in Banner. Meal plan updates are not processed by this script. This is a manual process right now.

 Revision Date : 6/29/2017