Forums
Human Capital Management
Infor Global HR (GHR)
S$ table for EMPLOYEECONTACT
1 Replies
1
Subscribed to this topic
45 Subscribed to this forum
:
Author
Messages
James Styles
New Member
Posts: 1
11/17/2016 7:11 PM
For instance, the S$ table for EMPLOYEE is S$EMPL. What is the S$ table for EMPLOYEECONTACT?
Woozy
Veteran Member
Posts: 709
11/17/2016 7:57 PM
Split
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.