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.
Hi all,
I would like a way to quickly determine (preferably through a DB query) who our supervisors are in Maximo.
Currently, I'm not sure that we designate them in a separate way from standard employees.
I know you can set supervisors for users through their user information, but is there a "best practice" location to store the type of employee (supervisor vs. standard, etc.)? Would the best place be a security group, or a field on the person record, etc. etc.
Thanks in advance for any help you can give!
--
Sean
The Person table has a 'supervisor' field on it. (Maximo 7.5.0.3 - available in previous 7 versions as well, I do not remember if it was on 6).
select personid, displayname from maximo.person
where personid in (
select supervisor from maximo.person)
will bring back all the supervisors.
Pat Morrow
pmorrow8@yahoo.com
________________________________
From: "Killeen, Sean J." <sean.killeen@jhuapl.edu>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Tuesday, November 6, 2012 8:29 AM
Subject: [MAXIMO List] Best way to specify supervisors for workflows?
Hi all,
I would like a way to quickly determine (preferably through a DB query) who our supervisors are in Maximo.
Currently, I'm not sure that we designate them in a separate way from standard employees.
I know you can set supervisors for users through their user information, but is there a "best practice" location to store the type of employee (supervisor vs. standard, etc.)? Would the best place be a security group, or a field on the person record, etc. etc.
Thanks in advance for any help you can give!
--
Sean
In Maximo 7.5 and maybe in earlier versions there is an Employee Type field located in the Person application. Out of the box this is Null domain but can be added too within domains EMPLOYEETYPE
There are many ways that you could identify someone as a supervisor. First i would define why is there a current need of knowing who is a supervisor..
If this information is needed on the work order then you could use the supervisor field in the Person, labor application and have that field cross over to the work order when the labor record is chosen.. This would allow you to see the employee working on the work order and the employees supervisor.
It might be as simple as to create a simple check box (Is Supervisor?) in the Labor or People application..
Define customization based off your business processes...
________________________________
From: "Killeen, Sean J." <sean.killeen@jhuapl.edu>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Tuesday, November 6, 2012 10:29 AM
Subject: [MAXIMO List] Best way to specify supervisors for workflows?
Hi all,
I would like a way to quickly determine (preferably through a DB query) who our supervisors are in Maximo.
Currently, I'm not sure that we designate them in a separate way from standard employees.
I know you can set supervisors for users through their user information, but is there a "best practice" location to store the type of employee (supervisor vs. standard, etc.)? Would the best place be a security group, or a field on the person record, etc. etc.
Thanks in advance for any help you can give!
--
Sean
In my utopian dream world, how I'd do it is:
I would have a Calendar for each worker.
For each shift in that person's Calendar, there would be a field to put a Supervisor (which would be a table domain for Person.PersonID)
But that's for me, at a college -- we have several student workers that work irregular schedules, and who are sometimes shared between supervisors for different shifts (e.g., Worker may work Monday afternoon for Mr. Jackson and Thursday night for Mr. Stevens).
Side note: I found the Person.Supervisor field to be painful. If a Person is listed as the Supervisor of another Person, and the Supervisor leaves your company, you can't set the Supervisor's Person record to INACTIVE until you have removed him/her from the Supervisor field on all Person records. And as I mentioned above, it's not always a one-to-one relationship from Worker to Supervisor (at least not for us), so having ONE field which can take ONE name wouldn't work (for us).
Travis Herron
--- In MAXIMO@yahoogroups.com, shannon sutton <shannonsuttondale@...> wrote:
>
> In Maximo 7.5 and maybe in earlier versions there is an Employee Type field located in the Person application. Out of the box this is Null domain but can be added too within domains EMPLOYEETYPE
>
> There are many ways that you could identify someone as a supervisor. First i would define why is there a current need of knowing who is a supervisor..Â
>
> If this information is needed on the work order then you could use the supervisor field in the Person, labor application and have that field cross over to the work order when the labor record is chosen.. This would allow you to see the employee working on the work order and the employees supervisor.
>
> It might be as simple as to create a simple check box (Is Supervisor?) in the Labor or People application..
>
> Define customization based off your business processes...
>
>
>
> ________________________________
> From: "Killeen, Sean J." <sean.killeen@...>
> To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> Sent: Tuesday, November 6, 2012 10:29 AM
> Subject: [MAXIMO List] Best way to specify supervisors for workflows?
>
>
> Â
> Hi all,
>
> I would like a way to quickly determine (preferably through a DB query) who our supervisors are in Maximo.
>
> Currently, I'm not sure that we designate them in a separate way from standard employees.
>
> I know you can set supervisors for users through their user information, but is there a "best practice" location to store the type of employee (supervisor vs. standard, etc.)? Would the best place be a security group, or a field on the person record, etc. etc.
>
> Thanks in advance for any help you can give!
>
> --
> Sean
>
>
>
>
>
>
>
>