PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/22/2014 7:21 AM by  rebekxrunr
Global Hr For LTM - ERDs
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Ruma Malhotra
Private
Private
Veteran Member
(1092 points)
Veteran Member
Posts:412


Send Message:

--
08/18/2011 11:20 AM
    Does anybody know of any ERDs present for LTM especially global HR.

    Can anybody share how to get this information ?

    tia.
    Woozy
    Private
    Private
    Veteran Member
    (3490 points)
    Veteran Member
    Posts:708


    Send Message:

    --
    11/07/2011 4:24 PM
    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...
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    rebekxrunr
    Research Analyst
    Hillsborough Cty Schools
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    05/15/2013 2:31 PM
    Do you have the relationship between candidate and employee?
    Greg Moeller
    Private
    Private
    Veteran Member
    (4028 points)
    Veteran Member
    Posts:1434


    Send Message:

    --
    05/16/2013 9:16 AM
    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.com/Forums/tabid/96/aft/3435/Default.aspx
    Athens Regional
    HRIS Coordinator
    Athens Regional Health Services
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    08/29/2013 10:11 AM
    Did you ever get this information? I am in need of the exact same thing.
    rebekxrunr
    Research Analyst
    Hillsborough Cty Schools
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    01/22/2014 7:21 AM
    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
    You are not authorized to post a reply.