Purpose

To record Advanced Standing data in an Admission Course Application Instance (ACAI) context

It is here that Admission Course Application Instance (ACAI) Advanced Standing records can be created, updated, deleted, and when pre-enrolled transferred to a SCA context - Create Advanced Standing Details (ADVF4200). This function mirrors the Create Advanced Standing Details form. The user can, if data exists, switch between the two forms via a navigation button. Lamps indicate if data exists in both forms.

When defining an Advanced Standing the user can select from Granting Statuses (Granting Status) of: APPROVED, ASSESSING, CANCELLED, DECLINED, EXPIRED, GRANTED, NOT-APPRVD and REVOKED. The user can not select EXPIRED when creating or updating an Advanced Standing.

Other than a Granting Status of EXPIRED, Unit and Unit Level Advanced Standing records can be created with any Granting Status.

For further insights on the different Granting Status and Dates, see below.

For insights on Advanced Standing see 'Understanding Advanced Standing (ADVINTR3)'. For a glossary of terms, see 'Advanced Standing Glossary (ADVINTR2)'..

This form can be accessed from Direct Admissions Course (ADMF3240), Create Advanced Standing Details (ADVF4200) or the main menu.

The Person block contains:

• Person ID
• Sex
• Date Of Birth

Button

• Find Person (ADMF1211)

The Admission Course Application Instance Advanced Standing block contains:

• Sector (Pop)
• Commence Period
• Course (LOV)
• Version
• Location
• Attendance Mode
• Attendance Type
• Total Approved CP
• CH
• Total Granted CP
• CH
• Percentage of Course Requirements Granted
• Major Exemption Institution (LOV)
• Government Credit Basis (LOV)
• VET Field of Education (LOV)
• VET Level Detail (LOV)
• Government VET Provider (LOV)

Buttons

• SCA Advanced Standing (ADVF4200)
• Unit Details (Overlay)
  • Admission Course Application Instance Advanced Standing block contains:
    • Person ID
    • Sex
    • Date of Birth
    • Commencement Period
    • Course Version
    • Location
    • Attendance Mode
    • Attendance Type
  • ACAI Advanced Standing Unit block contains:
    • Unit Code (LOV)
    • Version
    • Adv Stnd Type (Pop)
    • Percentage
    • Credit Points
    • Institution (LOV)
    • Granting Status (Pop)
    • Institution Name
      • Admin Details Tab
        • Unit Title
        • Created
        • Approved
        • Granted
        • Cancelled
        • Authorised By
        • Crs Grouped check box
        • Not Transferable check box
        • Unit Level Details button
        • Back button
      • Basis Details Tab
        • Course Type (LOV)
        • Advanced Standing Source (LOV)
        • Last Year of Enrolment
        • Completed check box
        • Unit Level Details button
        • Back button
      • Origin Course Tab
        • Origin Course Code (LOV)
        • Title
        • Course Type
        • Yr Last Enrolled
        • Completed check box
        • Course Type Description
        • Unit Level Details button
        • Back button
      • Origin Unit Tab
        • Origin Unit Code (LOV)
        • Title
        • Credit Points
        • Contact Hours
        • Year Completed
        • Unit Level Details button
        • Back button
      • Alternate Unit Tab
        • Alternate Unit (LOV)
        • Version
        • Achievable Credit Pts
        • Supervised Contact Hrs
        • Optional check box
        • Unit Level Details button
        • Back button
      • Comments Tab
        • General
        • Not Approved
        • Declined
        • Unit Level Details button
        • Back button
      • Status Dates Tab
        • Assessing
        • Approved
        • Granted
        • Not Approved
        • Cancelled
        • Declined
        • Revoked
        • Expiry
        • Unit Level Details button
        • Back button
  • Unit Level Details Button
  • Back button
• Unit Level Details (Overlay)
  • Admission Course Application Instance Advanced Standing block contains:
    • Person ID
    • Sex
    • Date of Birth
    • Course Version
    • Course Version
    • Location
    • Attendance Mode
    • Attendance Type
  • ACAI Advanced Standing Unit Level block contains:
    • Unit Level (LOV)
    • Credit Points
    • Contact Hours
    • Discipline (LOV)
    • Institution (LOV)
    • Granting Status (Pop)
    • Institution Name
      • Admin Details Tab
        • Unit Level Description
        • Discipline Description
        • Created
        • Approved
        • Granted
        • Cancelled
        • Authorised By
        • Crs Grouped check box
        • Not Transferable check box
        • Unit Details button
        • Back button
      • Basis Details Tab
        • Course Type (LOV)
        • Last Year of Enrolment
        • Completed check box
        • Unit Details button
        • Back button
      • Origin Course Tab
        • Origin Course Code (LOV)
        • Title
        • Course Type
        • Yr Last Enrolled
        • Completed check box
        • Course Type Description
        • Unit Details button
        • Back button
      • Origin Unit Tab
        • Origin Unit Code (LOV)
        • Title
        • Credit Points
        • Contact Hours
        • Year Completed
        • Unit Details button
        • Back button
      • Comments Tab
        • General
        • Not Approved
        • Declined
        • Unit Details button
        • Back button
      • Status Dates Tab
        • Assessing
        • Approved
        • Granted
        • Not Approved
        • Cancelled
        • Declined
        • Revoked
        • Expiry
        • Unit Details button
        • Back button
  • Unit Details Button
  • Back button

Notes/Rules:

The three buttons at the base of the main screen; SCA Advanced Standing, Unit Details and Unit Level Details have a (+) or (-) sign next to them. If a record exists a (+) sign is displayed. If no record exists a (-) is displayed. In the case of the SCA Advanced Standing button, a (+) is displayed if Advanced Standing exists for any of the context Person's Student Course Attempts.

