FMS Job Scheduling
BAxxxxJ BMxxxxJ FMxxxxJ GAxxxxJ MMxxxxJ PMxxxxJ FGxxxx Other

FG055R
Room Utilization Reporting

This job group extracts data and provides room utilization reports from either the MIS-2 data or from the Student Management System and Fixed Asset database. The job group also optionally transports the information to the SBCTC database.
Special Instructions MM5301S4-LINE01 thru LINE11 - There are 11 lines, 60 spaces per line, available for entering selection criteria. Separation of each selection criteria is indicated by a semi-colon (;). The format is: SHORT DATA ELEMENT NAME space OPERATOR space VALUE/ Short Data Element Name - refers to the name of the data element that you wish to sort the report on. Operator - refers to the valid comparison operators and descriptions available for specifying selected equipment items. These are: <R>EQ - Equal to. <R>NE - Not equal to. <R>GT - Greater than. <R>GE - Greater than or equal to. <R>LT - Less than. <R>LE - Less than or equal to. <R>IN - In the range. (Inclusive) <R>NI - Not in the range. (Inclusive) <R>OR - Or. <R>Value - refers to entering a value for an alpha/numeric data item. If that item contains embedded blanks, (i.e., MANUF), the value (name of manufacturer) must be in quotes. <R>EXAMPLE "HEWLETT PACKARD" <R>Extracting values with the same data element name implies an OR condition. Extracting values with different data element names implies an AND condition. <R>EXAMPLES: <R>1. Select all equipment records that have not been disposed. <R>MM5301S4-LINE01 DISPOSE-STAT EQ " " 2. Select all equipment records related to computing support where the manufacturer is Hewlett-Packard that have been lost or stolen. <R>MM5301S4-LINE01 NACUBO-PRG EQ 44; MANUF EQ "HEWLETT PACKARD" <R>MM5301S4-LINE02 DISPOSE-STAT EQ 2 OR 3 <R>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
O 01 00 MM5141J
Room Utilization MIS-2 Extract
R 02 01 MM5142J
Room Utilization SMS Extract
R 03 02 MM5307J
Facilities and Equipment Generalized Extract
  Facilities and Equipment Generalized Extract Repor (MM5301)
R 04 03 MM5140J
Room Utilization Process
O 05 04 MM5117J
Room Utilization Reports
  Classroom & Laboratory Utilization (MM5117A)
  Classroom & Laboratory Utilization Summary (MM5117B)
  Laboratory Utilization by Subject Area (MM5117C)
O 06 05 MM5143J
Transfer Room Utilization Data to SBCCE
R 07 06 MM5144J
Room Utilization Purges


Parameters

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"
MM5301S4-LINE01
MM5301S4-LINE02
MM5301S4-LINE03
MM5301S4-LINE04
MM5301S4-LINE05
MM5301S4-LINE06
MM5301S4-LINE07
MM5301S4-LINE08
MM5301S4-LINE09
MM5301S4-LINE10
MM5301S4-LINE11
Extract parameter lines
ROOM-UTIL-YRQ The year/quarter (session) to be processed (YYYQ)

Distribution: FMS
Created: WED, JAN 04, 2012, 07:09 AM