Results for “adv_stand_unit_code”

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

Overview

IGSBV_AV_ADV_STND_UNIT is a read-only view owned by the APPS schema in the Oracle E-Business Suite Student System (product group IGS). It describes a unit granted to a student as advanced standing — that is, academic credit or exemption awarded for prior learning, external qualifications, or equivalent study rather than for attendance in the current program. In ETRM the object is registered under the title "View: IGSBV_AV_ADV_STND_UNIT" with status VALID, and its implementation text is a single SELECT statement terminated by the WITH READ ONLY clause, which guarantees that no DML can be issued against the view through this interface.

The leading "BV" convention identifies this as a business view intended for reporting, inquiry, and integration consumers rather than for transactional maintenance. For a user searching on adv_standing_type, this view is the exposure point that surfaces the advanced-standing classification alongside the unit, institution, credit, and approval information required for student-record reporting.

Underlying Base Objects

The view is defined exclusively over IGS_AV_STND_UNIT_ALL, aliased ASU in the view text. No other base tables or views are documented as referenced in the ETRM metadata. The _ALL suffix on the base table indicates that the underlying table is partitioned by operating unit or a similar multi-tenant discriminator; the view does not filter on that column, so all rows visible to the querying responsibility are exposed. Lookups are not resolved through joins: the view carries two literal instructional expressions, '_LA:ASU.S_ADV_STND_RECOGNITION_TYPE:IGS_LOOKUP_VALUES:ADV_STND_RECOGNITION_TYPE:MEANING' and '_LA:ASU.S_ADV_STND_GRANTING_STATUS:IGS_LOOKUP_VALUES:ADV_STND_GRANTING_STATUS:MEANING', which indicate to the Oracle Forms/report client that the meaning of these coded columns should be derived from the IGS_LOOKUP_VALUES table using the corresponding lookup types.

Key Columns

The view projects the full column list of the base table apart from the credit percentage, which is deliberately nulled out in the view text and therefore always returns NULL.

• PROGRAM_CODE / PROGRAM_VERSION_NUMBER — sourced from AS_COURSE_CD and AS_VERSION_NUMBER; identify the program to which the advanced standing applies.
• ADV_STANDING_TYPE — sourced from S_ADV_STND_TYPE; the classification of the advanced standing award, and the column most directly relevant to the adv_standing_type search term.
• ADV_STAND_UNIT_CODE / ADV_STAND_UNIT_VERSION_NUMBER — the unit for which credit is granted and its version.
• EXEMPTION_INSTITUTION_CODE — the external or internal institution at which the equivalent study was undertaken.
• CREDIT_PERCENTAGE / CREDIT_POINTS — percentage is not populated (NULL literal); ACHIEVABLE_CREDIT_POINTS is exposed as CREDIT_POINTS.
• "_LA:ADV_STND_RECOGNITION_TYP" / "_LA:ASU_UNIT_GRANTING_STATUS" — descriptive lookup columns for recognition type and granting status.
• APPROVED_DT, GRANTED_DT, EXPIRY_DT, CANCELLED_DT, REVOKED_DT — the lifecycle dates of the award; CANCELLED_DT and REVOKED_DT discriminate withdrawn awards from active ones.
• PERSON_ID, UNIT_DETAILS_ID, TST_RSLT_DTLS_ID, DEG_AUD_DETAIL_ID, AUTHORISING_PERSON_ID — foreign-key style identifiers linking the award to the student, unit details, test results, degree audit, and the authorising officer.
• Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical consumers are student-record extracts, credit-award audits, and regulatory returns enumerating exemptions granted to a cohort.

• List active advanced standing for a student: SELECT adv_standing_type, adv_stand_unit_code, granted_dt FROM igsbv_av_adv_stnd_unit WHERE person_id = :p_person_id AND revoked_dt IS NULL AND cancelled_dt IS NULL;
• Summarise awards by type: SELECT adv_standing_type, COUNT(*) FROM igsbv_av_adv_stnd_unit GROUP BY adv_standing_type;
• Find awards sourced from external institutions: SELECT person_id, exemption_institution_code, adv_stand_unit_code FROM igsbv_av_adv_stnd_unit WHERE exemption_institution_code IS NOT NULL;

Because CREDIT_PERCENTAGE returns NULL, reports requiring that value must read the base table directly. All access should be treated as read-only.