Home

User's Manual Maintenance Management Information System

1. Search Detail Equipment Code Rental Rate Code 7 Equipment Class Code Valid Equipment Equipment Description District Equipment Rental Rate eT TRAININGOS 53 TRAINING n NUM Figure 8 5 8 2 5 The AMC Contractor Equipment Table To enter the Rental Rate for each piece of equipment the AMC contractor will Select a piece of equipment from the Search tab Select the Detail tab Click on the Equipment Rental Rate column Enter the Equipment Rental Rate Repeat steps 3 and 4 if there is more than one contract Save the record by pressing the Save button or press F6 de cu Feb 03Rev 2 0 8 8 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Figure 8 6 Feb 03Rev 2 0 8 9 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 6 The Highway Table MMIS Main Screen MMIS Table Maintenance HIGHWAY Figure 8 7 The Highway table provides a listing of highways for the program This table is administered by the Head Office MMIS business administrator Feb 03Rev 2 0 8 10 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 7 The Material Table The Material table provides a list of material that can be used on a job The Material Code Description Unit of Measure Code UM Code and the Valid Material check box are updated by the MMIS business administrator within the MTO maintenance office To enter the Ma
2. NUM Figure 7 4 After the the accomplishments have been entered in the appropriate date fields click on Add Material enter the quantities Click on Save Feb 03Rev 0 2 2 31 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL To change the Status to Closed 3 Select the Status box drop down arrow 4 Select Closed 4 Savethe job by clicking on the Save button or press F6 on the keyboard NOTE The status of a job should be set to Closed after you have checked the information you have entered and are satisfied it is complete and correct Saving Your Work Save often to reduce data loss To save your work Click the Save icon button in the tool bar or press F6 Feb 03Rev 0 2 2 32 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 3 0 0 Searching for Information in MMIS 3 1 0 Introduction The Search tab allows the user to locate existing information contained in MMIS Search tabs are located on the Jobs screen the Queries screen and each Admin table The search criteria acts as a filter to locate information If minimal filter information is entered broad range of records will meet the criteria As you enter more fields to narrow the search a smaller number of records will meet the criteria To search for information e Click on the Search tab fill in the desired fields click on the Search button Although the fields that are available on each Search tab may differ the process o
3. button keeping all header information standard as in the Header information attached to an MDWR You will only have to enter data in the Operations portion of the information for up to 8 different operations Feb 03Rev 0 2 2 26 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Enter up to a maximum of 8 jobs per MDWR The following error message will appear should you try to continue gt MMIS Main Screen MMIS Manage MDWR 0 2 xl ol eff zd dr ET rliziory Each of the 8 jobs will line up with all the Labour Equipment Material and Service sections Setting the Status The Status field is used in the Data Promotion process to ensure the integrity of data in MMIS The five options are Initiated Closed Reviewed Accepted and Rejected The user s choices are based on their user group access in MMIS For a complete description of this process please read 5 0 0 Data Promotion in MMIS After you have completed all data input and have saved a job the system will set its status to Initiated When you are satisfied that an Initiated job is complete and correct you will then change its status to Closed Caution Closed jobs cannot be edited Only Initiated data can be edited Only the Status Date and Comment fields may be edited on the Form tab after a Save Feb 03Rev 0 2 2 27 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL To change the Status to Closed 1 Select the Status box drop
4. Feb 03Rev2 0 9 5 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 9 2 15 The Event Time Format event times are entered using the 24 hour clock format The time is recorded to the nearest gt hour 9 3 0 Entering Bare Pavement Event Information MMIS Main Screen MMIS Manage Bare Pavement 5 Red Rejected Events one or more weeks istry iens Rai ae sme Tmf Figure 9 6 Feb 03Rev2 0 9 6 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MMIS Main Screen MMIS Manage Bare Pavement ej xj 28 File Edit Manage Record Reports Queries Admin Windows Help Legend Blue Initiated Events or more weeks old Red Hejected Events or more weeks old Search BP Entry jistory Region SOUTHWEST BP ID District OWEN SOUND Event No Blank indicates Create New Event Patrol BP Patrol Patrol COOKSTOWN x ew Event Date Month Day Year 2002 11 25 Event X v Continuous Entry B Both Highway 88 Highway Class 1B Class 1B Time values expressed in terms of 24 hrs Event Beginning WYYY MM DD 2002 11 25 Time BP Lost Y YY7MM DD 2002 11 25 Time Event Ending YYY MM DD Time BP Regained Y Y Y MM DD Time Comments j Event T mss TRAMOS Figure 9 6
5. 9 2 8 Highway and Highway Class You type in the Highway number or Right click on the Highway box or Press the F2 key to show a list of highways When the Highway is entered the Highway Class field will automatically be filled in You can overide the Highway Class by clicking on the drop down arrow and selecting one of the Highway Class options 9 2 9 Event Beginning date and Time The date and time when the event started 9 2 10 BP Lost date and Time The date and time when bare pavement was lost 9 2 11 Event End date and Time The date and time the event stopped Feb 03Rev2 0 9 4 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 9 2 12 BP Regained date and Time The date and time bare pavement was regained 9 2 13 The Error Message The BP Regained date and Time must be after the BP Lost date and Time The Event End date and Time must be after the Event Beginning date and Time The following message Figure 9 4 will appear when an incorrect entry is made Error Lost date time should not be less than start date time Figure 9 4 9 2 14 The Date Format Bare Pavement Dates are entered in the Year Month Day format You have the option of entering the date Or Press the F2 key on your keyboard Or right click with the mouse to display a calendar to select the date 8 9 5 o iw 9 2 a 20 23 24 25 26 2 28 e9 30 31 1 2 4 5 5 9 5 10 11 Cancel the current operation Figure 9 5
6. numm 2002704701 EZEZ Figure 5 14 Feb 03Rev2 0 5 13 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Method 3 Updating Multiple Records The user can change the status of consecutive jobs in the table as follows 1 Click on the first job you wish to change in the Job ID column hold down the left mouse button and drag the mouse to the last Job you wish to change At this point all these records will be highlighted in black 2 Click on the Reviewed or Rejected box below the button bar 3 Save the change by pressing F6 or by pressing the Save icon on the button bar Screen MMIS Manage Job Status 81 x 28 File Edit Manage Reports Queries Admin Windows x es Location Period Region SOUTHWEST Date from 2002 04 01 2002 09 26 OWEN SOUND e EERE H Comments Patrol si Prefix Code Structure Site Comments Patrol Patrol Work Work pe Type Athur 1097 2002 06 14 MO 0102 22648 Closed 2002 06 28 Chatswoi 0 Press F1 For Help Iz 52 503 53 TRAINING 8i Figure 5 15 Feb 03Rev2 0 5 14 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 52 4 Changing the Status from Reviewed to Accepted or Rejected To view the jobs that can be Accepted 1
7. 338 SAND SCREENED amp TREATED 1 41 587 80 5 812 00 TONN 703 SALT COARSE FINE BULK 193 085 88 2 443 00 TONN 990 MISCELLANEOUS MATERIALS 8 437 78 60 NUMB New liskeard material patrol 46 141 Ready p T n on T Figure 7 17 Feb 03Rev 2 0 7 20 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 0 0 Tables In MMIS The tables contain information that populates various fields in the program The tables contain administrative information codes and costs used by the system Different tables are maintained by the MTO maintenance office MTO District s MMIS Coordinator and Area Maintenance Contractor Your user group will determine your access to tables Some Users will not be able to modify table data though they will be able to view the table information MTO and AMC contractors set their own rates in MMIS AMC contractors can set rates for material equipment and labour that are specific to their contract Only the contractor can see these rates MTO or other AMC contractors cannot see them MTO sets rates that are specific to MTO use and cannot be viewed by AMC Contractors Caution Never delete a record in a table If the record is no longer used set it to Inactive Historical information will not be available if a table record is deleted Feb 03Rev 2 0 8 1 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 0 1 Table Adminis
8. To enter Bare Pavement information Press the New Button to enter a new record Select the Patrol from the drop down arrow options Enter the Event Date Select the Event Type from the drop down arrow options Enter the Highway Confirm the Highway Class is correct Enter the Event Beginning date and Time Enter the BP Lost date and Time Enter the Event Ending date and Time 10 Enter the BP Regained date and Time 11 Enter Comments if applicable 12 Save the record by pressing the Save button on the button bar or press F6 Feb 03Rev2 0 9 7 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Appendix A Log In Groups in MMIS The Group you belong to in MMIS allows access to different parts of the system There are groups available for MTO staff and Area Maintenance Contract staff MTO MMIS Groups Group Enter and Edit Jobs for View Information for Data Approval Table Administration MMIS 1 Single patrol Multiple patrols within a District Initiate and Close Cannot Change Tables MMIS 2 Multiple patrols within a Multiple patrols within a District Initiate and Close District and Review Patrol Access to Admin Employees in Patrol Table MMIS 3 Multiple patrols within a Regions Review and Reject District and Bare Pavement District Access to Admin AMC Table Admin MTO Equipment Rates Admin MTO Material Rates Admin Patrol Table Admin MTO Labour Rates Admin P
9. 2000 12 04 C Period from 71 in To 71 Status sz Region i T Region Material hz JHEIDRIBO cooRD TRAINING Figure 7 5 Feb 03Rev 2 0 7 7 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 7 0 Creating a Custom Query To begin creating a Custom Query e Click on the New button with the left mouse button MMIS Main Screen MMIS Queries BEE dit Manage Record Reports Queries Admin Windows Help lal x Record Deleted Search Detail Query By Material Selected Groups Query Name Material by operation and highway Filter Date from 2000 01 401 2000 12 05 Period from z To s Status zd THEIDRIEO cooRD TRAINING RUM Figure 7 6 7 7 1 Setting Your Query Options To create a Custom Query 1 Select the Class in the Query By box with the drop down arrow The available Query Classes are Bare Pavement Equipment Hired Equipment HEQ Job Labour Material and Services 2 Choose a Query Name In the Query Name box enter the new Query name Choose a meaningful name since it will be displayed when you search for queries Feb 03Rev 2 0 7 8 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 3 Setthe Filter options The Filter allows you to select a Date Range or a Period Range for the query The Status box lets you select the job s
10. 7 3 Running A Custom Query 7 7 4 Saving A Custom Query 7 8 0 Using the Query Display Table 7 8 1 An Example of the Query Table 7 9 0 Printing a Query 7 9 1 What Information is Printed 7 9 2 Starting the Print 7 10 0 Exporting a Query 7 10 1 What Information is Exported 7 10 2 Starting the Export 7 10 3 Selecting the Export File Type 7 10 4 Saving the Export File 7 10 5 Example of a Query Export Chapter 8 Chapter Section Heading Sub Section 8 0 0 Tables in MMIS 8 0 1 Table Administration by MMIS Groups 8 1 0 Opening a Table Screen 8 2 0 Tables in MMIS Feb Rev 2 0 Page 7 3 7 4 7 4 7 4 7 5 7 5 7 6 7 6 7 6 7 6 7 6 7 7 7 7 7 8 7 8 7 9 7 10 7 11 7 12 7 13 7 15 7 15 7 16 7 17 7 17 7 18 7 18 7 19 7 20 Page 8 1 8 2 8 4 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Table of Contents Chapter 8 continued Chapter Section Heading Page Sub Section 8 2 1 AMC Contract Table 8 4 8 2 2 The Equipment Class Table 8 5 8 2 5 The Equipment Table 8 6 8 2 4 Entering the MTO Equipment Rental Rate 8 7 8 2 5 The AMC Contractor Equipment Table 8 8 8 2 6 The Highway Table 8 9 8 2 7 The Material Table 8 10 8 2 8 The AMC Contractor Material Table 8 11 8 2 9 The OP Prefix Table 8 12 8 2 10 The Operation Table 8 13 8 2 11 The Patrol Table 8 14 8 2 12 Creating a Home Location Patrol 8 17 8 2 13 The AMC Contractor Patrol Table 8 18 8 2 14 The Project Contract Account Table 8 19 8 2 15 The
11. Coeation Hignway POA Code Cty toos Dot Dol Dol Dol Dol Dol Lu 7020 399 500 Humber 27879 18324 o S335 0 0 Form Total 27879 18824 a 88 55 v ________ Figure 6 7 Feb 03Rev 02 6 7 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 6 2 2 MOR Reports MMIS Main Screen Edit Manage Bare Pavement Reports gt Management Report Admin Listings Project History Queries Figure 6 8 Feb 03Rev 02 6 8 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 1 Location Summary Report This report provides a summary by Work Location and Prefix of total Expenditure and total Man Hours and compares actual to planned values Location Summary Report 19 1 of 1 ri amp 75 Total 6 100 6 of 6 Comparison of Actual vs Planned Productivity and Expenditure LOCATION SUMMAR Y iu m 2 FROM 01 J2n2001 Ontario i 284012001 WORK EXPENDITURE MAN HOURS DONE BY Planned Actual Ran Planned Actual DISTRICT OTTAWA PATROL Wart Loc iam MO Prefix 00 Raine General INTCRNAL Siatue ACCEPTED 20 00 31 614 12 31 614 12 2811 50 311 50 Salus REVIEWED 40 00 445 04 445 04 12 00 12 00 Status ACCEPTED 40 00 33 022 75 33 022 75 oc oc 00 Taal 55 081 99 55 081 99 823 50 823 50 04 Damage C rown Praperty INTCRNAL Siatu
12. Jose Giperetion Hime TERE Press FI For Help Hs emo lexww op Figure 7 7 Reorder the selected groups by using the UP and DN buttons located below the Selected Groups box To do this 1 Select the group that you wish to move by clicking on it with the left mouse button 2 Thenclick on the UP or DN button to move the group 7 7 3 Running A Custom Query To run the Query Click with the left mouse button the Generate Run button gu When the query is complete the information will be displayed in the Query Display Table The tabs that will appear in the table will match the Selected Groups and contain information for that group Feb 03Rev 2 0 7 10 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Go To Section 7 6 0 Using the Query Display Table for an explanation of the Query tabs MMIS Main Screen MMIS Queries e x Search Detail Query By Material x Query Name Material by operation and highway Filter Date from 2000 01 01 To 2000 01 03 C Period from 71 To 71 Status 7 Region Jose Press F1 For Help h Hs BHRawwG Figure 7 8 7 7 4 Saving A Custom Query Saving a Custom Query allows the user to use it at a later date Saving stores the selection criteria used to create the query The results are not saved The fields that are saved are Query Name the Query Clas
13. MANAGEMENT INFORMATION SYSTEM USERS MANUAL 6 2 4 HETS Reports Figure 6 14 Feb 03Rev 02 6 14 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 1 Hired Equipment Work Sheet This report shows the details of the work done by hired equipment For each job it identifies the Vendor Vendor Equipment Hours worked and Job Status a Hired Equipment Work Sheet KI 4 1 of 25 gt y a amp 100 Total 50 100 60 of 60 Ps HIRED EQUIPMENT WORK SHEET Transportation Printed 26 Jul 2001 Ontario DISTRICT PATROL THUNDER BAY 46 Ignace VENDOR Yendors Equipment Number 3 Type combination VENDOR CODE 8293372 Make SEQ NO 0 Licence No 444 EDWIN L KENNARD Model 8022 P O BOX 929 P C V No 066987591 Min Operating Weight SAE Rating IGNACE Serial No ON Gross Weight 24 000 00 POT 1TO Capacity Gas or Diesel D Horsepower Form ID 8935 Form Date 01 2001 Form Status ACCEPTED Operation 7050 Accom Qty Accom Code Prefix Highway Hours 06 0 6100823 1 00 Operation Total 1 00 Job Total 1 00 i NENNEN Figure 6 15 Feb 03Rev 02 6 15 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 Hired Equipment Time Sheet The Hired Equipment Time Sheet is provided to the Shared Services Bureau SSB as confirmation to pay the hired equipment vendor for their services It identifies the Vendor Vendor Equipment Hours worked
14. PLACING AHD SPREADING 1001 Total ae 659 25 558 25 m 1900 19 00 me 1 BP me 62122 252122 nme 1923 1923 1250 Klilomet ROAD PATROL 1250 Total 411144 11144 ae 1506 11606 ec 21900 21900 ae FT T2 ae er e 3031 LITER PICK UP 3031 Total ae 5041 14 504 4 mE 11106 11100 ae 3050 Metre FARM FEHCE 305 Total ec 4523 4523 me 25 200 1000 1026 nm 450 450 ne 2 2 Coeation 31055 Mele VEUALAKDSOuKD BARRIER 3055 Total c 6215 3 4235 3 ae 13100 06 ae 300 M06 ae 164 11 164 11 ae 2M 24 Coeration 3905 MISCELLANEOUS MATERIALS 5 SuPPLIES 3906 Total ae 72152 T2198 ne nm nm me Ogsaa 3907 SAFETY SuPPLIES m 1907 Tatal 7 ane amp px mona ul ue xu M UIIAGK A ir eoa E Figure 6 4 Feb 03Rev 02 6 4 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 1 C Report Comp Actual Vs Plan Expnd and MnHrs This report shows a Comparison of Actual vs Planned Productivity and Expenditures for crews For each operation it summarizes expenditures man hours accomplishment dollars per accomplishment unit and man hours per accomplishment unit g Comp Act vs Plann 1 i x 4 1of1 gt n Sel 75 Total4 100 4of4 Comparison of Actual vs Planned Productivity And Expenditures Page 1 Report 1 C Printea Ce 26Jul 2004 Transpartasian vnd From 01 Jan 2001 26
15. existing query Double click with the left mouse button on the line in the query table Or e Click on the line once with the left mouse button to highlight it then click on the Ok button 7 5 0 The Detail Tab The Detail tab allows you to work with an existing query or create new Custom Queries The Detail tab consists of the following sections 5 Main Screen MMIS Queries we ojej aa jes br Dno Bau c 7 78 Tz n E Figure 7 4 Feb 03Rev 2 0 7 5 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 5 1 The Query By Selection Box When creating a Custom Query use the Query By box to choose the Query Class from the drop down arrow The available Query Classes are Bare Pavement Equipment Hired Equipment HEQ Job Labour Material and Services This field will be read only when working with an existing query 7 5 2 The Query Name In the Query Name box enter the name of the new Custom Query being saved This field will be read only when working with an existing query 7 5 3 The Filter NOTE Filter options are not saved The Filter allows you to select a Date Range or a Period Range for the query The Status box lets you select the job status that the query will search If this field is left blank all job statuses will be used Filter options are available for both Standard and Custom Queries NOTE Information on Job Status is available in Chapter 5 0 0 D
16. in the Detail table at the bottom of the screen EEIITITUNEITITUUDONME 1 xj ES File Edit Manage Record Reports Queries Admin Windows Help Labour 384 16 Equipment 0 00 Material 0 00 Service 0 00 HEG 0 00 Total 384 16 Search Detail History Job ID 20032101 E Job UPDATE MMISO3 10 02 2003 08 12 Operation L New Value SMITH 1 1 503 MMIS3 TRAINING 8i jugi NUM m Press F1 For Help Figure 4 4 Feb 03Rev 0 2 4 4 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 5 0 0 Data Promotion in MMIS The Data Promotion process ensures information is reviewed and corrected before it becomes part of the MTO database This ensures data integrity and allows MTO and contractors to use the data with confidence for decision making 5 1 0 The Data Promotion Steps There are four steps in the Data Promotion process Initiated Jobs Closed Jobs Reviewed Jobs and Accepted Jobs Data for the Bare Pavement module follow the same approval process 5 1 1 Initiated Jobs When a job is created and saved in MMIS the system will automatically set its status to Initiated This indicates the information is being worked on The user can save Initiated data and retrieve it later to complete the job entry NOTE Only data with an Initiated status can be changed When the data entry has been completed and the user is satisfied it is correct t
17. in the Query Display Table is printed Both Standard and Custom Queries can be printed Feb 03Rev 2 0 7 15 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 9 2 Starting the Print After the query has been generated 1 Click the Print button with the left mouse button and a preview of the query will appear on the screen MMIS Main Screen MMIS Queries ole alll ow gt luj eln SSS SSE 2001701703 Figure 7 13 Feb 03Rev 2 0 7 16 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 To send the query to the printer click the Print button on the preview window CENTURA Report Builder QUERY QRP Ele Mew Pin KRON Operation 1001 1002 1004 1005 1006 1007 1008 1009 1011 1012 1014 1017 1250 1255 1902 2001 2003 2004 2005 3011 3031 3033 Figure 7 14 Reg Lab 17 264 87 282 19 2 045 12 608 49 00 761 70 375 45 00 00 415 80 00 280 00 86 453 56 559 54 925 80 920 74 00 1 146 07 2 014 38 76 17 13 817 74 240 47 Chrg OT 1 327 71 00 00 00 00 196 77 00 00 00 00 00 00 3 322 52 58 21 00 00 00 00 155 22 00 304 68 00 7 10 0 Exporting a Query MMOS Job Query Jobs by Operation Highway Equipment 6 029 43 00 292 60 00 7 00 00 94 50 00 00 180 00 44 00 00 43 715 91 00 4 00 552 20 00 188 40 535
18. 001 116 64 4 00 1 00 116 64 4 00 Operation 12 ROAD PATROL ars nHous Work Loc EXPENDITURES MAN HOURS ACCOMPLISHMENT or Dollars Per Man Hrs D Planned Actual A P Planne Actual AP Planne Actual AP Planned Actual AIP Hanne Actual AIP ACCEPTED 5250 23 209 00 3 400 00 1 75 INITIATED 0 2 133 95 58 00 1 052 00 2 02 OS Total 1250 8 084 18 25700 6 445900 0 181 0 Operation x1 LITTER PICK UP ars nHours Work Los EXPENDITURES MAN HOURS ACCOMPLISHMCNT or Dollars Per Man Hrs D Planned Actual AP Planne Actual AIP Planne Actual Planned Actual AIP lanne Actual AIP g MO ACCEPTED 582 20 20 00 Figure 6 10 Feb 03Rev 02 6 10 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 6 2 3 MDWR Reports IS Main Screen Windows Help Figure 6 11 Feb 03Rev 02 6 11 1 MDWR Summary MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL This report displays a summary grouped by Job Status for each patrol The information reported is Responsibility Centre Prefix Operation Highway Project Number Structure Number Accomplishment and Hours g Maintenance Daily Work Report Summary 16 of 65 5 Minisiry Transpartasan Ontario alee 2 Total414 100 414 of 414 af MAINTENANCE DAILY WORK SUMMAR Y 1 DISTRI
19. 2 gle 75 100 1812 of 1812 PEI ES Ministry of Transporation Project History Fage 23 Prieta Ga 27 Jul 2001 Ontario rom 01 Jun 1999 DISTRICT THUNDER BAY Te 2744201 61 83S cREW 24970 1 Jun232001 den 95820 Project Totals Eg 958 60 a Eg a 95860 Project 99 34 17 1 Damaged lvert removed replsood Resp Centre 6133 Accom Accom Labour Service HEQ Materiali Equipment Total Dt Patrol Fom D Rev Date Operation Code QTY Dollars Dollars Dollars Dollars Dollars Dollars amp t M MC PAT 20019 1 02001 52 100 149500 1495 00 Project Totals 100 a 1495 00 a a a 1495 00 Project 99 34 1 1 Rameoval of extension from cu Resp Centra 6133 Accom Accom Labour Service Material Equipment Total Dist Patrol Fom ID Rev Date Operation Code Dollars Dollars Dolas Dolas Dollars Dollars 1 HAMC 12700 1 Mzzg 22 2001 52 100 0 245000 0 5 0 249058 Project Totals 100 245000 x 58 a 2454 58 Project 99 3421 Oil spill ckan up Resp Centre 6139 Accom Accom Labour Serice HEQ Material Equipment Tota Dii Patrol Fom D Ro Date Operation Code Dollars Dollars Dollars Dollars Dollars Dollars HAMC PAT 14719 1 JunO7 2001 9 0 w 72000 0 0 72000 Project Totals a 72040 x a 7204 Projoct 99321 1 Repair Cuert Figure 6 26 Feb 03Rev 02 6 25 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 6 2 9 Queries Que
20. 89 00 97 20 53 60 Material Service 11 302 69 689 00 48 92 00 730 00 2 188 90 1 740 00 00 00 00 00 00 00 00 00 00 60 00 100 00 496 85 10 189 48 00 00 00 00 138 10 00 00 00 00 00 00 00 00 00 158 00 00 611 54 1 000 00 00 00 1 695 90 00 00 00 HEQ 4 593 83 00 00 00 00 00 00 6 053 90 227 50 00 00 00 00 00 00 00 880 00 00 1 976 40 00 00 00 2001 01 Total 41 207 5 331 1 5 256 2 348 7 0 958 4 469 5 6 053 5 447 5 11 282 1 44 0 280 C 133 630 C 6175 921 1 4725 880 C 1 492 6 293 76 1 15915 294 C 4 Queries results can be exported to the user s computer for use in common spreadsheet database programs 7 10 1 What Information is Exported The information displayed in the Query Display Table is exported Both Standard and Custom Queries can be exported Feb 03Rev 2 0 7 17 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 10 2 Starting the Export To export the information displayed in the table e Click on the Export button MMIS Main Screen MMIS Queries jv ale a Figure 7 15 7 10 3 Selecting the Export File Type When exporting you will be prompted to save the file to a folder on your computer Save the file in either one of two fo
21. ANUAL To Log on to the network through a phone line connection 1 Start your Dial up network connection 2 Enter your User Name and Password 3 Click on Connect to access the network Once connected you will be able to log on to MMIS z Connect ao tollfree User name 0 Password Save password Phone number 18778899981 Dialing from Default Location Dial Properties tees Figure 1 2 1 3 0 Starting the MMIS Program To start the MMIS program Double click on the MMIS icon on your desktop Maintenance Management Information System Ink Feb 03Rev 0 2 1 3 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL The program will begin by asking you to log in To do this 1 Enter your UserName and Password 2 Click on the Login button The Database field should be set to HWREF when you log in The Group field will be automatically set based on your user name The Group tells the system what type of work you are authorized to perform within MMIS For a list of the available Groups please see Appendix A Once you have logged in you are ready to begin working with MMIS Feb 03Rev 0 2 1 4 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 1 4 0 The MMIS Main Screen The main screen consists of four sections the Menu Bar the Button Bar the Work Area and the Information Bar Figure 1 4 shows the screen you will see when you are log
22. ANUAL When you select the Admin Listing option a window will appear where you can choose a table to view or print Admin Listings OWEN SOUND SOUND SOUTHWEST L e Figure 6 23 Feb 03Rev 02 6 23 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 6 2 8 Project History Admin Windows Help Reports 12 I ms gt 4 E gt Bare Pavement Reports gt Management Report Admin Listings 7 COORD MRANNG Figure 6 24 The report displays detailed information either for one or all the projects It includes the Project number Form ID Date Operation Accomplishment quantity Accomplishment code Labour dollars Service dollars Hired Equipment dollars Material dollars Equipment dollars and the Total dollars The Project History Print Window Figure 6 25 functions differently from the Project History Period YYYY 7MM DD Date from 1939 06 01 To 2001 03 25 Figure 6 25 other print windows It allows you to choose 1 A specific Project Number or leave it blank for all projects 2 Your desired Date or Period ranges Feb 03Rev 02 6 24 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL NOTE Some Users may be able to select a Region or District depending on their MMIS Group Project History 3 of 3 Total 191
23. CA Table Admin Vendor Equipment Rates Admin Vendor Supervisors MMIS 4 Cannot Enter or Edit Regions Accept and Reject Cannot Change Tables MMIS 5 Cannot Enter or Edit Regions Admin MTO Tables MMIS Allows the user to view Regions No access to data Cannot Change Tables R O information in MMIS only promotion MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Area Maintenance Contractor MMIS Groups Group Enter and Edit Jobs for View Information for Data Promotion Table Administration AMC 1 Single patrol within a Single patrol within a Contract Initiate and Close Cannot Change Tables Contract 2 Multiple Patrols within a Multiple patrols within a Contract Initiate and Close Contract Admin AMC Equipment Rates for a Contract Admin AMC Material Rates for a Contract Admin AMC Patrol Labour Rates and Employees for a Contract AMC 3 Multiple patrols within a Multiple patrols within a Contract Review and Contract Reject Admin AMC Equipment Rates for a Contract Admin AMC Material Rates for a Contract Admin AMC Patrol Labour Rates and Employees for a Contract AMC This access allows the user Multiple patrols within Contract No access to data Cannot Change Tables R O to view information in promotion MMIS only A 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Glossary Index Responsibility Centre Identifies the acco
24. CT NEW LISKEARD Form ID Dict ELOSED 14019 52 14123 52 141027 52 14129 52 14053 52 14040 52 1441 52 14042 52 Work Location 44 Elt Late AMC PAT 44 Elt Late AMC PAT 44 Elt Late AMC PAT 44 Elt Late AMC PAT 44 Elt Late AMC PAT 44 Elt Late AMC PAT 44 Elt Late AMC PAT 44 Elt Late AMC PAT PATROL Prefix Bl a 00 Glas w Glas w Bl a w Glas Glas w Blaa w Blaa o0 Day Total for 04162001 Operation 44 Elt Late AMC PAT Highway ProjCont Sructurc Acc Oty 1000 55820 Acc Code Kilometre Kilometre Kilometre Nonm Hr 400 16 00 am 2 0 250 050 4451 Page 16 of 65 26Jul 2001 Chrg Hr 0 w 0 w 0 0 w 0 w 0 o ooi ool MEIE r d Figure 6 12 Feb 03Rev 02 6 12 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 MDWR Details This report displays the details of each job Maintenance Daily Work Report Details KIKI 373 of 373 amp 75 Total484 100 484 of 484 9 Minisiry MAINTENANCE DAILY WORK REPORT a gee 5 PrnmedOn 26 ul 2001 af Transpartasan Ontario DISTRICT SOUND PATROL MC MO DATE TucJun 19 2001 Fom ID 16990 Operation 3080 SERVICES 1 L L Galden Mice Figure 6 13 Feb 03Rev 02 6 13 MAINTENANCE
25. Click on the Detail tab MMIS Main Screen MMIS Manage MDWR The Patrol Type Patrol and Date fields must be completed Once these fields are populated click on the New Job button located beside the MDWR ID The Job Header Entry screen will open and will enter the Prefix Operation Hwy Accomp PCA Type PCA and Struct Site Recov Ref and any applicable comments Once completed click on the OK button Feb 03Rev 0 2 2 19 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL OWEN SOUND Mng Outsource e 01 Clavering Once the Job Header information has been entered the 8 job entry areas are available Similar to that of a hard copy MDWR Feb 03Rev 0 2 2 20 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MMIS Main Screen MMIS Manage MDWR Feb 03Rev 0 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL The Labour Tab Under the Labour tab enter the time for the employees who worked on the job To see a list of the available employees click on the Employee Name box using the right mouse button or press the F2 key on your keyboard Select Employee NENNEN DISTRICT PATROL OWEN SOUND CREW 95 Using the tab key Tab to regular hours and fill in the hours of work for the operation under the appropriate column If using operation code 8001 fill in the ABSENT column Options Sick Vacation Holiday Overtime and
26. Continuous Entry Highway Highway Class x All Time values expressed in terms of 24 hrs Event Beginning YYYY MM DD 2002 11 25 Time BP Lost v YY7MM DD 2002 11 25 Time Event Ending MM DD Time BP Regained Y YYY MM DD Time Comments mE Press F1 For Help 5 mmiss NM Figure 9 3 9 2 1 The Location The Location is determined by the Region District Patrol and Patrol Type The Region and District is based on your User ID The Patrol is the location where the winter operation was performed The Patrol Type should be set to BP Patrol The BP Patrol is set up under the Patrol Table 9 2 2 BP ID The BP ID is a unique number assigned by the system to each Bare Pavement Record This is a searchable field Feb 03Rev2 0 9 3 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 9 2 3 Status Bare pavement records follow the Data Promotion process All new records are assigned a Status of Initiated NOTE Please check the accuracy your data before setting the Status to Closed Only Initiated data can be edited The record must be saved with each change in Status 9 2 4 The Event Date The Event Date is the day the storm started 9 2 5 The Event Type The Event Type options are Snow Ice and Both 9 2 7 The Continous Entry Check Box When checked this box retains the Location and Event Type information to speed up data entry
27. INTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 14 PCA Project Contract Account The Project Contract Account table in MMIS contains information about projects This table is administered by the MTO MMIS Coordinator MMIS Main Screen MMIS Table Maintenance PCA ES Eile Edit Manage Record Reports Queries Admin Windows Help n amp s 5 q c EE Record Updated Search Detail itor l Region CENTRAL 7 Io C Capital Project n P Project CE gS ss NW Work Order Default RC Privatization Code Iv Has Operation T Recoverable Iv Valid Project PCA Status District MMIS PCA Type 54 176 MATHESSU COORD TRAINING a rd p Figure 8 14 To set up a PCA 1 Click the New button on the button bar to create a new or select the Detail tab to edit an existing PCA 2 Confirm the system has defaulted to your Region and District Enter the PCA Code Enter the PCA Type by selecting one of these options from the drop down arrow Capital Project Project or Work Order Enter a text Description of the Project Enter the Project Default RC if required Leave the Privatization Type box blank Check the Has Operation check box if operation numbers are required Check the Recoverable box if the cost of the project can be recovered 0 Check the Valid Project box so jobs can be entered against the project Uncheck this b
28. Jul 2001 AP RANGE om TO 120 DOLLARS ACCOMP om TO 120 HOUIRS ACCOMP Dollars Per Acconp Man Hours per EXPENDITURES MAN HRS ACCOMPLISHMENT or Dollars Per Man Hrs Accor Plan Actual Rem Plan Actual Rem Plan Actual Rem Plan Actual Rem Pian A Ctual Rem REGION NORTHWEST DISTRIC THUNDER BAY Crew 99 CREW Prefix Does 3954 COMTRACT INSPECTION REPARATIOR 3954 Total m 109241 100241 D 4150 siso 5 Doeration 8001 EMPLOYEE ABSENCE 8001 Tatal mw 006 mM mM ET 200 ae Doeration 3952 PAPERWORK 3952 Total T3216 TA 22850 20850 Ae 0 Dosan 3951 SuPERVISION 3951 Total ae 57577 m 21550 21550 4 mw CO Roule Gee go 4417149 1417140 so saso ao ae Total Paola CREW Total 20 1417149 AG ATI AD 0 50 p Dhiki THUNDER BAY jo 1417149 14 171 42 m 68750 saso 6 m p Total Regio NORTHWEST 1417149 1417140 D 68750 saso oo D p Total wll Figure 6 5 Feb 03Rev 02 6 5 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 3 Expenditures Summary Report For each job this report shows Form ID Responsibility Centre Prefix Date and totals for Labour Material Equipment Hired Equipment Service and Total cost of the job fg Summary Expenditures Report m x 4 1 of 10 n amp 75 Total 211 100 211 of 211 ini Summary Expenditures Report Transpartasi
29. MC Contractor Patrol Table The contractor can enter employees and set the pay rate for each patrol within their contract MMIS Main Screen MMIS Table Maintenance PATROL 28 File Edit Manage Record Reports Queries Admin Windows Help Adl Search Detail Region SOUTHWEST Resp Centre ps District pweNsouNp v Pay Rate Patrol errant e Patrol Code p Patrol Description r Employees Highways Last Name First Name Active Employee 01 JOHN MONAHAN 02 REID 03 KERRY HODGKINSON M04 TIM DONNELL 05 JIM HALLMAN 06 KEVIN MCNAB 55 TODD ELDER i SO DOUGRADER 1 54444444 MMIS Patrol Pay Rate 1 1 TRAININGOS 2 TRAINING Figure 8 13 To enter the information Select a Patrol from the Search tab Select the Detail tab Enter the Pay Rate for the patrol Select the Employees tab enter the Last Name First Name and check the Active Employee box Repeat this step for each employee 5 Save the record by pressing the Save button or press F6 NOTE Do not delete an employee from the Employee Tab When an employee is no longer at patrol uncheck the Active Employee checkbox When entering jobs the employee s name will not appear in the list of employees on the Labour tab If a new patrol is required contact your MTO MMIS Coordinator Feb 03Rev 2 0 8 18 MA
30. MIS Table Maint ce MATERIAL Figure 8 9 Feb 03Rev 2 0 8 12 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 9 The OP Prefix Table The Operation Prefix table sets the prefix numbers that can be used in MMIS The table contains the Prefix Code and Prefix Description and e Check boxes are used to set a prefix to valid Valid Prefix and allow projects PCA Allowed to be used with the prefix This table is administered by the MMIS business administrator within the MTO Maintenance Office n MMIS Table Maintenance OP_PREFIX isi 811 ROUTINE GENERAL E Figure 8 10 Feb 03Rev 2 0 8 13 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 10 The Operation Table The Operation table is a list of all Operation Numbers in MMIS This table is administered by the MMIS business administrator within the MTO Maintenance Office This table contains the Operation Code Operation Description Accomplishment Code Check Boxes determine if Ahighway is required Highway Required e A structure Site Number is required Site No Required This table also e Displays the Valid Prefix numbers applicable to an Operation Code MMIS Main Screen MMIS Table Maintenance OPERATION ojee sjeiv idol DRAGGING OR GRADING OUTINE GENERAL Figure 8 11 Feb 03Rev 2 0 8 14 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 11 The Pat
31. N v Figure 8 3 The Equipment Class table contains The Equipment Class Code e The Equipment Class Description A Valid Equipment Class check box to tell the system that the Equipment class is valid and can be used This table is administered by the MMIS business administrator within the MTO Maintenance Office Feb 03Rev 2 0 8 6 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 3 The Equipment Table MHIS Main Screen MMIS Table Maintenance EQUIPMENT sjejajelalx oiv I Figure 8 4 The Equipment table provides a list of all equipment This table is administered by the MMIS business administrator within the MTO Maintenance Office with the exception of the rental rate The MTO Rental Rate is administered by the MTO MMIS Coordinator For an AMC contractor the Rental Rate is set by the contractor 8 2 4 Entering the MTO Equipment Rental Rate To enter the Rental Rate the MTO MMIS Coordinator will Select a piece of equipment from the Search tab Select the Detail tab Click on the Equipment Rental Rate column for your district Enter the Equipment Rental Rate Save the record by pressing the Save button or press F6 CS pue Feb 03Rev 2 0 8 7 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MHIS Main Screen MMIS Table Maintenance EQUIPMENT ES File Edit Manage Record Reports Queries Admin Windows Help lej x
32. N SYSTEM USERS MANUAL 6 0 0 Reports in MMIS 6 0 1 The Difference between Reports and Queries Reports are preformatted summaries of information in MMIS Queries are custom reports that summarize MMIS data according to criteria that you establish This chapter contains an explanation of the various reports that are available in MMIS 6 1 0 The Reports Queries Menu To select a Report Comp Actual Vs Plan Expnd And MnHrs 1B Comp Actual Vs Plan Expnd And MnHrs 1C Expenditures Summary Report Detailed Expenditures Report Bare Pavement Reports Management Report Admin Listings Project History Queries Figure 6 1 1 Select Reports Queries from the menu bar 2 Select one of the Report categories 3 Select one of the available Reports from the Report category This process is the same for all reports Feb 03Rev 02 6 1 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 6 1 1 Viewing and Printing Reports When you select a Report a window appears containing the Region District Patrol Patrol Type and Period options Users are able to make selections in this box based on their MMIS Group To Print or Preview a Report Select the Region if allowed Select the District if allowed Select the Patrol Type and Patrol if allowed Choose your Date From amp To or Period From amp To Click on the Print button or the Preview button pg o po The Print button sends the R
33. ORMATION SYSTEM USERS MANUAL 1 1 3 Manual Format If a word is in bold and in a different font than the normal text it refers to an option on the menu bar the button bar a tab on one of the windows a button on one of the windows a keystroke on the keyboard or a field on one of the windows eg Select Manage from the menu bar 1 1 4 Mouse Settings This manual refers to left and right mouse clicks The assumption is made that your mouse is set up for a right handed person If you wish to set your mouse up for a left handed person please remember that the mouse commands will be reversed If you wish to change your mouse settings please consult your Windows manual or the Windows Help 1 2 0 Connecting to the MTO Network Before you can start the MMIS program you must be logged on to the MTO network This can be done in two ways e Ifyou connected to the MTO network through the MTO LAN log in by entering your Password and User name You are now ready to start the MMIS program Enter Network Password Faj Enter your network password for Microsoft Networking 4 m User name faw Password p Domain MTO Figure 1 1 e Ifyou log on to the network through a phone line you must first connect through a Dial up network connection For MTO users this connection will be the same as the one used to access the network for e mail Feb 03Rev 0 2 1 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS M
34. Ontario MECC C TCT on System f P o e E T pe im 7 User s Manual March 2003 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Table of Contents Chapter 1 Chapter Section Heading Sub Section 1 0 0 Getting Started with MMIS 1 1 0 Introduction 1 1 1 Data Promotion 1 1 2 MMIS Map 1 1 3 Manual Format 1 1 4 Mouse Settings 1 2 0 Connecting to the MTO Network 1 3 0 Starting the MMIS Program 1 4 0 The MMIS Main Screen 1 4 1 The Menu Bar 1 4 2 The Button Bar 1 4 3 The Work Area 1 4 4 The Information Bar 1 5 0 Setting Your User Preferences 1 5 1 Right Mouse Click 1 5 2 Result Set Warning 1 5 3 When Opening Manage Jobs 1 5 4 Background Colours 1 6 0 Changing Your Password Chapter 2 Chapter Section Heading Sub Section 2 0 0 MMIS Data Entry Overview 2 0 1 Introduction 2 1 0 Entering a JOB in MMIS 2 1 1 Introduction 21 2 Jobs Screen 2 1 3 Data Input 2 1 4 Job Entry Header 2 1 5 Entering the Date 2 1 6 Job Detail Entry Zo Entering Labour Detail 2 1 8 The Equipment Tab 2 1 9 Entering Material Detail 2 1 10 Entering Services Detail 2 1 11 Entering Hired Equipment Detail Feb Rev 2 0 Page 1 m m lt lt Page 22 2 1 24 2 9 PET 2 5 2 6 2 7 224 2 9 2 10 2 11 2 12 MAINTENANCE MANAGEMENT INFORMATION SYSTEM
35. SOUND OWEN SOUND ris Feb 03Rev2 0 5 5 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL To view the individual MDWR group double clicking on the MDWR ID located on the left hand side of the screen and all jobs entered in that group will appear MMIS Main Screen MMIS Manage Job Statuses Ms OWEN SOUND E Figure 5 6 To view any job within an MDWR you can double click with the left mouse button and you will be taken to the Job Entry screen MMIS Main Screen MMIS Manage Jobs v ojej Ier 1 1 1 1 Figure 5 7 Feb 03Rev2 0 5 6 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 52 2 Changing the Status from Initiated to Closed To view the jobs that can be Closed 1 Select the status of Initiated in the Status box 2 Click on the Load Jobs button This displays the Initiated Jobs in the table at the bottom of the screen The default will show Groups in the job window which will include all MDWR entries as well MMIS Main Screen MMIS Manage Job Statuses E witjated and Overdue Rejected and Overdue Not Editable pf SOUND owen sou Ousouce Gutcurce Dua gl Figure 5 8 Feb 03Rev2 0 5 7 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL There are three ways to change the Status from Initiated to Closed Method 1 The Detai
36. Select the status of Reviewed in the Status box 2 Click on the Load Jobs button This displays the Reviewed Jobs in the table at the bottom of the screen ES MMIS Main Screen MMIS Manage Job Statuses Figure 5 16 NOTE If you Reject jobs provide a reason in the Remarks box that will appear on your screen next to the Status Column before saving See 5 2 5 Rejected Jobs There are three ways in which the user can change the Status Feb 03Rev2 0 5 15 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Method 1 The Detail Tab 1 Double click with the left mouse button on a job in the table on the Manage Status Screen This opens the Detail Tab where you can see and review the details of the job 2 Click on the drop down arrow in the Status box with your left mouse button 3 Select Accepted or Rejected 4 Savethe change by pressing F6 or by pressing the Save icon on the button bar ES MMIS Main Screen MMIS Manage Jobs bd ms c pao mm 7 TN 30 00 Update reason Figure 5 17 NOTE If you Reject jobs provide a reason in the Update Reason box that will appear on your screen See 5 2 5 Rejected Jobs Feb 03Rev2 0 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Method 2 The Status Column 1 Click on the Status column of the table on a particular job and a drop down menu will appear 2 Select Accepted or Rejected 3 Save the change by pre
37. TE Do not delete an employee from the Employee Tab When an employee is no longer at a patrol uncheck the Active Employee checkbox When entering jobs the employee s name will not appear in the list of employees on the Labour tab Never delete a patrol If the patrol is no longer used set it to Inactive Feb 03Rev 2 0 8 16 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 12 Creating a Home Location Patrol The Home Location patrol is used only by MTO MMIS Coordinators to enter work order information in an AMC area when the work order is not awarded to the AMC contractor To create a Home Location Patrol 1 Click the New button on the button bar to create a new patrol or select the Detail tab to edit an existing patrol The system will default to your Region and District Set the Patrol Type to Home Location by clicking on the drop down arrow Enter the Patrol Code Enter the Patrol Description Enter the Responsibility Centre or leave the field blank The RC is optional for a Home Location Patrol Enter a Pay Rate of 0 Save the record by pressing the Save button or press F6 O d NOTE Employees or Highways are not required for a Home Location Patrol The Responsibility Centre is optional for the Home Location Patrol The Pay Rate should be set to 0 This field cannot be left blank Feb 03Rev 2 0 8 17 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 13 The A
38. TEM USERS MANUAL 7 1 1 The Difference between Queries and Reports Queries are custom reports that summarize MMIS data according to the criteria establish Reports are preformatted summaries of information in MMIS 7 2 0 Starting Queries To open the query screen 1 Select Reports Queries from the menu bar 2 Then select Queries s MMIS Main S Screen Outlook BY Microsoft Word Docume rmt Main Screen 959599400 Figure 7 1 7 2 1 The Queries Screen Tabs The Query section of MMIS contains two Tabs I The Search Tab This screen allows to search for Standard Queries and saved Custom Queries Feb 03Rev 2 0 7 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 The Detail Tab This screen allows you to run saved queries or create Custom Queries 7 3 0 The Search Tab The Search tab contains the following areas MMIS Main Screen MMIS Queries md x File Edit Manage Record Reports Queries Admin Windows Help la x Search pesi Query By r Query Type C Standard Queries Custom Queries Query Class Query Name Bare Pavement Bare Pavement by Event Type Bare Pavement re Pavement by Highway Patrol Press F1 For Help fi he HEIDRIBO TRANNG a 1 Figure 7 2 7 3 1 The Query By Selection Box The Query By box is used to limit the search to a specific Query Class The Query Class is a method of grouping similar queries according to the inform
39. USERS MANUAL Table of Contents Chapter 2 continued Chapter Section Heading Page Sub Section 2 2 0 Saving Your Work 2 16 2 3 0 Setting The Status 2 16 2 4 0 Job ID Number 2 17 2 5 0 MDWR Entry Introduction 2 18 2 5 1 Data Entry 2 18 2 6 0 HEWSs Entry Introduction 2 29 2 6 1 Data Entry 2 29 Chapter 3 Chapter Section Heading Page Sub Section 3 0 0 Searching for Information in MMIS 3 1 3 1 0 Introduction 3 1 3 1 1 The Search Tab 3 1 3 1 2 Starting the Search 3 2 Chapter 4 Chapter Section Heading Page Sub Section 4 0 0 The History Tab 4 1 4 0 1 Introduction 4 1 41 0 Activating the History Tab 4 4 1 1 Selecting the History Tab 4 2 412 Viewing the History Details 4 3 Chapter 5 Chapter Section Heading Page Sub Section 5 0 0 Data Promotion in MMIS 5 1 5 1 0 The Data Promotion Steps 5 1 5 1 5 The Outstanding Jobs Window 5 2 5 2 0 Starting the Manage Status Screen 5 3 52 1 The Manage Status Screen 5 3 Feb Rev 2 0 B MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Table of Contents Chapter 5 continued Chapter Section Heading Sub Section 5 1 5 The Outstanding Jobs Window 5 2 0 Starting the Manage Status Screen 52 1 The Manage Status Screen 5 2 2 Changing the Status from Initiated to Closed 5 2 3 Changing the Status from Closed to Reviewed or Rejected 5 2 4 Changing the Status from Reviewed to Accepted or Rejected 5 2 5 Rejected Jobs 5 3 0 Typical Roles for the Promotion of Data Chapter 6 Chapter Se
40. Vendor Table 8 20 8 2 16 The Vendor Table in AMC Areas 8 20 8 2 17 The Vendor Equipment Table 8 21 Chapter 9 Chapter Section Heading Page Sub Section 9 0 0 The Bare Pavement Module 9 1 9 0 1 Opening the Bare Pavement Module 9 1 9 1 0 The Bare Pavement Window 9 2 9 2 0 The BP Entry Tab 9 3 9 2 1 The Location 9 3 9 2 2 BP ID 9 3 9 2 3 Status 9 4 9 2 4 The Event Date 9 4 9 2 8 The Event Type 9 4 9 2 7 The Continuous Entry Box 9 4 9 2 8 Highway and Highway Class 9 4 9 2 9 Event Beginning 9 4 9 2 10 BP Lost 9 4 9 2 11 Event End 9 4 9 2 12 BP Regained 9 5 92 13 The Error Message 9 5 9 2 14 The Date Format 9 5 Feb Rev 2 0 E MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Table of Contents Chapter 9 continued Chapter Section Heading Page Sub Section 9 2 15 The Event Time Format 9 6 9 3 0 Entering Bare Pavement Information 9 6 Appendix A Chapter Section Heading Page Sub Section Log In Groups in MMIS 1 MTO MMIS Groups 1 Area Maintenance Contractor MMIS Groups A 2 Glossary Feb Rev 2 0 E MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 1 0 0 Getting Started with MMIS 1 1 0 Introduction MMIS is a centralized data base system developed by the Ministry of Transportation to track maintenance work performed on the provincial highways of Ontario Daily operations records will be entered through the Manage Jobs portion of the system Since a variety of users will use MMIS several different user grou
41. a The HEWS Screen Allows input of all hired equipment data for MTO ONLY Data for 1 piece of equipment can be entered for a bi weekly period from 1 screen CAUTION Do NOT mix input methods for data input 2 1 0 Entering a Job in MMIS 2 1 1 Introduction When jobs are entered in MMIS information is recorded on the work performed operations on provincial highways This information includes the operation the labour the material services and equipment used and the accomplishment Feb 03Rev 0 2 2 1 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL To enter data into the MMIS system the system may require some or all of the following job details The Operation code mandatory Location Accomplishment mandatory Equipment Materials Employees Services Hired Equipment To enter data into MMIS 1 Select Manage from the menu bar 2 Then select Jobs Figure 2 1 2 1 2 The Jobs Screen There are three tabs in the Manage Jobs Option Feb 03Rev 0 2 2 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MMIS Main Screen MMIS Manage Jobs EI ole EL SSS aes DE frases 00 5 Fiqure 2 2 They are Search Detail and History The Search tab allows you search for existing jobs and is explained in 3 0 0 Searching for Information in MMIS The Detail tab allows you to enter job information and explained in 2 1 3 Starting Data Input The Histo
42. able tabs Feb 03Rev 2 0 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 8 1 An Example of the Query Table The District tab is currently selected and displays material costs for each district By double clicking on the District row the material costs will be displayed for each Patrol within that District I MMIS Main Screen MMIS Queries ES File Manage Record Reports Queries Admin Windows Help laj xj disleal search Query Material Custom Query Query Name Material by District Filter Date from 2001 01 01 Te 2001 07 05 C Period from edm zz Status Home Hone e Meter Job MTO Material Selected Groups Home District Home Patrol Material Job Available Groups Work Patrol Prefix Prvt Code peration Highway d wj Home District CHATHAM E 53078 38 8 M LONDON Lo 445 362 23 u 77777 712383 55 0 128 426 60 n m en m em i SUDBURY e fi hz HEIDRIBO 55 PRODUCTION Press F1 For Help Figure 7 10 NOTE Patrol is the Group that follows District in the Selected Groups Box Feb 03Rev 2 0 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL You ca
43. an From 0122001 Onaria To dul 26 7 2001 REGION EASTERN DISTRICT OTTAWA Patrol 46MO Wart District 42 Wart Lostian 48 Total Labour Material Equipment HEG Farm ID R C Farm Dae Cammers Dol Dd Dd Dol Dol Dol 12171 00 01 27208 20646 0 0 00 12078 Gla 00 2001 107 Dr D D w 1279 00 2001 197 Dr 0 0 w 12080 Gi 00 Apa0 197 Dr w w 0o 1254 Sla 00 fpnOl2001 9176 9176 00 000 w D 12388 Sla 00 1007893 w 1007899 000 w 12416 Sla 00 2001 71222 w 00 000 71222 w 12422 Sla 00 fpnOt2001 7000 D 000 7000 w 12488 Sid 00 fpnOt2001 102800 w 000 102800 w 12 32 Gia 00 Apoa 128120 00 w 000 128120 00 12455 00 Apoa 14000 00 w 000 14000 w 12598 Gia 00 00 w 000 00 12638 Gi 00 2001 7000 w 000 7000 00 Gia 00 Apoa 2070 w 000 32070 w 12 5 00 00 0 000 w 12870 GaG 00 Apa0 20196 00 w 000 20196 w 12878 GaG 00 ApwOt2001 2409 14 00 2409 14 w 12720 00 2001 22000 00 22000 w 12511 00 202001 oman 22940 w 74 00 w 00 12512 Ga 00 2001 22940 22940 000 w 00 12517 Sla 00 001 90 20590 w 000 D D 1080 Cte nm fient ww 19 74 1626 m Figure 6 6 Feb 03Rev 02 6 6 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 4 D
44. and Cost It summarizes payment information for accepted jobs on a period basis Hired Equipment Time Sheet 41 4 1041 2 Sel 00 Tota 5 1002 5of5 Ministry Page 1 of 1 of HIRED EQUIPMENT TIME SHEET Transportation Printed On 26 Jul 2001 02 03 56PM Ontario INVOICE 142 REV 0 FROM Monday Jul 09 2001 Last printed on 25 Jul 2001 8 31 174M TO Sunday Jul 22 2001 Last printed by SPYRKABE DISTRICT THUNDER BAY Vendor Equipment Number 1 PATROL 47 Savant Lake MO GRADER Make VENDORCODE 5093172 SEQ NO 0 Licence No Model KOVAL CONTRACTING P C V No BOX4 Min Op Weight SAE Rating Serial No PICKLE LAKE ON Gross Weight POY Capacity Gas or Diesel PO Tender No 50 00 112 Horsepower Prefix Operation HWY PCA Sruct Acc Acc Hours Rate Amount Code Qty Job ID 36663 Work Distict 61 Work Location 47 MO RC 6147 O7 Recoverable Work 1007 M6199550 39 30 14 00 69 00 966 00 Job ID 36664 Work Distict 61 Work Location 47 MO RC 6147 D7 Recoverable Work 1007 M6199550 39 20 9 45 69 00 652 05 v 4 b Figure 6 16 Feb 03Rev 02 6 16 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 6 2 5 Bare Pavement Reports gt MMIS Main Screen di Eile Manage Reco vi amp m amp 9 s amp District By HWY Class District Patrol Detail Eve District Patrol Events Patrol Highway Events Figure 6 17 These reports display information based on th
45. ata Promotion in MMIS 7 5 4 The Available Groups Box and The Selected Groups Box The Available Groups box displays the options that are available for sorting a query The Selected Groups box displays the Groups selected for a specific Custom Query These boxes are read only for Standard Queries 7 5 5 The Query Display Table The results of a query are displayed in this table Feb 03Rev 2 0 7 6 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 6 0 Working With Standard Queries When running a Standard Query the user can change only the Filter options The area of the screen entitled Selected Groups shows the fields and the order in which the report will be displayed in the Query Display Table 7 6 1 Running A Standard Query To run the Query Click with the left mouse button on the Generate Run button Fg The Query results are arranged in a drill down fashion When the Query is complete the information will be displayed in the Query Display Table The tabs that will appear in the table will match the Selected Groups and contain information for that group Go To Section 7 8 0 Using the Query Display Table for an explanation of the Query display tabs MMIS Main Screen MMIS Queries BEE ES Eile Edit Manage Record Reports Queries Admin Windows Help 81 xl Search Detail Query By Material Query Name i by Region District Patrol Filter Date from 2000 01 01 To
46. ate From Vendor Code 3 Sequence No Equipment Make 2 PO Jom Vendor Name _ 2 Tender No Equipment Code mr Licence No Equipment Type Serial Location New Work Detail Summarized Show Material hdd Material Add Work Unit Oper Work Hwy PCA Code Struct Accomp Priv Cod Recov Comment Units Press F1 For Help T ww TRANNG NM 2 Figure 7 2 The Patrol Type Patrol and Date fields must be completed Once these fields are populated the Job Header Entry screen will appear Enter data into the appropriate fields and press Feb 03Rev 0 2 2 30 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MMIS Main Screen MMIS Manage HEWS 1 File Edt Manage Record Reports Queries Admin Windows 1 Search Detail IE Home Region SOUTHWEST v District OWEN SOUND Patrol Mng Patrol or Clavering Invoice Status Initiated Period 2003 2 Date From 2003 01 20 Te 2003 02 02 Vendor Code 5745579 Sequence No 000 Equipment Make 3001 0 00276 Vendor Name ALLAN NEWMAN TRUCKING Modet Tender No Equipment Code PLOW Licence No Equipment Type KM Serial No Location SHELBURNE New Work Detail Summarized Oper R C Work Hwy PCA Code Struct Accomp Priv Cod R
47. ate field To enter the Date e Type it into the date field in the Year Month Date format e g 2001 03 28 Or e To open calendar 1 Click on the Date field with the right mouse button and a calendar will appear 2 Click on the appropriate date with the left mouse button 3 Click on Ok with the left mouse button story Job Header Entry 0 z Hi amc Pa 2 Hg Figure 2 4 Feb 03Rev 0 2 2 6 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 1 6 Job Detail Entry The basic Job Header information is entered in the middle portion of the screen and the job details are entered in the bottom of the screen gt MMIS Main Screen MMIS Manage Jobs je Af en n oa es ed Figure 2 5 The DETAIL screen contains the Labour Material Equipment Services and Hired Equipment tabs that are used to enter information Left mouse click on the appropriate tab and the window will open 2 1 7 Entering Labour Detail In the Labour window enter the hours for the employees who worked on the job When entering a new job the names of all available employees in the Patrol will appear in the table Employees not showing in the table can be added to the patrol list Feb 03Rev 0 2 2 7 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MHIS Main Screen MMIS Manage Jobs Figure 2 6 To enter information 1 Left mouse c
48. ation that is being reported If this box is blank the queries for all Query Classes will be displayed The available Query Classes are Bare Pavement Equipment Hired Equipment HEQ Job Labour Material and Services Feb 03Rev 2 0 7 3 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MMIS Main Screen MMIS Queries File Edit Manage Record Reports Queries Admin Windows Help 181 x lt gt Search Query Query Type Standard Queries Custom Queries Query Class Bare Pavement Bare Pavement Press F1 For Help h he HEIDRIBO cooRD FHRANNG Figure 7 3 7 3 2 The Query Type Options The Query Type option can be set to Standard Queries Custom Queries or Both 7 3 3 The Query Table The Query Table Figure 7 3 at the bottom of the screen displays a list of queries The three columns in this table are Query Class Query Name and Custom Query If the Custom Query check box is blank then the query is a Standard Query 7 4 0 Searching for Existing Queries To run a search 1 Select your choice in the Query By box 2 Select the Query Type 3 Click on the Search button to start the search The Queries that mee the criteria will be displayed in the Query Table Feb 03Rev 2 0 7 4 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 4 1 Selecting an Existing Query To select an
49. calculated based on the equipment cost in the Equipment Table The equipment Table is explained in 8 2 2 the Equipment Class Table and 8 2 3 Feb 03Rev 0 2 2 24 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL The Material Tab To enter information into the Material Tab Left mouse click on the Material tab MHIS Main Screen MMIS Manage MDWR ef xo pe Privatized is for the tracking of materials used by Contractors with no cost associated Internal entries will show a cost value This is explained 8 2 7 The Material Table Feb 03Rev 0 2 2 25 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL To enter material 1 Click on the first empty cell in the Code column to enter the material Code view a list of materials press the F2 key or right mouse click in the cell Enter the Material Code the material description will automatically appear in the Description column and the unit of measure will automatically appear in the Unit column Select a Material 2 Enter the material quantity in the Qty Column The material costs are based on the material rate set in the Material Table The cost will be calculated for the material This is explained in 8 2 7 The Material Table Repeat steps 1 and 2 for each material used entering them in the appropriate job columns The above process will be followed for each job entry by clicking on the New Job
50. cord The Right Arrow Button moves you to the next record First Record Last Record The Double Left Arrow Button moves you to the first record The Double Right Arrow Button moves you to the last record Export Saves the information contained in a report or a query in a standard file format to your computer Generate Run gu This button is used to generate a report or query You use it after you have selected the criteria for your report or query 1 4 3 The Work Area The work area is the large grey area of the screen This is where the different windows will open when you select an option from the Menu Bar Feb 03Rev 0 2 1 7 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 1 4 4 The Information Bar The information bar is located at the bottom of the MMIS screen and shows the user name MMIS user group and the database that is being used MHIS Main Screen Press FI For Heip meo pao RA WM DO Figure 1 5 Feb 03Rev 0 2 1 8 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 1 5 0 Setting Your User Preferences The user Preferences section allows you to set certain options within the program These include the ability to set the starting screen under Manage Jobs to either Search or Form select how you would like the pop up tables to appear and how many rows can be returned when you search for a record The best way to determine how you would l
51. ction Heading Sub Section 6 0 0 Reports in MMIS 6 0 1 The Difference between Reports and Queries 6 1 0 The Reports Queries Menu 6 1 1 Viewing and Printing Reports 6 2 0 Available Reports 6 2 1 Expenditure Reports 6 2 2 MOR Reports 6 2 3 MDWR Reports 6 2 4 HETS Reports 6 2 5 Bare Pavement Reports 6 2 6 Management Reports 6 2 7 Admin Listing 6 2 8 Project History 6 2 9 Queries Chapter 7 Chapter Section Heading Sub Section 7 0 0 Queries in MMIS 7 1 0 Introduction 7 1 1 The Difference between Queries and Reports 7 2 0 Starting Queries 7 2 1 The Queries Screen Tabs 7 3 0 The Search Tab Feb Rev 2 0 Page 5 2 5 3 5 7 5 11 5 15 5 17 5 20 Page 6 1 6 1 6 1 6 2 6 3 6 8 6 11 6 14 6 17 6 22 6 22 6 24 6 26 Page 7 1 7 1 7 2 7 2 7 2 7 3 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Table of Contents Chapter 7 continued Chapter Section Heading Sub Section 7 3 1 The Query By Selection Box 7 3 2 The Query Type Options 7 3 3 The Query Table 7 4 0 Searching for Existing Queries 7 4 1 Selecting an Existing Query 7 5 0 The Detail Tab 7 5 1 The Query By Selection Box 7 5 2 The Query Name 7 5 3 7 5 4 The Available Groups Box and the Selected Groups Box 7 5 5 The Query Display Table 7 6 0 Working With Standard Queries 7 6 1 Running a Standard Query 7 7 0 Creating a Custom Query 7 7 1 Setting Your Query Options 7 7 2 Sorting Your Query 7
52. down arrow 2 Select Closed 3 Save the job by clicking on the Save button or press F6 on the keyboard NOTE The status of a job should be set to Closed after you have checked the information you have entered and are satisfied it is complete and correct Saving Your Work Save often to reduce data loss To save your work Click the Save icon button in the tool bar or press F6 When an MDWR is saved there will be a number assigned to each operation entered and a number assigned to the MDWR as an ID for the group of jobs entered Feb 03Rev 0 2 2 28 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 6 0 Introduction HEWS Entry Screen When jobs are entered in MMIS information is recorded on the work performed operations on provincial highways In HEWS all vendor equipment material usage and accomplishments are recorded on a bi weekly basis 2 6 1 Entering data into the HEWS Screen To open the HEWS input screen l Select Manage from the menu bar 2 Then select HEWS Figure 7 1 Click on the Detail tab Feb 03Rev 0 2 2 29 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MMIS Main Screen MMIS Manage HEWS 8j x Eg File Edit Manage Record Reports Queries Admin Windows Help l SIETEILI Al Home Region SOUTHWEST v District OWEN SOUND Patrol Type z Invoice 8 Status initiated 71 Period 1 D
53. e ACCEPTED 0 00 9 132 17 9 138 17 17 00 17 00 Siaus ACCEPTED 0 00 21 472 25 47925 oc oc Praia 04 Taal 30 618 02 30 618 02 17 00 17 00 Pref i 08 Praed General Status ACCEPTED 0 00 13 542 51 12 549 51 coc 08 Taal 13 549 51 13 544 51 W Move Lat inn A LAS Tl 1409 249546 400 749 51 P rr SS E amp t amp Feb 03Rev 02 6 9 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 Maintenance Operation Report This report provides a summary by Patrol Prefix and Operation and shows Expenditures Man hours Accomplishment Dollars per Accomplishment and Man hours per Accomplishment BEI x fg Maintenance Operation Report 28 of 31 gt 9 AA 75 Totak101 100 101 of 101 MAINTENANCE OPERATION REPORT Faas 28 Flaa Oe 26ul 2001 Transporation From Jan01 2001 AP Exodoa Raege C30 1 20 DOLLARSVACCOMP To Jul 26 2001 O32 MAN HOURS ACCOMP REGION CENTRAL DISTRICT TORONTO Patrol Prefix o Operation 1001 MANUAL PATCHING PLACING AND SPRCADING ars nHours Work Loc EXPENDITURES MAN HOURS ACCOMPLISHMENT or Dollars Per Man Hrs D Planned Actual A P Planne Actual AP Plannec Actual Planned Actual AIP Hanne Actual AIP o MO ACCEPTED 116 64 4 00 1 00 116 64 4 00 Total 1
54. e Bare Pavement module The information is grouped according to its title as follows Feb 03Rev 02 6 17 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 1 District by Hwy Class 1815 IU By Hwy Class Report 4 4 1of1 amp 75 Total 2 100 2012 District By Highway Class Report MET Fram Jan 01 2000 Ontario Ta dul 27 2001 DISTRICT OWEN SOUND No of AverageLegth Average Length Average Length Class Events ofan Event of TimeBarePavenentLost of TimetoRegaini Bare Pavernert Patrol 1 3 PATROL 2 00 1 5 2 3 1 3 Highway C ns 1 Taal 2 00 15 23 13 1B 3 PATROL 2 00 1 5 2 3 1 3 Highway C bss 1B Toal 2 00 1 5 2 3 13 Figure 6 18 Feb 03Rev 02 6 18 MAINTENANCE MANAGEMENT INFORMATION SYSTEM 2 District Patrol Detail Events DIET Events Detailed Report USERS MANUAL KIKI 1of1 01 amp 75 Total 4 100 Ontario DISTRICT OWEN SOUND Patrol 9 PATROL 9 PATROL 9 PATROL 9 PATROL r Y S555 Event Event No Type 2 5 1 5 2 5 1 5 Average Length ofan Event 13 District Patrol Detail Events Report Jan 01 2000 Jul 27 2001 Average Length Awerage Length ofTimeBarePavenentLost ofTimeto Regain Bare Pavemet 15 20 13 20 05 20 05 20 s a Figure 6 19 Feb 03Rev 02 6 19 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 3 District Patrol E
55. ecov Comment hdd Heterial Had Work Unit Mob Header Entry E Invoice ID 7 SOUTHWEST v Distict OWEN SOUND z Patol Type Outsource gt 1 Caveira gt Work Region SOUTHWEST Distict OWEN SOUND v Patol Type Outsource Patol 07 Caverna x Period 2 Responsibility Cente 148 i E Highway Accomplishment eer PCAType 2 3 Recov Ref Comments TI Complete the current operation MMIS Vendor Equipment Code 503 imss TRANNGG Figure 7 3 MMIS Main Screen MMIS Manage xi Patrol Mng Patrol 01 Clavering X Invoice Status initiated z Period 2003 v 24 DateFrom 2003702717 To 2003 03 02 Vendor Code 5003229 Sequence 000 Equipment Ford PO Vendor Name DON BOYD TRUCKING Model 18000 Tender Equipment Code 01 Licence No 946 WD Equipment Type Combo Serial No HFDZY82ESPVA29478 Location New Work Detail Summarized Show Material Add Material Add Work Unit 09 d tret Pigs re ed me e Recov Comment Units 17 20 06 7006 6149 01 6 Ki lome 5 00 10 00 11 00 E ER Choose materia E Material Code Material Description SALT COARSE amp FINE BULK UM Desc fone Cancel Press F1 For Help 503 mmiss TRAINING 8i
56. eport directly to the default printer The Preview button provides an on screen display of the Report and allows you the option of printing it CAPPE 1B REPORT 2002 04 01 2002 10 28 Figure 6 2 Feb 03Rev 02 6 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 6 2 0 Available Reports This section provides a brief summary of the information that is contained in the MMIS reports 6 2 1 Expenditure Reports MMIS Main Screen Expenditure Reports Figure 6 3 Feb 03Rev 02 6 3 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 1 1 B Report Comp Actual Vs Plan Expnd and MnHrs This report shows a Comparison of Actual vs Planned Productivity and Expenditures for patrols For each operation it summarizes expenditures man hours accomplishment dollars per accomplishment unit and man hours per accomplishment unit Comp Act vs Plann 1B 4 1 of 1 b y lel 75 Total 33 100 33 of 33 wr Comparison of Actual vs Planned Productivity And Expenditures 1 Report 1 B 26Jul 2004 aa From 01 Jan 2001 AIP RANGE DOLLARSIACCOMP Te P HOURS ACCOMP Dollars Per Acconp Man Hours per EXPENDITURES HRS ACCOMPLISHMENT or Dollars Per Man rs Plan Actu Rem Plan Actual Rem Plan Actual lan Actual Rem Plan Actual Rem REGION EASTERN DISTRICT OTTAWA Patral 46 MO Prefix o Ogsaa 1001 Tone VAKUAL PATCHING
57. esults to the information entered into MMIS 5 1 4 Accepted Jobs The status of a job is set to Accepted after the appropriate person has reviewed it See 5 3 0 Typical Roles for the Promotion of Data When a job has been Accepted the information is reported provincially and becomes official ministry data The status of a record can be set to Rejected if information is incorrect When a job is Rejected a reason must be recorded in the dialog box on why the job was Rejected 5 1 5 The Outstanding Jobs Window When you log into MMIS a reminder window will appear showing the number of Initiated and or Rejected jobs that are more than 1 week old To continue from this point e Click on the OK button with the left mouse button Outstanding Jobs i There are 88 overdue jobs in Initiated status There are 4 overdue jobs in Rejected status Figure 5 1 Feb 03Rev2 0 5 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 5 2 0 Starting The Manage Status Screen To enter the screen 1 Select Manage from the menu bar 2 Select Status 3 Select Job to update Job Status or select Bare Pavement to update Bare Pavement Record Status MMIS Main Screen Manage Statuses wes aa Figure 5 2 5 2 1 The Manage Status Screen The appropriate Status screen will appear depending on the selection Examples for promoting Jobs follows The process is the same for promoting Bare Pave
58. etail Expenditures Report For each job this report shows Form ID Responsibility Centre Prefix Operations Highway PCA Code Date Labour Material Equipment Hired Equipment Service and Total Dollars 4 Detail Expenditures Report 4 41 1 of 92 9 75 Total 364 100 364 of 364 Detail Expenditures Report SMART Transporation From Jant 01 2001 Onaria To dul 26 2001 REGION NORTHWEST DISTRICT THUNDER Bay PATROL 47 Savant Late Wark Diari 61 Wart Lotion 47 MO Fonm 853 lt 8147 Form Date Mon Apr 02 2001 Comments Acc Acc Total Lancur Ep uloment HEC Seele Pref Ooerallon Hanway Cooe Cty coos Dol Dol Dol Dol Dol Dol w 1230 20000 Kiama 9579 7038 0 220 0 0 Form Total 95 79 70 59 2520 a Form ID 854 RL Form Date Mon Apr 02 2001 Comments Acc Acc Total Lapcuc Material Ep u loran HEC Senke Ooealioa Hnway POA Coge Dol Dol Dol Dol Dol Dol 2951 ns 2252 0 aad 0 For Total 31 93 23 53 x a a Form ID 855 Fom Mon Apr 02 2001 Comments Acc Acc Total Lateuc Eo uloment HEC Senke Pete Hignweay POA Coase Cty Dol Dol Dol Dol Dol Dol 00 2952 12252 12252 0 Form Total 123 53 123 53 E Fonm 856 Form Date Mon Apr 02 2001 Comments Acc Acc Total Lacus Eo uloment HEC Seele
59. etails for a specific record have been selected The History Tab will become active when a record is selected To activate the History tab 1 Set your Search criteria and run your Search 2 In the Search Table double click with the left mouse button on the record you wish to view For Manage Jobs this is the Form and Jobs tabs 3 TheHistory tab is now available Figure 4 1 Feb 03Rev 0 2 4 1 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 4 1 1 Selecting the History Tab To view the History tab screen Select a record and Click on the History tab with the left mouse button MMIS Main Screen MMIS Manage Jobs i 18 28 File Edit Manage Record Reports Queries Admin Windows Help laj xj 8 ei co S rl gt Labour 0 01 Equipment 0 00 Material 0 00 Service 0 00 HEQ 0 00 Tota 0 01 INSERT MMISO3 10 01 2003 09 59 AM UPDATE MMISOS 10 01 2003 10 00 AM Field Name Old Value New Value Press F1 For Help 39 55 503 MMIS3 TRAINING 8i Figure 4 2 The History Box Update Reason and the Detail Table which appears at the bottom of the screen The History Box displays the changes made to a record in a tree format Each branch shows if a record was Inserted or Updated the user ID the date and time If additional information is available for this record a sign will appear next to the branch Click on the sign w
60. f performing a search is the same This chapter will use the Search tab on the Jobs screen to illustrate the process 3 1 1 The Search Tab In the MMIS Manage screen e Click on the Search tab with the left mouse button MMIS Main Screen MMIS Manage Jobs Feb 03Rev 0 2 3 1 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Define the search criteria based on the fields available as outlined in Figure 3 2 The jobs that meet the search criteria will be returned in the Search table located at the bottom of the screen To perform a search of all jobs within a district select the Region and District fields As more fields are filled in the number of jobs returned in the table is reduced 3 1 2 Starting the Search To execute the search Fill in the fields for the search criteria Click on the Search button located on the upper right of the screen with a single click of the left mouse button Ne MMIS Main Screen MMIS Manage Jobs med E SOUTHWEST OWEN SOUND El ire Je 01 Clavering Feb 03Rev 0 2 3 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Click on the advanced search button on the right hand side of the screen toto search by Employee Equipment Code Equipment Class Material Code Serv Ref Vendor Seq No Vend Equipment Created by AMC and previous years history from DDIS ES MMIS Main Screen MMIS Manage Jobs Initia
61. ged into MMIS ETTE Main Screen File Edit Manage Record Reports Queries Admin Windows Help Do 2 Press F1 For Help Figure 1 4 1 4 1 The Menu Bar bj MMIS Main Screen File Edit Manage Record Reports Queries Admin Windows Help The menu bar in MMIS is similar to other Windows programs When a menu option is selected a drop down menu will appear providing the user with the options available under that menu bar Feb 03Rev 0 2 1 5 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 1 4 2 The Button Bar The button bar contains several buttons that can be clicked on with the mouse to perform specific tasks The MMIS buttons are shown below Help Provides help for the area of the system you are in New Starts a new record Opens a saved record Save FI Saves your work n Delete Deletes the record Cancel Cancels the current changes you made but does not delete a saved record Print Sends a report or query to your printer Close ni Closes the current window in your MMIS session Feb 03Rev 0 2 1 6 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Exit Closes all windows in your MMIS session and closes your current session Note You should save your work before exiting the program Next Record Previous Record 4 gt The Left Arrow Button moves you to the previous re
62. hange by pressing F6 or by pressing the Save icon on the button bar IS Main Screen MMIS Manage Job S el File Edit Manage Record Reports Queries Admin Windows Help x Rejected then Closed Job ID Status Initiated z MDWR ID Responsibility Centre Regon Regon SOUTHWEST 2116 Date from 2002 04 01 To ea District EN SOUN Dena menson E SOUND Period from 20 To 2003 z Type Patrol z Patrol Prefix 5 peration Highway Code Structure Site Recov Ref Job ID Status Comments Patrol Patrol Work Work Patrol Description 1 lt Group gt LIEST 222 i TTestssss 4 Test3333334 SESE SD d Test 26 347 502 MMIS2 TRAINING 8i Press F1 For Help Figure 5 11 Feb 03Rev2 0 5 10 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 5 2 3 Changing the Status from Closed to Reviewed or Rejected To view the jobs that can be Reviewed 1 Select the status of Closed in the Status box 2 Click on the Load Jobs button This displays the Closed Jobs in the table at the bottom of the screen The default will show Groups in the job window which will include all MDWR entries as well MMIS Main Screen MMIS Manage Job Statuses pepe pede epe me o f n s and Overdue Rejected and Overdue Not Editable Rejected then C
63. he status must be changed to Closed and the job saved If you decide that you would like to start over on the data input and it has not yet been saved the user can click the Cancel button and start over 5 1 2 Closed Jobs The status of a job is changed to Closed when the data input is complete and the person doing the input is satisfied that the information is correct If the status is Closed jobs can be deleted by the user to make changes or the user can contact their MMIS Coordinator who will Reject the job and the status will be set back to Initiated Initiated or Closed jobs can only be reported on within the AMC contract or within the MTO district When the status of a Job has been set to Closed the information is ready to be Reviewed and then Accepted Feb 03Rev2 0 5 1 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 5 1 3 Reviewed Jobs The status of a job is set to Reviewed after it has been reviewed by the appropriate person See 5 3 0 Typical Roles for the Promotion of Data If the person who reviews jobs notices errors in the information the status of the record can be set to Rejected so the appropriate changes can be made When a job is Rejected enter a reason in the dialog box to define why the job was Rejected When a job is Reviewed it has been reviewed by a supervisor and is unlikely to have errors MTO Maintenance Co ordinator can do a field spot check of the operations to compare the r
64. here is not a specific Responsibility Centre that is assigned to the project then the Responsibility Centre will be the default number for your location For information on setting up a project see 8 2 13 PCA Project Contract Account Toenter the PCA type click on the PCA Type box drop down arrow and select from the options To enter the Code right mouse click on the Code box and select the code or Press the F2 key to view a list of available projects Structure Site Number Is a unique identifier for each bridge on a provincial highway If you re unsure of the Structure Site Number contact your MMIS Co Ordinator e The Structure Site Number is required for operations that are carried out on the structure e To enter the site number click on the Struct Site box and enter the number Recoverable Reference Number This field is required when the cost of the job is recovered from another source Contact your MMIS Co Ordinator to determine the numbers that are applicable for use in your area e To enter the number click on the Recov Ref field and enter the number Comments Comments field is where relevant information for the job is entered The Comments field is a maximum of 50 characters in length Comments are searchable therefore all comments should be consistent and accurate REMARKS are NOT searchable Feb 03 Rev 0 2 1 2
65. ike these options to be set is by testing various choices and selecting those that work best To set your preferences e Select File from the menu bar then select Preferences Click To Set Preferences Figure 1 7 Seachtab E Feb 03Rev 0 2 1 9 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 1 5 1 Right Mouse Click This preference setting allows you to choose between a Menu or List of values when the Right Mouse Button is clicked in a data entry field The Menu option opens a right mouse window and then you must select List Values to see the list of codes Dro SUI Paste Help Figure 1 8 The List option will take you directly to the list of codes Select a Highway gt lt CODE Figure 1 9 1 5 2 Result Set Warning The Result Set Warning tells you that the number of records that will be returned when doing a search will exceed the Rows threshold that has been set in this preference You can turn this warning On or Off Feb 03Rev 0 2 1 10 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL This warning is useful for Dial up users who have a slow connection and may wait a long time for the information to be returned It allows them to decide if they want to proceed or cancel the search 1 5 3 When Opening Manage Jobs This preference allows you to choose the system tab you wish to star
66. ith the left mouse button the branch will expand to show additional details Click on the branch and the Field Name the Old Value and the New Value appear in the Detail Table The Update Reason box shows comments that were inserted by the user Feb 03Rev 0 2 4 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Note The History tab is read only No History information is retained for a deleted record 4 1 2 Viewing the History Details To view the Update Reason e Click on the desired branch with the left mouse button MMIS Main Screen MMIS Manage Jobs F xi 81 28 File Edit Manage Record Reports Queries Admin Windows Help eff sped opu DESI mm Labour 384 16 Equipment 0 00 Materia 0 00 Service 0 00 HEQ 0 00 Total 38416 Search Detail History 20032101 Update Reason Changed employee s time R Smith Job ID New Value Old Value Field Name h Hh Press F1 For Help Figure 4 3 Feb 03Rev 0 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL To view the changes to the record 1 Double click on the desired branch with the left mouse button or single click with the left mouse button on the sign to expand the branch 2 Click with the left mouse button on the expanded branch to enable the Detail table 3 The Field Name Old Value and New Value will appear
67. its status to Closed Caution Closed jobs cannot be edited Only Initiated data can be edited Only the Status Date and Comment fields may be edited on the Form tab after a Save Feb 03Rev 0 2 2 16 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 4 0 Job ID Number The system assigns a Job ID number once the job is saved This is a unique number and can be used as a reference number to locate the job in the future it is located in the header information Hint If you write this number on your hard copy of the MDWR form you will be able to search for it in MMIS Feb 03Rev 0 2 2 17 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 5 0 Introduction MDWR Entry Screen When jobs are entered in MMIS information is recorded on the work performed operations on provincial highways This information includes the operation the labour the material and equipment used and the accomplishment To enter data into the MMIS the system may require some or all of the following job details The Operation number mandatory Location Accomplishment mandatory Equipment Materials Employees Services Hired Equipment This information is found on the Maintenance Daily Work Report MDWR 2 5 1 Entering data into the MDWR screen To open the MDWR input screen 1 Select Manage from the menu bar 2 Then selecc MDWR Feb 03Rev 0 2 2 18 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL
68. l Tab 1 Double click with the left mouse button on a job in the table on the Manage Status Screen This opens the Detail Tab where you can see and review the details of the job Click on the drop down arrow in the Status box with your left mouse button Select Closed Save the change by pressing F6 or by pressing the Save icon on the button bar MMIS Main Screen MMIS Manage Jobs Figure 5 9 Feb 03Rev2 0 5 8 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Method 2 The Status Column 1 Click on the Status column of the table on a particular job and a drop down menu will appear 2 Select Close 3 Save the change by pressing F6 or by pressing the Save icon on the button bar MMIS Main Screen MMIS Manage Job Statuses E Initiated and Overdue Rejected and Overdue Not Editable oven SOUND it Figure 5 10 Feb 03Rev2 0 5 9 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Method 3 Updating Multiple Records The user can change the status of consecutive jobs in the table as follows 1 Click on the first job you wish to change the Job ID column hold down the left mouse button and drag the mouse to the last Job you wish to change At this point all these records will be highlighted in black 2 Click on the Close box on the top row below the button bar 3 Save the c
69. lick on the Labour tab 2 Select an employee who worked on the job e To add employees who do not appear in the table click it the fist empty cell in the Employee Name column and right mouse click in the cell or press F2 3 Using the tab key Tab to regular hours and fill in the hours of work for the operation e When using operation code 8001 fill in the Absent column Options Sick Vacation Holiday Overtime and Other e When entering overtime for an employee fill in the Overtime column Options Normal Call back Statutory and Time travelled 4 Repeat steps 2 to 3 for each employee who worked on the job When hours are entered the costs are automatically calculated The costs are based on the labour rate that is set for each Patrol To set the labour rate see 8 2 11 The Patrol Table Feb 03Rev 0 2 2 8 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 1 28 The Equipment Tab When entering a new job all equipment in the Patrol list will appear in the table Equipment not showing in the table can be added to the patrol list Enter the number of hours for each piece of equipment used on the job r MMIS Manage Jobs Figure 2 7 To enter information into the Equipment tab 1 Left mouse click on the Equipment tab with 2 Enter the Equipment Class Code and the Hours in the appropriate columns for each piece of equipment used When the Equipment Code is entered the sys
70. losed a __ pourwest E fsourkwest El iro 38 E I lt Mes Outsource a C Te 2002 06 11 t 2002 06 12 test Figure 5 12 Feb 03Rev2 0 5 11 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL There are three ways to change the Status from Closed to Reviewed Method 1 The Detail Tab 1 Double click with the left mouse button on a job in the table on the Manage Status Screen This opens the Detail Tab where you can see and review the details of the job 2 Click on the drop down arrow in the Status box with your left mouse button 3 Select Reviewed or Rejected 4 Savethe change by pressing F6 or by pressing the Save icon on the button bar MMIS Manage Jobs Closed Reject Review Update reason Needs Equipment for operation Figure 5 13 NOTE If you Reject jobs provide a reason in the Update Reason box that will appear on your screen See 5 2 5 Rejected Jobs Feb 03Rev2 0 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Method 2 The Status Column 1 Click on the Status column of the table on a particular job and a drop down menu will appear 2 Select Reviewed or Rejected 3 Save the change by pressing F6 or by pressing the Save icon on the button bar dede Del Initiated and Overdue Rejected and Overdue Not Editable Rejected then Closed mmm Cosed
71. ment Records Feb 03Rev2 0 5 3 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Figure 5 3 shows the Manage Status screen for Jobs MMIS Main Screen MMIS Manage Job Statuses elo ft e deed reb Initiated and Overdue Rejected and Overdue Not Editable Rejected then Closed SOUTHWEST SOUTHWEST Ellis 2002 04 01 EXE OWEN SOUND OWEN SOUND E o i __ Figure 5 3 There are two sections to the Manage Job Screen When you have chosen your criteria for jobs you wish to review with the left mouse button click on the Load Jobs button on the top right of the screen This will load all jobs in the status you requested screen will show the MDWR ID on the left and will default to load Groups status The Groups status will show all jobs entered whether entered through MDWR Entry or through the Job Entry screen The All Groups will be the defaulted mode Feb 03Rev2 0 5 4 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MMIS Main Screen MMIS Manage Job Statuses Not Editable Rejected then Closed SOUTHWEST 2002 04 01 f 2002 09 23 OWEN SOUND Te IS Figure 5 4 Click with the left mouse on No Group to see only jobs that have been entered through the Job Entry mode MMIS Main Screen MMIS Manage Job Statuses E mmm fsouTHwesT ourewest E Emi gl 2002 08 23 OWEN
72. n repeat the process used in this example to view the information for each successive tab in the Query Display Table gt I MMIS Main Screen MMIS Queries x lj xj 25 Eile Manage Record Reports Queries Admin Windows Help v o eje s x eje v deea Search Detai Query By Material Custom Query Query Name Material by District Selected Groups Home District Home Patrol Available Groups Work Patrol Prefix Material Job Filter Date from 2001 01 01 Te 2001 07 05 C Period from Status X Home District OTTAWA Home Patra B Home Patrol Material 46 82002455 95 1 118251 7277 Code peration Highway UP DN 1 17 HEIDRIBO IMMISS PRODUCTION Press F1 For Help Figure 7 11 Once all the tabs have been activated you can move from tab to tab User Tip When the Job ID number is displayed double click on the Job ID and the system will take you to the Job Detail screens Form tab and Detail tab See Figure 7 12 This will only work if Job is last group in the Selected Groups Box Feb 03Rev 2 0 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MMIS Main Screen MMIS Queries 2000 01 01 2000 12 05 Figure 7 12 7 9 0 Printing a Query Printing sends a copy of the query to the printer 7 9 1 What Information is Printed The information displayed
73. other If using overtime for an employee fill in the Overtime column Options Normal Call back Statutory and Time travelled Repeat steps 2 to 3 for each employee who worked on the job Feb 03Rev 0 2 2 22 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL The Equipment Tab Enter the equipment and the number of hours that each piece of equipment used on the job To enter information into the Equipment Tab MMIS Main Screen MMIS Manage MDWR To open the Equipment Tab click left mouse button Enter the Equipment Class Code and the hours in the appropriate columns for each piece of equipment used When entering the Equipment Code the Class will automatically set for the first class therefore you should verify that the class code is correct The Equipment Class defines the category that the equipment is placed in The Equipment Code is a unique identifying number for each piece of equipment To get a listing of available equipment Right mouse click on the Class or Code column to view a list of available equipment or use the F2 key to access the list of available equipment Feb 03Rev 0 2 2 23 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Please Enter Equipment Class 11 2 TON PICKUP 172 TON PICK UP 172 TON PICK UP 172 TON PICK UP PICKUP TRUCK Once the hours for each job have been entered the cost will be
74. ox when the project is complete 11 Set the PCA Status box to O open or C closed 12 Save the record by pressing the Save button or press F6 m cud moo uo INA Feb 03Rev 2 0 8 19 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL NOTE Setting a Default RC for the project causes all patrol and crew work on that project to be charged to the project RC If the Default RC field is left blank all project costs will be charged to the RC for the patrol or crew when entering jobs 8 2 15 The Vendor Table The Vendor table lists the Vendors in MMIS Vendors are obtained from the government s list of Active Vendors of Record The Vendor table is imported from the Ontario Government s financial system 8 2 16 The Vendor Table in AMC Areas The MTO MMIS Coordinator will maintain the Supervisors list in the Vendor table This identifies the contractors staff who will use MMIS and Review jobs for the Data Promotion Process This information is required to complete the Area Contract table To set up the Supervisors list 1 Select the appropriate vendor from the Search tab and double click with the left mouse to move to the Detail tab 2 Click in an empty line in the Name column with the left mouse button 3 Right click with the mouse to see a list of available supervisors 4 Select the appropriate individual and click on the Ok button with the left mouse button 5 Save the record by pressing the Save button or p
75. ports Queries Admin Windows Help Inflation Figure 8 1 Feb 03Rev 2 0 8 3 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 0 Tables in MMIS Each table is described in this section 8 2 1 AMC Contract Table f MMIS Main Screen MMIS Table Maintenance Area Contract ES Eile Edit Manage Record Reports Queries Admin windows Help e x Region mS District m Arma ConractNo Description 0 Vendor Code y Sequence Vendor Name Active Patrols Supervisors Not Assigned Assigned Press Fa HEiDRIBO 55 TRAINING Figure 8 2 This table is administered by the MTO District s MMIS Coordinator The AMC contract table sets up an AMC contract in order to give the contractors access to MMIS The assigned patrols and supervisors for an area maintenance contract are set up in this table AMC supervisors need to be identified so they can access the system to review jobs To update or add new contracts to this table 1 Click the New button on the button bar to create a new contract or select the Detail tab to edit an existing contract Confirm that the default Region and District are correct Enter the Contract Number Enter a text Description of the contract Enter the Vendor Code Vendor Sequence Number Check the Active check box e This box tells the system that the information is cur
76. ps have been developed to ensure that the needs of all users are met When you enter information in the system you can create reports by printing one of the Standard Reports that are available in MMIS or by performing a Query where you set your own preferences on the information 1 1 1 Data Promotion To ensure that the information in the system is accurate a Data Promotion process has been put in place This allows information to be checked and corrected before it becomes part of the MMIS database Clients may then use the information with reliability and confidence 1 1 2 MMIS Map Each chapter in this manual explains a specific part of the system as shown below Topics Where to get the Information To get connected and set your system Start At 1 0 0 Getting Started preferences To enter Jobs into MMIS Start At 2 0 0 Entering a Job in MMIS To search for existing information Start At 3 0 0 Searching for Information in MMIS To understand the History Tab Start At 4 0 0 The History Tab To understand the Data Promotion process Start At 5 0 0 Data Promotion in MMIS To run a Standard Report Start At 6 0 0 Reports in MMIS To create or use a Custom or Standard Start At 7 0 0 Queries in MMIS Query To enter or update Table information Start At 8 0 0 Tables In MMIS To use the Bare Pavement module Start At 9 0 0 The Bare Pavement Module Feb 03Rev 0 2 1 1 MAINTENANCE MANAGEMENT INF
77. reen MMIS Manage Jobs Figure 2 10 Selecting the correct unit of measure UoM The system then populates the rate from the vendor equipment table If any information in this table is not correct please contact your MMIS coordinator Enter the quantity corresponding to this UoM in the Amt field The cost is calculated by the system Relevant information may be entered in the remarks field Feb 03Rev 0 2 2 13 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL M DUMPHY 0 BOX 211 E OLMSTEAD GENERAL DE Figure 2 11 Adding Vendor Equipment Vendor equipment not appearing in the equipment list or vendor equipment requiring more than one UoM may be added To add a vendor click on the first empty Vendor Code field and type in the vendor code Or To display a list of valid vendor codes click the right mouse button or use the F2 key A window will appear enter the first letter s of the vendor s name right mouse click on the OK button and a list of Vendors starting with the first letter s will appear Choose the Vendor then either double click the right mouse button or right mouse click on the OK button Feb 03Rev 0 2 2 14 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Entering Vendor Equipment 1 Click on the first empty cell in the Equipment Code column and enter the Equipment Code To display a list of valid Equipment Codes click the right mouse but
78. rently active and data can be entered against this contract ew Un des I9 Feb 03Rev 2 0 8 4 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 Select the Patrols tab and select the patrols that are located within the AMC contract by moving them from the Not Assigned box to the Assigned Box 8 Select the Supervisors tab and select the supervisors for the contract by moving them from the Not Assigned box to the Assigned Box e These individuals will have access to MMIS data for their contract and will Review jobs in the Data Promotion Process 9 Save by clicking on Save on the button bar or by pressing F6 NOTE MMIS Coordinators must set a contract to Inactive immediately after a contract is completed or terminated 8 2 1 PATROL Contract Table Search Detail stor Region SOUTHWEST 71 Resp Centre District M Pay Rate Patrol Type Active Patrol Patrol Code Patrol Description Highways Employees Equipment Hired Equipment __ Hwy Code Highway Description _ Highway Class Press F1 For Help J lt 03 53 TRAINING 8i Figure 8 3 Feb 03Rev 2 0 8 5 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 2 The Equipment Class Table The Equipment Class defines the type of equipment e g gt Ton Pickup 6 Ton Rubber Tire Backhoe MMIS Main Screen MMIS Table Maintenance EQUIPMENT CLASS s e e slelv jf STATION WAGO
79. ress F6 NOTE If a name is not available then it has been selected by another contract or the user has not been issued an User ID by MTO Feb 03Rev 2 0 8 20 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 17 The Vendor Equipment Table This table is administered by the MMIS business administrator within the MTO Maintenance Office The MTO MMIS Coordinator will enter the rental rate for the equipment for their district To enter the Rate Search for the appropriate piece of equipment and double click on it with the left mouse button to move to the Detail tab Double click your home District in the District Choose the Unit Measure from the drop down menu and enter the Default Rate There can be several Unit Measures chosen with different Default Rates Save the record by pressing the Save button or press F6 2 3 4 5 MMIS Main Screen MMIS Table Maintenance VENDOR EQUIPMENT v JE Fe E eed Feb 03Rev 2 0 8 21 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 9 0 0 The Bare Pavement Module The Bare Pavement module tracks the highway maintenance program s winter performance measure The data 15 collected at the patrols recorded on paper forms and later entered into the system at the MTO district office Your MMIS user group will determine if you have access to the Bare Pavement module 9 0 1 Opening the Bare Pavement Module To open the Bare Pavemen
80. ries are explained in a separate chapter Queries in MMIS 7 0 0 Bee D ManagementRepor Admin Listings CIA LL Figure 6 27 Feb 03Rev 02 6 26 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 0 0 Queries in MMIS 7 1 0 Introduction Queries are custom reports that summarize MMIS data according to the criteria establish Queries are subdivided into two categories 1 Standard Queries These were carried over from DDIS and are available in MMIS for all users The Head Office Maintenance Office can create other standard queries on request The available standard queries are as follows Bare Pavement by Event Type Bare Pavement by Highway Patrol Bare Pavement by Patrol Highway Bare Pavement by Region District Patrol Equipment by Highway Equipment by Region District Patrol HEQ by Region District Patrol HEQ by Vendors Jobs by Operation Highway Jobs by Region District Patrol Project Summary Labour by Operation Labour by Region District Patrol Material By Patrol Material by Prefix RC Job Material by Region District Patrol Services by RC Services by Region District Patrol IQ occ Ax Dac pcr e 2 Custom Queries These are created by the user and can be saved for future use Custom queries are only available to the user who created them Feb 03Rev 2 0 7 1 MAINTENANCE MANAGEMENT INFORMATION SYS
81. rmats 1 The Text formation Saves the information as unformatted text 2 The CSV format Maintains all the column and number formatting of the original query This format is used when the exported data is used in a spreadsheet or database program Feb 03Rev 2 0 7 18 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 10 4 Saving the Export File To save the file 1 Click on the Save in box to choose a directory on the computer to store the file 2 Entera name in the File name box 3 Choose the File Type by selecting one of the options in the Save as type box 4 Click the Save Button Save in a MMIS DATA amp j File name Save as type csv Fils Cancel EE Figure 7 16 Feb 03Rev 2 0 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 7 10 5 Example of a Query Export Figure 7 17 shows the information was exported as a CSV file and saved as New Liskeard material patrol csv This file was opened using MS Excel X Microsoft Excel New liskeard material patrol 46 cs Elle Edit Insert Format Tools Data Window Help le xl Dc E SRY BROT O S rri aria 10 BZU amp Ez HBH 338 SAND SCREENED amp TREATED WINT rz Material Material Material Qty mmi 102 ASPHALT COLD MIX 769 46 7 2 TONN 103 ASPHALTS COLD PRE MIX 155 28 2 TONN 143 150MMX150MM SIGN POSTS 64 30 2 NUMB
82. rol Table The Patrol table contains a list of patrols within a district The MTO MMIS Coordinator maintains this table EU MMIS Main Screen MMIS Table Maintenance PATROL To set up a Patrol 1 Click the New button on the button bar to create a new patrol or select the Details tab to edit an existing patrol Confirm that the system has defaulted to your Region and District Select the Patrol Type by clicking on the drop down arrow and making a selection Enter the Patrol Code Enter the Patrol Description Enter the Responsibility Centre for the patrol Enter the Pay Rate for the patrol Set the patrol to active with the Active Patrol check box Select the Employees tab enter the Last Name First Name and check the Active Employee box if the employee currently works at the patrol This must be done for each employee on the patrol IUe CT UN qe en Feb 03Rev 2 0 8 15 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 10 Select the Highways tab and enter the Highway Code Highway Description and Highway Class This must be done for each highway within the patrol 11 Select the Equipment tab enter a list of frequently used equipment for the patrol 12 Select the Hired Equipment tab enter a list of frequently used hired equipment 13 Save the record by pressing the Save button or press F6 gt MMIS Main Screen MMIS Table Maintenance PATROL ef oeie elei v al Search NO
83. ry tab provides you with a log of changes that was made to the job record and is explained in 4 0 0 The History Tab Feb 03Rev 0 2 2 3 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 1 3 Starting Data Input To enter jobs 1 Select the Detail tab and then click on the new button This will only be apply if the preferences not set to activate the Detail tab first 2 Once selected the Job header screen will appear See Figure 2 2 3 Enter all job header information NOTE Grey Fields are READ ONLY Information that is incorrect should be reported to your MMIS Co Ordinator as soon as possible User Tip Any button that has letter with an underscore letter can be used as a key board function by using the Alt button and the underscore letter Feb 03Rev 0 2 2 4 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 1 4 The Job Header Entry The Job Header Entry screen is used throughout MMIS when inputting data Figure 2 3 The Home Location and Work Location The Home Location identifies who did the work e The Work Location defines where the work was performed The following information is entered for the Home Location and Work Location 1 Region 2 District 3 Patrol 4 Patrol Type Feb 03Rev 0 2 2 5 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 1 5 Entering the Date Enter the date on which the work was performed in the D
84. s set in the Query By Box and the Selected Groups The Filter information is not saved and will have to be set each time a saved query 15 used A Custom Query is only available to the person who created it A saved query can be found by performing a Search This is explained is section 7 4 0 Searching for Existing Queries Feb 03Rev 2 0 7 11 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL To save a query e Click the Save button on the Button Bar Or e Press F6 MMIS Main Screen MMIS Queries BEE File Edit Manage Record Reports Queries Admin Windows Help lej x Search Detail Query By Material 71 Query by operation and highway Filter Date from 2000 01 01 To 2000 01 03 C Period from Status 1 TERE h BADMIN TRAINING a Figure 7 9 7 8 0 Using the Query Display Table The Query Display Table is where Query Results are shown There is a tab in the query table for each of the Selected Groups The tabs are in the same order as the Selected Groups By double clicking on the desired row in the first column of the Query Display Table the details for the next tab are displayed This process is repeated to move to the next tab Once a tab has been activated it becomes available and be can moved between the avail
85. sary changes to the job When the changes have been made the user will save the job 3 The record will then have a status of Initiated and will follow the Data Promotion process Closed Reviewed and Accepted When you set the status of a job to Rejected provide a reason in the Update Reason dialog box that appears on your screen so that is clear to the person who will make the changes why the job was Rejected ZU MMIS Main Screen MMIS Manage Job Statuses ej J TRI fd es pr Initiated and Overdue E Rejected then Closed Reviewed e Figure 5 20 NOTE If you Reject jobs provide a reason in the Remarks box that will appear on your screen next to the status column before saving See 5 2 5 Rejected Jobs Feb 03Rev2 0 5 19 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 5 3 0 Typical Roles for the Promotion of Data The following tables represent typical roles for Data Promotion Each individual district may choose to assign these roles based on their own resources In an AMC Area Area Maintenance Contractor Initiate Close Review or Reject Jobs MTO Maintenance Coordinator Accept or Reject Jobs In an MO Area MTO MO Patrol Staff Initiate and Close Jobs MTO Maintenance Coordinator Review or Reject Jobs MTO Maintenance Superintendent Accept or Reject Jobs Feb 03Rev2 0 5 20 MAINTENANCE MANAGEMENT INFORMATIO
86. ssing F6 or by pressing the Save icon on the button bar ES MMIS Main Screen MMIS Manage Job Statuses Not Editable Rejected then Closed Reviewed 5 HEN SOUTHWEST E SOUTHWEST 2002 04 01 Te 2002 09 26 ps PS 12002 08 13 Figure 5 18 NOTE If you Reject jobs provide a reason in the Remarks box that will appear on your screen next to the Status Column before saving See 5 2 5 Rejected Jobs Feb 03Rev2 0 5 17 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Method 3 Updating Multiple Records The user can change the status of consecutive jobs in the table as follows 1 Click on the first job you wish to change in the Job ID column hold down the left mouse button and drag the mouse to the last job you wish to change At this point all these records will be highlighted in black 2 Click on the Reviewed or Rejected box under the button bar 3 Save the change by pressing F6 or by pressing the Save icon on the button bar MMIS Main Screen MMIS Manage Job Statuses Initiated and Overdue Rejected and Overdue Not Editable Rejected then Closed SOUTHWEST Figure 5 19 Feb 03Rev2 0 5 18 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 5 2 5 Rejected Jobs In MMIS a rejected job must be changed by the person who initiated the job or by the MTO District MMIS Coordinator To update the record 1 The user will make the neces
87. t on when using Manage Jobs The Activate Search Tab option will start you on the Search tab so you can begin searching for existing records The Activate Form Tab will start you on the Form tab so you can begin entering or editing jobs For more information on the Search tab see 3 0 0 Searching for Information in MMIS For more information on the Form tab see 2 2 0 The Form Tab 1 5 4 Background Colours If you check the Background Colours box your Search tab and Form tab will appear in a different colour under the Manage Jobs portion of the system This can be helpful in distinguishing between the Search and Form tabs 1 6 0 Changing Your Password To change your password Select the Change Password option under the File menu Enter your Old Password Enter your New Password Confirm your New Password Click on the Change button ope pups Change Password Old password New password i 7 Confirm new password Figure 1 10 Feb 03Rev 0 2 1 11 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 0 0 MMIS Data Entry Overview 2 0 1 Introduction There are 3 input screens in MMIS2 1 JOB SCREEN 2 HEW SCREEN 9 MDWR SCREEN The JOB Screen Allows input of all data labour material equipment services and hired equipment Each operation highway requires a separate job The MDWR Screen Allows input up to 8 jobs on one form except Hired Equipment dat
88. t window 1 Select Manage from the menu bar 2 Select Bare Pavement MMIS Main Screen Figure 9 1 Feb 03Rev2 0 9 1 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 9 1 0 The Bare Pavement Window 18 1 x Region BP ID District EventNo Blank indicates Create New Event Status Initiated Patrol Event Date Month Day Year Event Type M Continuous Entry Highway Highway Class All Time values expressed in terms of 24 hrs Event Beginning Y Y Y Y MM DD Time BP Lost Y Y Y e MM DD Time Event Ending Y Y MM DD Time Regained Y Y Y Y MM DD Time Comments wu Press F1 For Help Figure 9 2 The Bare Pavement window has three tabs The Search tab This screen is used to Search existing records and is explained in 3 0 0 Searching for Information in MMIS 2 The BP Entry tab Enter new information or edit existing records on this screen Shown in Figure 9 2 3 The History Tab This screen displays the changes to a record and is explained in 4 0 0 The History Tab Feb 03Rev2 0 9 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 9 2 0 The BP Entry Tab Region BP ID District AN Event No Blank indicates Create New Event Patrol BP Patrol 70 COOKSTOWN Status fr iitiated Event Date Month Day Year 2002 11 25 Event Type
89. tatus that the query will search If this field is left blank all job statuses will be used Filter options are not saved Information on Job Status is available in 5 0 0 Data Promotion in MMIS 7 7 2 Sorting A Query A Query built by choosing one or more groups from the Available Groups Box and moving them to the Selected Groups box The Query is sorted in descending order by the groups in the Selected Groups box Figure 7 7 shows that the order of the selected groups matches the order in which the tabs are displayed in the Query Display Table For more information on using this table see 7 8 0 Using the Query Display Table To select a group 1 Click on a group in the Available Groups box 2 Click on the Right Arrow button to move the group to the Selected Groups Box 3 Repeat this until you have the groups you require in the Selected Groups box NOTE The Left Arrow button will move a highlighted group from the Selected Groups box to the Available Groups box Feb 03Rev 2 0 7 9 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 28 Eile Edi Manage Record Reports Queries Admin Windows Help 18 x vj fo fete Search Detail Query By Material m Available Groups Selected Groups Query Name Material by operation and highway Prefix Filter RC Date from 2000 01 01 Te 2000 01 03 Prvt Code PCA C Period from Im zi 1 71 5i Job Status mmm Region
90. ted and Overdue Not Editable Rejected then Closed TI H m Boumwtsr Borwwest 200270470 2002709723 OWEN SOUND zi OWEN SOUND alle Feb 03Rev 0 2 3 3 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL To view the details of a specific job returned in the search table e Click on the line containing the job with the left mouse button and then click on the Ok button Or Double click with the left mouse button on the line containing the job MMIS Main Screen MMIS Manage Jobs eo del delim cdd md Initiated and Overdue Rejected and Overdue Not Editable Rejected then Closed SOUTHWEST SOUTHWEST uens s DWEN SOUND E ire il fing Ouscuce 01 Clavering 01 Clavering z Figure 3 4 shows all details of the job you have chosen Feb 03Rev 0 2 3 4 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL Feb 03Rev 0 2 3 5 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 4 0 0 The History Tab 4 0 1 Introduction The History tab provides detailed information on changes made to records This information includes who made the change when the change was made and the comments associated with the change History Tabs are located on the Jobs Screen The Bare Pavement Screen and on each of the Admin Table screens 4 1 0 Activating the History Tab The History tab will not be available appears in grey until the d
91. tem fills in the equipment Class Verify that the equipment class codes are correct To view a list of available equipment Right mouse click on the Class or Code column to view a list of available equipment or use the F2 key to access the list of available equipment Hint By entering the 5 digit Class you can click on the code column with the right mouse button and you will get a list of all the equipment for that class only Feb 03Rev 0 2 2 9 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL After the hours for the equipment has been entered the cost will be calculated based on the equipment cost in the Equipment Table The Equipment Table is explained in 8 2 2 The Equipment Class Table and 8 2 3 The Equipment Table 2 1 9 Entering Material Detail Enter the material that was used on the job To enter information into the Material tab e Left mouse click on the Material tab MMIS Main Screen MMIS Manage Jobs Figure 2 8 To enter material 1 Click on the first empty cell in the Code column to enter the material Code To see a list of materials click the right mouse button or press the F2 key Enter the Material Code the material description will appear in the Description column and the unit of measure will automatically appear in the Unit column 2 Enter the material quantity in the Qty column The material costs are based on the material rate set in the Material Table You can over ride the rate wi
92. terial cost for their district the MTO district MMIS Coordinator will 1 2 3 4 5 6 NOTE Check the Allow Override check box to allow the material cost to be Select a material from the Search tab Select the Detail tab Click on the Material Cost column for your district Enter the Material Cost Check the Allow Override check box to allow the material cost to be overwritten Save the record by pressing the Save button or press F6 overwritten with actual costs during data input 51 18 x MMIS Main Screen MMIS Table Maintenance MATERIAL ES File Edit Manage Record Reports Queries Admin Windows Help amp x e amp v A Search Detail Material Code 120 Material Lon ppke CONNECTICUT BARRIER COMPONENTS UM Code 52 Valid District Material Cost Allow Override Check All Uncheck h Hh MMis3 TRAINING NUM Press F1 For Help Figure 8 8 Feb 03Rev 2 0 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 2 8 The AMC Contractor Material Table To enter the Material Cost the AMC contractor will Select a material from the Search tab Select the Detail tab Click on the appropriate cell in the Material Cost column Enter the Material Cost Repeat steps 3 and 4 for each contract Save the record by pressing the Save button or press F6 Qu i pac paces M
93. th the actual material cost This is explained in 8 2 7 The Material Table 3 Repeat steps 1 and 2 for each material used Feb 03Rev 0 2 2 10 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 1 10 Entering Services Detail A Service is work that has been contracted out to a service provider This can include work contracted out by MTO or an AMC contractor To open the Services tab e Click on the Services tab with your left mouse button MMIS Main Screen IMMIS Manage Jobs Figure 2 9 To enter Services information 1 Click on the first empty cell in the Reference column and fill in the Reference field with the appropriate information 2 Inthe Service Type field select the appropriate option from the drop down arrow Feb 03Rev 0 2 2 11 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 3 Enter the Rate for the Service Type in the Rate field 4 Enter the quantity in the QTY field 5 Repeat steps 1 to 3 for each Service for the job The cost is calculated using on the Quantity and the Rate 2 1 11 Entering Hired Equipment Detail Hired equipment usage is recorded in the Hired Equipment window To open the Hired Equipment tab Click on the Hired Equipment tab with your left mouse button When entering a new job the names of all vendors in the Patrol list will appear in the table Feb 03Rev 0 2 2 12 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL MMIS Main Sc
94. ton or the press the F2 key Figure 2 12 2 Enter the number of hours the equipment was used in the Hours field The cost 1s calculated based on the Hours and Rate After selecting the equipment the system sets the Rate based on the Rate in the Vendor Equipment Table If any information in this table is not correct please contact your MMIS Coordinator User Tip For a job you can enter multiple pieces of equipment from one or more vendors Feb 03Rev 0 2 2 15 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 2 2 0 Saving Your Work Click on the Save icon in the tool bar or press F6 Save work often to reduce data loss When a new job is saved its status is automatically set to Initiated To change the Status to Closed 1 Select the Status box drop down arrow 2 Select Closed 3 Save the job by clicking on the Save button or press F6 on the keyboard 2 3 0 Setting the Status The Status field is used in the Data Promotion process to ensure the integrity of data in MMIS The five options are Initiated Closed Reviewed Accepted and Rejected The user s choices are based on their user group access in MMIS For a complete description of this process please read 5 0 0 Data Promotion in MMIS After you have completed all data input and have saved a job the system will set its status to Initiated When you are satisfied that an Initiated job is complete and correct you will then change
95. tration by MMIS Groups MTO MMIS GROUPS MTO Table Administration Groups MMIS 1 Cannot Change Tables MMIS 2 Patrol Access to Administer Employees in Patrol Table MMIS 3 District Access to Administer AMC Table Administer MTO Equipment Rates Administer MTO Material Rates Administer Patrol Table Administer MTO Labour Rates Administer PCA Table Administer Vendor Equipment Rates Administer Vendor Supervisors MMIS 4 Cannot Change Tables MMIS 5 Administer All MTO Tables AMC MMIS GROUPS AMC Table Administration Groups AMC 1 Cannot Change Tables AMC 2 Administer AMC Equipment Rates for a Contract Administer AMC Material Rates for a Contract Administer AMC Patrol Labour Rates and Employees for a Contract AMC 3 Administer AMC Equipment Rates for a Contract Administer AMC Material Rates for a Contract Administer AMC Patrol Labour Rates and Employees for a Contract Feb 03Rev 2 0 8 2 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 8 1 0 Opening a Table Screen To work with tables 1 Select Admin from the menu bar 2 Select the appropriate table to view or update 3 Upon entering a table screen you will be placed on the Search tab for that table a To update or view an existing table perform a Search then move to the Details tab or b To create a new table entry click on the New button MMIS Main Screen E File Edit Manage Record Re
96. unt where the expenditures will be allocated for the Job e To view a list of the available R C s right mouse click on the Responsibility Centre box or Press the F2 key on the keyboard Prefix Codes Prefix codes categorize maintenance operations To view a list of the available Prefix Codes right mouse click on the Prefix Code box or Press the F2 key on the keyboard Continuous Entry Continuous entry mode is on by defaulted This can be turned off in the Preferences Settings Operation Number Identifies what operation was performed e To view a list of the available operations right mouse click on the Operation Number box or Press the F2 key on the keyboard Highway Number Identifies what highway the operation took place e To view a list of the highways right mouse click on the Highway box or Press the F2 key on the keyboard Accomplishment Quantity Identifies the accomplishment quantities for a job Accomplishment units are based on the Operation number and automatically entered into the field next to the Accomplishment Quantity Type and Code The PCA Type options are Capital Project Project and Work Order The PCA Code is a unique number that identifies the project Feb 03 Rev 0 2 1 1 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL e Ifthe project has a specific Responsibility Centre RC the Responsibility Centre will change to reflect the RC of the project when the PCA Code is entered If t
97. vents District Patrol E vents Report 4 4 1of1 amp 75 Total 2 100 2 of 2 Fram Jan 01 2000 Ta Jul 27 2001 Ontario District Patrol Events Report DISTRICT OWEN SOUND Awerage Length Average Length Awerage Length Class Events ofan Event of TimeBarePaverren Lost of Timeto Regain Bare Pavemert Patrol 9 PATROL 1 2 15 23 13 9 PATROL 1B 2 15 23 13 4 15 23 13 Paral 3 PATROL Taal smm Figure 6 20 Feb 03Rev 02 6 20 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 4 Patrol Highway Events DIET Events Detailed Report 4 4 1of1 amp 75 Total 2 100 2 of 2 Patrol Highway Events Report erp Ontario s eon District OWEN SOUND Hignaay No of Average Length Average Length Average Length Events ofTimeBarePavenentLost of TimetoRegainBare Pavemet Highway Class ofan Event Patrol 9 PATROL 26 1B 2 15 24 14 400 1 2 15 23 13 sm Figure 6 21 Feb 03Rev 02 6 21 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS MANUAL 6 2 6 Management Report To be developed in the future 6 2 7 Admin Listing The Admin Listing prints the information that is contained within the MMIS Admin Tables MMIS Main Edi Men IwamEssu coo Figure 6 22 Feb 03Rev 02 6 22 MAINTENANCE MANAGEMENT INFORMATION SYSTEM USERS M

User's Manual Maintenance Management Information System

Contents

Download Pdf Manuals

Related Search

Related Contents