Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 290
	Members: 0
	Total: 290

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

S$ table for EMPLOYEECONTACT

1 Replies

1 Subscribed to this topic

45 Subscribed to this forum

Sort:

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

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.