Top of Proposals

Index

Table of Contents

Feedback

Proposal Outcomes

Table of Contents

• Overview
• Examples

Overview

The System Outcome for a Proposal Instance is determined at the time of submission, resubmission and when PAAJ1110 is run, post completion of workflow. System outcome values can be:

• NEW, NEW_V, UPD_V or NO-TRF-UN for unit proposals
• NEW-CRS, NEW-CRS-V,UPD-CRS-V, CRS-POC or NO-TRF-CRS for course proposals
• NEW-US, NEW-US-V, UPD-US-V or NO-TRF-UN for unit set proposals
• NEW-USRDEF for user-defined proposals.

The outcome of the proposal is determined at the item level and is affected by:

• The Selection Option selected to initiate the proposal. This is recorded in PAAW0200 and may be for 'New Proposal' or 'Update Proposal'.
• The System Proposal Outcome for each of the items in the proposal, defined for each item in the proposal type of the proposal. (System Proposal Outcomes as above).

The Selection Option selected for a proposal affects how data in the proposal is treated but doesn't necessarily prescribe the outcome of a proposal.

The outcome of the proposal may affect the Review Category assigned to the proposal and will affect how the proposal is treated by the Proposal Transfer jobs CRSJ6000, CRSJ6010 and CRSJ6020.

The outcome of a unit proposal will be set following the rules below:

• If any items have a status of NEW the proposal will create a new unit from from the proposal.
• If any item has a status of NEW_V, and no item has a status of NEW, the proposal wil create a new version of the unit.
• If any item has a status of UPD_V and no item has a status of NEW or NEW_V, the proposal will update the existing version of the unit set.
• If any item has a status of NO-TRF-UN and no item has a status of NEW, NEW_V or UPD_V the proposal will not be transferred.

Unit set and course proposals are treated in a similar manner.

Indicators in the PROPOSAL_INSTANCE_ELEMENT (PIE) and PROPOSAL_INSTANCE_ITEM (PII) tables indicate what is happening in the proposal instance.

Return to Top

Examples

In each case below the ranking of changes is NEW-CRS > NEW-CRS-V > UPD-CRS-V.

a) Proposal Type consisting of two elements - Course Details and Course Award
Selection Option > NEW_PROPOSAL_IND = Y
If the selection option is for a New Proposal, then all elements are regarded as 'INSERT's even when you are basing the proposal on an existing curriculum item.

The PROPOSAL_INSTANCE_ELEMENT.INSERT_IND indicator is always Y.
The PROPOSAL_INSTANCE_ELEMENT.DELETE_IND indicator is always N
The PROPOSAL_INSTANCE_ITEM.UPDATE_IND is always N.
The item in the Course Detail and Course Award elements with the highest ranked outcome will determine the outcome of the proposal.

b) Proposal Type with a single element – Field of Study
Selection Option > UPDATE_PROPOSAL_IND = Y

A new FOS is defined in a course proposal.
The PROPOSAL_INSTANCE_ELEMENT.INSERT_IND = Y.
The PROPOSAL_INSTANCE_ELEMENT.DELETE_IND = N
The PROPOSAL_INSTANCE_ITEM.UPDATE_IND = N.
The item in the FOS element with the highest ranked outcome will determine the outcome of the proposal.

c) Proposal Type with a single element – Course Details
Selection Option > UPDATE_PROPOSAL_IND = Y

'Course Title' item is changed
PROPOSAL_INSTANCE_ELEMENT.INSERT_IND = N.
PROPOSAL_INSTANCE_ELEMENT.DELETE_IND = N
PROPOSAL_INSTANCE_ITEM.UPDATE_IND = Y.
Updated item has Outcome = NEW-CRS.
Outcome of the proposal = NEW-CRS.

