Information Systems and Computing
UNDERGRADUATE ADMISSIONS SYSTEM (UAD)
Operations Documentation
Last Updated: October 11, 2011
Table of Contents
1.3 System Interfaces FROM UAD
Undergraduate Admissions System (UAD) TO Corporate
Student System (CSS)
Undergraduate Admissions System (UAD) to the UCOP
Corporate Data Warehouse (CDW)
1.4 Application Control Information
1.8 How to produce or update this document
Overview of Monthly Processing
MVS Job UADRCMP Edit One Campus UAD Input File
MVS Job UADSETUP Delete current quarters of data
from UADM Database
MVS Job UADUETS Edit Educational Testing Service
(ETS) data and Update UADM database
MVS Job UADUCMP Combine Campus UAD Input Files and
Update UADM Focus Database
MVS Job UADFLAG Update Flag Fields in the UADM
Common Segment
MVS Job UAD501 Produce UAD501 Campus and Systemwide
Reports
MVS Job UADWEXT Extract Data for loading into the
Student Data Warehouse
UNIX Job UADZEXT
Load UAD data into Corporate Data Warehouse
MVS Job UADBKP Backup of the UADM Focus Database and
Focus Master
MVS Job UADUQTR Delete one or more quarters of data
from UADM Database
Overview of Miscellaneous Processing On Request or
As Needed
MVS Job UADREST Restore the Current UADM Focus
Database from a Disk Backup
MVS Job UADREORG Rebuild/Reorg UADM after master
change
Last Updated August 27, 2007
The purpose of the UNDERGRADUATE ADMISSIONS
SYSTEM (UAD) is to collect, validate, and integrate admissions data. UAD data
contains information about applicants for admission to the
Educational Testing Service (ETS) to Undergraduate
Admissions System (UAD)
The ETS file is sent using ftp to the UCOP vsftp site with the following filename:
/ftphome/ftpusret/put/css/UADETS.mmmyy
where: mmm is:
JAN - January
FEB - February
MAR - March
APR - April
MAY - May
JUN - June
JUL - July
AUG - August
SEP - September
OCT - October
NOV - November
DEC - December
yy is: the last two digits of calendar year
The file is due from the Educational Testing Service (ETS) on the 5th working day of the month.
Local campus systems to UAD (UAD Campus Input Files)
All UAD campus data files are made available to UCOP via FTP to the UCOP vsftp site with the following filename:
/ftphome/ftpusr[n]/put/css/UADCMP.mmmyy
where n is 1 10 indicating the campus (excluding SF):
1
3
4 -
5
6 -
7 -
8 -
9
10
And mmm is FEB, APR, MAY, JUN, AUG, OCT or DEC
Files for
specific months must include specific terms (term
year is the same as calendar year except where indicated):
|
|
Fall |
Winter |
Spring |
|
February |
|
X |
X |
|
April |
X |
X |
X |
|
May |
X |
X |
X |
|
June |
X |
X-Final |
X |
|
August |
X |
|
X-Final |
|
October |
X |
|
|
|
December |
X-Final |
X (next year) |
|
FILE ARRIVAL DATE: 5th working day of the month
SENT
BY: All UC campuses but
Note:
Corporate Student System (CSS) TO
Undergraduate Admissions System (UAD)
CSS Tables used by UAD Jobs
UAD jobs use several of the CSS cross-reference tables (see CSS Operations documentation for more information on CSS files).
|
Job(s) |
CSS Table |
CSS Table DSN |
Description |
|
UADRCMP UADUCMP |
CSSATP |
CSS.FOC.CSSATP.ALLYRS |
School Code Table |
|
UADRCMP UADUCMP |
CSSCCM |
CSS.FOC.CSSCCM.ALLYRS |
Campus, College and Major table |
|
UADFLAG |
CSSCOL |
CSS.FOC.CSSCOL.ALLYRS |
College Code Table |
|
UADFLAG UADRCMP UADUCMP |
CSSLOC |
CSS.FOC.CSSLOC.ALLYRS |
Location Code Table |
|
UADFLAG |
CSSMAJOR |
CSS.FOC.CSSMAJOR.ALLYRS |
Major Code Table |
The UADRCMP and UADUCMP jobs use the CSS tables
listed above - extracts of these tables are created by the UADXTBLS Focexec,
and these extracts are then used by the
Note: Some of the above tables also contain references to other CSS tables within the Focus Master:
Location CSSLOC CSS.FOC.CSSLOC.ALLYRS
District CSSDIST CSS.FOC.CSSDIST.ALLYRS
CIP CSSCIP CSS.FOC.CSSCIP.ALLYRS
College CSSCOL CSS.FOC.CSSCOL.ALLYRS
Major CSSMAJOR CSS.FOC.CSSMAJOR.ALLYRS
UC Discipline CSSUCDSP CSS.FOC.CSSUCDSP.ALLYRS
CSS Data Update for Registration Field
The UADUREG step of the UADUCMP job uses data captured from the CSSREG and CSSREGIN quarterly databases to update the CREGISTER flag in the Common segment of the UADM database, to show which students have registered for a given quarter.
Last Updated: June 11, 2010
CSS processes Undergraduate Admissions data four times each academic year. The data is processed by the following two jobs:
Last Updated: August 27, 2007
Undergraduate Admissions System data is extracted from the UAD Focus databases and sent to the Corporate Data Warehouse. The UADWEXT extract job creates the following extract files for the data warehouse:
|
MVS Extract file(s) |
Files on unix (sybserv2.ucop.edu)
in /datawh/ctl/prod/dwhstu/data/uad |
|
UAD.UADWUAC UAD.UADWUACC UAD.UADWUACY UAD.UADWUAV UAD.UADWUAV2 UAD.UADWUAVC |
dwh_stu_uad_appliccmp.dat dwh_stu_uad_appliccmp_cnt.dat dwh_stu_uad_cycle.dat dwh_stu_uad_applic.dat dwh_stu_uad_applic2.dat dwh_stu_uad_applic_cnt.dat |
Last Updated: October 11, 2011
Production Control: Matthew Valenzuela
Kaiser 3rd floor
(510) 987-0330
Kaiser 3rd floor
(510) 987-0202
Maintenance: Chris Handy
Kaiser 12th floor
(510) 987-9417
DWCS Analyst: Chris Handy
Kaiser 12th floor
(510) 987-9417
Functional Users: Liz Tamayo
SAS
File availability date: 5th working day of the month.
Production start date: 6th working day of the month.
Production stop date: 8th working day of the month.
Output due date: 10th working day of the month.
Last Updated: August 27, 2007
The libraries where UAD code resides on MVS are as follows:
Library Description
PRO.CTL.CNTLIB Control cards (e.g. sort control cards or program control cards)
PRO.CTL.ISPPLIB ISPF Panels for Job Submission
PRO.CTL.ISPSLIB ISPF Skeletons (run JCL)
PRO.CTL.PROCLIB JCL Cataloged Procedures (PROCs)
PRO.CTL.FTPLIB FTP commands (generally only machine, userid
and password; remainder of commands is kept in each job skeleton)
Note: this library is not generally accessible only production control can read the contents
PRO.MNT.COBOL COBOL Source Code
PRO.MNT.COPYLIB COBOL Copy Members
PRO.MNT.FOCEXEC FOCUS source code (i.e. Focexecs)
PRO.MNT.INCLUDE PL/I Include Members
PRO.MNT.LOADLIB Load Modules for compiled batch programs
PRO.MNT.MASTER FOCUS Masters
PRO.MNT.PLI PL/I Source Code
The following libraries are for archiving old
versions of code (one generation of backup is retained):
CTLADM.BKPCTL.CNTLIB Backup of control cards
CTLADM.BKPCTL.ISPPLIB Backup of ISPF Panels for Job Submission
CTLADM.BKPCTL.ISPSLIB Backup of ISPF Skeletons (run JCL)
CTLADM.BKPCTL.PROCLIB Backup of JCL Cataloged Procedures (PROCs)
MNTADM.BKPMNT.COBOL Backup of COBOL Source Code
MNTADM.BKPMNT.COPYLIB Backup of COBOL Copy Members
MNTADM.BKPMNT.FOCEXEC Backup of FOCUS source code (i.e. Focexecs)
MNTADM.BKPMNT.INCLUDE Backup of PL/I Include Members
MNTADM.BKPMNT.MASTER Backup of FOCUS Masters
MNTADM.BKPMNT.PLI Backup of PL/I Source Code
The following UAD MVS jobs produce report files:
UADUETS Update the UADM database with data from ETS
MVS Report Dataset Name (DSN):
UAD.UADEED.mmmyy.RPT
MVS Report Dataset Name PDF format:
UAD.UADCEDcc.PDF
Report filename on vsftp:
/ftphome/ftpusru/get/css/UADEED.mmmyy.PDF
where mmm is JAN, FEB, etc.
UADRCMP Edit one campus UAD input file
MVS Report Dataset Name (DSN):
UAD.UADCED.cc.mmmyy.RPT
where cc is BK, SF,
mmm is JAN, FEB, etc.
MVS Report Dataset Name PDF format:
UAD.UADCEDcc.PDF
Report filename on vsftp:
/ftphome/ftpusr[n]/get/css/UADCED.mmmyy.PDF
/ftphome/ftpusru/get/css/UADCED[cc].mmmyyPDF
where cc is BK, SF,
where mmm is JAN, FEB, etc.
UAD501 Produce the 501 reports
MVS Report Dataset Name (DSN):
UAD.UAD501.RPT
Note: there is no PDF format version of this UAD501 report file, and the file is not sent to the vsftp site.
Last Updated: March 18, 2008
There are no UAD system tables. However, a number of CSS Tables are used in UAD processing. The following lists the CSS tables that are used by UAD:
|
Table |
DSN
of FOCUS database on MVS |
FOCUS
Master on MVS |
|
|
CSS.FOC.CSSATP.ALLYRS |
CSSATP |
|
|
CSS.FOC.CSSCCM.ALLYRS |
CSSCCM |
|
Classification of Instruction Program |
CSS.FOC.CSSCIP.ALLYRS |
CSSCIP |
|
College Codes Table |
CSS.FOC.CSSCOL.ALLYRS |
CSSCOL |
|
|
CSS.FOC.CSSDIST.ALLYRS |
CSSDIST |
|
Location Table |
CSS.FOC.CSSLOC.ALLYRS |
CSSLOC |
|
Major Table |
CSS.FOC.CSSMAJOR.ALLYRS |
CSSMAJOR |
|
UC Discipline Codes Table |
CSS.FOC.CSSUCDSP.ALLYRS |
CSSUCDSP |
Last Updated: August 27, 2007
The complete UAD Operations Document is available on the web at the following web url:
http://www.ucop.edu/irc/prodctl/opsdoc/uad/uaddoc.html
If changes must be made to the document, then do the following:
1. Capture the word document from the web. The word document can be retrieved from the web by changing the html suffix in the above url to doc as follows:
http://www.ucop.edu/irc/prodctl/opsdoc/uad/uaddoc.doc
A pop-up window will appear asking if you want to open the file or save it select save and save the word document file on your PC.
2. Open the document with Word. Edit the document, making any necessary changes.
3. Once the changes are complete recreate the Table of Contents using Word:
o Highlight the table of contents
o Open the Insert menu ΰ Reference ΰ Index and Tables
o Select the Table of Contents tab
o If necessary, select Options and eliminate any heading styles that should NOT be included (varies with each document on which headings are used)
o Click on OK. You will be asked if you want to replace the existing Table of Contents respond that you do
4. Save the revised Word document
5. Send
the updated version of the Operations document to Production Control (either
the UCOP Production Control email address or directly to
Note: minor changes can be sent via email and incorporated by Production Control.
Last Updated: July 30, 2007
Production Control maintains run logs showing which jobs are run for every cycle. These logs are used to track each cycle, filling in the date each job is run plus some additional information as needed (such as record counts).
Anytime new jobs are added to production or old jobs removed from production, or changes made in what cycles a job must run then the Run Logs must be updated with this information.
Last Updated: November 2004
UAD processing consists of monthly, quarterly, and other processing operations streams. The quarterly jobs are run in addition to the regularly scheduled monthly jobs.
There are nine campus input files, one from each campus
except
Last Updated June 11, 2010
The monthly processing for the Undergraduate Admissions system (UAD) consists of the following jobs:
Job Description
UADRCMP on MVS As each campus file is received on MVS, the edit job UADRCMP is run for that campus.
UADSETUP on MVS This job first copies the UADM Focus database for backup purposes (UAD.FOC.UADM.PRESET(0)) and then deletes all data in the UADM Focus database for quarters to be loaded per schedule.
UADUETS on MVS This job edits the data sent from the Educational Testing Service (ETS) and then updates the UADM Focus database with the edited ETS data (after making a backup copy of the UADM Focus database).
UADUCMP on MVS This job merges the campus files into a single file, edits the combined file and updates the UADM Focus database with the edited campus data (after making a backup copy of the UADM Focus database).
UADFLAG on MVS This job updates five flags in the common segment of the UADM Focus database.
UAD501 on MVS This job produces the monthly Campus and Systemwide reports (501-A through 501-H).
UADWEXT on MVS This job produces the monthly extract files and ftps them to unix for loading into the student data warehouse
UADBKP
on MVS This
job copies the UADM Focus database and Focus Master to disk for onsite backup
and to tape for offsite backup.
Last Updated: March 18, 2008
The UADRCMP job edits one campus UADCMP interface file. The job first extracts data from three CSS tables: CCM, Location and ATP. The job then edits the UAD input file from one campus (using the CSS table extracts as part of the edit process) and produces several edit files. These edit files are converted to an edit report, which is then converted to PDF and copied to the vsftp site using ftp.
Frequency:
Monthly (JAN DEC)
Programs Executed:
STEP1 Proc UADGETFL
PSTEP01 delete file
PSTEP02 pre-allocate file
PSTEP03 FTP grab file from vsftp and delete file from 2 cycles ago
PSTEP04 IRXJCL test for empty file
STEP2-Proc UADXTBLS
PSTEP01 IEFBR14 delete files
PSTEP02 FOCUS,UADXTBLS Extract data from CSS tables
STEP3 Proc UADRCMP
PSTEP01 IEFBR14 delete files
PSTEP02 COBOL,UADCMPED edit campus UADCMP file
PSTEP03 IEFBR14 delete file
PSTEP04 FILELAID copy temp to permanent file
PSTEP05 IEFBR14 delete file
PSTEP06 FOCUS, UADRCMP convert edit files to an edit report (UADCED)
PSTEP07 FOCUS, IRC2PDF convert report to PDF format
STEP4 FTP (no proc)
Input Files:
on vsftp.ucop.edu:
/ftphome/ftpusr[c]/put/css/UADCMP.mmmyy
where c is 1, 3-10 (not 2, for SF)
CSS.FOC.CSSCCM.ALLYRS
CSS.FOC.CSSLOC.ALLYRS
CSS.FOC.CSSATP.ALLYRS
PRO.MNT.MASTER(CSSCCM)
PRO.MNT.MASTER(CSSLOC)
PRO.MNT.MASTER(CSSATP)
PRO.MNT.MASTER(UADE201)
PRO.MNT.MASTER(UADE202)
PRO.MNT.MASTER(UADE203)
PRO.MNT.MASTER(UADEX04)
PRO.MNT.MASTER(UADEX05)
PRO.MNT.MASTER(IRCRPT)
PRO.CTL.CNTLIB(UADXTBLS)
PRO.CTL.CNTLIB(IRC2PDF)
Created Files:
UAD.UADCMPcc.TEMP
UAD.UADCMPcc.mmmyy
where cc is BK DV LA RV SD SC SB IR or MC
UAD.CSSXCCM.TEMP
UAD.CSSXLOC.TEMP
UAD.CSSXSCH.TEMP
UAD.UADRCMP.UADE201.TEMP
UAD.UADRCMP.UADE202.TEMP
UAD.UADRCMP.UADE203.TEMP
UAD.UADRCMP.UADE205.TEMP
UAD.UADCEDcc.mmmyy.RPT
UAD.UADCEDcc.PDF
where cc is BK DV LA RV SD SC SB IR or MC
on vsftp.ucop.edu:
/ftphome/ftpusr[c]/get/css/UADCED.mmmyy.PDF
where c is 1, 3-10 (not 2, for SF)
Updated Files:
None
Resource Requirements
Elapsed Time 5 minutes
CPU Time 5 seconds
Print Lines no reports printed
Pre-processing Instructions:
Dependencies:
·
The
UAD input file (UADCMP) for the campus must be available on vsftp
Prompted variables:
· &MMM month of current cycle. Valid values are: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC
· &YY year of processing (e.g., 05 for 2005)
·
&CC 2-character abbreviation for the
campus. Valid values are: BK (Berkeley), DV (Davis), LA (Los Angeles), RV
(Riverside), SD (San Diego), SC (Santa Cruz), SB (Santa Barbara), IR (Irvine),
and MC (Merced). (Note: SF (
· &JRS - JOB RESTART STEP - Indicates at which step to restart the job. Default is 1; 1 should be used unless restarting the job (see rerun instructions).
· &PRS - PROC RESTART STEP - Indicates at which step within the proc to restart the job. Default is 01; 01 should be used unless restarting the job (see rerun instructions).
Post-processing Instructions:
Verification:
· Condition codes are zero for all steps
Spurious error messages:
· None
Log entries:
· Date campus file received
· Date job run
· Campus file input records
Report distribution:
· None (reports are made available to campuses via ftp on the vsftp site)
Rerun Procedures:
· This job is rerunnable.
Last Updated: March 18, 2008
The UADSETUP first copies the UADM Focus database for backup purposes (UAD.FOC.UADM.PRESET(0)) and then deletes all data in the UADM Focus database for quarters to be loaded per schedule.
Frequency:
As part of the bi-monthly load process.
Programs Executed:
STEP1 Proc UADSETUP
PSTEP01 FILEAID copy UADM Focus database for backup
PSTEP02 FOCUS, UADUQTR delete data for selected quarters in UADM Focus database
Input Files:
PRO.MNT.MASTER(UADM)
Created Files:
None
Updated Files:
UAD.FOC.UADM.CURRENT
Resource Requirements
Elapsed Time 1 - 18 minutes
CPU Time 1-10 seconds
Print Lines Job Log only
Job Class - A
Tape Drives - none
Pre-processing Instructions:
Dependencies:
·
UAD
files for the cycle must have been all approved by the functional user.
·
This
job must be run before UADUETS.
Prompted variables:
· &MON month of current cycle. Valid values are: FEB, APR, MAY, JUN, AUG, OCT, DEC
· &YEAR year of processing (e.g., 2008)
· &JRS - JOB RESTART STEP - Indicates at which step to restart the job. Default is 1; 1 should be used unless restarting the job (see rerun instructions).
· &PRS - PROC RESTART STEP - Indicates at which step within the proc to restart the job. Default is 01; 01 should be used unless restarting the job (see rerun instructions).
Post-processing Instructions:
Verification:
· Condition codes are zero for all steps
· No Focus errors
A short report counting records by quarter/year will print in the STEP1.PSTEP02 SYSPRINT log of the Focexec, both before and after the deletions. The before-purge report appears as follows:
NUMBER
OF RECORDS IN TABLE= 446 LINES=
2
PAGE 1
PGM
ID: UADUQTR COUNTS BEFORE
REBUILD 12/02/04
15.17.20
YEAR
QUARTER CAMPUS
APPLIED APPLIED
APPLIED APPLICANTS
------- -------
------- ----------
05 3 329 308
07 2 117 117
TOTAL 446 425
The after-purge report appears as follows:
NUMBER OF RECORDS IN TABLE= 117
LINES= 1
PAGE
1
PGM ID: UADUQTR COUNTS AFTER REBUILD 12/02/04
15.17.22
YEAR
QUARTER CAMPUS
APPLIED
APPLIED APPLIED APPLICANTS
-------
------- ------- ----------
07
2 117 117
TOTAL 117 117
Spurious error messages:
As less than four cycles of data are specified on the job panel for deletion, one or more quarter/year values will be set to Xs. Since Xs are not found in the database, the following messages will appear in the SYSPRINT file for STEP1.PSTEP02:
----------------------------------------------------------------------
FOCUS
7.1.1 15.17.21
SCAN FILE UADM
SCAN:
TLOCATE. CQUARTERAP EQ '3' AND YEARAP EQ
'05'
DELETE CQUARTERAP *
EOF:
SEGMENTS DELETED= 1253 η 305 cycle deleted
TLOCATE. CQUARTERAP EQ 'X' AND YEARAP EQ
'XX'
EOF:
DELETE CQUARTERAP *
CANNOT EXECUTE AT CURRENT POSITION η
XXX cycle not found
TLOCATE. CQUARTERAP EQ 'X' AND YEARAP EQ
'XX'
EOF:
DELETE CQUARTERAP *
CANNOT EXECUTE AT CURRENT POSITION η
XXX cycle not found
TLOCATE. CQUARTERAP EQ 'X' AND YEARAP EQ
'XX'
EOF:
DELETE CQUARTERAP *
CANNOT EXECUTE AT CURRENT POSITION η
XXX cycle not found
SAVE
FILE
Note: the above error message will also occur if a valid quarter/year is entered, but there is no data for that quarter/year in the UADM database.
Log entries:
Report distribution:
· None
Rerun Procedures:
This job is NOT rerunnable.
· The STEP1.PSTEP01 step copies the UADM Focus database to a GDG file as backup before the purge step in STEP1.PSTEP02. If the job fails in this copy step, then check to see if the GDG file UAD.FOC.UADM.PRESET(+1) was created:
o If the generation dataset WAS created but there is something wrong with it, then erase that generation of the backup dataset (using TSO) and rerun the job from the beginning.
o If no GDG file was created, then simply rerun the job from the beginning.
· If the job fails in STEP1.PSTEP02 OR if the job must be entirely rerun (e.g., the incorrect cycles of data were deleted), then the UADM Focus database will need to be restored:
o From TSO, rename the UAD.FOC.UADM.CURRENT database to something like UAD.FOC.UADM.CURRBAD.Dyymmdd
o Run the UADREST restore job, responding to the prompts that the backup file to be used is a GDG from the UADSETUP job.
o Restart the job in STEP1.PSTEP02. (Note: if restoring from some earlier backup file, then rerun the entire job; see note below)
NOTE: STEP1.PSTEP01 creates a generation dataset (GDG) backup copy of the UADM database prior to update. The GDG backup dataset UAD.FOC.UADM.PRESET(0) only retains 3 versions. Do NOT rerun or restart this job more than twice without checking with the maintenance programmer, since multiple reruns could result in having no good backup file.
NOTE: If other update jobs have been run before it is decided that UADSETUP must be rerun, then contact the maintenance programmer or Data Warehouse and Corporate Systems contact to determine restore and rerun steps.
Last Updated: March 18, 2008
The UADUETS job first edits the data received from the Educational Testing Service (ETS) and then uses the edited data to update the UADM database.
Frequency:
Monthly (JAN DEC)
Programs Executed:
STEP1 Proc UADGETFL
PSTEP01 IEFBR14 delete files
PSTEP02 IEFBR14 allocate temp input file
PSTEP03 FTP receive from vsftp into temp file
PSTEP04 IRXJCL check for empty input file
STEP2 Proc UADUETS
PSTEP01 IEFBR14 delete files
PSTEP02 UADEETS Cobol edit ETS data
PSTEP03 IEFBR14 delete files
PSTEP04 FILEAID copy temp input file to permanent file
PSTEP05 IEFBR14 delete files
PSTEP06 FOCUS, UADEETS produce edit reports
PSTEP07 FILEAID create backup of UADM database (GDG backup)
PSTEP08 IEFBR14 delete file
PSTEP09 FOCUS, UADUETS update UADM database with ETS data
PSTEP10 IEFBR14 delete file
PSTEP11 FOCUS, UADC101 produce 101 report
PSTEP12 IEFBR14 delete file
PSTEP13 FOCUS, IRC2PDF convert report to PDF format
STEP3 FTP (no proc)
Input Files:
on vsftp.ucop.edu:
/ftphome/ftpusret/put/css/UADETS.mmmyy
PRO.MNT.MASTER(UADE101)
PRO.MNT.MASTER(UADE102)
PRO.MNT.MASTER(UADEX04)
PRO.MNT.MASTER(UADEX05)
PRO.MNT.MASTER(UADM)
PRO.MNT.MASTER(IRCRPT)
PRO.CTL.CNTLIB(FICOPY)
PRO.CTL.CNTLIB(IRC2PDF)
Created Files:
UAD.UADETS.TEMP
UAD.UADETS.mmmyy
UAD.UADUETS.ETSINUAD.mmmyy
UAD.UADUETS.UADE101.TEMP
UAD.UADUETS.UADE102.TEMP
UAD.UADUETS.UADE103.TEMP
UAD.UADUETS.UADE104.TEMP
UAD.UADUETS.UADE105.TEMP
UAD.UADEED.mmmyy.RPT
UAD.FOC.UADM.PREETS(+1)
UAD.UADUETS.UADC101.mmmyy
UAD.UADC101.mmmyy
UAD.UADEED.PDF
on vsftp.ucop.edu:
/ftphome/ftpusru/get/css/UADEED.mmmyy.PDF
Updated Files:
UAD.FOC.UADM.CURRENT
Resource Requirements
Elapsed Time 2 minutes
CPU Time 5 seconds
Print Lines Job Log only
Job Class - A
Tape Drives - none
Pre-processing Instructions:
Dependencies:
·
The
file for the month must have been received from the Educational Testing Service
(ETS) (see vsftp info above)
·
Notification
from the Data Warehouse and Corporate Systems (DWCS) Contact that we are ready
to proceed with UAD monthly processing.
· UADSETUP must have run.
Prompted variables:
· &MMM month of current cycle. Valid values are: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC
· &YY year of processing (e.g., 05 for 2005)
· &LIM the number of errors that will be printed on the edit reports (normally set to 500)
· &JRS - JOB RESTART STEP - Indicates at which step to restart the job. Default is 1; 1 should be used unless restarting the job (see rerun instructions).
· &PRS - PROC RESTART STEP - Indicates at which step within the proc to restart the job. Default is 01; 01 should be used unless restarting the job (see rerun instructions).
Post-processing Instructions:
Verification:
· Condition codes are zero for all steps
Spurious error messages:
· None
Log entries:
· Date job run
· Transaction and segment counts from FOCUS Modify (update to UADM database in STEP1.PSTEP07)
Report distribution:
· None (reports are made available to campuses via ftp on the vsftp site)
Rerun Procedures:
This job is NOT rerunnable:
· If the job fails in step 1, fix the problem with the input file, remove the .SENT suffix on the file name on vsftp if necessary, and rerun from the beginning.
· If the job fails in any steps between STEP2.PSTEP01 and STEP2.PSTEP06, then the job may be rerun from the beginning after removing the .SENT suffix on the file name on vsftp.
· The STEP2.PSTEP07 step copies the UADM Focus database to a GDG file as backup before the update step in STEP2.PSTEP09. If the job fails in this copy step, then check to see if the GDG file UAD.FOC.UADM.PREETS(+1) was created:
o If the generation dataset WAS created but there is something wrong with it, then erase that generation of the backup dataset (using TSO) and RESTART the job in STEP1.PSTEP07.
o If no GDG file was created, then simply RESTART the job in STEP2.PSTEP07.
· If the job fails in STEP2.PSTEP09 OR if the job must be entirely rerun (e.g., there was something wrong with the campus input data), then the UADM Focus database will probably need to be restored:
o If
the job fai
o If some updates occurred or if this is a complete rerun, then the UADM database must be restored before restarting or rerunning the job:
· From TSO, rename the UAD.FOC.UADM.CURRENT database to something like UAD.FOC.UADM.CURRBAD.Dyymmdd
· Run the UADREST restore job, responding to the prompts that the backup file to be used is a GDG from the UADUETS job.
·
If the job fai
· The last four steps of the proc in STEP2, STEP2.PSTEP10 through STEP2.PSTEP13 runs a Focus program to create a report, and then converts the report to PDF format. If the job fails anywhere in these three steps then restart the job in STEP2.PSTEP10.
· If the job fails in STEP3, the ftp step to copy the PDF format edit report to the very secure ftp site, then restart the job in STEP3. Since this step does not invoke a proc, the RESTART parameter must be modified in the OLDJCL library before submitting. The RESTART will look like this:
RESTART=(STEP3.PSTEP01),
Change the RESTART line to:
RESTART=(STEP3),
NOTE: STEP2.PSTEP07 creates a generation dataset (GDG) backup copy of the UADM database prior to update. The GDG backup dataset UAD.FOC.UADM.PREETS(0) only retains 3 versions. Do NOT rerun or restart this job more than twice without checking with the maintenance programmer, since multiple reruns could result in having no good backup file.
NOTE: If other update jobs have been run before it is decided that UADUCMP must be rerun, then contact the maintenance programmer or Data Warehouse and Corporate Systems contact to determine restore and rerun steps.
Last Updated: June
11, 2010
The UADUCMP job first extracts data from three CSS tables: CCM, Location and ATP. The job then combines the campus UADCMP interface files, edits the combined files and updates the UADM Focus database.
Frequency:
Monthly (JAN DEC)
Programs Executed:
STEP1 Proc UADXTBLS
PSTEP01 IEFBR14 delete files
PSTEP02 FOCUS, UADXTBLS extract data from CSS tables
STEP2 Proc UADUCMP
PSTEP01 IEFBR14 delete file
PSTEP02 SORT sort, combine campus UADCMP input files
PSTEP03 IEFBR14 delete files
PSTEP04 COBOL,UADCMPED combined campus UADCMP files
PSTEP05 IEFBR14 delete files
PSTEP06 FOCUS, UADSCMP process edited file
PSTEP07 FILEAID copy UADM Focus database for backup
PSTEP08 FOCUS, UADUCMP update UADM Focus database with campus data
PSTEP09 FOCUS, UADROLL update UADM winter/spring rollovers missing vendor data with fall
vendor data
Input Files:
CSS.FOC.CSSCCM.ALLYRS
CSS.FOC.CSSLOC.ALLYRS
CSS.FOC.CSSATP.ALLYRS
UAD.UADCMPBK.mmmyy
UAD.UADCMPDV.mmmyy
UAD.UADCMPLA.mmmyy
UADUADCMPRV.mmmyy
UAD.UADCMPSD.mmmyy
UADUADCMPSC.mmmyy
UADUADCMPSB.mmmyy
UAD.UADCMPIR.mmmyy
UAD.UADCMPMC.mmmyy
where mmm may be: JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
PRO.MNT.MASTER(CSSCCM)
PRO.MNT.MASTER(CSSLOC)
PRO.MNT.MASTER(CSSATP)
PRO.MNT.MASTER(UAD1CMP)
PRO.MNT.MASTER(UADCMPIN)
PRO.MNT.MASTER(UADCMP)
PRO.MNT.MASTER(UADM)
PRO.CTL.CNTLIB(UADXTBLS)
PRO.CTL.CNTLIB(UADCMP)
PRO.CTL.CNTLIB(UAD1CMP1)
PRO.CTL.CNTLIB(UADCMP2)
PRO.CTL.CNTLIB(UAD1CMP2)
PRO.CTL.CNTLIB(UADSCMP)
PRO.CTL.CNTLIB(FICOPY)
PRO.CTL.CNTLIB(UADUCMP)
Created Files:
UAD.CSSXCCM.TEMP
UAD.CSSXLOC.TEMP
UAD.CSSXSCH.TEMP
UAD.UADCMPAL.mmmyy
UAD.UADRCMP.UADE201.TEMP
UAD.UADRCMP.UADE202.TEMP
UAD.UADRCMP.UADE203.TEMP
UAD.UADRCMP.UADE205.TEMP
UAD.UADUCMP.UADSCMP.TEMP
UAD.FOC.UADM.PRECMP(+1)
Updated Files:
UAD.FOC.UADM.CURRENT
Resource Requirements
Elapsed Time 15 minutes
CPU Time 3 minutes
Print Lines Job Log only
Job Class - A
Tape Drives - none
Pre-processing Instructions:
Dependencies:
·
The
UAD input files (UADCMP) for every campus must have been edited (UADRCMP job)
and the edits approved
·
The
UADSETUP and UADUETS job must have been run.
·
The
UADUETS report must have been approved by the functional user.
Prompted variables:
· &MMM month of current cycle. Valid values are: FEB, APR, MAY, JUN, AUG, OCT, DEC
· &YY year of processing (e.g., 05 for 2005)
· &JRS - JOB RESTART STEP - Indicates at which step to restart the job. Default is 1; 1 should be used unless restarting the job (see rerun instructions).
· &PRS - PROC RESTART STEP - Indicates at which step within the proc to restart the job. Default is 01; 01 should be used unless restarting the job (see rerun instructions).
Post-processing Instructions:
Verification:
· Condition codes are zero for all steps
Spurious error messages:
· None
Log entries:
· Date job run
· Transaction and segment counts from the Modify (STEP2.PSTEP13)
Report distribution:
· None
Rerun Procedures:
This job is NOT rerunnable:
· If the job fails in any steps between STEP1.PSTEP01 and STEP2.PSTEP07, then the job may be rerun from the beginning.
· The STEP2.PSTEP07 step copies the UADM Focus database to a GDG file as backup before the update step in STEP2.PSTEP11. If the job fails in this copy step, then check to see if the GDG file UAD.FOC.UADM.PRECMP(+1) was created:
o If the generation dataset WAS created but there is something wrong with it, then erase that generation of the backup dataset (using TSO) and RESTART the job in STEP2.PSTEP07.
o If no GDG file was created, then simply RESTART the job in STEP2.PSTEP07
· If the job fails in STEP2.PSTEP08 OR if the job must be entirely rerun (e.g., there was something wrong with the campus input data), then the UADM Focus database will probably need to be restored:
o If
the job fai
o If some updates occurred or if this is a complete rerun, then the UADM database must be restored before restarting or rerunning the job:
§ From TSO, rename the UAD.FOC.UADM.CURRENT database to something like UAD.FOC.UADM.CURRBAD.Dyymmdd
§ Run the UADREST restore job, responding to the prompts that the backup file to be used is a GDG from the UADUCMP job.
§ If
the job fai
NOTE: STEP2.PSTEP07 creates a generation dataset (GDG) backup copy of the UADM database prior to update. The GDG backup dataset UAD.FOC.UADM.PRECMP(0) only retains 3 versions. Do NOT rerun or restart this job more than twice without checking with the maintenance programmer, since multiple reruns could result in having no good backup file.
NOTE: If other update jobs have been run before it is decided that UADUCMP must be rerun, then contact the maintenance programmer or Data Warehouse and Corporate Systems contact to determine restore and rerun steps.
Last Updated: March 18, 2008
The UADFLAG job computes flags based on examination and comparison of certain data elements for an ETSNO within the UADM Focus database, and then updates the flag field in the common segment.
Frequency:
Monthly (JAN DEC)
Programs Executed:
STEP1 Proc UADFLAG
PSTEP01 IEFBR14 delete files
PSTEP02 FOCUS, UADFLAG extract UADM data, compute flags and update UADM database
Input Files:
UAD.FOC.UADM.CURRENT
CSS.FOC.CSSLOC.ALLYRS
CSS.FOC.CSSCOL.ALLYRS
CSS.FOC.CSSATP.ALLYRS
CSS.FOC.CSSMAJOR.ALLYRS
PRO.MNT.MASTER(UADM)
PRO.MNT.MASTER(CSSLOC)
PRO.MNT.MASTER(CSSCOL)
PRO.MNT.MASTER(CSSATP)
PRO.MNT.MASTER(CSSMAJOR)
PRO.MNT.MASTER(CSSSCH)
PRO.CTL.CNTLIB(UADFLAG)
Created Files:
UAD.UADFLAG.UAD7.TEMP
UAD.UADFLAG.UADFLAGS.TEMP
Updated Files:
UAD.FOC.UADM.CURRENT
Resource Requirements
Elapsed Time 3 minutes
CPU Time 20 seconds
Print Lines no reports printed
Pre-processing Instructions:
Dependencies:
·
The UADUETS
and UADUCMP jobs must have completed successfully
Prompted variables:
· &JRS - JOB RESTART STEP - Indicates at which step to restart the job. Default is 1; 1 should be used unless restarting the job (see rerun instructions).
· &PRS - PROC RESTART STEP - Indicates at which step within the proc to restart the job. Default is 01; 01 should be used unless restarting the job (see rerun instructions).
Post-processing Instructions:
Verification:
· Condition codes are zero for all steps
· No Focus errors
· TOTAL transactions must equal ACCEPTED transactions in the Focus MODIFY (in STEP1.PSTEP02)
· REJECTED transactions must equal zero (in STEP1.PSTEP02)
Spurious error messages:
· None
Log entries:
Report distribution:
· None
Rerun Procedures:
This job is rerunnable.
Note: this job does update the UADM Focus database. Normally such an update job would NOT be rerunnable, but the value of the updated fields are determined based on independent data in the database, and rerunning will simply recalculate the same values and overlay the same flag fields.
Last Updated: March 18, 2008
The UAD501 job produces the following monthly reports:
· UAD501 Focexec: produces 501-A through 501-H Campus and Systemwide reports (Undergraduate Admissions Application flow)
Frequency:
Monthly, after UADUCMP and UADFLAG jobs have completed
Programs Executed:
STEP1 Proc UAD501
PSTEP01 IEFBR14 delete files
PSTEP02 FOCUS, UAD501 create Campus and Systemwide reports
STEP2 Proc MNTPRINT
PSTEP01 SORT print report
Input Files:
UAD.FOC.UADM.CURRENT
CSS.FOC.CSSCOL.ALLYRS
CSS.FOC.CSSLOC.ALLYRS
CSS.FOC.CSSATP.ALLYRS
CSS.FOC.CSSMAJOR.ALLYRS
PRO.MNT.MASTER(UADM)
PRO.MNT.MASTER(CSSCOL)
PRO.MNT.MASTER(CSSLOC)
PRO.MNT.MASTER(CSSATP)
PRO.MNT.MASTER(CSSMAJOR)
Created Files:
UAD.UAD501.RPT
Updated Files:
None
Resource Requirements
Elapsed Time 2 minutes
CPU Time 40 seconds
Print Lines 7,000 lines
Pre-processing Instructions:
Dependencies:
·
The
UADUCMP and the UADFLAG jobs must have completed successfully for the current
month
Prompted variables:
· &YY current calendar year of processing (e.g., 05 for 2005) (not academic year)
· &JRS - JOB RESTART STEP - Indicates at which step to restart the job. Default is 1; 1 should be used unless restarting the job (see rerun instructions).
· &PRS - PROC RESTART STEP - Indicates at which step within the proc to restart the job. Default is 01; 01 should be used unless restarting the job (see rerun instructions).
Post-processing Instructions:
Verification:
· Condition codes are zero for all steps
· no Focus errors
Spurious error messages:
· None
Log entries:
Report distribution:
· All reports to the Data Warehouse and Corporate Systems contact
Rerun Procedures:
This job is rerunnable.
Last Updated: June 11, 2010
The UADWEXT job creates two extract files, one containing common and vendor data and the second containing campus-level data. These two extract files are ftped to unix, for loading into the student data warehouse.
Frequency:
Monthly (JAN DEC)
Programs Executed:
STEP1 Proc UADWEXT
PSTEP01 IEFBR14 delete files
PSTEP02 FOCUS, UADWUAC extract UADM campus data
PSTEP03 IEFBR14 delete files
PSTEP04 FOCUS, UADWUAV extract UADM common and vendor data
Input Files:
UAD.FOC.UADM.CURRENT
CSS.FOC.CSSLOC.ALLYRS
CSS.FOC.CSSCOL.ALLYRS
CSS.FOC.CSSATP.ALLYRS
CSS.FOC.CSSMAJOR.ALLYRS
CSS.FOC.CSSCCM.ALLYRS
CSS.FOC.CSSCIP.ALLYRS
CSS.FOC.CSSUCDSP.ALLYRS
PRO.MNT.MASTER(UADM)
PRO.MNT.MASTER(CSSLOC)
PRO.MNT.MASTER(CSSCOL)
PRO.MNT.MASTER(CSSATP)
PRO.MNT.MASTER(CSSMAJOR)
PRO.MNT.MASTER(CSSCCM)
PRO.MNT.MASTER(CSSCIP)
PRO.MNT.MASTER(CSSUCDSP)
PRO.CTL.CNTLIB(UADFLAG)
Created Files:
UAD.UADWUAC campus extract
UAD.UADWUACC campus extract record count
UAD.UADWUACY cycle
UAD.UADWUAV vendor extract
UAD.UADWUAVC vendor extract record count
UAD.UADWUAV2 vendor extract 2
Updated Files:
None
Resource Requirements
Elapsed Time 15-20 minutes
CPU Time 2-3 minutes
Print Lines Job Log only
Job Class - A
Tape Drives - none
Pre-processing Instructions:
Dependencies:
·
The UADUETS,
UADUCMP and UADFLAG jobs must have completed successfully
Prompted variables:
· &MON month of current cycle. Valid values are: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC
· &YEAR year of processing (e.g., 2005)
· &JRS - JOB RESTART STEP - Indicates at which step to restart the job. Default is 1; 1 should be used unless restarting the job (see rerun instructions).
· &PRS - PROC RESTART STEP - Indicates at which step within the proc to restart the job. Default is 01; 01 should be used unless restarting the job (see rerun instructions).
Post-processing Instructions:
Verification:
· Condition codes are zero for all steps
· No Focus errors
Spurious error messages:
· None
Log entries:
Report distribution:
· None
Rerun Procedures:
This job is rerunnable.
Last Updated: September 25, 2008
Unix Server: Vulcan
Unix Account: dwhstup
Zeke Driver Script: /apps/iscprod/dwhstu/zekejobs/uadzext.sh
Description:
This job loads the UAD extracts created by MVS job UADWEXT into the DWH.
Frequency:
Every other month, after MVS job UADWEXT has completed successfully.
Zeke Parameters:
None
Other Parameters:
None
Shell Scripts Called:
/apps/iscprod/dwhstu/uadzext_dwh_uad_load.sh
Sybase
Stored Procedures Called:
dwh_stu_uad_ld_all_applic_cnt.sp
dwh_stu_uad_ld_all_applic2_cnt.sp
dwh_stu_uad_ld_all_appliccmp_cnt.sp
SQL scripts called
dwh_stu_uad_ld_all_applic.lod
dwh_stu_uad_ld_all_applic2.lod
dwh_stu_uad_ld_all_appliccmp.lod
Programs
Called:
Input Files:
passwd
dwh_stu_uad_cycle.dat
dwh_stu_uad_applic.dat
dwh_stu_uad_applic_cnt.dat
dwh_stu_uad_appliccmp.dat
dwh_stu_uad_appliccmp_cnt.dat
dwh_stu_uad_applic2.dat
dwh_stu_uad_applic2_cnt.dat
Output
Files:
dwh_stu_uad_cycle.$cycle
dwh_stu_uad_applic.$cycle.Z
dwh_stu_uad_applic_cnt.$cycle
dwh_stu_uad_appliccmp.$cycle.Z
dwh_stu_uad_appliccmp_cnt.$cycle
dwh_stu_uad_applic2.$cycle.Z
dwh_stu_uad_applic2_cnt.$cycle
Input Sybase Tables:
None
Updated Sybase Tables:
Stu_UAD_All_Applic_Tbl
Stu_UAD_All_Applic2_Tbl
Stu_UAD_All_Appliccmp_Tbl
Log
Files:
Resource
Requirements:
Normally this job takes less than 10 minutes elapsed time
Dependencies:
MVS job UADWEXT must have completed successfully.
Processing Instructions:
None
Post-processing Instructions/Problem resolution/Rerun Instructions:
Last Updated: August 21, 2007
The UADBKP job creates an onsite disk copy of the UADM Focus database (UAD.FOC.UADM.CURRENT) and the current production Focus Master for the UADM database (PRO.MNT.MASTER(UADM)).
Frequency:
Monthly, after all updates to the UADM database have occurred, and also quarterly, after the quarterly jobs are run that update the UADM database (UADUREG and UADUQTR).
Programs Executed:
STEP1 Proc UADBKP
PSTEP01 FILEAID copy UADM Focus database for onsite backup
PSTEP02 FILEAID copy UADM Focus Master for onsite backup
Input Files:
UAD.FOC.UADM.CURRENT
PRO.MNT.MASTER(UADM)
PRO.CTL.CNTLIB(FICPYMLT)
Created Files:
UAD.FOC.UADM.ARC.Dyymmdd disk backup with management class MC1825 (5 year retention) UAD.MAS.UADM.ARC.Dyymmdd disk backup with management class MC1825 (5 year retention)
Updated Files:
None
Resource Requirements
Elapsed Time 5 minutes
CPU Time 2 seconds
Print Lines Job Log only
Job Class - A
Tape Drives - none
Pre-processing Instructions:
Dependencies:
·
For
monthly processing, the monthly UAD update jobs must have completed
successfully (UADUETS, UADUCMP AND UADFLAG)
·
For
quarterly processing, the UADREG and UADAQTR jobs must have completed
successfully
Prompted variables:
· &JRS - JOB RESTART STEP - Indicates at which step to restart the job. Default is 1; 1 should be used unless restarting the job (see rerun instructions).
· &PRS - PROC RESTART STEP - Indicates at which step within the proc to restart the job. Default is 01; 01 should be used unless restarting the job (see rerun instructions).
Note: the date in the backup dataset names is the system date in YYMMDD format. This backup job cannot be run twice in the same day.
Post-processing Instructions:
Verification:
· Condition codes are zero for all steps
Spurious error messages:
· None
Log entries:
· Date job run
Report distribution:
· None
Additional procedures:
· None
Rerun Procedures:
· This job is rerunnable.
Because there is no delete step, the datasets will need to be deleted before re-running this job.
Last Update: June 11, 2010
The yearly processing for the Undergraduate Admissions system (UAD) consists of the following jobs:
Job Description
UADUQTR on MVS This job removes 1, 2, 3 or 4 quarters of data from the UADM database (after making a backup copy of the UADM Focus database). The quarters to be deleted are passed as parameters to the job. This job runs on request before the April Load.
UADBKP This
job creates an onsite disk copy of the UADM Focus database for backup purposes.
See monthly processing for details on this job.
Last Updated: April 14, 2010
The UADUQTR first copies the UADM Focus database for backup purposes (UAD.FOC.UADM.PREQTR(0)) and then deletes all data in the UADM Focus database for selected quarters, identified by quarter (2, 3 or 4) and year. At least one quarter must be selected for deletion, and up to four quarters may be deleted in one run of UADUQTR.
Frequency:
Yearly, before the April load, which starts the processing
for next academic year.
Programs Executed:
STEP1 Proc UADUREG
PSTEP01 FILEAID copy UADM Focus database for backup
PSTEP02 FOCUS, UADUQTR delete data for selected quarters in UADM Focus database
Input Files:
PRO.MNT.MASTER(UADM)
Created Files:
None
Updated Files:
UAD.FOC.UADM.CURRENT
Resource Requirements
Elapsed Time 1 - 18 minutes
CPU Time 1-10 seconds
Print Lines Job Log only
Job Class - A
Tape Drives - none
Pre-processing Instructions:
Dependencies:
·
This job
should be run after the UADBKP job during the April cycle, and the prompted
variables should be as follows:
&Q1 =
2, &YY1 = current calendar year - 2
&Q2 =
3, &YY2 = current calendar year 1
&Q3 =
4, &YY3 = current calendar year 1
Ex: in
April 2010, we purge 208, 309 and 409
Prompted variables:
· &Q1 quarter of the first quarter/year to be deleted (must be 2, 3 or 4)
· &YY1 2-digit year for the first quarter/year to be deleted (must be entered)
· &Q2 quarter of the second quarter/year to be deleted, or leave as X if there is only one quarter/year to delete (if entered, must be 2, 3 or 4)
· &YY2 2-digit year for the second quarter/year to be deleted, or leave as XX if there is only one quarter/year to delete (if entered, must be numeric)
· &Q3 quarter of the third quarter/year to be deleted, or leave as X if there are less than three quarter/years to delete (if entered, must be 2, 3 or 4)
· &YY3 2-digit year for the third quarter/year to be deleted, or leave as XX if there are less than three quarter/years to delete (if entered, must be numeric)
· &Q4 quarter of the fourth quarter/year to be deleted, or leave as X if there are less than four quarter/years to delete (if entered, must be 2, 3 or 4)
· &YY4 2-digit year for the fourth quarter/year to be deleted, or leave as XX if there are less than four quarter/years to delete (if entered, must be numeric)
· &JRS - JOB RESTART STEP - Indicates at which step to restart the job. Default is 1; 1 should be used unless restarting the job (see rerun instructions).
· &PRS - PROC RESTART STEP - Indicates at which step within the proc to restart the job. Default is 01; 01 should be used unless restarting the job (see rerun instructions).
Post-processing Instructions:
Verification:
· Condition codes are zero for all steps
· No Focus errors
A short report counting records by quarter/year will print in the STEP1.PSTEP02 SYSPRINT log of the Focexec, both before and after the deletions. The before-purge report appears as follows:
NUMBER
OF RECORDS IN TABLE= 446 LINES=
2
PAGE 1
PGM
ID: UADUQTR COUNTS BEFORE
REBUILD
15.17.20
YEAR
QUARTER CAMPUS
APPLIED APPLIED
APPLIED APPLICANTS
------- -------
------- ----------
05 3 329 308
07 2 117 117
TOTAL 446 425
The after-purge report appears as follows:
NUMBER OF RECORDS IN TABLE= 117
LINES= 1
PAGE
1
PGM ID: UADUQTR COUNTS AFTER REBUILD
15.17.22
YEAR
QUARTER CAMPUS
APPLIED
APPLIED APPLIED APPLICANTS
-------
------- ------- ----------
07
2 117 117
TOTAL 117 117
Spurious error messages:
If less than four cycles of data are specified on the job panel for deletion, then one or more quarter/year values will be set to Xs. Since Xs are not found in the database, the following messages will appear in the SYSPRINT file for STEP1.PSTEP02:
----------------------------------------------------------------------
FOCUS
7.1.1 15.17.21
SCAN FILE UADM
SCAN:
TLOCATE. CQUARTERAP EQ '3' AND YEARAP EQ
'05'
DELETE CQUARTERAP *
EOF:
SEGMENTS DELETED= 1253 η 305 cycle deleted
TLOCATE. CQUARTERAP EQ 'X' AND YEARAP EQ
'XX'
EOF:
DELETE CQUARTERAP *
CANNOT EXECUTE AT CURRENT POSITION η
XXX cycle not found
TLOCATE. CQUARTERAP EQ 'X' AND YEARAP EQ
'XX'
EOF:
DELETE CQUARTERAP *
CANNOT EXECUTE AT CURRENT POSITION η
XXX cycle not found
TLOCATE. CQUARTERAP EQ 'X' AND YEARAP EQ
'XX'
EOF:
DELETE CQUARTERAP *
CANNOT EXECUTE AT CURRENT POSITION η
XXX cycle not found
SAVE
FILE
Note: the above error message will also occur if a valid quarter/year is entered, but there is no data for that quarter/year in the UADM database.
Log entries:
Report distribution:
· None
Rerun Procedures:
This job is NOT rerunnable.
· The STEP1.PSTEP01 step copies the UADM Focus database to a GDG file as backup before the purge step in STEP1.PSTEP02. If the job fails in this copy step, then check to see if the GDG file UAD.FOC.UADM.PREQTR(+1) was created:
o If the generation dataset WAS created but there is something wrong with it, then erase that generation of the backup dataset (using TSO) and rerun the job from the beginning.
o If no GDG file was created, then simply rerun the job from the beginning.
· If the job fails in STEP1.PSTEP02 OR if the job must be entirely rerun (e.g., the incorrect cycles of data were deleted), then the UADM Focus database will need to be restored:
o From TSO, rename the UAD.FOC.UADM.CURRENT database to something like UAD.FOC.UADM.CURRBAD.Dyymmdd
o Run the UADREST restore job, responding to the prompts that the backup file to be used is a GDG from the UADUQTR job.
o Restart the job in STEP1.PSTEP02. (Note: if restoring from some earlier backup file, then rerun the entire job; see note below)
NOTE: STEP1.PSTEP01 creates a generation dataset (GDG) backup copy of the UADM database prior to update. The GDG backup dataset UAD.FOC.UADM.PREQTR(0) only retains 3 versions. Do NOT rerun or restart this job more than twice without checking with the maintenance programmer, since multiple reruns could result in having no good backup file.
NOTE: If other update jobs have been run before it is decided that UADUQTR must be rerun, then contact the maintenance programmer or Data Warehouse and Corporate Systems contact to determine restore and rerun steps.
The miscellaneous processing for the Undergraduate Admissions system (UAD) consists of the following job:
Job Description
UADREST on MVS This job restores the current UADM Focus database from a disk backup file from either one of the update jobs (UADUETS, UADUCMP, UADUREG or UADUQTR) or from the UADBKP job run after monthly and quarterly processing.
UADRSTOF on MVS This job restores the current UADM Focus database from an offsite cartridge backup file from the UADBKP job run after monthly and quarterly processing. (NOTE: THIS JOB DOES NOT EXIST YET)
Last Updated:
The UADREST job restores the current UADM Focus database from a disk backup. The disk backup file may be from any of the following:
|
UAD Job Creating Disk Backup File |
MVS Dataset Name (DSN) of Backup File |
Comments |
|
UADUETS |
UAD.FOC.UADM.PREETS(0) |
Backup from the beginning of theUADUETS job before ETS updates are made |
|
UADUCMP |
UAD.FOC.UADM.PRECMP(0) |
Backup from the beginning of theUADUCMP job before campus updates are made |
|
UADUQTR |
UAD.FOC.UADM.PREQTR(0) |
Backup from the beginning of theUADUQTR job before data is purged from UADM database |
|
UADBKP |
UAD.FOC.UADM.BKP.Dyymmdd |
Backup from UADBKP job run after monthly and after quarterly processing (yymmdd date is run date) |
Note: This restore job assumes that the current UADM Focus database (UAD.FOC.UADM.CURRENT) has either been erased or renamed before the restore job is submitted. This is to avoid accidentally destroying a good version of the current UADM Focus database if UADREST is run inadvertently.
Note: to restore the UADM Focus database from an offsite tape (cartridge) backup, use the UADRSTOF job instead of the UADREST job.
Frequency:
Only run this job when the UADM database must be restored.
Programs Executed:
STEP1 Proc UADREST
PSTEP01 FILEAID copy disk backup to current UADM Focus database
Input Files:
One of the following disk backup copies of the UADM Focus database:
UAD.FOC.UADM.PREETS(0) or UAD.FOC.UADM.PREETS.GggggV00
UAD.FOC.UADM.PRECMP(0) or UAD.FOC.UADM.PRECMP.GggggV00
UAD.FOC.UADM.PREQTR(0) or UAD.FOC.UADM.PREQTR.GggggV00
UAD.FOC.UADM.BKP.Dyymmdd
PRO.CTL.CNTLIB(FICOPY)
Created Files:
UAD.FOC.UADM.CURRENT
Updated Files:
None
Resource Requirements
Elapsed Time 1 minute
CPU Time 1 second
Print Lines Job Log only
Job Class - A
Tape Drives - none
Pre-processing Instructions:
Dependencies:
·
This
restore job should ONLY be run when there is a problem with the UADM database
·
The UAD.FOC.UADM.CURRENT
production Focus file must first be either renamed or deleted via TSO
Prompted variables:
· &N enter number corresponding to the backup file to use for restoring the UADM database:
· If the backup file to be used is BKP (from the UADBKP job N is 1 above), then enter the run date of the backup file to be used (otherwise, ignore the run date on the panel):
· If the backup file to be used is from any of the update jobs that created a generation dataset (GDG) prior to update (N is 2, 3 or 4 above), then enter either the specific 4-digit generation number of the backup file to be used for the restore, or a single 0 (zero) with trailing blanks if the most recent version of the GDG is to be used for the restore
Post-processing Instructions:
Verification:
· Condition code is zero for the single step
Spurious error messages:
· None
Log entries:
Report distribution:
· None
Rerun Procedures:
This job is NOT rerunnable. If the restore job runs successfully but must be rerun (e.g., the wrong backup file was used for the restore), then the current UADM Focus database (UAD.FOC.UADM.CURRENT) must again be deleted or renamed using TSO before rerunning the UADREST job.
Last Updated: April, 14, 2006
The UADREORG job rebuilds/reorgs the UADM focus database after a master change.
Frequency:
Only run this job when the the UADM master has been changed,
upon request by analyst.
Programs Executed:
STEP1 FILEAID copy UAD.FOC.UADM.CURRENT to UAD.FOC.UADM.Yyyyy for backup purpose
STEP2 - FOCUS rebuild/reorg UAD.FOC.UADM.CURRENT in place
Input Files:
UAD.FOC.UADM.CURRENT
Created Files:
UAD.FOC.UADM.Yyyyy
Updated Files:
UAD.FOC.UADM.CURRENT
Resource Requirements
Elapsed Time 15 minutes
CPU Time 4 minutes
Print Lines Job Log only
Job Class - A
Tape Drives - none
Pre-processing Instructions:
Dependencies:
·
The
old UADM master must have been renamed to PRO.MNT.MASTER(UADMyyyy)
·
The
new UADM master must have been installed in production.
Prompted variables:
· &YYYY enter year of old master per analysts instructions. This parameter must echo the old master name. ex: if old master has been renames UADM2005, enter 2005 on the panel.
Post-processing Instructions:
Verification:
· Condition code is zero for both steps
· There are no Focus errors
Spurious error messages:
· None
Log entries:
Report distribution:
· None
Rerun Procedures:
This job is NOT rerunnable. Contact analyst if any problem occurs.
Last Updated: June 1, 2010
The UADUREG job extracts register flag data from the CSS REG database and uses this extract to update the register flag in the UADM database. This job is no longer run separately, as it is integrated into UADUCMP.
Frequency:
Quarterly, during the final UAD cycle for each term: in December for fall, in June for Winter,
August for Spring.
Programs Executed:
STEP1 Proc UADXREG
PSTEP01 IEFBR14 delete file
PSTEP02 FOCUS, UADXREG extract register flag from CSS REG database
STEP2 Proc UADUREG
PSTEP01 IEFBR14 delete files
PSTEP02 FOCUS, UADUREG update register flag in UADM database
Input Files:
CSS.FOC.CSSREG.Yyyyy
CSS.FOC.CSSREGIN.Yyyyy
PRO.MNT.MASTER(CSSREG)
PRO.MNT.MASTER(UADM)
PRO.CTL.CNTLIB(UADUREG)
Created Files:
UAD.UADRGFLG.TEMP temp file with register flag from CSS REG database
UAD.UADUREG.REJREG.TEMP temp file containing rejected records
Updated Files:
UAD.FOC.UADM.CURRENT
Resource Requirements
Elapsed Time 4 minutes
CPU Time 5 second
Print Lines Job Log only
Job Class - A
Tape Drives - none
Pre-processing Instructions:
Dependencies:
·
CSS REG
Third Week processing for the quarter has completed; and
·
Data
Warehouse and Corporate Systems analyst requests the UADUREG job
·
UADUREG
must run before UADFLAG.
Prompted variables:
· &Q quarter for the cycle being updated (must be 2, 3 or 4)
· &YYYY 4-digit calendar year (This is translated to academic year, to match the year of the CSS REG database used as input. For Fall (q=2) calendar and academic year are the same; for winter (q=3) and spring (q=4), the academic year is equal to calendar year minus 1.)
· &JRS - JOB RESTART STEP - Indicates at which step to restart the job. Default is 1; 1 should be used unless restarting the job (see rerun instructions).
· &PRS - PROC RESTART STEP - Indicates at which step within the proc to restart the job. Default is 01; 01 should be used unless restarting the job (see rerun instructions).
Post-processing Instructions:
Verification:
· Condition codes are zero for all steps
· No Focus errors
· Some transactions should be ACCEPTED transactions in the Focus MODIFY (in STEP2.PSTEP02) but many transactions may be REJECTED
Spurious error messages:
· None
Log entries:
Report distribution:
· None
Rerun Procedures:
This job is rerunnable.
Note: this job DOES update the UADM Focus database. Normally such an update job would NOT be rerunnable. However, only a single field is updated, and rerunning will simply overlay the same value in this field.