Topic
  • 1 reply
  • Latest Post - ‏2014-01-15T00:54:25Z by swkim90049
lakshmi_maximo
lakshmi_maximo
28 Posts

Pinned topic Difference between PM Extend Date and PM Extend Dates with History Report

‏2010-08-03T19:56:53Z |
Hello friends,

I would like to know the difference between PM Extend Date and PM Extend Dates with History report.

PM Extend Date report lists all PMs with extend date and pluscpmextdate.history=0.
***************************************************************************************************
Here is the query used in Actuate:

select pm.pmnum, pm.description, pm.assetnum, pm.location,
pluscpmextdate.masterpmnum, pluscpmextdate.extdate, pluscpmextdate.prevextdate,
pluscpmextdate.comments, pluscpmextdate.changeby, pluscpmextdate.changedate
from MAXIMO.pm, MAXIMO.pluscpmextdate
where pm.pmnum=pluscpmextdate.pmnum
and pm.siteid=pluscpmextdate.siteid
and pluscpmextdate.history=0
and pm.extdate is not null
and pm.worktype in (select value from synonymdomain where domainid='WORKTYPE' and maxvalue in ('CAL'))
and 1=1
order by pluscpmextdate.extdate desc

PM Extend Dates with History report lists all PMs with extend date and pluscpmextdate.history=1:
************************************************************************************************

Here is the query used in Actuate

select distinct pm.pmnum, pm.description, pm.assetnum, pm.location
from MAXIMO.pm, MAXIMO.pluscpmextdate
where pm.pmnum=pluscpmextdate.pmnum
and pm.siteid=pluscpmextdate.siteid
and pm.extdate is not null
and pm.worktype in (select value from synonymdomain where domainid='WORKTYPE' and maxvalue in ('CAL'))
and 1=1
order by pm.pmnum

I do not have a clue on when the pluscpmextdate.history is set to 1. I tried multiple options of setting Extended Date, but did not see the history flag set to 1.

Please advice!!

Thanks!!
  • swkim90049
    swkim90049
    384 Posts

    Re: Difference between PM Extend Date and PM Extend Dates with History Report

    ‏2014-01-15T00:54:25Z  

    http://publib.boulder.ibm.com/tividd/td/ITMICM/GC23-8817-00/en_US/PDF/64_mx_cal_ugadd.pdf

     

    PMs with Extended Dates (Preventive Maintenance)-List of PMs where the 
    date of the PM has been extended.

     

    PMs with Extended Dates with History (Preventive Maintenance)-List of 
    PMs where the date of the PM has been extended along with the historical 
    data of the date extension