Download 61 Mx Techref PDF

Title61 Mx Techref
File Size3.5 MB
Total Pages454
Table of Contents
                            Maximo Technical Reference Guide
Chapter 1 - MAXIMODIRECTORY Structure
Chapter 2 - Tables and Columns for Maximo 6
Chapter 3 - Index List
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
                        
Document Text Contents
Page 1

Technical Reference Guide
August 2006




Maximo 6
Release 6.0

Page 2

This document and its publication do not constitute or create a contract. MRO Software, Inc. makes no warranties, express or implied,
as to the accuracy or completeness of this document or with respect to the related software.
© 2005 MRO Software, Inc. All rights reserved. This document contains confidential and trade secret information of MRO Software,
Inc. Use, transfer, disclosure, or copying without MRO Software, Inc.'s express written permission is strictly forbidden.
Patents: United States Patent Nos. 6,324,522 B2, 6,519,588 B1, and Aust. Pat. No. 758001. Multiple foreign patents pending.
U.S. Restricted Rights: If Customer is a government agency, Customer acknowledges and agrees that the Licensed Software is
provided with RESTRICTED RIGHTS. Subparagraph (c)(1)(ii) of The Rights in Technical Data and Computer Software clause at
252.227-7013 of the Department of Defense FAR Supplement and FAR clause 52.227-19 entitled Commercial Computer Software
Restricted Rights, apply and use, duplication, or disclosure by the Government is subject to restrictions as set forth in this Agreement.
The aforementioned restrictions shall prevail over any similar "Rights" provisions under the laws of any country.
Contractor/Manufacturer: MRO Software, Inc., 100 Crosby Drive, Bedford, MA 01730.
Trademarks: Maximo® is a registered trademark of MRO Software, Inc. The following table contains a list of MRO Software's
trademarks and service marks:


Maximo® Enterprise
Maximo® Enterprise/SP
Maximo® Enterprise IT
Maximo® Asset Center
Maximo® Service Center
Maximo® Discovery
Maximo® Enterprise IT/SP

Maximo® SLA Manager
Maximo® Navigator
Maximo® Project Manager
Maximo® Calibration
Maximo® Enterprise Adapter
Maximo® Fusion

Maximo® OCS
Maximo® Mobile Suite
Maximo® Mobile Auditor
Maximo® Mobile Inventory Manager
Maximo® Mobile Work Manager
Maximo® Mobile Calibration


IBM® and WebSphere® are registered trademarks of IBM Corporation. WebLogic® is a registered trademark of BEA Systems, Inc.
Broadvision® and related marks are registered trademarks or trademarks of Broadvision, Inc. webMethods® is a registered trademark
of webMethods, Inc. Snowbound™ and RasterMaster™ are trademarks of Snowbound Software Corporation. Syclo® and Agentry® are
registered trademarks of Syclo, LLC.
Other products and brand names are trademarks or registered trademarks of their respective companies.
Third-Party Technology: Certain MRO Software, Inc. products contain technology provided under license from third parties, as
noted in the following table:


MRO Software
Products

Third-Party Information

Maximo Portions © 1995-2004 Actuate Corporation. Portions © 2003 BEA Systems, Inc. BEA
WebLogic® Server™ provided by BEA Systems, Inc. Portions © 1996-2004 IBM
Corporation. IBM® WebSphere® provided by IBM Corporation. Portions © 1996-2005,
i-net software GmbH.

All Products Portions © 1996-2003 Visual Mining, Inc. Visual Mining™ NetCharts Server™
provided by Visual Mining, Inc.

Maximo® Discovery ©1988-2004 Centennial Software Limited. MSDE © Microsoft Corporation.
Maximo Navigator Portions © 1993-2002 Snowbound Software Corporation. RasterMaster™ Raster

imaging technology provided by Snowbound Software Corporation. Portions © 1989-
1998 Cimmetry Systems, Inc.

Maximo Mobile Suite Portions © 2002-2003 Syclo LLC.

