This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Greetings Everyone,
Last January I posted a couple questions about Maximo 4.1
The company I work for has the latest version but still has not implemented it. I heard they a very close to a decision though.
I received a lot of help then and I need to ask a couple SQL/Maximo questions now.
Under the "Workorder" section in "Quick Reporting" There is a place to put the "Start Time" and Finish Time". When you populate these fields, Maximo calculates "Hours".
In the dbo.workorders table I found where those data were stored until 2006. The system was not used for a couple years then.
Now when I try to retrieve "Hours" associated to a work order that is newer than 2006 I get zeros for start time, finish time and hours.
When I bring up work orders in Maximo all the data is there.
Does anyone have any idea which table might contain that data?
Thanks
Glen Ray
You shoul do a query in the wplabor table for planing and in the labtrans
table for actual.
Hope this help.
On Tuesday, August 20, 2013, GlenR wrote:
> **
>
>
> Greetings Everyone,
>
> Last January I posted a couple questions about Maximo 4.1
> The company I work for has the latest version but still has not
> implemented it. I heard they a very close to a decision though.
>
> I received a lot of help then and I need to ask a couple SQL/Maximo
> questions now.
>
> Under the "Workorder" section in "Quick Reporting" There is a place to put
> the "Start Time" and Finish Time". When you populate these fields, Maximo
> calculates "Hours".
>
> In the dbo.workorders table I found where those data were stored until
> 2006. The system was not used for a couple years then.
>
> Now when I try to retrieve "Hours" associated to a work order that is
> newer than 2006 I get zeros for start time, finish time and hours.
>
> When I bring up work orders in Maximo all the data is there.
>
> Does anyone have any idea which table might contain that data?
>
> Thanks
> Glen Ray
>
>
>
--
__________
Sent from Gmail Mobile
Thanks Jun, That's exactly what I needed.
GR
--- In MAXIMO@yahoogroups.com, Juniko <juniko@...> wrote:
>
> You shoul do a query in the wplabor table for planing and in the labtrans
> table for actual.
> Hope this help.
>
> On Tuesday, August 20, 2013, GlenR wrote:
>
> > **
> >
> >
> > Greetings Everyone,
> >
> > Last January I posted a couple questions about Maximo 4.1
> > The company I work for has the latest version but still has not
> > implemented it. I heard they a very close to a decision though.
> >
> > I received a lot of help then and I need to ask a couple SQL/Maximo
> > questions now.
> >
> > Under the "Workorder" section in "Quick Reporting" There is a place to put
> > the "Start Time" and Finish Time". When you populate these fields, Maximo
> > calculates "Hours".
> >
> > In the dbo.workorders table I found where those data were stored until
> > 2006. The system was not used for a couple years then.
> >
> > Now when I try to retrieve "Hours" associated to a work order that is
> > newer than 2006 I get zeros for start time, finish time and hours.
> >
> > When I bring up work orders in Maximo all the data is there.
> >
> > Does anyone have any idea which table might contain that data?
> >
> > Thanks
> > Glen Ray
> >
> >
> >
>
>
> --
> __________
> Sent from Gmail Mobile
>
>
>
>