FMS Job Scheduling
BAxxxxJ BMxxxxJ FMxxxxJ GAxxxxJ MMxxxxJ PMxxxxJ FGxxxx Other

FG037R
Equipment Inventory Reporting

This job group extracts and reports equipment records from the Inventory database (INVEN).
Special Instructions There are 11 lines(MM5301S1-LINE01 thru MM5301S1-LINE11), 60 spaces per line, available for entering selection criteria. Separation of each selection criteria is indicated by a semicolon (;). 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> EXAMPLE:<R> 1. Select all equipment records that have not been disposed. MM5301S1-LINE01 DISPOSE-STAT EQ " "<R> 2. Select all equipment records related to Computing Support where the manufacturer is Hewlett-Packard that have been lost or stolen.<R> MM5301S1-LINE01 NACUBO-PRG EQ 44; MANUF EQ "HEWLETT PACKARD"<R> MM5301S1-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
R 01 00 MM5301J
Facilities and Equipment Generalized Extract
  Facilities and Equipment Generalized Extract Repor (MM5301)
O 02 01 MM5201J
Equipment Conversion Report
  Equipment Conversion Report (MM5201)
O 03 02 MM5203J
Equipment Inventory Worksheet
  Equipment Inventory Worksheet (MM5203)
O 04 03 MM5204J
Equipment Replacement Cost Report
  Equipment Replacement Cost Report (MM5204)
O 05 04 MM5205J
Equipment At End of Useful Life
  Equipment At End of Useful Life (MM5205)
O 06 05 MM5206J
Incomplete Record & Error Report For Equipment
  Incomplete Record & Error Report For Equipment (MM5206)
O 07 06 MM5207J
Equipment Listing
  Equipment Listing (MM5207)
O 08 07 MM5211J
Equipment Detail Listing
  Equipment Detail Listing (MM5211)
R 09 08 MM5305J
FAE Extract File Purge