LAMPS

Lamps can appear, depending on the record, to the right of the Admission Course Application Instance Advanced Standing block title. They are:

• Student Course Attempt Advanced Standing Exists - this displays when Student Course Attempt Advanced Standing exists in ADVF4200 for the context Admission Course Application Instance

Under the 'Status Dates' Tab, the label name displays as 'Expired' if current status is expired. Otherwise it displays as Expiry.

Validations include:

• When the Advanced Standing AASTU (Advanced Standing Unit) or AASTUL (Advanced Standing Unit Level) record is set to APPROVED or GRANTED then an Authorised By Person ID must be specified
• When creating an Advanced Standing AASTU or ASSTUL record and inserting a Granting Status other than APPROVED or GRANTED, an 'Authorised By' ID cannot be inserted
• Only open Disciplines (at the Unit Level) can be used
• Closed Origin values cannot be selected
• Can only record 'Not Approved' comments for an AASTU or AASTUL record when status is NOT-APPRVD
• Can only record 'Declined' comments for an AASTU or AASTUL record when the status is declined
• Year Completed/Year Last Enrolled cannot be later than the current year
• Once the authorising person ID for an AASTU or AASTUL record is populated (when setting the Granting Status to APPROVED or GRANTED) it cannot be deleted
• Advanced Standing Origin must be from the same institution as the Advanced Standing 'Major Exemption Institution'
• Cannot change the ACAI Advanced Standing Unit Major Exemption Institution while child Origin records exist

For Error Messages see 'Possible Error Messages' below

Granting Status

Depending on what Granting Status is selected, the area after the 'Created' field in the Admin Tab dynamically changes. For example, if ASSESSING was selected as a Granting Status, then the area after the 'Created' date field in the Admin Tab would have an 'Assessing' date field added. The matrix below shows what field/s are displayed, when different Granting Statuses are selected.

*EXPIRED is greyed out, because presently, ACAI Advanced Standing can never have an EXPIRED status.

The Origin Course and Origin Unit records are not related (even though they are created in one form), therefore, when entering data in one, the other does not need to be populated.

Advanced Standing Origins are maintained in the form, Maintain Advanced Standing Origin (ADVF1190).

Note: Data from the Origin Course Code field in the Origin Course Tab or Origin Unit Code field in the Origin Unit Tab are found in one table, the Advanced Standing Origin Instance Table (ADV_STND_ORIGIN_INSTANCE).

Crs Grouped check box. Has no system functionality. It is used for local development reports to, for example, determine how many units of a course a student has undertaken.

Note: The Granting Status defaults to values defined in Maintain System Advanced Standing Granting Status form (ADVF1180) upon creation of new Advanced Standing records.

Label

Field Source

Field Type

Format Mask or Length

Comments

Person ID

PERSON_DISPLAY_V.PERSON_ID

Text

Number

.

.

PERSON_DISPLAY_V.CONTEXT_BLOCK_NAME

Display Field

Varchar2 (85)

.

Sex

PERSON_DISPLAY_V.SEX

Text

Varchar2(1)

.

Date of Birth

PERSON_DISPLAY_V.N.BIRTH_DT

Text

Date

.

Sector

.

Poplist

.

Use to query the block only

.

ACAI_ADVANCED_STANDING.PERSON_ID

Text

Number

Non-display item

.

ACAI_ADVANCED_STANDING.SEQUENCE_NUMBER

Text

Number

Non-display item

.

ACAI_ADVANCED_STANDING.ADMISSION_APPL_NUMBER

Text

Number

Non-display item

.

ACAI_ADVANCED_STANDING.NOMINATED_COURSE_CD

Text

Varchar2(20)

Non-display item

.

ACAI_ADVANCED_STANDING.AAST_SEQUENCE_NUMBER

Text

Number

Non-display item.
Get value from  a sequence

Commence Period

ADMISSION_APPL_SUMMARY_V.COMMENCEMENT_PERIOD

Display Field

Varchar2(21)

.

Course

ADM_COURSE_APPL_INSTANCE.COURSE_CD

Display Field

Varchar2(20)

.

Version

ADM_COURSE_APPL_INSTANCE.CRV_VERSION_NUMBER

Display Field

Number

.

.

COURSE_VERSION.TITLE

Display Field

Varchar2(100)

.

Location

ADM_COURSE_APPL_INSTANCE.LOCATION_CD

Display Field

Varchar2(10)

.

Attendance Mode

ADM_COURSE_APPL_INSTANCE.ATTENDANCE_MODE

Display Field

Varchar2(2)

.

Attendance Type

ADM_COURSE_APPL_INSTANCE.ATTENDANCE_TYPE

Display Field

Varchar2(2)

.

.

COURSE_VERSION.S_SECTOR_CD

ICON

.

.

Total Approve: CP

ACAI_ADVANCED_STANDING.TOTAL_EXMPTN_APPROVED

Text

Number(6,3)

.

CH

ACAI_ADVANCED_STANDING.TOTAL_CH_EXMPTN_APPROVED

Text

Number(4,0)

Dynamic – for VET only

Total Granted: CP

ACAI_ADVANCED_STANDING.TOTAL_EXMPTN_GRANTED

Text

Number(6,3)

See layout for the prompt

CH

ACAI_ADVANCED_STANDING.TOTAL_CH_EXMPTN_GRANTED

Text

Number(4,0)

Dynamic – for VET only

Percentage of Course Requirements Granted

ACAI_ADVANCED_STANDING.TOTAL_EXMPTN_PERC_GRNTD

Text

Number(5,2)

