Results for “igs_av_stnd_unit”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AV_STND_UNIT is a reporting and integration view within the Oracle E-Business Suite IGS (Student System) product family. IGS, also referred to as the Advanced Student System or Student Information Management, is classified in the ETRM metadata as obsolete, meaning it is no longer actively supported or shipped in current releases, though the underlying database objects may persist in legacy installations. The view presents advanced standing unit data, capturing the recognition, granting, and status tracking of academic units awarded to a student on the basis of prior learning, exemptions, or transfer credit rather than through direct enrolment and completion within the institution.

The view is defined over the base table IGS_AV_STND_UNIT_ALL and exposes a multi-org security filter through the ORG_ID column. The naming suffix _ALL indicates that the underlying table is partitioned by operating unit, and the view applies a WHERE clause referencing USERENV('CLIENT_INFO') to restrict rows to the current organization context. This makes the view suitable for multi-org enabled reporting where results must be scoped to the session's active operating unit, returning rows matching the client information or, where the organization cannot be resolved, a fallback value of -99.

Underlying Base Objects

The view is defined solely over IGS_AV_STND_UNIT_ALL, which contains the fully denormalised set of advanced standing unit attributes. The view text selects the row's ROWID as ROW_ID, then maps the standard multi-org audit columns (ORG_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the descriptive and transactional columns onto the view. Two columns present in the base table, CREDIT_PERCENTAGE and PREV_UNIT_CD, are commented out in the view definition, and a literal NULL placeholder appears where CREDIT_PERCENTAGE would sit. This indicates a versioning difference between the base table and the view, likely reflecting a column that was deprecated or restructured across patch levels. The ETRM metadata documents no explicitly referenced base objects, so the view text should be treated as the authoritative source for the object relationship.

Key Columns

• ROW_ID — the physical ROWID of the underlying row, useful for direct updates or de-duplication.
• ORG_ID — the operating unit identifier, central to the multi-org security predicate.
• PERSON_ID — the identifier of the student to whom the advanced standing is granted.
• AS_COURSE_CD / AS_VERSION_NUMBER — the course and version associated with the advanced standing record.
• UNIT_CD / VERSION_NUMBER — the specific unit being recognised.
• S_ADV_STND_TYPE — the category of advanced standing.
• S_ADV_STND_GRANTING_STATUS — the current status of the grant.
• AUTHORISING_PERSON_ID — the person who authorised the granting of the advanced standing. This is the column most closely associated with the search term "authorising_person_id," and it is exposed directly by the view, making it queryable for audit and approval reporting.
• APPROVED_DT, GRANTED_DT, EXPIRY_DT, CANCELLED_DT, REVOKED_DT — the lifecycle dates governing the award.
• S_ADV_STND_RECOGNITION_TYPE, GRADE, GRADING_SCHEMA_CD, ACHIEVABLE_CREDIT_POINTS — outcome and credit information.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID — concurrent request and concurrent program context columns.

Common Use Cases and Queries

The view is typically used to report advanced standing awards, audit which operator authorised a grant, and reconcile lifecycle dates. A representative query retrieving all authorisations for a student follows:

SELECT person_id, unit_cd, authorising_person_id, approved_dt, s_adv_stnd_granting_status FROM igs_av_stnd_unit WHERE person_id = :p_person_id;

To track awards authorised by a specific individual within the current operating unit:

SELECT av.unit_cd, av.granted_dt, av.expiry_dt FROM igs_av_stnd_unit av WHERE av.authorising_person_id = :p_authoriser AND av.s_adv_stnd_granting_status = 'GRANTED';

Because the view enforces the ORG_ID predicate automatically, callers must ensure CLIENT_INFO is set correctly through the multi-org initialisation routines before execution. Given the obsolete status of IGS, these queries are relevant only to legacy environments retained for historical data extraction and migration.