SAPRD89 - ROLLA

TIDAL JOB NAME / NAVIGATION / RUN CONTROL / DEPENDENCIES / Special Instructions /
Bio_Demo
UM_CC_2659_ROLLA –
(Application Engine)
UM Sync Trigger Check / UM Processes and Reports > UM Bio-Demo Sync > UM Sync Trigger Check / UM_CC_2659_ROLLA / Hourly from 8 AM – 5 PM
Workdays / Send email notification to Lance Barber, Rita Ellebracht, Joan Goodwin and UM – Production Control.
Persdata
HR_PERSDATA (APPLICATION ENGINE)
RUN PERSONAL DATA UPDATE PROCESS – / Set Up HRMS, System Administration, Database Processes, Update Personal Data-Future / HR_PERSDATA / 11:00 PM Submit Time / Nightly. This process will part of the HR and SA/Student Records Process Scheduling when those applications/modules go live. This only needs to be run once each night.
USCC0041_ROLLA – (SQR Report) Update PS_NAMES and PS_PERSONAL_DATA Tables / UM Processes and Reports > UM Campus Community > Correct Names / USCC0041_ROLLA / HR_PERSDATA (SAPR89 Instance) / Night Call Not Necessary. Send email notification to Jim Givens, Bharath Srinivasan and UM – Production Control.
USCC0042_ROLLA – (SQR Report) Remove Special Characters in LAST_NAME_SRCH and FIRST_NAME_SRCH fields in PS_NAMES and PS_PERSONAL_DATA Tables / UM Processes and Reports > UM Campus Community > Correct Names / USCC0042_ROLLA / USCC0041_ROLLA (Completed) / Night Call Not Necessary. Send email notification to Jim Givens, Bharath Srinivasan and UM – Production Control.
Index_Packing
PROCESS – USAD0210 - SQR Run Scholarship Index and Packaging / UM Processes and Reports > UM Admit and Recruit > Early Award Scholarships > UM Scholarship Award / USAD0210_ROLLA / 6:00 PM Submit Time
First Logic
PROCESS – FLADDRHED_ ROLLA – (Application Engine) First Logic Batch Address Cleanse. This job is run on the PSNT server. / Data Quality > Process > Batch Address Cleanse > / FIRST_LOGIC
Run Control Set Up:
Record (table) to Process:
Addresses
Record Filter Options
Process Addresses Previously Cleansed:
Box Checked
Cleanse Inactive Address:
Box Blank
Last Name Range:
Box Blank
Cleanse Addresses Added or Modified Since:
Date updated by USSR0495
Exclude Address Types:
DEGR Degree
DORM Residential Life
FAXH Fax-Home
FAXU Fax-UM
FAXW Fax-Work(non UM)
SEVS SEVIS
UMWK UM-Work
UMGO Geographic Origin / USAD7000_ROLLA / DO NOT run USSR0495_ROLLA if FLADDRHED_AE abends.
If the log file indicates this error: Caught exception while attempting to communicate with Firstlogic IQ then an email should be sent to the UM - ASP Database Team because there is a communication problem between the SAPRD89* instance and the FirstLogic server.
In case of error, send an email to Wende Waltz, Sarabeth Rhodes, Jim Givens and Production Control
PROCESS – USSR0495_ROLLA – (Application Engine) First Logic Run Control Update. Updated with a +1 date (update to next days date)
Starts on 10/01/2007 / Data Quality > Process > Batch Address Cleanse > / FIRST_LOGIC / FLADDRHED_ ROLLA / Nightly
Run Control Set Up:
Record (table) to Process:
Addresses
Record Filter Options
Process Addresses Previously Cleansed:
Box Checked
Cleanse Inactive Address:
Box Blank
Last Name Range:
Box Blank
Cleanse Addresses Added or Modified Since:
Date updated by USSR0495
Exclude Address Types:
Dorm Residential Life
FAXH Fax-Home
FAXU Fax-UM
FAXW Fax-Work(non UM)
UMGO Geographical Origin
UMWK UM-Work
UMGO Geographic Origin

Assign Communications

