Go to previous topic
Go to next topic
Last Post 01/22/2014 7:21 AM by  rebekxrunr
Global Hr For LTM - ERDs
 5 Replies
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
    (3493 points)
    Veteran Member
    Posts:709


    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
    (4035 points)
    Veteran Member
    Posts:1439


    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


    ---