SIPASS - UPDATE POLICE DATA WITH BANNER DATA here.

UTS receives data from police SIPASS system, uploads it to table, updates current rows and inserts new rows with data from Banner, transfer data file back to SIPASS system hourly.

Created SZROUPD.SHL file to upload police data to SATURN.SZTOUPD table using SZROUPD.CTL file to set-up table with both found here:

lchesnutt@banjobs5 PROD /banner/PROD/oakdev/student/misc $ vi szroupd.shl

lchesnutt@banjobs5 PROD /banner/PROD/oakdev/student/misc $ vi szroupd.ctl

USE

UC4/Atomic job SZROUPD to run szroupd.shl every hour between 6:20 am and 18:40

USE

Argos data block ‘OU – Police SiPass Master File Update Extract w/view’ which runs to create file that will update data sent from SIPASS and also insert new rows when comparing with Banner data. Runs every hour, once an hour, at the 30 mark of the hour. Sends completed file to GoAnywhere for transfer to SIPASS server.

USE

GoAnywhere uses SiPassArgosToSiPassServer.Template and SiPass.Output.Master project to send file received from Argos to SIPASS server. Job is activated by trigger SiPass - Master – Output immediately once file is put into ARGOS_POLICE folder on GoAnywhere.