• System CATALOG TABLES
• People Tools Tables
• Application Data Tables 

System Catalog Tables: System Catalog Tables stores physical attributes of the tables and VIEWS. Naming convention for these tables is SYS.

PeopleTools Tables: The OBJECTS that we develop using the People Tool Objects are saved in PeopleTools Tables. Naming convention for these tables prefixed with PS_. Once a field is created it would be stored in psfield definition table, once a record is created it would be stored in psrecdef. (Only definition/structure is stored)

Application Data Tables: stores the data, which is entered by the user through PeopleSoft application windows and pages. Naming convention for these tables is PS_.

Application Data Tables are divided into 2 types:

• Control Tables
• Transaction Tables

Control Tables: Define the company structure and processing rules.

Transaction Tables: These are tables used to record our day-to-day transactions, such as personal data about employees.

System Catalog Tables: System Catalog Tables stores physical attributes of the tables and views. Naming convention for these tables is SYS.

PeopleTools Tables: The objects that we develop using the People Tool Objects are saved in PeopleTools Tables. Naming convention for these tables prefixed with PS_. Once a field is created it would be stored in psfield definition table, once a record is created it would be stored in psrecdef. (Only definition/structure is stored)

Application Data Tables: stores the data, which is entered by the user through PeopleSoft application windows and pages. Naming convention for these tables is PS_.

Application Data Tables are divided into 2 types:

Control Tables: Define the company structure and processing rules.

Transaction Tables: These are tables used to record our day-to-day transactions, such as personal data about employees.