Parameters

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).
MM5201-SORT-OPT 01 = COL, TAG
02 = COL, BLDG, ROOM, TAG
03 = COL, BLDG, ROOM, DESC
04 = COL, BLDG, ROOM, ACQ COST
05 = COL, COUNTY, BLDG, ROOM, TAG
06 = COL, COUNTY, BLDG, ROOM, DESC
07 = COL, COUNTY, BLDG, ACQ COST
08 = COL, DIV-DEPT, BLDG, ROOM, TAG
09 = COL, DIV-DEPT, BLDG, ROOM, DESC
10 = COL, DIV-DEPT, BLDG, ROOM, ACQ COST
11 = COL, PRG, ORG, BLDG, ROOM, TAG
12 = COL, PRG, ORG, BLDG, ROOM, DESC
13 = COL, PRG, ORG, BLDG, ROOM, ACQ COST
14 = COL, COMMOD, TAG
15 = COL, COMMOD, BLDG, ROOM, TAG
16 = COL, NACUBO, TAG
17 = COL, NACUBO, BLDG, ROOM, TAG
18 = COL, NACUBO, DIV-DEPT, TAG
19 = COL, OWNR-STAT, COMMOD, TAG
MM5203-SORT-OPT 01 = Sort by COL, TAG
02 = Sort by COL, BLDG, ROOM, TAG
03 = Sort by COL, BLDG, ROOM, DESC
04 = Sort by COL, BLDG, ROOM, ACQ COST
05 = Sort by COL, COUNTY, BLDG, ROOM, TAG
06 = Sort by COL, COUNTY, BLDG, ROOM, DESC
07 = Sort by COL, COUNTY, BLDG, ACQ COST
08 = Sort by COL, DIV-DEPT, BLDG, ROOM, TAG
09 = Sort by COL, DIV-DEPT, BLDG, ROOM, DESC
10 = Sort by COL, DIV-DEPT, BLDG, ROOM, ACQ COST
11 = Sort by COL, PRG, ORG, BLDG, ROOM, TAG
12 = Sort by COL, PRG, ORG, BLDG, ROOM, DESC
13 = Sort by COL, PRG, ORG, BLDG, ROOM, ACQ COST
14 = Sort by COL, COMMOD, TAG
15 = Sort by COL, COMMOD, BLDG, ROOM, TAG
16 = Sort by COL, NACUBO, TAG
17 = Sort by COL, NACUBO, BLDG, ROOM, TAG
18 = Sort by COL, NACUBO, DIV-DEPT, TAG
19 = Sort by COL, OWNR-STAT, COMMOD, TAG
MM5204-COMMOD Y = Yes, produce report by commodity group.
N = No, not produce report by commodity group.
MM5204-DATE The date for which the report is to be run (YYMMDD).
MM5204-LIFE-IND
MM5204-MJR-GRP Y = Yes, produce report by commodity major group.
N = No, do not produce report by commodity major
group.
MM5204-SUMMARY Y = Yes, produce report by combining all commodity groups and useful lifes together.
N = No, do not produce report by combining all commodity groups and useful lifes together.
MM5204-USE-LIFE Y = Yes, produce report by commodity useful life.
N = No, do not produce report by commodity useful
life.
MM5205-DATE The date for which the report is to be run (YYMMDD)
MM5205-PG-BRK Y = Yes, provide a page break on Primary and Secondary Sort options.
N = No, do not provide a page break on Primary and Secondary sort options; provide a page break on the Primary Sort Option only.
MM5205-SORT-OPT 01 = Sort by TAG
02 = Sort by BLDG, ROOM, TAG
03 = Sort by BLDG, ROOM, DESC
04 = Sort by BLDG, ROOM, ACQ COST
05 = Sort by COUNTY, BLDG, ROOM, TAG
06 = Sort by COUNTY, BLDG, ROOM, DESC
07 = Sort by COUNTY, BLDG, ACQ COST
08 = Sort by DIV-DEPT, BLDG, ROOM, TAG
09 = Sort by DIV-DEPT, BLDG, ROOM, DESC
10 = Sort by DIV-DEPT, BLDG, ROOM, ACQ COST
11 = Sort by PRG, ORG, BLDG, ROOM, TAG
12 = Sort by PRG, ORG, BLDG, ROOM, DESC
13 = Sort by PRG, ORG, BLDG, ROOM, ACQ COST
14 = Sort by COMMOD, TAG
15 = Sort by COMMOD, BLDG, ROOM ,TAG
16 = Sort by NACUBO, TAG
17 = Sort by NACUBO, BLDG, ROOM, TAG
18 = Sort by NACUBO, DIV-DEPT
19 = Sort by OWNR STAT, COMMOD, TAG
MM5211-SORT-OPT 01 = Sort by COL, TAG
02 = Sort by COL, BLDG, ROOM, TAG
03 = Sort by COL, BLDG, ROOM, DESC
04 = Sort by COL, BLDG, ROOM, ACQ COST
05 = Sort by COL, COUNTY, BLDG, ROOM, TAG
06 = Sort by COL, COUNTY, BLDG, ROOM, DESC
07 = Sort by COL, COUNTY, BLDG, ACQ COST
08 = Sort by COL, DIV-DEPT, BLDG, ROOM, TAG
09 = Sort by COL, DIV-DEPT, BLDG, ROOM, DESC
10 = Sort by COL, DIV-DEPT, BLDG, ROOM, ACQ COST
11 = Sort by COL, PRG, ORG, BLDG, ROOM, TAG
12 = Sort by COL, PRG, ORG, BLDG, ROOM, DESC
13 = Sort by COL, PRG, ORG, BLDG, ROOM, ACQ COST
14 = Sort by COL, COMMOD, TAG
15 = Sort by COL, COMMOD, BLDG, ROOM, TAG
16 = Sort by COL, NACUBO, TAG
17 = Sort by COL, NACUBO, BLDG, ROOM,TAG
18 = Sort by COL, NACUBO, DIV-DEPT, TAG
19 = Sort by COL, OWNR-STAT, COMMOD, TAG
MM5301S1-LINE01
MM5301S1-LINE02
MM5301S1-LINE03
MM5301S1-LINE04
MM5301S1-LINE05
MM5301S1-LINE06
MM5301S1-LINE07
MM5301S1-LINE08
MM5301S1-LINE09
MM5301S1-LINE10
MM5301S1-LINE11
Extract parameter lines

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