Purpose

Records the Advanced Standing Origin reference data.

The reference data is used for defining the Units and/or Courses that formed the basis of the Advanced Standing Unit and Unit Level records.

It is the institution’s own business processes that determine the meaning of Advanced Standing Origin Unit Credit points and/or Contact Hours. They may represent the value the unit had at the Origin institution or the value to be attributed at the local institution.

Internal Courses and Units will need to be set up as Advanced Standing Origins if they are to be recorded as the basis for Advanced Standing.

The Advance Standing reference data will be available in the Create ACAI Advanced Standing Details (ADVF2000) and Create Advanced Standing Details (ADVF4200) forms.

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

This form is accessed from the main menu.

The Institution block contains:

• Institution Code (LOV)
• Status
• Country

The Advanced Standing Origin block contains:

• Type (Pop)
• Code
• Version
• Title
• Sector
• Closed check box

When Origin Type is UNIT

• Description
• Achievable Credit Points
• Contact Hours

When Origin Type is COURSE

• Description
• Course Type (LOV)

Notes/Rules:

Label

Field Type

Format Mask or Length

Comments

Institution Code

INS.INSTITUTION_CD

Text with LOV

Varchar2(10)

Institution Name

INS.NAME

Text

Varchar2(90)

Allow user to scroll to the right of the field. Field is enabled but not able to be updated

Status

INS.INSTITUTION_STATUS

Text

Varchar2(10)

Allow user to scroll to the right of the field. Field is enabled but not able to be updated

Country

COUNTRY.DESCRIPTION

Display Field

Varchar2(60)

joined on ins.country_cd note this is an optional column

Label

Field Type

Format Mask or Length

Comments

ASTO.ASTO_SEQUENCE_NUMBER

Text

Number 999990

Sequence Number, non-displayed field

ASTO.INSTITUTION_CD

Varchar2(10)

non-displayed field

Type

ASTO.ORIGIN_TYPE

Pop list

Varchar2(10)

COURSE or UNIT

Code

ASTO.ORIGIN_CODE

Text

Varchar2(20)

Version

ASTO.ORIGIN_VERSION

Text

Number 990

Title

ASTO.TITLE

Text

Varchar2(60)

Sector

ASTO.S_SECTOR_CD

Pop list

Varchar2(10)

Closed

ASTO.CLOSED

Check box

Varchar2(1)

Description

ASTO.DESCRIPTION

Text

Varchar2(4000)

Multi-lines

Achievable Credit Points

ASTO.ACHIEVABLE_CREDIT_POINTS

Text

Number
90.999

Only displayed when Origin Type = UNIT

Contact Hours

ASTO.CONTACT_HOURS

Text

Number 9990

Only displayed when Origin Type = UNIT

Course Type

ASTO.COURSE_TYPE

Text with LOV

Varchar2(10)

Only displayed when Origin Type = COURSE

CTY.DESCRIPTION

Text

Varchar2(60)

Only displayed when Origin Type = COURSE

Allow user to scroll to the right of the field. Field is enabled but not able to be updated