Peoplesoft Template Definition Table
The selection determines how peoplesoft data archive manager will generate the where clause for the base table of the base object at runtime.
Peoplesoft template definition table. However youmust keep the delivered template variables unless you create yourown sql objects that are referenced on the configuration definition. Peoplesoft data archive manager uses peoplesoft query to define selection criteria from the base table of the base archive object for example archive all rows in jrnl header where business unit abc01. Often a times when working on something like a peoplesoft issue or a peoplesoft upgrade you feel the need to have a handly list of peoplesoft tables. Creatingor modifying notification template definitions.
Creating or modifying notification template definitions. You can insert multiple archive or. You can modifythe verbiage or create your own template definitions. Template variables are placeholders in the template that can be populated with data passed in with peoplecode.
The list mentioned in this post pertains to peopletools 8 53 release. Template definition has effective dated template files as a child object. Select from a list of queries defined in the template. This example illustrates the fields and controls on the report definition template page rtf template.
Psxptmplfieldef this table stores template file definition. The vat defaults setup page is a common page used to set up vat defaults for all peoplesoft applications that process vat transactions. On this page you can define accounting template defaults as applicable. Complete list of peoplesoft tables i could not find this else where and hence i decided to build one myself a complete list of peoplesoft tables.
Psxptmpldefn this table stores template including sub template definition for bi publisher. An archive template can contain multiple objects and multiple queries. Only queries of the type archive or restore can be defined in the archive template. However the important integration broker tables will continue to find favor and will remain in the list.
Here is the list of peoplesoft integration broker tables categorized as per their functions. Psxptmploutfmt this table stores the output formats for templates. The following table lists each available calculation type by source. You can find definitions for the fields and controls later on this page.