PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/17/2016 2:57 PM by  Woozy
S$ table for EMPLOYEECONTACT
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
James Styles
IT
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
11/17/2016 2:11 PM

    For instance, the S$ table for EMPLOYEE is S$EMPL.  What is the S$ table for EMPLOYEECONTACT?

    Woozy
    Private
    Private
    Veteran Member
    (3469 points)
    Veteran Member
    Posts:701


    Send Message:

    --
    11/17/2016 2:57 PM
    EmployeeContact is S$EMCTD.

    This is based on the table prefix. You can either go to $LASRCDIR/{prodline}/modules/hr/bl/EmployeeContact.busclass and look at the line at the top that says "prefix is....",
    or you can open a form or something on that BC in Config Console or Personalization and click the "view base LPL" link.

    If you have SQL access, you can check the indexes for the EmployeeContact business class to find the prefix. For EmployeeContact the first index is EMCTDBYUNIQUEID.

    I hope this helps.
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    You are not authorized to post a reply.