Dynamic – for HE only

Major Exemption Institution

ACAI_ADVANCED_STANDING.EXEMPTION_INSTITUTION_CD

Text

Varchar2(10)

Dynamic – for HE only

Government Credit Basis

ACAI_ADVANCED_STANDING.GOVT_CREDIT_BASIS

Text

Number(3,0)

Dynamic – for HE only

VET Field of Education

ACAI_ADVANCED_STANDING.VET_FIELD_OF_EDUCATION

Text

Varchar2(10)

Dynamic – for HE only

VET Level Detail

ACAI_ADVANCED_STANDING.VET_LEVEL_DETAIL

Text

Varchar2(10)

Dynamic – for HE only

Government VET Provider

ACAI_ADVANCED_STANDING.GOVT_VET_PROVIDER_TYPE

Text

Number(2,0)

Dynamic – for HE only

.

AAST.AAST_SEQUENCE_NUMBER

Text

Number

Get value from AAST block

Person ID

PE.PERSON_ID

Text

Number

Get value from PE block

.

PE.CONTEXT_BLOCK_NAME

Text

Varchar2(85)

Get value from PE block

Sex

PE.SEX

Text

Varchar2(1)

Get value from PE block

Date of Birth

PE.BIRTH_DT

Text

Date

Get value from PE block

Commencement Period

AAST.COMMENCEMENT_PERIOD

Text

Varchar2(21)

Get value from AAST block

.

AAST.COURSE_CD

Text

Varchar2(20)

Get value from AAST block

.

AAST.VERSION_NUMBER

Text

Number(3)

Get value from AAST block

Course Version

AAST.COURSE_CD|| AAST.VERSION_NUMBER

Text

Varchar2(24)

.

.

AAST.TITLE

Text

Varchar2(100)

Get value from AAST block

Location

AAST.LOCATION

Text

Varchar2(10)

Get value from AAST block

Attendance Mode

AAST.ATTENDANCE_MODE

Text

Varchar2(2)

Get value from AAST block

Attendance Type

AAST.ATTENDANCE_TYPE

Text

Varchar2(2)

Get value from AAST block

.

ACAI_ADV_STND_UNIT.PESON_ID

Text

Number

Non-display item

.

ACAI_ADV_STND_UNIT.AAST_SEQUENCE_NUMBER

Text

Number

Non-display item

Unit Code

ACAI_ADV_STND_UNIT.UNIT_CD

Text

Varchar2(20)

.

Version

ACAI_ADV_STND_UNIT.VERSION_NUMBER

Text

Number

.

Adv Stnd Type

ACAI_ADV_STND_UNIT.A_ADV_STND_TYPE

Poplist

Varchar2(10)

.

Percentage

ACAI_ADV_STND_UNIT.CREDIT_PERCENTAGE

Text

Number(5,2)

.

Credit Points

UNIT_VERSION_V. ACHIEVABLE_CREDIT_POINTS

Display Field

Number(6,3)

NVL(UVV.ACHIEVABLE_CREDIT_POINTS, UVV.ENROLLED_CREDIT_POINTS)

Contact Hours

UNIT_VERSION_V. SUPERVISED_CONTACT_HOURS

Display Field

Number(4,0)

Display for VET course only

Institution

ACAI_ADV_STND_UNIT.EXEPTION_INSTITUTION_CD

Text

Varchar2(10)

If installed sector is VET or course sector is VET then default 8004
Otherwise Default the adv_stnd_basic_inst from s_adv_stnd_conf

Granting Status

ACAI_ADV_STND_UNIT.S_ADV_STND_GRANTING_STATUS

Poplist

Varchar2(10)

.

Institution Name

INSTITUTION.NAME

Display Field

Varchar2(90)

.

Unit Title

UNIT_VERSION.TITLE

Display Field

Varchar2(100)

.

Created

ACAI_ADV_STND_UNIT.CREATED_DT

Text

Date

.

Approved

ACAI_ADV_STND_UNIT.APPROVED_DT

Text

Date

.

Granted

ACAI_ADV_STND_UNIT.GRANTED_DT

Text

Date

.

Cancelled

ACAI_ADV_STND_UNIT.CANCELLED_DT

Text

Date

.

Assessing

aastu.assessing_dt

Text

DD/MM/YYYY

Admin Details Tab

Not Approved

aastu.not_apprvd_dt

Text

DD/MM/YYYY

Admin Details Tab

Declined

aastu.declined_dt

Text

DD/MM/YYYY

Admin Details Tab

Expiry

aastu.expiry_dt

Text

DD/MM/YYYY

Admin Details Tab

Revoked

aastu.revoked_dt

Text

DD/MM/YYYY

Admin Details Tab

Authorised By

ACAI_ADV_STND_UNIT.AUTHORISING_PERSON_ID

Text

Number(10)

Admin Details Tab
This field is mandatory when the Granting Status is APPROVED or GRANTED.
This field cannot be set when a record is created where the Granting Status is not APPROVED or GRANTED

.

PERSON_DISPLAY_V.CONTEXT_BLOCK_NAME

Text

Varchar2(85)

Admin Details Tab

Crs Grouped

ACAI_ADV_STND_UNIT.CRS_GROUP_IND

Check box

Varchar2(1)

Admin Details Tab

Not Transferable

ACAI_ADV_STND_UNIT.NOT_TRANSFER_IND

Check box

Varchar2(1)

Admin Details Tab

Course Type

ACAI_ADV_STND_UNIT.BASIS_COURSE_TYPE

Text

Varchar2(10)

Basis Details Tab

Advanced Standing Source

ACAI_ADV_STND_UNIT.ADVANCED_STANDING_SOURCE

