Residential Life

SAPRD89S

TIDAL JOB NAME / NAVIGATION / RUN CONTROL / DEPEND / SPECIAL INSTRUCTIONS

RESIDENTIAL LIFE

USRL2001_STLOU (SQR) / UM Processand Reports > UM Residential LifeRL/CC Processes (Bio/Demo) > SIS External Lookup Extract / USRL2001_STLOU_WS
-p mobius_ascii / Successful completion of USRL3000_STLOU and USRL4001_STLOU.
5:00 AM M-F (runs at 5 AM Tuesday – Saturday)
USRL4000_STLOU / If the abend is caused by a database connectivity error, rerun the job when connectivity is restored. email UM DoIT SAAS Residential Life Programmers and Production Control.
No Night Call Necessary. If an error occurs in the log file stating there are problems writing to the Mobius output destination, contact a member of the DBA team.
USRL2002_STLOU (SQR) / UM Processand Reports > UM Residential LifeRL/CC Processes (Bio/Demo) > UM AL PS External Lookup Extract / USRL2002_STLOU_WS
-p mobius_ascii / Successful completion of USRL3000_STLOU and USRL4001_STLOU.
5:00 AM M-F (runs at 5 AM Tuesday – Saturday)
USRL4000_STLOU / In case of error email UM DoIT SAAS Residential Life Programmers Joan Goodwin and UM – Production Control.
No Night Call Necessary.
If the abend is caused by a database connectivity error, rerun the job when connectivity is restored.
USRL3000_APTS_STLOU / 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) 442-2378 home phone number. Send an email to UM DoIT SAAS Residential Life Programmers and UM – Production Control.
MOBIUS Reports: APTS section
USRL3000S1, USRL3000S2 USRL3000S3, USRL3000S4, USRL3000S5, USRL3000S6, USRL3000S7, USRL3000S8
USRL3000_HALLS_STLOU / 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 SAAS Residential Life Programmers and UM – Production Control.
MOBIUS Reports: HALLS section
USRL3000S1, USRL3000S2 USRL3000S3, USRL3000S4, USRL3000S5, USRL3000S6, USRL3000S7, USRL3000S8
USRL3000_STLOU (SQR) / UM Processand Reports > UM Residential LifeRL/SF Processes > UM Residential Life PS Transaction Export > Find and Existing Value / USRL3000_STLOU
“-p mobius-qa_ascii” / 7:15 PM Submit Time, USRL4000_STLOU completed normally or abnormally.
If USRL4000 is skipped for the evening, skip USRL3000 as well. / Call Claire Major for all abends. Send an email to UM DoIT SAAS Residential Life Programmers and UM – Production Control.
MOBIUS Reports:
USRL3000S1, USRL3000S2 USRL3000S3, USRL3000S4, USRL3000S5, USRL3000S6, USRL3000S7, USRL3000S8
USRL4000_STLOU (SQR) / UM Processand Reports > UM Residential LifeRL/SR Processes (Registration) > UM RL ID Verify / USRL4000_STLOU
"-p mobius-qa_ascii" / 5:15 PM
If USRL4000 is skipped for the evening, skip USRL3000 as well. / Night Call not necessary.
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 DB access is restored. Send email to UM DoIT SAAS Residential Life Programmers and UM – Production Control.
USRL4005_STLOU (SQR) / UM Process and Reports > UM Residential Life > RL/SR Processes (Registration) > UM RL ID Verify / USRL4005_STLOU
"-p mobius-qa_ascii" / 5:30 PM submit time, USRL4000_STLOU completed normally. / 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.
USRL3002_STLOU (SQR)
Stop running permanently on
4-10-2009 / UM Process and Reports > UM Residential Life > RL/SF Processes > UM ALStrm Billing Tran Expt / USRL3002_STLOU
"-p mobius-qa_ascii" / 5:30 PM submit time, USRL4005_STLOU completed normally, and USRL3000 completed normally or abnormally. / Call Claire Major for all abends. Send an email to Sandy Weisman, Claire Major and UM – Production Control.
USRL4001_STLOUS (SQR) / UM Process and Reports > UM Residential Life > RL/SR Processes (Registration) > UM RL Data Import / USRL4001_STLOU
"-p mobius-qa_ascii" / 5:00 AM submit time, USRL4000_STLOU completed normally, USRL4000_STLOU is a true dependency. / 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_STLOU (SQR) / UM Process and Reports > UM Residential Life > RL/CC Processes (Bio Demo) > UM RL RESLIFE Address Export / USRL2004_STLOU
"-p mobius-qa_ascii" / USRL4000_STLOU 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 Data error call Claire Major. If you can’t get in contact with Claire Major then call Sandy Weisman. Send an email to Sandy Weisman, Claire Major and UM – Production Control.
USRL4006_STLOU (SQR) / UM Process and Reports > UM Residential Life > RL/SR Processes (Registration) > UM AL Data Import / USRL4006_STLOU
"-p mobius-qa_ascii" / 5:00 AM submit time, USRL4002_STLOU completed normally, USRL4000_STLOU is a true dependency. USRL4001_STLOU completed normally or abnormally (not 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.

LIBRARY INTERFACE

USCC0200_STLOU – Library Interface – SQR Process / Um Processes and Reports > UM Student RecordsStudent Enrollment & Records > Library Interface / USCC0200_STLOU
Run Control Set Up:
Academic Institution: STLOU
Output Directory:
/um-data/transfer/SAPRD89S/UMSLPATRONS.TXT / 5:05 PM
Mondays with a roll forward on Holidays / If errors, send email to:
Linda Silman, Tyrome Petty and UM – Production Control.
Night Call NOT NECESSARY.

WEB_APPLICATIONS

UM_AD_1784_STLOU – Web Admission App Processing / Um Processes and Reports > UM Admit and Recruit > Web Applications > WA – USE PIA > Infinet Apply Web App Payments / UM_AD_1784_STLOU / USAD7000_ROLLA being completed / If errors, send email to:
Rita Ellebracht, Joan Goodwin, James Givens and UM – Production Control.
Night Call NOT NECESSARY.
USAD7000_STLOU – Web Admission App Processing. / Um Processes and Reports > UM Admit and Recruit > Web Applications > Load Web Apps and Prospects / USAD7000_STLOU / UM_AD_1784_STLOU andUSAD7000_ROLLA being completed / If errors, send email to:
Linda Silman, Jerry D. Hoffman, Barb Brown, Jamie Lincoln, Octavia Hollins, Kaminsky Williams, Joan Goodwin, Rita Ellebracht, James Givens and UM – Production Control.
Night Call NOT NECESSARY.
Assign Remedy ticket to Group
Assignment ‘AITS PS Student’ and assign to Joan Goodwin
Admissions
MASSCHNG_FTC_CHK_STLOU– Produces a group of FTC applicants that applied online & needs Checklist (Application Engine) / Campus community > Checklists > Mass change Checklists > Run Mass Change / MASSCHNG_FTC_CHK_STLOU / USAD7000_STLOU
This is dependent on the application load program USAD7000_STLOU if this fails mass change should not be ran. / No night call necessary. Notify Jaime Lincoln, Jerry Hoffman and UM-Production Control via email.
MASSCHNG_REA_CHK_STLOU– Produces a group of FTC applicants that applied online & needs Checklist (Application Engine) / Campus community > Checklists > Mass change Checklists > Run Mass Change / MASSCHNG_REA_CHK_STLOU / USAD7000_STLOU
This is dependent on the application load program USAD7000_STLOU if this fails mass change should not be ran. / No night call necessary. Notify Jaime Lincoln, Jerry Hoffman and UM-Production Control via email.
MASSCHNG_TRN_CHK_STLOU– Produces a group of FTC applicants that applied online & needs Checklist (Application Engine) / Campus community > Checklists > Mass change Checklists > Run Mass Change / MASSCHNG_TRN_CHK_STLOU / USAD7000_STLOU
This is dependent on the application load program USAD7000_STLOU if this fails mass change should not be ran. / No night call necessary. Notify Jaime Lincoln, Jerry Hoffman and UM-Production Control via email.
3C_FTC_CHK_STLOU
3C Engine - Masschange – FTC
(Application Engine) / Campus Community > Communications > Run 3C Engine / UMSL_FTC_CHECKLIST_STLOU / USAD7000_STLOU and
MASSCHNG_FTC_CHK_STLOU
This is dependent on the application load program USAD7000 if this fails mass change should not be ran. / Rerun job 3C_FTC_CHK_STLOU if you receive the following error message - SQL error. Stmt #: 1603 Error Position: 7 Return: 60 - ORA-00060: deadlock detected while waiting for resource
No night call necessary. Notify Jaime Lincoln, Jerry Hoffman and UM-Production Control via email.
3C_REA_CHK_STLOU
3C Engine - Masschange – REA
(Application Engine) / Campus Community > Communications > Run 3C Engine / UMSL_REA_CHECKLIST_STLOU / USAD7000_STLOU and
MASSCHNG_REA_CHK_STLOU
This is dependent on the application load program USAD7000 if this fails mass change should not be ran. / Rerun job 3C_REA_CHK_STLOU if you receive the following error message - SQL error. Stmt #: 1603 Error Position: 7 Return: 60 - ORA-00060: deadlock detected while waiting for resource
No night call necessary. Notify Jaime Lincoln, Jerry Hoffman and UM-Production Control via email.
3C_TRN_CHK_STLOU
3C Engine - Masschange – TRN
Application Engine / Campus Community > Communications > Run 3C Engine / UMSL_TRN_CHECKLIST_STLOU / USAD7000_STLOU and
MASSCHNG_TRN_CHK_STLOU
This is dependent on the application load program USAD7000 if this fails mass change should not be ran. / Rerun job 3C_TRN_CHK_STLOU if you receive the following error message - SQL error. Stmt #: 1603 Error Position: 7 Return: 60 - ORA-00060: deadlock detected while waiting for resource
No night call necessary. Notify Jaime Lincoln, Jerry Hoffman and UM-Production Control via email.
3C_APPFEEPD_COMM_STLOU
3C Engine - Masschange – TRN
Application Engine / Campus Community > Communications > Run 3C Engine / UMSL_TRN_CHECKLIST_STLOU / MASSCHNG_FTC_CHK_STLOU,
MASSCHNG_REA_CHK_STLOU,
MASSCHNG_TRN_CHK_STLOU / Rerun job 3C_APPFEEPD_COMM_STLOU if you receive the following error message - SQL error. Stmt #: 1603 Error Position: 7 Return: 60 - ORA-00060: deadlock detected while waiting for resource
No night call necessary. Notify Jaime Lincoln, Jerry Hoffman and UM-Production Control via email.
Student_Financials_Daily
USSF0400_STLOU_Mon_Fri – UM Delete C02 ServiceInd ( SQR Report) / UM Processes and Report > UM Student Financials > Process > Delete C02 ServiceInd. / USSF0400_STLOU / Every15 minutes
7:30 amthru 7:00 PM(Monday thru Friday)
Should be running sameoccurrences number. / Send email notification to:
Mitch Hess, Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis
RUN_CONTROL Set up:
Academic Institution:STLOU
USSF0400_STLOU_Sat – UM Delete C02 ServiceInd ( SQR Report) / UM Processes and Report > UM Student Financials > Process > Delete C02 ServiceInd. / USSF0400_STLOU / 10:00 am (Saturday) / Send email notification to:
Mitch Hess, Sarabeth Rhodes, Christine Wilson, Wende Waltz andCornell Lewis.
RUN_CONTROL Set up:
Academic Institution:STLOU
USSF0400_STLOU_1_Wknd- UM Delete C02 ServiceInd ( SQR Report) / UM Processes and Report > UM Student Financials > Process > Delete C02 ServiceInd. / USSF0400_STLOU / 1:00 pm (Saturday and Sunday) / Send email notification to:
Mitch Hess, Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis.
RUN_CONTROL Set up:
Academic Institution:STLOU
USSF0400_STLOU_2_Wknd- UM Delete C02 ServiceInd ( SQR Report) / UM Processes and Report > UM Student Financials > Process > Delete C02 ServiceInd. / USSF0400_STLOU / 4:00 pm (Saturday and Sunday) / Send email notification to:
Mitch Hess, Sarabeth Rhodes Christine Wilson, Wende Waltz and Cornell Lewis.
RUN_CONTROL Set up:
Academic Institution:STLOU
USSF0400_STLOU_3_Wknd- UM Delete C02 ServiceInd ( SQR Report) / UM Processes and Report > UM Student Financials > Process > Delete C02 ServiceInd. / USSF0400_STLOU / 10:30 pm (Saturday and Sunday) / Send email notification to:
Mitch Hess, Cornell Lewis, Sarabeth Rhodes, Christine Wilson and Wende Waltz.
RUN_CONTROL Set up:
Academic Institution:STLOU
7 AM Job Stream
USSF9700_ALL_STLOU – Prepare External Files - (SQR Report) / Home > UM Processes and Reports > UM Student Financials > External Files > Prepare External Files / USSF9700_ALL_STLOU / 7:00 AM submit time / In case of error email Sarabeth Rhodes, Christine Wilson, Mitch Hess, Wende Waltz and Cornell Lewis.
If an 'Error' status is received,
Cancel job USSF9703_ALL_STLOU.
Jobs USSF9700_ALL_STLOU and USSF9703_ALL_STLOU must be set to
Completed Normal so rest of the
stream will be run.
RUN_CONTROL Set up:
Academic Institution:STLOU
File Path and Name:Blank
All Files Box:Checked
USSF9703_ALL_STLOU– Batch EFL to load all files (SQR Report) / Home > UM Processes and Reports > UM Student Financials > External Files > Prepare External Files / USSF9703_ STLOU / USSF9700_ALL_STLOU / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis.Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Academic Institution:STLOU
File Path and Name:Blank
All Files Box:Checked
USSF9702_ALL_STLOU– Update GP Run Controls (SQR Report) / Home > UM Processes and Reports > UM Student Financials > External Files > Update GP Run Controls / USSF9702_ALL_STLOU / USSF9700_ALL_STLOU
USSF9703_ALL_STLOU / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis.
Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Academic Institution:STLOU
UM_SF_7020_STLOU– Set permissions waiver on students based on their answers from self Financial Aid Waiver sync (Application Engine) / Home > UM Processes and Reports > UM Student Financials > Process > Financial Aid Waiver Sync / UM_SF_7020_STLOU / USSF9702_ALL_STLOU / In case of error email Mitch Hess, Cornell Lewis, Christine Wilson, Cornell Lewis and UM – Production Control. Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Academic Institution:STLOU
Aid Year:2011
EFFDT of Waiver:Blank
Waiver:PAYALL
SFPGRPST_GP_M_STLOU– Post Transactions (COBOL SQL) / Home > Student Financials > Charges and Payments > Group Processing > Post Transactions / SFPGRPST_GP_M_STLOU / UM_SF_7020_STLOU / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis.
Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Business Unit:STLOU
Group Type: M
Starting Group ID:blank (program will populate this field)
Ending Group ID: blank (program will populate this field)
Operator ID: blank
Assign Group OperID: blank
SFPGRPST_GP_C_STLOU– Group Posting Process (COBOL SQL) / Home > Student Financials > Charges and Payments > Group Processing > Post Transactions / SFPGRPST_GP_C_STLOU / SFPGRPST_GP_M_STLOU / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis.Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Business Unit:STLOU
Group Type: C
Starting Group ID:blank (program will populate this field)
Ending Group ID: blank (program will populate this field)
Operator ID: blank
Assign Group OperID: blank
SFPGRPST_GP_F_STLOU– Group Posting Process (COBOL SQL) / Home > Student Financials > Charges and Payments > Group Processing > Post Transactions / SFPGRPST_GP_F_STLOU / SFPGRPST_GP_C_STLOU / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis. Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Business Unit:STLOU
Group Type: F
Starting Group ID:blank (program will populate this field)
Ending Group ID: blank (program will populate this field)
Operator ID: blank
Assign Group OperID: blank
UM_SF_2672_STLOU– Update GP Run Controls (SQR Report) / Home > UM Processes and Reports > UM Student Financials > Third Party > 3rd Party/Pay Reapply Process / UM_SF_2672_STLOU / SFPGRPST_GP_F_STLOU / In case of error email Mitch Hess, Cornell Lewis and UM – Production Control. Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Business Unit:STLOU
Origin ID:00010
Group Type:C
USSF9702_ALL_STLOU_A– Update GP Run Controls (SQR Report) / Home > UM Processes and Reports > UM Student Financials > External Files > Update GP Run Controls / USSF9702_ALL_STLOU / UM_SF_2672_STLOU / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis. Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Academic Institution:STLOU
SFPGRPST_GP_C_STLOU_A– Group Posting Process (COBOL SQL) / Home > Student Financials > Charges and Payments > Group Processing > Post Transactions / SFPGRPST_GP_C_STLOU / USSF9702_ALL_STLOU_A / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis. Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Business Unit:STLOU
Group Type: C
Starting Group ID:blank (program will populate this field)
Ending Group ID: blank (program will populate this field)
Operator ID: blank
Assign Group OperID: blank
Evening- Job Stream
USSF9400_ STLOU – Load Bookstore Detail for Ebill –
(SQR Process) / Home > UM Processes and Reports > UM Student Financials > Billing > Load Cost Center Billing Dtl / USSF9400_STLOU / 6 PM / In case of error email Sarabeth Rhodes, and Wende Waltz.
USSF9700_ALL_STLOU_1 – Prepare External Files - (SQR Report) / Home > UM Processes and Reports > UM Student Financials > External Files > Prepare External Files / USSF9700_STLOU / USSF9950_STLOU, USRL3000_APTS_STLOU, USRL3000_HALL_STLOU / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz, Cornell Lewis and Mitch Hess.
If an 'Error' status is received,
Cancel job USSF9703_ALL_STLOU_1.
Jobs USSF9700_ALL_STLOU_1 and USSF9703_STLOU_1 must be set to
Completed Normal so rest of the
stream will be run.
RUN_CONTROL Set up:
Academic Institution:STLOU
File Path and Name:Blank
All Files Box:Checked
USSF9703_ ALL_STLOU_1– Batch EFL to load all files (SQR Report) / Home > UM Processes and Reports > UM Student Financials > External Files > Prepare External Files / USSF9703_ STLOU / USSF9700_ALL_STLOU_1 / In case of error email Mitch Hess, Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis.
Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Academic Institution:STLOU
File Path and Name:Blank
All Files Box:Checked
USSF9702_ALL_STLOU_1– Update GP Run Controls (SQR Report) / Home > UM Processes and Reports > UM Student Financials > External Files > Update GP Run Controls / USSF9702_ALL_STLOU / USSF9703_ALL_STLOU_1 / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis.
Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Academic Institution:STLOU
SFPGRPST_GP_M_STLOU_1– Post Transactions (COBOL SQL) / Home > Student Financials > Charges and Payments > Group Processing > Post Transactions / SFPGRPST_GP_M_STLOU / USSF9702_ALL_STLOU_1 / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis.
Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Business Unit:STLOU
Group Type: M
Starting Group ID:blank (program will populate this field)
Ending Group ID: blank (program will populate this field)
Operator ID: blank
Assign Group OperID: blank
USSF7010_ STLOU– Final step of the write off process, which creates group of charges to be written off. (SQR Report) / Home > UM Processes and Reports > UM Student Financials > Write-Offs > Write-Off Process (Direct) / USSF7010_STLOU / SFPGRPST_GP_M_STLOU_1 / In case of error email Sarabeth Rhodes, Mitch Hess, Christine Wilson, Wende Waltz and Cornell Lewis.
Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Business Unit:STLOU
Report Only:Unchecked
USSF9702_ALL_STLOU_1A– Update GP Run Controls (SQR Report) / Home > UM Processes and Reports > UM Student Financials > External Files > Update GP Run Controls / USSF9702_ALL_STLOU / USSF7010_STLOU
Academic Institution:STLOU / In case of error email Mitch Hess, Cornell Lewis and UM – Production Control. Mark job ‘Completed Normally’ after sending email notification.
Problem will be resolved during normal business hours.
RUN_CONTROL Set up:
Academic Institution:STLOU
SFPGRPST_GP_C_STLOU_2– Post Transactions (COBOL SQL) / Home > Student Financials > Charges and Payments > Group Processing > Post Transactions / SFPGRPST_GP_C_STLOU / USSF9702_ALL_STLOU_1A / In case of error email Sarabeth Rhodes, Christine Wilson, Wende Waltz and Cornell Lewis.Problem will be resolved during normal business hours.