| Top of Proposals | Index | Table of Contents | Feedback | |
This job updates the Display Value and Display Description fields as displayed for Proposal Items in instances of Proposals.
For each proposal instance affected, the SQL statements which populate the data items for that instance will be re-run, and the Display Description and Display Value fields will be updated as defined.
Only items from Proposal Instances with a System Transfer Status of PENDING, READY or NOT-APPLIC will be updated.
A user updating such a proposal will then see the description value displayed such as shown below:
In this case the 'BACHELOR'S PASS' text is derived from the SQL Query for a Course Type of 10. This gives the user additional information about this Course Type.
The SQL statement for the item is recorded in the Display SQL Statement field in PAAW0300.
Note: This query will only be run if the Display Field Description check box is selected in that same page.
The proposals affected by this job can be limited by selecting an appropriate set of parameters.
Parameter field available are:
Multiple parameters and check boxes may be selected for this job. Where multiple parameters are selected, the user must be sure that they are not selecting impossible combinations that will result in no updates.
All proposal Status check boxes are unselected by default.
e.g. Proposal Type = NEW_COURSE and Status DRAFT is selected.
> All Proposals of this Proposal Type with a status of DRAFT will have their descriptions updated .
e.g. System Proposal Type = COURSE and Statuses DRAFT and APPROVAL-PENDING is selected.
> All Course Proposals with a status of DRAFT or APPROVAL-PENDING will have their descriptions updated.
e.g. Proposal Type = NEW_COURSE, System Proposal Item Code = ADMCAT and Status DRAFT is selected.
> All Proposals of this Proposal Type with a status of DRAFT will have their Admission Category descriptions updated.
e.g. System Proposal Type = COURSE, System Proposal Item Code = AIA_UC (unit class) and Status DRAFT is selected.
>No descriptions will be updated because this item will not occur in Course proposals.
At least one of the status check boxes must be selected to run the job.
The total number of records selected, the total number of records failed and the total number of records updated are returned in the run log with an S_LOG_TYPE of PII-DISP.
The key for the S_LOG record created is:
pii.proposal_id || '|' || pii.pie_sequence_number || '|' || pii.sequence_number || '|' || pii.proposal_type || '|' || pii.proposal_element_cd || '|' || pii.proposal_item_cd || '|' || COALESCE (PII.CHARACTER_FIELD, PII.NUMBER_FIELD, PII.DATE_VALUE)
This job should be run in Schedule Mode. It is recommended that this job be scheduled to run each night in order to provide regular updates for proposals users.
Last modified on 9 August, 2012 4:38 PM
History Information
| Release Version | Project | Change to Document |
| 15.0.0.2 & 15.1 | 1844 - CAPS Enhancements 2012 | New help page |