Common Tables Used in Application Development

Projects:

PSPROJECTDEFN   
This Table will allow you to search for any project that is in your database.


Records:

PSRECDEFN        
This table is used to find parent child relationships. 

PSKEYDEFN  
This table is used for finding indexes on records so that you can develop your programs with indexes in mind so that you can tune your program to run in the shortest time possible. 


Fields:

PSXLATITEM 
This record is used to find translate values for fields on pages, sometimes in trace files a variable value will be "n" so what you can do is query PSXLATITEM and you can easily find the value of the variable.

                                           
Pages:

PSPNLDEFN
This table will provide you with information about your Page Definition. 


Components:

PSPNLGRPDEFN   
This table will provide information about a Component Definition. 

PSPNLGROUP 
This table will give you all of the pages in a Component. 


Process Scheduler:

PSPRCSRQST 
This table will give you information about the run times and such information can be useful if you are trying to tune a process.

                                                  
Application Engine:


PSAEAPPLDEFN 
This table will give you information about an Application Engine. 

PSAEAPPLSTATE  
This table will give you the state records of Application Engines

PSAEAPPLTEMPTB 
This table will give you all of the temp tables for an application engine program. 


PeopleCode:

PSPCMPROG   
You can use this table to search peoplecode programs. 

PSPCMTXT   
You can use this table to search peoplecode text.


SQL Definitions:

PSSQLDEFN  
You can use this table to search a SQL Definition. 

PSSQLTEXTDEFN
You will use this table to search for SQL Text when looking for where long running SQL is called in peoplesoft programs. 


File Layout Definitions:

PSFLDDEFN        
You can use this table to get information about file layouts. 

PSFLDFIELDDEFN 
This table is used to find fields in file layouts.