Text

Varchar2(10)

Basis Details Tab

Display for VET and CROSS sector installations only

Last Year of Enrolment

ACAI_ADV_STND_UNIT.BASIS_YEAR

Text

Number(4,0)

Basis Details Tab

Completed

ACAI_ADV_STND_UNIT.BASIS_COMPLETION_IND

Checkbox

Varchar2(1)

Basis Details Tab

.

ADV_STND_ORIGIN_INSTANCE.PERSON_ID

Text

Number

Non-display

.

ADV_STND_ORIGIN_INSTANCE.ASTOI_SEQUENCE_NUMBER

Text

Number

Get value from a sequence.
Non-display

.

ADV_STND_ORIGIN.ASTO_SEQUENCE_NUMBER

Text

Number

Non-display

.

ADV_STND_ORIGIN_INSTANCE.S_ADV_STND_TYPE

Text

Varchar2(10)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.UNIT_CD

Text

Varchar2(20)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.UV_VERSION_NUMBER

Text

Number

Non-display

Origin Course Code

ADV_STND_ORIGIN.ORIGIN_CODE || ‘.’ || ADV_STND_ORIGIN.ORIGIN_VERSION

Text (with LOV)

varchar2(24)

Note this is not the same as a normal Callista Course Code

Title

ADV_STND_ORIGIN.TITLE

Display Field

varchar2(60)

.

Course Type

ADV_STND_ORIGIN.COURSE_TYPE

Display Field

varchar2(10)

.

Yr Last Enrolled

ADV_STND_ORIGIN_INSTANCE.YEAR

Text

9999

.

Completed

ADV_STND_ORIGIN_INSTANCE.COMPLETION_IND

Checkbox

varchar2(1)

.

Course Type Description

COURSE_TYPE.DESCRIPTION

Display Field

varchar2(60)

.

.

ADV_STND_ORIGIN_INSTANCE.PERSON_ID

Text

Number

Non-display

.

ADV_STND_ORIGIN_INSTANCE.ASTOI_SEQUENCE_NUMBER

Text

Number

Get value from a sequence.
Non-display

.

ADV_STND_ORIGIN.ASTO_SEQUENCE_NUMBER

Text

Number

Non-display

.

ADV_STND_ORIGIN_INSTANCE.S_ADV_STND_TYPE

Text

Varchar2(10)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.UNIT_CD

Text

Varchar2(20)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.UV_VERSION_NUMBER

Text

Number

Non-display

.

ADV_STND_ORIGIN_INSTANCE.COMPLETION_IND

Text

Varchar2(1)

Not shown Set value to ‘Y’ when Year completed is not NULL, else set to ‘N’

Origin Unit Code

ADV_STND_ORIGIN.ORIGIN_CODE || ‘.’ || ADV_STND_ORIGIN.ORIGIN_VERSION

Text (with LOV)

varchar2(24)

Origin Unit Tab
Note this is not the same as a normal Callista Unit Code

Title

ADV_STND_ORIGIN.TITLE

Display Field

varchar2(60)

Origin Unit Tab

Credit Points

ADV_STND_ORIGIN.ACHIEVABLE_CREDIT_POINTS

Display Field

990.000

Origin Unit Tab

Contact Hours

ADV_STND_ORIGIN.CONTACT_HOURS

Display Field

9990

Origin Unit Tab

Year Completed

ADV_STND_ORIGIN_INSTANCE.YEAR

Text

number(4,0)

Origin Unit Tab

.

ACAI_ADV_STND_ALT_UNIT.PERSON_ID

Text

Number

Non-display

.

ACAI_ADV_STND_ALT_UNIT.AAST_SEQUENCE_NUMBER

Text

Number

Non-display

.

ACAI_ADV_STND_ALT_UNIT.S_ADV_STND_TYPE

Text

Varchar2(10)

Non-display

.

ACAI_ADV_STND_ALT_UNIT.UNIT_CD

Text

Varchar2(20)

Non-display

.

ACAI_ADV_STND_ALT_UNIT.VERSION_NUMBER

Text

Number

Non-display

Alternate Unit

ACAI_ADV_STND_ALT_UNIT.ALT_UNIT_CD

Text (with LOV)

varchar2(20)

.

Version

ACAI_ADV_STND_ALT_UNIT.ALT_VERSION_NUMBER

Text

Number(3)

.

.

UNIT_VERSION.TITLE

Display Field

varchar2(100)

.

Achievable Credit Points

NVL(UVSV.ACHIEVABLE_CREDIT_POINTS, UVSV.ENROLLED_CREDIT_POINTS)

Display Field

990.000

.

Supervised Contact Hours

UVSV.SUPERVISED_CONTACT_HOURS

Display Field

9990

.

Optional

ACAI_ADV_STND_ALT_UNIT.OPTIONAL_IND

CHECKBOX

Varchar2(1)

.

General

ACAI_ADV_STND_UNIT.COMMENTS

Text

varchar2(4000)

Comments Tab

Not Approved

ACAI_ADV_STND_UNIT.NOT_APPRVD_COMMENTS

Text

varchar2(4000)

Comments Tab
Can only be entered when the granting status is NOT-APPRVD

Declined

ACAI_ADV_STND_UNIT.DECLINED_COMMENTS

Text

varchar2(4000)

Comments Tab
Can only be entered when the granting status is DECLINED

Assessing:

AASTU.ASSESSING_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Approved:

AASTU.APPROVED_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Granted:

AASTU.GRANTED_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Not Approved:

AASTU.NOT_APPRVD_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Cancelled:

AASTU.CANCELLED_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Declined:

AASTU.DECLINED_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Revoked:

