There are 7 types of records in PeopleSoft.
SQL Table: A record that is actually built on database.
SQL View: PeopleSoft View is a query written specially to retrieve/modify data on the records and also view's are used to show transaction data on reports and much more.
Derived/Work: This record does not store any data. It is not a database object an hence cannot be built.
SubRecord: They are used to group fields together and inserted in to records. These are reusable objects. A Subrecord too is not a database object and hence does not store any data.
Dynamic View: These are essentially SQL statements executed on the fly by the PeopleSoft component processor. This is different to a regular PeopleSoft view which is a database view that needs to be built and exists in the PeopleSoft database.
Query View: This is selected to define the record definition as a view that is constructed using the PeopleSoft Query tool. Before you can create the view, PeopleSoft Application Designer prompts you to save the definition.
Temporary Table: They are used in Parallel processing and are used for improving performance of a process like Application Engine.
- SQL Table
- SQL View
- Derived/Work
- SubRecord
- Dynamic View
- Query View
- Temporary Table.
SQL Table: A record that is actually built on database.
SQL View: PeopleSoft View is a query written specially to retrieve/modify data on the records and also view's are used to show transaction data on reports and much more.
Derived/Work: This record does not store any data. It is not a database object an hence cannot be built.
SubRecord: They are used to group fields together and inserted in to records. These are reusable objects. A Subrecord too is not a database object and hence does not store any data.
Dynamic View: These are essentially SQL statements executed on the fly by the PeopleSoft component processor. This is different to a regular PeopleSoft view which is a database view that needs to be built and exists in the PeopleSoft database.
Query View: This is selected to define the record definition as a view that is constructed using the PeopleSoft Query tool. Before you can create the view, PeopleSoft Application Designer prompts you to save the definition.
Temporary Table: They are used in Parallel processing and are used for improving performance of a process like Application Engine.
No comments:
Post a Comment