SMS Job Scheduling
CMxxxxJ FCxxxxJ ISxxxxJ SDxxxxJ SMxxxxJ SRxxxxJ MGxxxx SGxxxx Other

Build S/F Data by Col,Cip

This job summarizes the FTES, FTEF, and S/F RATIO by college and CIP from the SMIS data base for the specified YRQ and updates the COL-CIP-RATIO-D data set in the TBL3 data base.
Special Instructions This job is for SBCCE use only.
Frequency Quarterly
Scheduling Restrictions None
Execution Time Production (P)
Job Completion Status JOBFAIL
Job Groups None
Job Dependency None
Operator Instructions None
Estimated Run Time 30 MINUTES
Recovery/Restart This job is restartable.


MIS-COL Enter ALL or a valid college code for which COL-CIP-RATIO-D records to be built:
ALL = Build records for all colleges.
nnn = Build records for the specified college only (where nnn is a college code).
SMIS-DB-AYR Leave blank to use current academic year's data base as input. Otherwise, enter academic year of SMIS data base to be used for input (e.g., for academic year 1990-91, enter 9091).
YRQ Enter the year-quarter to be processed.

Distribution: SMS P999
Created: WED, JAN 04, 2012, 07:38 AM