AASTU.REVOKED_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Expiry:

AASTU.EXPIRY_DT

Display Field

DD/MM/YYYY

Status Dates Tab
Note the label dynamically changes to Expired: when the status is ‘EXPIRED’, otherwise is Expiry

Label

Field Source

Field Type

Format Mask or Length

Comments

.

AAST.AAST_SEQUENCE_NUMBER

Text

Number

Get value from AAST block

Person ID

PE.PERSON_ID

Text

Number

Get value from PE block

.

PE.CONTEXT_BLOCK_NAME

Text

Varchar2(85)

Get value from PE block

Sex

PE.SEX

Text

Varchar2(1)

Get value from PE block

Date of Birth

PE.BIRTH_DT

Text

Date

Get value from PE block

Commencement Period

AAST.COMMENCEMENT_PERIOD

Text

Varchar2(21)

Get value from AAST block

.

AAST.COURSE_CD

Text

Varchar2(20)

Get value from AAST block

.

AAST.VERSION_NUMBER

Text

Number(3)

Get value from AAST block

Course Version

AAST.COURSE_CD|| AAST.VERSION_NUMBER

Text

Varchar2(24)

.

.

AAST.TITLE

Text

Varchar2(100)

Get value from AAST block

Location

AAST.LOCATION

Text

Varchar2(10)

Get value from AAST block

Attendance Mode

AAST.ATTENDANCE_MODE

Text

Varchar2(2)

Get value from AAST block

Attendance Type

AAST.ATTENDANCE_TYPE

Text

Varchar2(2)

Get value from AAST block

Unit Level

AASTUL.UNIT_LEVEL

Text (with LOV)

Varchar2(1)

.

Credit Points

AASTUL.CREDIT_POINTS

Text

Number(6,3)

.

Discipline

AASTUL.DISCIPLINE_GROUP_CD

Text (with LOV)

varchar2(10)

.

Institution

AASTUL.EXEMPTION_INSTITUTION_CD

Text (with LOV)

varchar2(10)

If installed sector is VET or course sector is VET then default 8004
Otherwise
Default the adv_stnd_basic_inst from s_adv_stnd_conf

Granting Status

AASTUL.S_ADV_STND_GRANTING_STATUS

Poplist

Varchar2(10)

NVL( S_ADV_STND_CONF. DEFAULT_GRANTING_STATUS, ‘ASSESSING’)

Institution Name

INS.NAME

Display Field

varchar2(90)

.

Unit Level Description

UNIT_LEVEL.DESCRIPTION

Display Field

varchar2(60)

Admin Details Tab

Discipline Description

DISCIPLINE.DESCRIPTION

Display Field

varchar2(60)

Admin Details Tab

Created

AASTUL.CREATION_DT

Display Field

DD/MM/YYYY

Admin Details Tab
Should be automatically populated by form when a new record is created.
Can be null for historical records

Approved

AASTUL.APPROVED_DT

Text

DD/MM/YYYY

Admin Details Tab

Granted

AASTUL.GRANTED_DT_DT

Text

DD/MM/YYYY

Admin Details Tab

Cancelled

AASTUL.CANCELLED_DT

Text

DD/MM/YYYY

Admin Details Tab

Assessing

aastu.assessing_dt

Text

DD/MM/YYYY

Admin Details Tab

Not Approved

aastu.not_apprvd_dt

Text

DD/MM/YYYY

Admin Details Tab

Declined

aastu.declined_dt

Text

DD/MM/YYYY

Admin Details Tab

Expiry

aastu.expiry_dt

Text

DD/MM/YYYY

Admin Details Tab

Revoked

aastu.revoked_dt

Text

DD/MM/YYYY

Admin Details Tab

Authorised By

AASTUL.AUTHORISING_PERSON_ID

Text

Number 999999999

Admin Details Tab This field is mandatory when the granting status is APPROVED or GRANTED.
This field cannot be set when a record is created where the granting status is not APPROVED or GRANTED.
If the field is already populated and the status is altered it remains mandatory.

Crs Grouped

AASTUL.CRS_GROUP_IND

Checkbox

Varchar2(1)

Admin Details Tab

Not Transferable

AASTUL.NOT_TRANSFER_IND

Checkbox

Varchar2(1)

Admin Details Tab

Course Type

ACAI_ADV_STND_UNIT_LEVEL.BASIS_COURSE_TYPE

Text (with LOV)

Varchar2(10)

Basis Details Tab

.

CTY.DECRIPTION

Displayed item

Varchar2(60)

Basis Details Tab

Advanced Standing Source

ACAI_ADV_STND_UNIT._LEVEL.ADVANCED_STANDING_SOURCE

Text (with LOV)

Varchar2(10)

Basis Details Tab Display for VET and CROSS sector only

.

ASS.DESCRIPTION

Display item

Varchar2(60)

Basis Details Tab

Last Year of Enrolment

ACAI_ADV_STND_UNIT_LEVEL.BASIS_YEAR

Text

Number(4,0)

Basis Details Tab

Completed

ACAI_ADV_STND_UNIT_LEVEL.BASIS_COMPLETION_IND

Checkbox

Varchar2(1)

Basis Details Tab

.

ADV_STND_ORIGIN_INSTANCE.PERSON_ID

Text

Number

Non-display

.

ADV_STND_ORIGIN_INSTANCE.ASTOI_SEQUENCE_NUMBER

Text

Number

Get value from a sequence.
Non-display

.

ADV_STND_ORIGIN.ASTO_SEQUENCE_NUMBER

Text

Number

Non-display

.

ADV_STND_ORIGIN_INSTANCE.S_ADV_STND_TYPE

Text

