Results for “total_exmptn_approved”

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

Overview

IGS_AV_ADV_STANDING is an APPS-owned view within the Oracle E-Business Suite Student System (IGS) product family. It exposes advanced standing and exemption data recorded against a student or person record, filtered by the Multi-Org security model. The view is defined over the IGS_AV_ADV_STANDING_ALL table, the multi-org enabled base table that stores advanced standing awards, exemption approvals, and granted exemption credit associated with prior learning or external qualifications.

The name prefix "AV" reflects the Advanced Standing function, which evaluates and records exemptions a student has been awarded on the basis of previous study at another institution. The view presents approved exemption totals, granted exemption totals, and the derived percentage of exemption granted, together with the awarding institution. It carries the standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) plus ROW_ID, the ROWID pseudo-column, which supports updateable-view and DML integration scenarios.

Because the view applies an ORG_ID filter based on the USERENV('CLIENT_INFO') session attribute, it returns only the operating unit context of the current session. This makes it suitable for concurrent programs, forms-based inquiries, and reports that must respect Multi-Org access control, rather than for cross-org bulk extracts.

Underlying Base Objects

The only documented base object is IGS_AV_ADV_STANDING_ALL. The view is a thin projection: it selects every column of the base table without joins, aggregation, or transformation other than the addition of ROW_ID and the Multi-Org predicate.

The Multi-Org predicate compares the ORG_ID of each row to the organization derived from the first ten characters of USERENV('CLIENT_INFO'). When the first character of CLIENT_INFO is a space, the decoded value is NULL; the NVL chains fall back to -99. This pattern is the standard EBS "secure organization" filter and confirms that IGS_AV_ADV_STANDING_ALL is partitioned by operating unit. The _ALL suffix on the base table reflects that it holds all organizations, while the view restricts visibility to the session's organization. In Oracle EBS 12.1.1 and 12.2.2 the same view text applies; it is not affected by the 12.2 online patching editioning changes because it is a view, not a table.

Key Columns

• ROW_ID — the base-table ROWID, used as a unique row identifier and for updateable-view integration.
• ORG_ID — operating unit that owns the advanced standing record; drives the Multi-Org filter.
• PERSON_ID — the student or person to whom the advanced standing applies.
• COURSE_CD — the course for which exemption credit is being recorded.
• VERSION_NUMBER — the course version to which the standing relates.
• TOTAL_EXMPTN_APPROVED — the total exemption amount approved for the person and course. This is the column users most commonly reference when searching for "total_exmptn_approved".
• TOTAL_EXMPTN_GRANTED — the total exemption actually granted, which may differ from the approved figure where approval and grant are separate workflow steps.
• TOTAL_EXMPTN_PERC_GRNTD — the granted exemption expressed as a percentage, typically of the total course requirement.
• EXEMPTION_INSTITUTION_CD — code of the external institution at which the prior study was completed.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN for change tracking.

Common Use Cases and Queries

Typical uses include exemption approval reports, articulation and credit-transfer audits, and reconciliation between approved and granted exemption totals. A simple query by person is:

SELECT person_id, course_cd, version_number, total_exmptn_approved, total_exmptn_granted, total_exmptn_perc_grntd, exemption_institution_cd FROM apps.igs_av_adv_standing WHERE person_id = :person_id;

To compare approved against granted exemptions and identify discrepancies:

SELECT person_id, course_cd, total_exmptn_approved, total_exmptn_granted, (total_exmptn_approved - total_exmptn_granted) variance FROM apps.igs_av_adv_standing WHERE total_exmptn_approved <> total_exmptn_granted;

Because the view is Multi-Org filtered, the query returns only rows for the operating unit set in the session CLIENT_INFO. Reports requiring all organizations must query IGS_AV_ADV_STANDING_ALL directly, subject to the appropriate org security, or initialize the MO session context before calling the view.