FG037R Equipment Inventory Reporting
| 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
| Job ID | Description | ||||||
|---|---|---|---|---|---|---|---|
| R | 01 | 00 | MM5301J |
| |||
| Facilities and Equipment Generalized Extract Repor (MM5301) | |||||||
| O | 02 | 01 | MM5201J |
| |||
| Equipment Conversion Report (MM5201) | |||||||
| O | 03 | 02 | MM5203J |
| |||
| Equipment Inventory Worksheet (MM5203) | |||||||
| O | 04 | 03 | MM5204J |
| |||
| Equipment Replacement Cost Report (MM5204) | |||||||
| O | 05 | 04 | MM5205J |
| |||
| Equipment At End of Useful Life (MM5205) | |||||||
| O | 06 | 05 | MM5206J |
| |||
| Incomplete Record & Error Report For Equipment (MM5206) | |||||||
| O | 07 | 06 | MM5207J |
| |||
| Equipment Listing (MM5207) | |||||||
| O | 08 | 07 | MM5211J |
| |||
| Equipment Detail Listing (MM5211) | |||||||
| R | 09 | 08 | MM5305J |
| |||
Parameters
| Parameter | Values |
|---|---|
| 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