Varchar2(10)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.UNIT_LEVEL

Text

Varchar2(1)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.CRS_GROUP_IND

Text

Varchar2(1)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.EXEMPTION_INST_IND

Text

Varchar2(10)

Non-display

Origin Course Code

ADV_STND_ORIGIN.ORIGIN_CODE || ‘.’ || ADV_STND_ORIGIN.ORIGIN_VERSION

Text (with LOV)

varchar2(24)

Note this is not the same as a normal Callista Course Code.

Title

ADV_STND_ORIGIN.TITLE

Display Field

varchar2(60)

.

Course Type

ADV_STND_ORIGIN.COURSE_TYPE

Display Field

varchar2(10)

.

Yr Last Enrolled

ADV_STND_ORIGIN_INSTANCE.YEAR

Text

9999

.

Completed

ADV_STND_ORIGIN_INSTANCE.COMPLETION_IND

Checkbox

varchar2(1)

.

Course Type Description

COURSE_TYPE.DESCRIPTION

Display Field

varchar2(60)

.

.

ADV_STND_ORIGIN_INSTANCE.PERSON_ID

Text

Number

Non-display

.

ADV_STND_ORIGIN_INSTANCE.ASTOI_SEQUENCE_NUMBER

Text

Number

Get value from a sequence.
Non-display

.

ADV_STND_ORIGIN.ASTO_SEQUENCE_NUMBER

Text

Number

Non-display

.

ADV_STND_ORIGIN_INSTANCE.S_ADV_STND_TYPE

Text

Varchar2(10)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.UNIT_LEVEL

Text

Varchar2(1)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.CRS_GROUP_IND

Text

Varchar2(1)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.EXEMPTION_INST_IND

Text

Varchar2(10)

Non-display

.

ADV_STND_ORIGIN_INSTANCE.COMPLETION_IND

Text

Varchar2(1)

Non-display

Origin Unit Code

ADV_STND_ORIGIN.ORIGIN_CODE || ‘.’ || ADV_STND_ORIGIN.ORIGIN_VERSION

Text (with LOV)

varchar2(24)

Origin Unit Tab Note this is not the same as a normal Callista Unit Code

Title

ADV_STND_ORIGIN.TITLE

Display Field

varchar2(60)

Origin Unit Tab

Credit Points

ADV_STND_ORIGIN.ACHIEVABLE_CREDIT_POINTS

Display Field

990.000

Origin Unit Tab

Contact Hours

ADV_STND_ORIGIN.CONTACT_HOURS

Display Field

9990

Origin Unit Tab

Year Completed

ADV_STND_ORIGIN_INSTANCE.YEAR

Text

number(4,0)

Origin Unit Tab

General

AASTUL.COMMENTS

Text

varchar2(4000)

Comments Tab

Not Approved

AASTUL.NOT_APPRVD_COMMENTS

Text

varchar2(4000)

Comments Tab Can only be inserted or updated when the granting status is NOT-APPRVD

Declined

AASTUL.DECLINED_COMMENTS

Text

varchar2(4000)

Comments Tab Can only be inserted or updated when the granting status is DECLINED

Assessing

AASTUL.CREATION_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Approved

AASTUL.APPROVED_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Granted

AASTUL.GRANTED_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Not Approved

AASTUL.NOT_APPRVD_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Cancelled

AASTUL.CANCELLED_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Declined

AASTUL.DECLINED_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Revoked

AASTUL.REVOKED_DT

Display Field

DD/MM/YYYY

Status Dates Tab

Expiry

AASTUL.EXPIRY_DT

Display Field

DD/MM/YYYY

Status Dates Tab Note the label dynamically changes to Expired: when the status is ‘EXPIRED’, otherwise is Expiry:

Granting Status

Date field values set (The Status Dates Conditions below: 1 and 2 apply over and above this matrix)

Assessing Date

Approved Date

Granted Date

Cancelled Date

Expiry/Expired Date

Revoked Date

Declined Date

Not Apprvd Date

ASSESSING

If null set to sysdate – else no change

No change

NULL

No change

No change

No change

No change

No change

APPROVED

No change

If null set to sysdate – else no change

NULL

No change

Derive as per current functionality

No change

No change

No change

GRANTED

No change

If null set to sysdate – else no change

Sysdate

No change

No change

No change

No change

No change

CANCELLED

No change

No change

No change

If null set to sysdate – else no change

No change

No change

No change

No change

EXPIRED
(set by job ADVJ4412)

No change

No change

No change

No change

Derive as per current functionality

No change

No change

No change

REVOKED

No change

No change

No change

No change

No change

If null set to sysdate – else no change

No change

No change

DECLINED

No change

No change

No change

No change

No change

No change

If null set to sysdate – else no change

No change

NOT-APPRVD

No change

No change

No change

No change

No change

No change

No change

If null set to sysdate – else no change

Message Number

When to Fire

Where to Fire

Message Text

.

Insert/update item
aast. exemption_institution_cd

Form and Trigger

Invalid value for major exemption institution

272

Insert/update record aastu

Form and Trigger

Unit version does not have a status of active or planned

319

Insert/update record aastu

Form and Trigger

The Unit Code, Unit Version Number does not exist

438

Insert/update item
Aastu. AUTHORISING_PERSON_ID

Form and Trigger

Person is not a staff member

438

Insert/update item
Aastul. AUTHORISING_PERSON_ID

Form and Trigger

Person is not a staff member

884

Insert/update item
Aastu. AUTHORISING_PERSON_ID

Form and Trigger

Invalid Person ID

884

Insert/update item
Aastul. AUTHORISING_PERSON_ID

Form and Trigger

Invalid Person ID

