1. 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.

2. What is application package?

Application package is a container for application subpackages and application classes, which will provide a hierarchical structure to your PeopleCode programs and help you extend the common functionality of existing PeopleCode classes from one application to another.

3. Explain TREE MANAGER?

PSTREEDEFN:
Tree Definition and Properties

PSTREENODE:
Folders and records (nodes of the tree/tree node type)

PSTREEBRANCH:
Tree Branch

PSTREELEAF:
Tree Leaf

PSTREELEVEL:
Tree Level

4. 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)

5. What is XLAT - Translate Values?

Tables holding Translate Values for individual fields.

6. What is Workflow?

Tables holding Workflow Meta Data for Business Processes, Activies, Events, and workflow items needing to be worked.

7. What is User Profile & Security?

Tables holding User Profile information including Primary Permission lists, Roles, email addresses, etc.

8. What is Tree Manager?

Tables holding Tree Manager Meta Data.

9. What is SQL Definitions?

Tables holding SQL Object definitions.