| Record Type | Type Description | Comment |
|---|
| 0 | SQL Table | The record will be built as a table and there will be a corresponding row on DBA_TABLES. |
| 1 | SQL View | The record will be built as a view and there will be a corresponding row on DBA_VIEWS. |
| 2 | Derived/Work | This provides working storage in the component. It does not correspond to any database object. |
| 3 | Sub-Record | This is a group of columns or other sub-records that is referenced by other records. It does not correspond to a database object. |
| 4 | Not Used | |
| 5 | Dynamic View | This does not correspond to any database object. A database view is a query executed by the database; this is a query executed by PeopleTools to populate a page. |
| 6 | Query View | The record will also be built as a database view. The difference between this and record type 2 is that the query is defined via the PeopleTools Query utility, rather than with free format text in the Application Designer. |
| 7 | Temporary Table | This record type is new in PeopleTools 8. One temporary table record can correspond to a number of database tables. They are used by the Application Engine to temporarily hold data. If multiple instances of the same Application Engine process execute simultaneously, each instance can use a different temporary table. The number of instances of the table is defined both globally and on the Application Engine program. If, for example, there are 10 instances (including shared instances) of record XXX, there will be 11 tables, PS_XXX, PS_XXX_1, through PS_XXX_10. |