Results for “adv_standing_type”

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

Overview

IGSBV_AV_ADV_STND_UNIT_LEVEL is an APPS-owned read-only view within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to describe the number of advanced standing credit points granted to a student at a given unit level. Advanced standing represents academic credit awarded to a student for prior learning, external qualifications, or equivalent study, and this view aggregates that credit at the granularity of the academic unit level associated with a student's programme attempt.

Because the view is defined with the WITH READ ONLY clause, it is strictly a reporting and integration artifact. It exposes advanced standing unit-level records without permitting DML through the view surface, which protects the underlying transactional table from unintended modification by downstream consumers. In EBS 12.1.1 and 12.2.2 the view is registered as VALID in the APPS schema, making it a stable reference point for custom reports, extracts, and interface programmes that need to surface advanced standing credit outcomes.

Underlying Base Objects

The view text documents a single base object: IGS_AV_STND_UNIT_LVL_ALL, aliased as ASUL. This is the advanced standing unit-level detail table, which stores one row per advanced standing unit-level grant record. The _ALL suffix indicates the table follows the multi-org partitioning convention used throughout EBS, though the view does not itself expose an ORG_ID column in its projected column list.

The view performs a straightforward projection and column aliasing over the base table rather than a join, which means there is effectively a one-to-one correspondence between rows in the view and rows in IGS_AV_STND_UNIT_LVL_ALL. One notable projection is a lookup translation expression: the view does not expose S_ADV_STND_GRANTING_STATUS directly but instead emits a descriptive string derived from IGS_LOOKUP_VALUES for the ADV_STND_GRANTING_STATUS lookup type, aliased as "_LA:ASUL_GRANTING_STATUS". This pattern is typical of EBS "LOV/translation" views that resolve coded values to their meaningful descriptions for end-user reporting.

Key Columns

• AS_COURSE_CD (exposed as PROGRAM_CODE) — the course or programme code to which the advanced standing relates.
• AS_VERSION_NUMBER (PROGRAM_VERSION_NUMBER) — the version of the programme under which the standing was granted.
• S_ADV_STND_TYPE (ADV_STANDING_TYPE) — the type of advanced standing awarded.
• UNIT_LEVEL (ADV_STND_UNIT_LEVEL) — the academic unit level for which credit points were granted. This is the unit_level_mark dimension that users most frequently query.
• UNIT_LEVEL_MARK — a mark or grade value recorded at the unit level, representing the outcome associated with the advanced standing.
• CREDIT_POINTS — the number of credit points granted, the core measurement the view is designed to communicate.
• "_LA:ASUL_GRANTING_STATUS" — the resolved meaning of the advanced standing granting status lookup.
• APPROVED_DT, GRANTED_DT, EXPIRY_DT, CANCELLED_DT, REVOKED_DT — the lifecycle dates governing when the standing was approved, granted, expires, or was cancelled/revoked.
• PERSON_ID — the student to whom the advanced standing applies.
• AV_STND_UNIT_LVL_ID — the primary key of the underlying base record.
• AUTHORISING_PERSON_ID, COMMENTS, CRS_GROUP_IND — authorisation, free-text, and grouping indicator attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

The primary use case is reporting granted advanced standing credit by level for a student or cohort. A typical query filters on PERSON_ID and UNIT_LEVEL, and aggregates CREDIT_POINTS:

• List granted credit per unit level: SELECT person_id, adv_stnd_unit_level, unit_level_mark, SUM(credit_points) FROM igsbv_av_adv_stnd_unit_level GROUP BY person_id, adv_stnd_unit_level, unit_level_mark;
• Audit lifecycle status: SELECT person_id, " _LA:ASUL_GRANTING_STATUS", granted_dt, expiry_dt FROM igsbv_av_adv_stnd_unit_level WHERE granted_dt IS NOT NULL;
• Identification of expired or revoked standing: SELECT * FROM igsbv_av_adv_stnd_unit_level WHERE expiry_dt < SYSDATE OR revoked_dt IS NOT NULL;

Because the view is READ ONLY, all such queries are safe for concurrent reporting. Note that the quoted status column must be referenced with the exact mixed-case alias and that no ORG_ID filtering is available at the view layer; multi-org restriction must be handled in the calling context.