TRAINING (PS-2) - Different table types (Catalog) and databases in PeopleSoft

Different Table Types (Catalog) in PeopleSoft Application Database: 

1.) System Catalog Tables > Keep track of all of the objects that reside in the database instance. > Are created by and owned by the RDBMS. > Are often described as system metadata. > For example DBA_Tables & V$Views 2.) PeopleTools Metadata Tables > Define the structure of all object definitions (such as records, fields, pages, PeopleCode, and security etc) that make up an application. > Use the same table structure for all applications (HCM, CRM, ELM, PA etc). > Contain data that is added and updated only when the application is installed, or when using development tools such as PeopleSoft Application Designer or Data Mover. > Generally prefixed with PS keyword. > For example PSSTATUS, PSOPRDEFN etc. 3.) PeopleSoft application data tables > Application data tables store data entered through a PeopleSoft online application (offline till PeopleTools 8.22). > The specific tables and their structures vary by application (HCM, CRM, ELM, PA etc).  > Application data tables contain day to day transactional data entered and updated by users. > They are empty prior to data entry (except the demo databases). > Generally prefixed with PS_ keyword. > For example PS_JOB, PS_PERSON etc.

Different Type of PS Databases: Based on Usage:

System: The System database has no company specific data, and can be used to load your data and begin development of your production database.

Demo: The Demo database contains data for a sample company, and can be used immediately for demonstration, for testing, and as a development reference.

Tools Only: Only System and People Tools tables.