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.

10. What is Security Information?

Tables holding Security Information.

11. What is Record Meta Data?

Tables holding Record Meta Data including fields, field type, indexes, and tablespace.

12. What are Query Tables?

Tables holding individual query Meta Data.

13. What is Project Meta Data?

Table holding PeopleTools project information (all objects in the project).

14. What is Process Scheduler Information?

Tables holding the process and job definitions along with information necessary to run a process.

15. What is Portal (Structure and Content)?

Tables holding portal content references and permission lists authorized.

16. What is PeopleCode Meta Data?

Tables holding PeopleCode Meta Data.

17. What is Page Meta Data?

Tables holding Page Meta Data.

18. What is Message Catalog?

Tables holding Message Catalog Entries.

19. What is Menu Meta Data?

Tables holding Menu Meta Data.

20. What is HTML & Image Meta Data?

Tables holding HTML and Image Meta Data.

21. What is File Layout Definitions?

Tables holding File Layout Segment and Field definitions.

22. What are the Field Values for Tools Tables?

Find field values for the following:
RECORD.FIELDNAME
PSPROJECTITEM.OBJECTTYPE
PSPROJECTITEM.UPGRADEACTION
PSPROJECTITEM.SOURCESTATUS
PSRECDEFN.RECTYPE
PSDBFIELD.FIELDTYPE
PSPNLFIELD.FIELDTYPE
PSSQLDEFN.SQLTYPE

23. What is Field Meta Data?

Tables holding PeopleTools Field information.

24. What is Component Meta Data?

Tables holding Component Meta Data.

25. What is Component Interface Meta Data?

Tables holding Component Interface Meta Data.

26. What is Change Control?

Tables holding PeopleTools project change history and current locks on Tools objects.

27. What is Application Engine Meta Data?

Tables holding Application Engine Meta Data for the AE, Section, Steps and SQL.

28. How to migrate roles from one database to another database?

A: Login to database through App Designer as a source database.
B: Click on upgrade tab and open the project which contains roles which you want to migrate.
C: Double click on Roles folder under the opened project.
D: Select Action as "Copy".
E: Go to Tools > Copy Project > To Database.....
F: Give database name (Target Database) to which you want to migrate roles.
G: Click on "OK"
H: Select "Roles" from different objects and copy that roles.
I: After completion of Copying, double click on Roles folder under the opened project and verify that "Done" checkbox should be checked.

29. How to store related field data into database?

It is not possible normaly. But u can write a people code by which u can insert the field data into the records.

30. Tell me how many sub pages, secondary pages can be created in one level?

Any no. of subpages can created and any no of secondary pages can created.
There is no restrictions.

31. What environments supported by People Tools tool set?

Peopletools: windows, Unix (Red Hat, SLES)
Database: Oracle, SqlServer, DB2
PIA: IE 5.0 or greater

33. How the output of a sql query be stored in a variable using peoplecode?

You can use SQLExec to do the same.
SQLExec("SELECT EMPLID FROM JOB",&Emplid);
The value of EMPLID gets stored in the variable &Emplid.

34. Explain the numbers of sub pages and secondary pages that can be created in one level?

Sub page:
Mainly use for sub records. We can place sub records in to sub page.
Secondary page:
It is used to enter additional data, rarely entered data & unimportant fields.
There can be any number of sub-pages but only one secondary page in a level. We can insert through push button or domodal function using peoplecode.

35. Tell me the benefits of set control field in record field properties?

Benefits of set control field:
If we specify one field as a set control field then we will retrieve data based on this when we are using prompt table. Based on this field only we can have valid prompt list at the time of prompt button clicking.