Global Hr For LTM - ERDs

Hi Ruma - this is an older post, so you probably already got what you needed, but I figured I'd add a couple of comments.

Unfortunately, there are no ERDs available, nor is there a tool to easily generate such documents as is provided on the S3 side. Once you've been working with it a while, it becomes a little easier, but it's not very intuitive.

Finding the relationships is a drag. Your best bet is to dig into $LAENVDIR/src folder and find the files relating to the business class you are working with.

For example, for the Employee BC, you'd want to go to $LAENVDIR/src//modules/hr/bl/ and look at Employee.busclass, Employee.dbmap, and Employee.keyfield as a start. By the way, within the modules, "bl" is "business logic" which includes actions, derived fields, etc; and "ui" is "user interface" which is more relating to screen fields and calls to the actions, etc.

I usually try to find the name of the relationship by looking at the Modified List Definition in Rich Client and identifying the relationship I think I'm looking for (they often, but not always, end with "Rel" such as "ActivePrimaryWorkAssignmentRel" on the Employee BC). I then look within the ../bl/.busclass to find the definition. Some of the LPL files are better documented than others. Of course, Employee isn't one of the good ones.

If you have a specific relationship you are looking for, I'd be happy to see if I can point you in the right direction, but that's more of a one-at-a-time sort of process.

Good Luck. It's a jungle out there in LTM land...

Do you have the relationship between candidate and employee?

If the relationships exist in the metadata in the database, you could use SchemaSpy which is a tool that has been very helpfull here. Generates html pages from the database. See my post from 4/5/2011 here https://www.lawsonguru.co...ft/3435/Default.aspx

Did you ever get this information? I am in need of the exact same thing.

The relationship between candidate and employee is the field "LINKEDEMPLOYEE" in the CANDIDATE table to the EMPLOYEE field in the EMPLOYEE table. (Also, HRORGANIZATION to HRORGANIZATION