Essay About Domain Values And Daily Procedure

Cmms Implementation Guide
Essay Preview: Cmms Implementation Guide
Report this essay
System
Oracle 10g Installation
Maximo Installation
Actuate Installation
Client-Server (Network)
Database Configuration (see attached Excel spreadsheet – MAXIMO DB Mapping.xls)
Provide DZSP with v.6.2 ERD and data dictionary
v.5.2 was provided to DZSP preconfigured with no ERD nor data dictionary
We will provide you with the current major database objects that we currently use
Recommend strategy of adding the “missing” columns in v.6.2 with the same naming convention
Data mapping Ð- what is your timeframe?
Data migration Ð- what is your timeframe?
Accounts and groups (see attached MAXIMO Usergroups.xls)
Setting up User Groups
v.5.2 currently has three main types of user groups Read Only, Insert/Update, Update
There are three major group access
Access to Work Order tracking, Equipment, PM
Access to Transportation modules
Access to all
Setting up Users Ð- recommend we migrate current “active” users (w/ passwords) to v.6.2
Domain Values/ Valuelist (see attached MAXIMO Value List.xls)
Priority (workorder.wopriority)
Work Center (workorder.supervisor)
Work Type (workorder.worktype, pm.worktype)
GL Account (workorder.glaccount)
Customer Survey Rate (workorder.aischeckbox)
Work Subtype (workorder.wopm5)
Equipment (workorder.eqnum)
Location (workorder.location)
Failure Class (workorder.failurecode)
Material Info (workorder.wopm2)
Severe Hazard (workorder.hazseverity)
Category (workorder.category)
Pool (equipment.io_number)
Category (equipment.transmission)
Assignment Status (equipment.assignstatus)
Alpha code (equipment.alphacode)
Status (workorder.status)
Status (equipment.status)
Equipment type (equipment.eq23, pm.pmeq2, workorder.woeq13)
Fuel category code (equipment.fuel_cat_code)
Fuel type (equipment.fuel_type)
Wo priority (pm.priority)
Work sub type (pm.pm10)
Work order status (pm.wostatus)
Configuring the Layout
See screen shots provided (Maximo 5_2 Screen Shots.ppt)
Labor
These are not managed manually in Maximo
The values of the labor is mapped to our Financial employees table which is managed by our HR department
A daily procedure, executed through an Oracle job queue, updates the entries in the labor table
Crafts
Currently, crafts are incorporated into the maximo.labor table, where labor.iscraft=Y
These are not managed manually in Maximo
The values of the labor is mapped to our Financial labor category table which is managed by our HR department
An annual procedure updates the entries in the labor table based on a spreadsheet provided by the Comptroller
GL Components
Currently there are four GL components defined in v.5.2, but DZSP only utilizes one component which is six characters
GL Account and update procedure
Currently, GL Accounts are not managed manually in Maximo
The values of the GL Account is mapped to our Financial projects table which is managed by our Finance department
A daily procedure, executed through an Oracle job queue, updates the entries in chartofaccounts
The procedure primarily links into the Financial database table, uploads all new records, and updates existing ones (active to inactive, etcÐ)
The procedure is executed manually if the need arises during business hours
Locations
The list of locations is provided by the Government for mass upload
Locations naming convention is based on the Governments locations template
Equipment
The list of equipment is provided by the Government through the Engineering department
Equipment numbers follow a prefix template
Facilities equipment follow a pattern of 2 letters + 3 occupant identifying numbers + 4 digit sequence (example MA5200001)
Two letter prefix: MA
Three numbers identify occupant
180 Ð- Naval Hospital
510 Ð- Branch Dental Clinic
520 Ð- ComNamMar
530 Ð- DODEA
540 Ð- NCTS
550 Ð- NavFacMar