41⟩ What is User Profile & Security?
Tables holding User Profile information including Primary Permission lists, Roles, email addresses, etc.
Peoplesoft Tools
Home PeopleSoft Peoplesoft Tools
“PeopleSoft Tools job preparation guide for freshers and experienced candidates. Number of PeopleSoft Tools frequently asked questions(FAQs) asked in many interviews”
44 Peoplesoft Tools Questions And Answers
42⟩ What is Workflow?
Tables holding Workflow Meta Data for Business Processes, Activies, Events, and workflow items needing to be worked.
43⟩ What is XLAT - Translate values?
Psxlatitem:
Stores field translate values (PeopleSoft version 8.4 and above)
Xlattable:
Stores field translate values (PeopleSoft version prior to 8.4)
44⟩ How to taken care performance management in People Tools?
Indexing tables on the database side helps in batch processing a great deal. Analysing tables helps. If there is custom code, make sure the SQL queries used are written well with the use of proper keys and joins are correct as well.