d) Proposal Type with a single element – Course Details
Selection Option > UPDATE_PROPOSAL_IND = Y'
Short Title' item is changed
PROPOSAL_INSTANCE_ELEMENT.INSERT_IND = N.
PROPOSAL_INSTANCE_ELEMENT.DELETE_IND = N
PROPOSAL_INSTANCE_ITEM.UPDATE_IND = Y.
Updated item has Outcome = NEW-CRS-V.
Outcome of the proposal = NEW-CRS-V.

e) Proposal Type with a single element – Course Details
Selection Option > UPDATE_PROPOSAL_IND = Y
'Course Title' and 'Short Title' item are changed
PROPOSAL_INSTANCE_ELEMENT.INSERT_IND = N.
PROPOSAL_INSTANCE_ELEMENT.DELETE_IND = N
PROPOSAL_INSTANCE_ITEM.UPDATE_IND = Y for both.
Course Title Outcome = NEW-CRS and Short Title item has Outcome =NEW-CRS-V.
Outcome of the proposal = NEW-CRS.

f) Proposal Type with a single element – Alternative Exits
Selection Option > UPDATE_PROPOSAL_IND = Y
An Alternative Exit course is to be deleted
PROPOSAL_INSTANCE_ELEMENT.INSERT_IND = N.
PROPOSAL_INSTANCE_ELEMENT.DELETE_IND = Y
PROPOSAL_INSTANCE_ITEM.UPDATE_IND = N.
The Alternative Exit item with the highest ranked outcome will determine the proposal outcome.

g) Proposal Type includes all the elements above
• Course Details
• Course Award
• FOS
Selection option > NEW_PROPOSAL_IND = Y and the proposal is based on an existing course.

An item in Course Details is updated and this item has an outcome of UPD-CRS-V.
A new course award record is added. (items in this record are all NEW-CRS).
A FOS record is updated (the updated item in this record has an outcome of NEW-CRS-V).
Because the Selection option is for a new course, all elements are regarded as inserts.
The outcome of the proposal instance will be the highest ranked outcome of items in elements for this proposal. Although the updated item in the Course Details element is NEW-CRS-V, there is another item in that element with an outcome of NEW-CRS. Because of this the outcome of the proposal instance is NEW-CRS.

h) Proposal Type includes all the elements above
• Course Details
• Course Award
• FOS
Selection option > UPDATE_PROPOSAL_IND = Y and the proposal is based on an existing course.

An item in Course Details is updated and this item has an outcome of UPD-CRS-V.
A new course award record is added. (items in this record are all NEW-CRS-V).
A FOS record is updated (the updated item in this record has an outcome of NEW-CRS-V).
Because the Selection option is for an updated course, all elements are not automatically regarded as inserts.
The outcome of the proposal instance will be the highest ranked outcome of items in elements for this proposal. In this case that is NEW-CRS-V.

For the Course Details element:
PROPOSAL_INSTANCE_ELEMENT.INSERT_IND = N.
PROPOSAL_INSTANCE_ELEMENT.DELETE_IND = N
PROPOSAL_INSTANCE_ITEM.UPDATE_IND = Y.
The item being updated has an outcome = UPD-CRS-V.

For the Course Award element:
PROPOSAL_INSTANCE_ELEMENT.INSERT_IND = Y.
PROPOSAL_INSTANCE_ELEMENT.DELETE_IND = N
PROPOSAL_INSTANCE_ITEM.UPDATE_IND = N.
The highest ranking item in the Course Award element is NEW-CRS.

For the FOS element:
PROPOSAL_INSTANCE_ELEMENT.INSERT_IND = N.
PROPOSAL_INSTANCE_ELEMENT.DELETE_IND = Y
PROPOSAL_INSTANCE_ITEM.UPDATE_IND = N.
The highest ranking item in the FOS element is NEW-CRS.
Because there are items in the inserted Course Award and FOS elements that have an outcome of NEW-CRS, the outcome of this proposal instance is NEW-CRS.

Return to Top

Page last modified: 1 June, 2012 1:27 PM

History Information: