FMS Job Scheduling
BAxxxxJ BMxxxxJ FMxxxxJ GAxxxxJ MMxxxxJ PMxxxxJ FGxxxx Other

FG060R
SBCCE FAE Room Reports

This job group extracts and reports room records from the SBCTC database.
Special Instructions This job group is restricted to SBCTC use. The parameters that appear will depend on the jobs that are selected.
Operator Instructions None


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
R 01 00 CR2134J
SBCCE FAE Extract
O 02 01 MM5110J
Summary of Area and Capacity
  Summary of Area and Capacity by Location, Nacubo P (MM5110)
O 03 02 MM5115J
Room Use Summary by Nacubo Program
  Room Use Summary by Nacubo Program (MM5115)
O 04 03 MM5149J
Room Listing by Building - SBCCE
  Room Listing by Building - SBCCE (MM5149)
O 05 04 MM5147J
Unload Smis Class Data - SBCCE
O 06 05 MM5148J
Room Utilization Process - SBCCE
O 07 06 MM5117J
Room Utilization Reports
  Classroom & Laboratory Utilization (MM5117A)
  Classroom & Laboratory Utilization Summary (MM5117B)
  Laboratory Utilization by Subject Area (MM5117C)
R 08 07 CR2114J
Purge Room Utilization Files


Parameters

COMMOD-GRP Enter "ALL" if all commodities are to be extracted. Enter 2 character Major Group Code to be extracted or 4 character Commodity Group Code to be extracted (e.g., "05" would select buildings only; "2810" would select Aircraft Engines).
FAE-COL The 3-digit college code to be extracted or "ALL", 999 for all colleges. A district may also be specified by entering district number followed by an "X" (e.g., 88X).
MIS-COL Enter ALL, 999 or a valid college for which report is to be produced:
ALL = Produce a college report for all colleges.
999 = Produce a system rollup report only.
nnn = Produce a report for the specified college only (where 'nnn' is a valid college code).
MM5117-COL The value of ALL should be used for SBCCE reporting. The college code should be used if only one college is to be reported.
MM5117-ROOM-OPT Indicator for which rooms to print reports for:
1 = Print all room records in the SMS/MIS-2 & FAE
2 = Print room records in FAE only
3 = Print room records in SMS/MIS-2 only
4 = Pring room records only in both
MM5117-RPT-OPT Enter AB to print the utilization report and the summary report. If all three(3) reports need to be printed, enter ABC.
A = Classroom & Laboratory Utilization Report
B = Classroom & Laboratory Utilization Summary
C = Laboratory Utilization by Subject Area
ALL = Print all reports
MM5117-TIME-LOC Up to ten time location indicators for which the reports are to be run or "ALL"
ROOM-UTIL-YRQ The year/quarter (session) to be processed (YYYQ)
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: FMS P999
Created: WED, JAN 04, 2012, 07:09 AM