Open Source: Maximo contains computer software obtained from the public domain, known as "Open Source." A complete listing of all
Open Source contained in Maximo may be viewed at http://www.mro.com/support/opensource, ownership of which is attributed as
follows: Portions © 2005, International Business Machines Corporation and others. Portions © 2002, Steve Souza
([email protected]). Portions © 2000 by Jef Poskanzer ([email protected]). Portions © 2000-2004 Jason Hunter & Brett McLaughlin.
Portions © 2004-2005, The Apache Software Foundation (http://www.apache.org/). All Rights Reserved.

Page 227

Maximo Database Columns




2-158

Table Name Column Name Col Type Length Scale Req’d? Must be Same as
SOLUTIONSTATUS STATUS 3 UPPER 8 0 1 0 .
SOLUTIONSTATUS CHANGEBY 4 UPPER 8 0 1 0 .
SOLUTIONSTATUS CHANGEDATE 5 DATETIME 10 0 1 0 .
SOLUTIONSTATUS MEMO 6 ALN 50 0 0 0 .
SPAREPART ASSETNUM 1 UPPER 12 0 1 0 ASSET.ASSETNUM
SPAREPART ITEMNUM 2 UPPER 30 0 1 0 ITEM.ITEMNUM
SPAREPART QUANTITY 3 DECIMAL 15 2 1 1 .
SPAREPART DESCRIPTION 4 ALN 100 0 0 0 ITEM.DESCRIPTION
SPAREPART SITEID 5 UPPER 8 0 1 0 SITE.SITEID
SPAREPART ORGID 6 UPPER 8 0 1 0 ORGANIZATION.ORGID
SPAREPART ITEMSETID 7 UPPER 8 0 1 0 SETS.SETID
SPAREPART SPAREPARTID 9 INTEGER 12 0 1 1 .
SPAREPART LANGCODE 10 UPPER 4 0 1 1 LANGUAGE.MAXLANGCODE
SPAREPART HASLD 11 YORN 1 0 1 1 .
SPLEXICONLINK SPWORKASSETID 1 INTEGER 12 0 1 1 SPWORKASSET.SPWORKASSETID
SPLEXICONLINK SAFETYLEXICONID 2 INTEGER 12 0 1 1 SAFETYLEXICON.SAFETYLEXICONID
SPLEXICONLINK APPLYSEQ 3 SMALLINT 10 0 0 0 SAFETYLEXICON.APPLYSEQ
SPLEXICONLINK REMOVESEQ 4 SMALLINT 10 0 0 0 SAFETYLEXICON.REMOVESEQ
SPLEXICONLINK ORGID 5 UPPER 8 0 1 0 ORGANIZATION.ORGID
SPLEXICONLINK SITEID 6 UPPER 8 0 1 0 SITE.SITEID
SPLEXICONLINK SPLEXICONLINKID 24 INTEGER 12 0 1 1 .
SPRELATEDASSET SPRELATEDASSETID 1 INTEGER 12 0 1 1 .
SPRELATEDASSET LOCATION 2 UPPER 12 0 0 0 LOCATIONS.LOCATION
SPRELATEDASSET ASSETNUM 3 UPPER 12 0 0 0 ASSET.ASSETNUM
SPRELATEDASSET RELATEDLOCATION 4 UPPER 12 0 0 0 LOCATIONS.LOCATION
SPRELATEDASSET RELATEDASSET 5 UPPER 12 0 0 0 ASSET.ASSETNUM
SPRELATEDASSET ORGID 6 UPPER 8 0 1 0 ORGANIZATION.ORGID
SPRELATEDASSET SITEID 7 UPPER 8 0 1 0 SITE.SITEID
SPWORKASSET SPWORKASSETID 1 INTEGER 12 0 1 1 .
SPWORKASSET SAFETYPLANID 2 UPPER 8 0 1 0 SAFETYPLAN.SAFETYPLANID
SPWORKASSET WORKASSET 3 UPPER 12 0 0 0 ASSET.ASSETNUM
SPWORKASSET WORKLOCATION 4 UPPER 12 0 0 0 LOCATIONS.LOCATION
SPWORKASSET ORGID 5 UPPER 8 0 1 0 ORGANIZATION.ORGID
SPWORKASSET SITEID 6 UPPER 8 0 1 0 SITE.SITEID
SR TICKETID 1 UPPER 10 0 1 0 TICKET.TICKETID
SR CLASS 2 UPPER 10 0 1 1 TICKET.CLASS
SR DESCRIPTION 3 ALN 100 0 0 1 TICKET.DESCRIPTION
SR STATUS 4 UPPER 8 0 1 1 TICKET.STATUS
SR STATUSDATE 5 DATETIME 10 0 1 1 TICKET.STATUSDATE
SR REPORTEDPRIORITY 6 INTEGER 12 0 0 1 TICKET.REPORTEDPRIORITY
SR INTERNALPRIORITY 7 INTEGER 12 0 0 1 TICKET.INTERNALPRIORITY
SR IMPACT 8 INTEGER 12 0 0 1 TICKET.IMPACT
SR URGENCY 9 INTEGER 12 0 0 1 TICKET.URGENCY
SR REPORTEDBY 10 ALN 62 0 0 0 PERSON.DISPLAYNAME
SR REPORTDATE 11 DATETIME 10 0 0 1 TICKET.REPORTDATE
SR AFFECTEDPERSON 12 ALN 62 0 0 0 PERSON.DISPLAYNAME

Page 228

Maximo Database Columns




2-159

Table Name Column Name Col Type Length Scale Req’d? Must be Same as
SR AFFECTEDDATE 13 DATETIME 10 0 0 1 TICKET.AFFECTEDDATE
SR SOURCE 14 ALN 20 0 0 1 TICKET.SOURCE
SR SUPERVISOR 15 UPPER 8 0 0 1 TICKET.SUPERVISOR
SR OWNER 16 UPPER 30 0 0 0 PERSON.PERSONID
SR OWNERGROUP 17 UPPER 8 0 0 0 PERSONGROUP.PERSONGROUP
SR ISGLOBAL 18 YORN 1 0 1 1 TICKET.ISGLOBAL
SR RELATEDTOGLOBAL 19 YORN 1 0 1 1 TICKET.RELATEDTOGLOBAL
SR GLOBALTICKETID 20 UPPER 10 0 0 1 TICKET.GLOBALTICKETID
SR GLOBALTICKETCLASS 21 UPPER 10 0 0 1 TICKET.GLOBALTICKETCLASS
SR EXTERNALRECID 22 ALN 20 0 0 1 TICKET.EXTERNALRECID
SR SITEVISIT 23 YORN 1 0 1 1 TICKET.SITEVISIT
SR ORIGRECORDID 24 UPPER 10 0 0 1 TICKET.ORIGRECORDID
SR ORIGRECORDCLASS 25 UPPER 10 0 0 1 TICKET.ORIGRECORDCLASS
SR GLACCOUNT 26 GL 23 0 0 1 .
SR COMMODITYGROUP 27 UPPER 8 0 0 1 COMMODITIES.COMMODITY
SR COMMODITY 28 UPPER 8 0 0 1 COMMODITIES.COMMODITY
SR INHERITSTATUS 29 YORN 1 0 1 1 TICKET.INHERITSTATUS
SR ISKNOWNERROR 30 YORN 1 0 1 1 TICKET.ISKNOWNERROR
SR TARGETSTART 31 DATETIME 10 0 0 1 TICKET.TARGETSTART
SR TARGETFINISH 32 DATETIME 10 0 0 1 TICKET.TARGETFINISH
SR ACTUALSTART 33 DATETIME 10 0 0 1 TICKET.ACTUALSTART
SR ACTUALFINISH 34 DATETIME 10 0 0 1 TICKET.ACTUALFINISH
SR ORIGRECSITEID 35 UPPER 8 0 0 1 TICKET.ORIGRECSITEID
SR ORIGRECORGID 36 UPPER 8 0 0 1 TICKET.ORIGRECORGID
SR SITEID 37 UPPER 8 0 0 0 SITE.SITEID
SR ORGID 38 UPPER 8 0 0 0 ORGANIZATION.ORGID
SR CHANGEDATE 39 DATETIME 10 0 1 1 TICKET.CHANGEDATE
SR CHANGEBY 40 UPPER 30 0 1 0 PERSON.PERSONID
SR HISTORYFLAG 41 YORN 1 0 1 1 TICKET.HISTORYFLAG
SR TEMPLATE 42 YORN 1 0 1 1 TICKET.TEMPLATE
SR HASACTIVITY 43 YORN 1 0 1 1 TICKET.HASACTIVITY
SR FAILURECODE 44 UPPER 8 0 0 0 FAILURECODE.FAILURECODE
SR PROBLEMCODE 45 UPPER 8 0 0 0 FAILURECODE.FAILURECODE
SR ACTLABHRS 46 DURATION 8 0 1 1 TICKET.ACTLABHRS
SR ACTLABCOST 47 AMOUNT 10 2 1 1 TICKET.ACTLABCOST
SR AFFECTEDPHONE 48 ALN 20 0 0 0 TICKET.AFFECTEDPHONE
SR REPORTEDPHONE 49 ALN 20 0 0 0 TICKET.REPORTEDPHONE
SR AFFECTEDEMAIL 50 ALN 50 0 0 1 EMAIL.EMAILADDRESS
SR REPORTEDEMAIL 51 ALN 50 0 0 1 EMAIL.EMAILADDRESS
SR ASSETSITEID 52 UPPER 8 0 0 0 SITE.SITEID
SR TEMPLATEID 53 UPPER 10 0 0 0 TICKET.TEMPLATEID
SR VENDOR 54 UPPER 12 0 0 0 COMPANIES.COMPANY
SR ASSETNUM 59 UPPER 12 0 0 0 ASSET.ASSETNUM
SR LOCATION 60 UPPER 12 0 0 0 LOCATIONS.LOCATION
SR CLASSSTRUCTUREID 62 UPPER 20 0 0 1 CLASSSTRUCTURE.CLASSSTRUCTUREID
SR ISKNOWNERRORDATE 63 DATETIME 10 0 0 0 TICKET.ISKNOWNERRORDATE

Similer Documents