1063

Insert/update item
Aastu. S_ADV_STND_GRANTING_STATUS

Form and Trigger

Person has an encumbrance revoking all services

1063

Insert/update item
Aastul. S_ADV_STND_GRANTING_STATUS

Form and Trigger

Person has an encumbrance revoking all services

1185

Insert/update item
Aastu. S_ADV_STND_GRANTING_STATUS

Form and Trigger

Person has an encumbrance suspending all services

1185

Insert/update item
Aastul. S_ADV_STND_GRANTING_STATUS

Form and Trigger

Person has an encumbrance suspending all services

1582

Insert/update
Aastu record

Form and Trigger

Approved date cannot be later than the expiry date

1582

Insert/update
Aastul record

Form and Trigger

Approved date cannot be later than the expiry date

1584

Insert/update item
Aastu.s_adv_stnd_recognition_type

Form and Trigger

Advanced Standing Recognition Type is closed

1756

Insert/update item
Asau.alt_unit_cd

Form and Trigger

Cannot record Alternate units for a recognition type other than 'PRECLUDE'

1757

Insert/update item
Asau.alt_unit_cd

Form and Trigger

Alternate unit must be different from the precluded unit it is associated with

1759

Insert/update item
Aastu.credit_percentage

Form

Warning: Credit percentage should be either 33, 66 or a multiple of 5

1769

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For HE and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Insufficient information to determine if Advanced Standing Course version limits have been exceeded

1769

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Insufficient information to determine if Advanced Standing Course version limits have been exceeded

1769

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For HE and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Insufficient information to determine if Advanced Standing Course version limits have been exceeded

1769

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Insufficient information to determine if Advanced Standing Course version limits have been exceeded

1770
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2013

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For HE and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Advanced Standing exceeds Course Version External Advanced Standing limit

1770
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2013

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Advanced Standing exceeds Course Version External Advanced Standing limit

1770
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2014

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For HE and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Advanced Standing exceeds Course Version External Advanced Standing limit

1770
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2014

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Advanced Standing exceeds Course Version External Advanced Standing limit

1771
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2015

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For HE and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Advanced Standing exceeds Course Version Internal Advanced Standing limit

1771
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2015

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Advanced Standing exceeds Course Version Internal Advanced Standing limit

1771
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2016

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For HE and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Advanced Standing exceeds Course Version Internal Advanced Standing limit

1771
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2016

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Advanced Standing exceeds Course Version Internal Advanced Standing limit

1855

Insert/update item
Asau.alt_unit_cd

Form and Trigger

Unit level is closed

1972

Insert/update item
Aastu.approved_dt

Form and Trigger

Approved date must be less than or equal to the current date

1972

Insert/update item
Aastul.approved_dt

Form and Trigger

Approved date must be less than or equal to the current date

1973

Insert/update item
Aastu.granted_dt

Form and Trigger

Granted date must be less than or equal to the current date

1973

Insert/update item
Aastul.granted_dt

Form and Trigger

Granted date must be less than or equal to the current date

1983

Insert/update item
Aastu.cancelled_dt

Form and Trigger

Cancelled date must be less than or equal to the current date

1983

Insert/update item
Aastul.cancelled_dt

Form and Trigger

Cancelled date must be less than or equal to the current date

1984

Insert/update item
Aastu.revoked_dt

Form and Trigger

Revoked date must be less than or equal to the current date

1984

Insert/update item
Aastul.revoked_dt

Form and Trigger

Revoked date must be less than or equal to the current date

2040
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2059

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For HE and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Warning: Minimum credit points for course completion now exceeded

2040
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2059

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Warning: Minimum credit points for course completion now exceeded

2040
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2058

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For HE and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Warning: Minimum credit points for course completion now exceeded

2040
Note: if s_adv_stnd_ granting_status = ‘APPROVED’
Then 2058

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Warning: Minimum credit points for course completion now exceeded

2042

Insert/update item
Aastu.basis_year

Form

Last year of enrolment cannot be greater than the current year

2042

Insert/update item
Aastul.basis_year

Form

Last year of enrolment cannot be greater than the current year

2044

Insert/update item
Aastu.basis_year

Form

Last year of enrolment is outside the qualification recency specified for the course

2044

Insert/update item
Aastul.basis_year

Form

Last year of enrolment is outside the qualification recency specified for the course

2044
2042

Insert/update item
Aastu_Astoi_crs.year

Form and Trigger

Last year of enrolment is outside the qualification recency specified for the course

2044
2042

Insert/update item
Aastu_Astoi_unit.year

Form and Trigger

Last year of enrolment is outside the qualification recency specified for the course

2044
2042

Insert/update item
Aastul_Astoi_crs.year

Form and Trigger

Last year of enrolment is outside the qualification recency specified for the course

2044
2042

Insert/update item
Aastul_Astoi_unit.year

Form and Trigger

Last year of enrolment is outside the qualification recency specified for the course

7227

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Warning: Minimum contact hours for course completion now exceeded

7227

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Warning: Minimum contact hours for course completion now exceeded

7242

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Course attempt must be for VET sector to call this function

7242

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For VET and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Course must be for VET sector to call this function.
(existing message needs to have text updated as above)

7243

Update item aastu.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For HE and aastu.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastu.CREDIT_PERCENTAGE') = 100

Form

Course must be for HE sector to call this function.
(existing message needs to have text updated as above)

7243

Update item aastul.S_ADV_STND_GRANTING_STATUS
Note: Having changed to GRANTED, check that the limits for course will not be exceeded by granting the unit level
For HE and aastul.S_ADV_STND_RECOGNITION_TYPE' = 'CREDIT' and aastul.CREDIT_PERCENTAGE') = 100

