Type Of Tables in PeopleSoft

In this post we discuss about the types of table available in ERP like PeopleSoft.

Below mentioned are the types of tables in PeopleSoft.

1) Base Table
2) Control Table
3) Views
4) Reporting Table
5) Non-Table (Sub-Records)

Lets discuss each of them in few details:

1) Base Table A Base table hold's the real data that is not static. This tables store information of an employee and contain data of an employee. It can be mentioned as an Live table where data is changing continually. Base tables are not distinguished with a prefix or sufix.
Examples :- PS_PERSONAL_DATA, PS_JOB

2) Control Table In PeopleSoft Control tables are also called as lookups, prompt tables. This control tables holds short list of values. For example a table which holds all earning codes (Bonus, Overtime, Allowance, etc) is a control table and where all the earning details are stored is known as Base Table.
Examples :- PS_EARNINGS_TBL, PS_DEPT_TBL

3) Views Views are the results of an SQL Statmenet that combines and retrives data from more than one table. Views in PeopleSoft has a suffix _VW. Views are linked directly to original tables i.e. Base table or control table.
Examples :- PS_AVT_DEPT_VW, PS_EARNING_CLR_VW

4) Reporting Tables PeopleSoft created three tables that contain the most-often-used human resources fields. This tables are similar like Views but are not dynamic since they hold specific data in one single table and are categorized under reporting tables.
Examples :- PS_EMPLOYEES, PS_BEN_PER_DATA, & PS_BEN_PLAN_DATA

5) Non-Table (Sub-Records) Sub-Record in PeopleSoft are kind of small tables that hold the definition of group of fields of some records.
Example :- ADDRESS_SBR