Results for “igs_av_stnd_unit_all”

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

Overview

IGS_AV_STND_UNIT_ALL is a Student System (IGS) table that records individual units granted to a student as advanced standing. In Oracle EBS 12.1.1 and 12.2.2, it functions as the unit-level detail behind the advanced standing header held in IGS_AV_ADV_STANDING_ALL. Where the header captures the overall advanced standing award for a person against a course and version, this table captures each unit recognized within that award, including the grading outcome, credit awarded, exemption institution, and the lifecycle dates of the grant.

The object carries the legacy "IGS - Student System (Obsolete)" product designation and is documented in ETRM 12.1.1 as "Not implemented in this database," meaning the table definition is catalogued but the object is not deployed in the reference environment. It remains relevant to historical data models and to environments where the Student System was previously installed. The documented physical schema lists 41 columns owned by IGS.

The heuristic Data Vault classification derived from the foreign key structure is satellite-leaning. In modeling terms, the table behaves as a satellite attached to an advanced standing hub or link keyed by PERSON_ID, AS_COURSE_CD, and AS_VERSION_NUMBER, with the AV_STND_UNIT_ID surrogate serving as its own row identifier. This classification is a suggestion rather than a documented Oracle construct.

Key Information Stored

The table's surrogate primary key is AV_STND_UNIT_ID, enforced by the IGS_AV_STND_UNIT_PK constraint and the IGS_AV_STND_UNIT_ALL_U1 unique index. A second unique index, IGS_AV_STND_UNIT_ALL_U3, defines the business key candidate over PERSON_ID, AS_COURSE_CD, AS_VERSION_NUMBER, S_ADV_STND_TYPE, UNIT_CD, VERSION_NUMBER, EXEMPTION_INSTITUTION_CD, UNIT_DETAILS_ID, and TST_RSLT_DTLS_ID. The most significant columns are:

• AV_STND_UNIT_ID — surrogate primary key for the granted-unit record.
• PERSON_ID — the student receiving the advanced standing; a business-key component and foreign key to IGS_AV_ADV_STANDING_ALL.
• AS_COURSE_CD and AS_VERSION_NUMBER — the course and version against which standing is granted.
• S_ADV_STND_TYPE — the type or category of advanced standing granted.
• UNIT_CD and VERSION_NUMBER — the unit of study being recognized, referencing IGS_PS_UNIT_VER_ALL.
• EXEMPTION_INSTITUTION_CD — the external institution from which the exemption originates.
• UNIT_DETAILS_ID and TST_RSLT_DTLS_ID — links to term unit details and test result details supporting the grant.
• S_ADV_STND_GRANTING_STATUS — status of the grant, paired with APPROVED_DT, GRANTED_DT, EXPIRY_DT, CANCELLED_DT, and REVOKED_DT for lifecycle tracking.
• GRADING_SCHEMA_CD, GRD_SCH_VERSION_NUMBER, and GRADE — the grading context and awarded grade.
• CREDIT_PERCENTAGE and ACHIEVABLE_CREDIT_POINTS — the credit value recognized.
• S_ADV_STND_RECOGNITION_TYPE — the recognition basis for the standing.
• ORG_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard multi-org and audit columns.

Common Use Cases and Queries

Reporting scenarios include verifying unit-level advanced standing for a student, reconciling credit awarded against program requirements, and auditing exemptions granted by external institutions. A representative query retrieves granted units for a person and course:

• SELECT av.AV_STND_UNIT_ID, av.UNIT_CD, av.VERSION_NUMBER, av.GRADE, av.CREDIT_PERCENTAGE, av.S_ADV_STND_GRANTING_STATUS FROM IGS_AV_STND_UNIT_ALL av WHERE av.PERSON_ID = :person_id AND av.AS_COURSE_CD = :course_cd AND av.AS_VERSION_NUMBER = :version_number;
• Joining to the header IGS_AV_ADV_STANDING_ALL on PERSON_ID, AS_COURSE_CD, and AS_VERSION_NUMBER produces a full award-plus-unit view for transcript or progression analysis.
• Aggregating ACHIEVABLE_CREDIT_POINTS by EXEMPTION_INSTITUTION_CD supports institutional exemption reporting.

Because the object is marked obsolete and not implemented, queries should be validated against the actual deployment before use in production reports.

Related Objects

The table participates in a well-defined network of foreign keys:

• IGS_AV_ADV_STANDING_ALL — parent header, joined on PERSON_ID, AS_COURSE_CD, AS_VERSION_NUMBER, and EXEMPTION_INSTITUTION_CD.
• IGS_AS_GRD_SCH_GRADE — grading schema and grade validation, joined on GRADING_SCHEMA_CD, GRD_SCH_VERSION_NUMBER, and GRADE.
• IGS_AD_TST_RSLT_DTLS — joined on TST_RSLT_DTLS_ID.
• IGS_AD_TERM_UNITDTLS — joined on UNIT_DETAILS_ID.
• IGS_PS_UNIT_VER_ALL — unit catalog, joined on UNIT_CD and VERSION_NUMBER.
• IGS_AD_TEST_SEGMENTS — joined on TEST_SEGMENT_ID.
• IGS_DA_DETAILS — joined on DEG_AUD_DETAIL_ID.
• Child tables IGS_AV_STND_ALT_UNIT, IGS_AV_UNT_REF_CDS, and IGS_AV_STD_UNT_BASIS_ALL reference this table via AV_STND_UNIT_ID.