/ / / Nightly
3CENGINE R-COMM-SCHOL-LETTERS / Campus Community > Communications > Run 3C Engine / R-COMM-SCHOL-LETTERS / USAD0210_ROLLA / MUST BE RUN BEFORE MIDNIGHT
Starting scheduling again on 9/20/2006 per Jennifer Bayless.
Update Checklist – CCITMUPD (SQR)
CCITMUPD_ACT / Campus Community > Checklists > Process Checklists > Item Update - Automated / CCITMUPD_ACT / Assign Communication Group
CCITMUPD_GRE / Campus Community > Checklists > Process Checklists > Item Update - Automated / CCITMUPD_GRE / CCITMUPD_A
CCITMUPD_SAT / Campus Community > Checklists > Process Checklists > Item Update - Automated / CCITMUPD_SAT / CCITMUPD_B
CCITMUPD_TOEFL / Campus Community > Checklists > Process Checklists > Item Update - Automated / CCITMUPD_TOEFL / CCITMUPD_C
CCITMUPD_TRANSCRIPTS / Campus Community > Checklists > Process Checklists > Item Update - Automated / CCITMUPD_TRANSCRIPTS / CCITMUPD_D
SA_HR_Synchronization
USHR009B / UM Processes and Reports > UM Campus Community > UM Synchonize Bio/Demo w/HRMS / USHR009B / 6:00 PM
Residential_Life
USRL1200_ROLLA_FS / Home > UM Process andReports> UM Residential Life> Export for Judicial Officer / USRL1200_ROLLA_FS / 3:00 AM
Workdays – Holiday processing – next working day / Send email to Claire Major and Sandy Weisman
Try resubmitting this job in 30 minutes. The job normally runs when resubmitted. We are thinking the problem is a contention problem with a table.
USRL2001_ROLLA / UM Process and Reports > UM Residential Life > RL/CC Processing (Bio/Demo) > SIS External Lookup Extract / USRL2001_ROLLA / Successful completion of USRL3000_ROLLA and USRL4001_ROLLA. This job has a 5 AM submit time. / No night call necessary. If the abend is caused by a database connectivity error,
rerun the job when connectivity is restored. Send an email to UM DoIT EAS Student Res Life, UM Production Control.
USRL3000_APTS / UM Process and Reports > UM Residential Life > PS Bill Export > Find an Existing Value / USRL3000_APTS
Run Control Set Up:
Residence Hall Database: Box Unchecked
Apartment Database:
Box Checked
Academic Institution: Auto
Term: Auto / 7:15 PM submit time, Job must run after USRL4000 (true dependency). If USRL4000 is skipped for the evening, please skip USRL3000_APTS and USRL3000_HALLS as well. / Call Claire Major for all abends (573) 882-6243) work phone number or (573) 489-7863 home phone number. Send an email to UM DoIT EAS Student Res Life, UM Production Control.
USRL3000_HALLS / UM Process and Reports > UM Residential Life > PS Bill Export > Find an Existing Value / USRL3000_HALLS
Run Control Set Up:
Residence Hall Database: Box Checked
Apartment Database:
Box Unchecked
Academic Institution: Auto
Term: Auto / 7:15 PM submit time, Job must run after USRL4000 (true dependency). If USRL4000 is skipped for the evening, please skip USRL3000_APTS and USRL3000_HALLS as well / Call Claire Major for all abends (573) 882-6243) work phone number or (573) 442-2378 home phone number. Send an email to UM DoIT EAS Student Res Life, UM Production Control.
USRL4000_ROLLA / UM Process and Reports > UM Residential Life > RL/SR Processes (Registration) > UM RL ID Verify / USRL4000_ROLLA / 5:15 PM submit time, USRL1000_ROLLA completed normally or abnormally, USRL1000_ROLLA is not a true dependency. / In case of error, skip processing for the evening (unless it’s a DB error, then feel free to rerun the process from the beginning when ADB access is restored). No night call necessary. Send an email to UM DoIT EAS Student Res Life, UM Production Control.
USRL4001_ROLLA / UM Process and Reports > UM Residential Life > RL/SR Processes (Registration) > UM RL Data Import / USRL4001_ROLLA / 5:00 AM submit time, USRL4000_ROLLA completed normally, USRL4000_ROLLA is a true dependency. / If the abend is caused by a database connectivity error, then rerun the job when connectivity is restored. If the problem is a program or data error, just leave the job to EAS personnel to fix during regular business hours. If problems prevent the running of the job until close to 7:00 AM, remove job from queue.
USRL2004_ROLLA / UM Process and Reports > UM Residential Life > RL/CC Processes (Bio Demo) > UM RL RESLIFE Address Export / USRL2004_ROLLA / USRL4000_ROLLA completed
UMAE2349_STLOU completed / If problem is due to Connection error then just rerun this job when Connection problem is resolved. If problem is due to a Data error call Claire Major at 573-489-7863. If you can’t get in contact with Claire Major then call Sandy Weisman at 573-884-7830. Send an email to UM DoIT EAS Student Res Life, UM Production Control.
USRL4005_ROLLA / UM Process and Reports > UM Residential Life > RL/SR Processes (Registration) > UM AL ID Verify / USRL4000_ROLLA / 5:15 PM submit time / In case of error, skip processing for the evening (unless it’s a DB error, then feel free to rerun the process from the beginning when ADB access is restored). No night call necessary. Send an email to UM DoIT EAS Student Res Life, UM Production Control.
USRL4006_ROLLA / UM Process and Reports > UM Residential Life > RL/SR Processes (Registration) > UM AL Data Import / USRL4006_ROLLA / 5:15 PM submit time
USRL2001_ROLLA
USRL4001_ROLLA
USRL4005_ROLLA / In case of error, skip processing for the evening (unless it’s a DB error, then feel free to rerun the process from the beginning when ADB access is restored).
No night call necessary.
If the abend is caused by a database connectivity error,
rerun the job when connectivity is restored. Send an email to UM DoIT EAS Student Res Life, UM Production Control.
UM_RL_2641_ROLLA
Application Engine / UM Process and Reports > UM Residential Life > TJO Processes > UM TJO Records Retention / UMRL2641_ROLLA / This job runs once a year on JULY 1st, next working day if it’s a holiday
2:00 am / No night call necessary. Send an email to UM DoIT EAS Student Res Life, UM Production Control
Student_Financials_Daily
SFAPRFND_ROLLA / Student Financials> Refunds > AP Refunding > Create Vendors and Vouchers / AP_Refunds_ROLLA
RUN_CONTROL Set up:
AP REFUND Tab
Business Unit – ROLLA
Run Option: Individual only
Generate Report - checked
AP Vendor Path:
/usr/tmp/SAPRD89/sfr/sfvendor.txt
AP Voucher Path:
/usr/tmp/SAPRD89/sfr/sfvoucher.txt / Monday thru Friday – submit time 4 PM
RUN_CONTROL Set up:
UM Transfer Files tab
Vendor Output File: /usr/tmp/transfer/SAPRD89/ROLLA_RAR_SFAPLD75.txt
Voucher Output File: /usr/tmp/transfer/SAPRD89/ROLLA_RAR_UMAP0007.txt / No night call necessary. Email: UM DoIT EAS Student Financials, Deb Mash and John Terrill.
USSF9400_ROLLA - Load Bookstore ebill detail into ps_um_ebill_books
SQR Process / UM Processes & Reports > UM Student Financials > Billing > Load Cost Center Billing Dtl / USSF9400_ROLLA
RUN_CONTROL Set up:
Business Unit – ROLLA / Monday thru Friday – submit time 6 PM / No night call necessary. Email: UM DoIT EAS Student Financials.
Note: There may be no file to be processed and that is a valid value. The log will have ‘No ebill_rolla_bookstore_detail.dat’
NBS_CONCILE_ROLLA – Process Reconciliation Report (Application Engine) / NBS Application > Process > Process Reconciliation Report / NBS_CONCILE_ROLLA
RUN CONTROL SET UP:
Business Unit:– ROLLA / 6:30 PM Submit Time / In case of error email UM DoIT EAS Student Financials.
and UM – Production Control.
Student Financials to Finance GL Application Messaging.
SFPGLINT_ROLLA (COBOL) / Student Financials > GL Interface > Generate Accounting Entries / SFPGLINT_ROLLA
RUN CONTROL SET UP:
Business Unit:– ROLLA
Journal Template:–SFJOURNAL
Term – *** user supplied *** / 4:00 AM
Monday – Friday (runs Tuesday thru Saturday mornings) / In case of error send email notification to UM DoIT EAS Student Financials, John Terrill and Deb Mash. The problem will be resolved during normal working hours. Jobs USSF9220_ROLLA and EOP_PUBLISHM_ROLLA should be cancelled.
Report GL Interface Errors USSF9222_ROLLA (SQR Report) / UM Processes and Reports > UM Student Financials > Report > GL Interface Errors Report / USSF9222_ROLLA
RUN CONTROL SET UP:
SetID:– ROLLA
Run Date:– Blank / SFPGLINT_ROLLA
1:00 AM
Monday – Saturday / In case of error send email notification to UM DoIT EAS Student Financials, John Terrill and Deb Mash. The problem will be resolved during normal working hours. Job EOP_PUBLISHM_ROLLA should be cancelled.
Student Financials to Finance GL Application Messaging USSF9220_ROLLA (SQR Report) / Student Financials > GL Interface > Generate Accounting Entries / USSF9220_ROLLA
RUN CONTROL SET UP:
Business Unit:– ROLLA
Journal Template:–SFJOURNAL
Term – *** user supplied *** / SFPGLINT_ROLLA
1:00 AM
Monday – Saturday / In case of error send email notification to UM DoIT EAS Student Financials, John Terrill and Deb Mash. The problem will be resolved during normal working hours. Job EOP_PUBLISHM_ROLLA should be cancelled.
Student Financials to Finance GL Application Messaging.
EOP_PUBLISHM_ROLLA (Application Engine) / Student Financials> GL Interface> Generate Accounting Entries>
then click the Manual Batch Publish link on the run control page / EOP_PUBLISHM_ROLLA
Run Control Data:
Request ID: 01
Description: GL Interface
Frequency: Always
Process Name: SFPGLINT / 4:00 AM
Monday – Friday (runs Tuesday thru Saturday)
USSF9220_ROLLA / In case of error send email notification to UM DoIT EAS Student Financials, John Terrill and Deb Mash.
The problem will be resolved during normal working hours. (No jobs depend on this job so it can be left for the next working day).
Script to Wait 15 minutes before running job USSF9223_ROLLA after job EOP_PUBLISHM_ROLLA has run..
Post_USSF9223_ROLLA (SCRIPT – ViewDirect-01) / ViewDirect-01 script - Wait_15_Min_Post_Tidal.cmd / EOP_PUBLISHM_ROLLA / EOP_PUBLISHM_ROLLA
Monday – Friday (runs Tuesday thru Saturday) / If job won’t run or fails check ViewDirect-01 TIDAL agent to ensure it is connected. This job can be marked completed normally if EOP_PUBLISHM_ROLLA has been run 15 minutes or longer. This script job waits 15 minutes before posting USSF9223_ROLLA to run.
Student Financials to Finance GL Application Messaging.
USSF9223_ROLLA (Application Engine) / UM Processes and Report > UM Student Financials > Reports >
GL Interface Error Report > / USSF9223_ROLLA
Run Control Data:
Bus_Unit: ROLLA
Date: Blank / Post_USSF9223_ROLLA
Monday – Friday (runs Tuesday thru Saturday) / In case of error send email notification to UM DoIT EAS Student Financials, John Terrill and Deb Mash.
The problem will be resolved during normal working hours. (No jobs depend on this job so it can be left for the next working day).
SFTBLVAL_ROLLA – Table Validation (SQR Report) / Student Financials > Charges & Payments > Validate Tables / SFTBLVAL_ROLLA / 5pm / No night call necessary. Send email notification to UM DoIT EAS Student Financials, John Terrill and Deb Mash.
Run SF Payment Applier – SFPQPYWK (SQL COBOL) / Student Financials > Charges & Payments > Apply Payments / SFPQPYWK_ROLLA / SFTBLVAL_ROLLA
12:00 AM
Fridays – incl holidays / No night call necessary. Send email notification to UM DoIT EAS Student Financials, John Terrill and Deb Mash.
SFPBCALC_ROLLA (SQL COBOL) Calculate Tuition & Fees For Students With Tuition-Cal-Required Flag ON – / Student Financials > Tuition and Fees > Calculate Batch Tuition > Calculate Tuition / SFPBCALC_ROLLA
RUN_CONTROL Set up:
Business Unit: ROLLA
Run Option: Calc and Post Tuition, Waivers