Form

Course must be for HE sector to call this function.
(existing message needs to have text updated as above)

7524

Insert/update item
aastul.CREDIT_POINTS' AND Course Version sector = 'HE' OR
aastul.CONTACT_HOURS' AND Course version sector = 'VET'

Form and Trigger

Advanced Standing Unit Level Contact Hours must be defined for VET courses

7525

Insert/update item
aastul.CREDIT_POINTS' AND Course Version sector = 'HE' OR
aastul.CONTACT_HOURS' AND Course version sector = 'VET'

Form and Trigger

Advanced Standing Unit Level Credit Points must be defined for Higher Education courses

7526

Insert/update record aastu

Form and Trigger

Advanced Standing Unit Credit Percentage must equal 100 for Advanced Standing Source values with a system mapping of 'RPL'

7527

Insert/update record aastu

Form and Trigger

Advanced Standing Recognition Type must be 'CREDIT' for Advanced Standing Source values with a system mapping of 'RPL'

7977

Inert/update item
Aastu.advanced_standing_source

Form and Trigger

Advanced Standing Source is closed

7977

Inert/update item
Aastul.advanced_standing_source

Form and Trigger

Advanced Standing Source is closed

12998

Insert item
Aastu.unit_cd

Form

You are attempting to record/grant ADV in a unit when the student has passed or is currently enrolled in another version of the unit. Proceed YES/NO

13403

Insert/update  item
Aastu.basis_course_type
Aastul.basis_course_type

Form and Trigger

Course Type is closed

13404

Insert/update item
Aast.vet_field_of_education

Form and Trigger

VET Field of Education is closed

13406

Insert/update  item
Aast.govt_vet_provider_type

Form and Trigger

Government VET Provider Type is closed

13407

Insert/Update record aast

Form and Trigger

When the Government Credit Basis is 200 or 300, then Major Exemption Institution, VET Field of Education, VET Level Detail and Government VET Provider must be specified

13419

Insert/Update record aast

Form and Trigger

The VET Field of Education cannot be set to a value where the Government Field of Education is NULL.

13728

Insert/update of record aastu

Form and Trigger

Expired date must not be prior to created date

13770

Insert/update of record aastu

Form and Trigger

Approved date must not be prior to created date

13771

Insert/update of record aastu

Form and Trigger

Granted date must not be prior to created date

13772

Insert/update of record aastu

Form and Trigger

Expiry date must not be prior to created date

13773

Insert/update of record aastu

Form and Trigger

Cancelled date must not be prior to created date

13774

Insert/update of record aastu

Form and Trigger

Revoked date must not be prior to created date

13775

Insert/update of record aastu

Form and Trigger

Assessing date must not be prior to created date

13776

Insert/update of record aastu

Form and Trigger

Not Approved date must not be prior to created date

13777

Insert/update of record aastu

Form and Trigger

Declined date must not be prior to created date

13779

Insert/update item
Aastu.assessing_dt

Form and Trigger

Assessing date must be less than or equal to the current date

13779

Insert/update item
Aastul.assessing_dt

Form and Trigger

Assessing date must be less than or equal to the current date

13780

Insert/update item
Aastu.not_apprvd_dt

Form and Trigger

Not_apprvd date must be less than or equal to the current date

13780

Insert/update item
Aastul.not_apprvd_dt

Form and Trigger

 Not Approved date must be less than or equal to the current date

13781

Insert/update item
Aastu.declined_dt

Form and Trigger

Declined date must be less than or equal to the current date

13781

Insert/update item
Aastu.declined_dt

Form and Trigger

Declined date must be less than or equal to the current date

13784

Insert/update
Aastu record

Form and Trigger

Granted date cannot be later than the expiry date

13784

Insert/update
Aastu record

Form and Trigger

Granted date cannot be later than the expiry date

13785

Insert/update
Aastu record

Form and Trigger

Approved date cannot be later than the granted date

13785

Insert/update
Aastul record

Form and Trigger

Approved date cannot be later than the granted date

13786

Insert/update
Aastu record

Form and Trigger

Approved date cannot be later than the cancelled date

13786

Insert/update
Aastul record

Form and Trigger

Approved date cannot be later than the cancelled date

13787

Insert/update
Aastu record

Form and Trigger

Granted date cannot be later than the cancelled date

13787

Insert/update
Aastul record

Form and Trigger

Granted date cannot be later than the cancelled date

13788

Insert/update
Aastu record

Form and Trigger

Approved date cannot be later than the revoked date

13788

Insert/update
Aastul record

Form and Trigger

Approved date cannot be later than the revoked date

13789

Insert/update
Aastu record

Form and Trigger

Granted date cannot be later than the revoked date

13789

Insert/update
Aastul record

Form and Trigger

Granted date cannot be later than the revoked date

13790

Insert/update
Aastu record

Form and Trigger

Approved date cannot be later than the declined date

13790

Insert/update
Aastul record

Form and Trigger

Approved date cannot be later than the declined date

13791

Insert/update
Aastu record

Form and Trigger

Granted date cannot be later than the declined date

13791

Insert/update
Aastul record

Form and Trigger

Granted date cannot be later than the declined date

13792

Insert/update
Aastu record

Form and Trigger

Approved date cannot be later than the  expired date

13792

Insert/update
Aastul record

Form and Trigger

Approved date cannot be later than the  expired date

13805

Insert item aast.nominated_course_cd
Note: If the user pressed Yes button then navigate to ADVF4200
Otherwise clear that record

Form

A Student Course Attempt Advanced Standing Exists.
Any maintenance must be made in ADVF4200 - Create Advanced Standing Details