Hello Keith,
Do you really need the PersonID stored in the LabTrans database table or do you want to display it on the UI table in Labor Reporting and the Actuals / Labor sub-tab in WO Tracking?
If you just need to display it, you can easily expose it using a linked field with attributeid="LABOR.PersonID". Users can filter/query on a linked field. They just can sort by one.
If you do want to add a PersonID column to the LabTrans table, you should be able to use a CrossoverDomain on the LaborCode field to do so.
------------------------------
Julio Hernandez
Ergonare, Inc.
------------------------------
Original Message:
Sent: 10-12-2023 09:59
From: Keith Henderson
Subject: Add data to the LABORTRANS table from WORKORDER Actuals
Good Morning,
Thanks for information. However we cannot use the laborcode as the university assigned id because the laborcode is tied to a university clock/time code value that works its way all the way into our finance system. I have added an attribute to the LABORTRANS table to capture the university id, which is never greater than 8 characters. I'm just not sure how to populate the person id field value on the workorder once the labor record is selected.
This process was started by Aquitas but not completed (not Aquitas's fault) , they also stated this should have been setup differently from the beginning ( way before my time).
Can you provide a suggestion on how to make that work ? Thanks again you are always very helpful Christopher.
------------------------------
D Keith Henderson
University of Louisville Physical Plant
Original Message:
Sent: 10-11-2023 20:56
From: Christopher Winston
Subject: Add data to the LABORTRANS table from WORKORDER Actuals
The LABORCODE is what appears on the labtrans record. You have the university ID as the PERSONID. You need the LABORCODE to be the University ID. Maximo supports the LABORCODE and PERSONID being the same data as long as you check your configuration to confirm the fields are large enough; by default, they are not the same size.
LABORCODE defaults to 8 characters and PERSONID defaults to 30. As long as your University ID is not greater than 8 characters, then the default will work, but you may still want to enlarge it now to allow for future growth; database configuration is always easier when you have less data.
There is a video on resources here if you wish to explore.
------------------------------
Christopher Winston
Projetech Inc.
Original Message:
Sent: 10-11-2023 16:25
From: Keith Henderson
Subject: Add data to the LABORTRANS table from WORKORDER Actuals
Good Afternoon,
We/I'm trying to add a university issued ID from the Labor record to the LABTRANS table via the workorder Actuals. Unclear how to populate the university ID field on the LABTRANS record once the Labor code has been selected, which is where the university issued ID is stored. I feel this should be simple, somehow I think a relationship on the LABOR table is the key but not sure of the relationship required to make this happen. I have a link to a very quick video outlining the process.
labor.avi
| Google Docs | remove preview |
|
Thank you for any suggestions.
#WorkManagement
------------------------------
D Keith Henderson
University of Louisville Physical Plant
------------------------------