SQL Utility Storage - PBTBPU
The Position Budgeting (PB) SQL Utility Storage (PBTBPU) page is used to store any required data manipulation SQL statements required to perform accurate budgeting. The PBTBPU page is a "catch-all" page used to perform updates or deletes not otherwise accommodated by the PB system. This page may or may not be used. It depends on client data manipulation needs. Note that there is not a Model ID field on this page. The PBUTPU SQLs are model-independent.
Sequence#: Enter a unique integer-sequence number value.
Description: Enter detailed description. The description may be viewed when running the PB Update SQL (PBUTPU) utility, thus a detailed description is helpful in choosing the correct sequence.
Action: Choose the SQL Action. Options are "Delete From," and "Update."
Table: Choose the PB table to affect.
Global Run Order: This numeric field indicates the order in which sequences set up to run globally shall be processed. The lower the number the higher the precedence. E.g., number 1 will run first, number 2 second, etc.
Global Run Link ID: This field is used to group sequence numbers together for global processing. Sequence numbers that are to be run one after the other can be given the same Global Run Link ID value and be run consecutively by the "Run PBUPDATE SQL" utility. If this field is left blank, then the sequence may only be run individually.
If a code of POSTIMPORT is entered for any SQLs, then those SQLs will automatically be run after the import program has finished.
If a code of PRECDHOVRD is entered for any SQLs, then those SQLs will automatically be run just before the PBIMPSPT override records are processed.
If a code of POSTCALC is entered for any SQLs, then those SQLs will automatically be run after the calculation program has finished.
See Example SQL: Shows base or example SQLs.
Model: Enter the Model ID. Model IDs available are defined in the PB Setup (PBSTRQ) page.
Statement: Enter the desired SQL update or delete statement. The entered SQL will be checked for validity when saving the record unless multiple SQL statements are entered for the same sequence number.
Dynamic prompts can be incorporated into SQL statements. N1-N9 for Numeric and C1-C9 for Character. The only condition for using these prompts is that there is no blank space allowed. For instance, "N1?" NOT "N1 ?".
Notes: Notes about the entered PBTBPU record.
Copy Sequence#: Select the Sequence number to Copy. The lookup contains previously created Sequence #s.