Results for “igs_da_out_unt_as”

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

Overview

IGS_DA_OUT_UNT_AS is a table in the IGS — Student System product of Oracle E-Business Suite (available in both 12.1.1 and 12.2.2). It stores outgoing Advanced Standing information for a student within the context of a Degree Audit Request. Advanced Standing represents academic credit, exemptions, or unit-level awards granted to a student—typically on the basis of prior learning, transfer credit, or institutional exemptions—that must be communicated to the Degree Audit processing engine so that awarded units are correctly reflected against program requirements.

The table is owned by the IGS schema and is documented with 72 columns. Under a heuristic Data Vault classification mined from its foreign-key structure, the table is satellite-leaning: it holds descriptive, attribute-rich payload (unit titles, grades, credit points, approval and expiry dates) keyed against a parent request-student relationship, rather than acting as a pure hub or link. This is a modeling suggestion, not an enforced architectural constraint.

Key Information Stored

The physical primary key is IGS_DA_OUT_UNT_AS_PK, defined over the composite columns BATCH_ID, PERSON_ID, and UNIT_SEQ_NUM. The unique index IGS_DA_OUT_UNT_AS_U1 carries the same three columns, making this composite the business-key candidate that uniquely identifies each advanced-standing unit record within a degree audit batch for a given student.

The most significant columns include:

• BATCH_ID — identifies the Degree Audit request batch; part of the PK and the FK to the parent student row.
• PERSON_ID — the student (person) for whom the advanced standing is recorded; part of the PK.
• UNIT_SEQ_NUM — sequence number distinguishing multiple advanced-standing units within the same batch/person.
• UNIT_CODE, UNIT_VERSION, UNIT_TITLE — the awarded unit and its descriptive title.
• ADV_STAND_TYPE, ADV_STAND_GRANT_STAT, ADV_STAND_UNIT_LVL — classification, grant status, and level of the advanced standing.
• UNIT_GRADE, GRADING_SCHEMA, GPA_PTS, QUALITY_PTS_EARNED — grading and point outcomes.
• UNIT_CREDIT_SIGN, LECT_CREDIT_PTS, LAB_CREDIT_PTS, CONTIN_EDU_UNITS, OTHER_CREDIT_PTS — credit components contributing to the award.
• ADV_STAND_UNIT_APPR_DATE, ADV_STAND_UNIT_EXP_DATE, ADV_STAND_UNIT_GRNT_DATE — approval, expiry, and grant dates.
• SRC_UNIT_INSTITUTION_ID, SRC_UNIT_CODE, SRC_UNIT_TITLE — the source (originating) unit and institution.
• TERM_PERIOD and the standard ATTRIBUTE1–20 / audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE).

Common Use Cases and Queries

Typical uses include degree audit processing, transfer-credit reporting, and reconciliation of awarded advanced standing against source institutions. A common pattern joins the satellite back to its parent request-student row:

• Listing all advanced-standing units for a batch/student:
  SELECT * FROM igs_da_out_unt_as WHERE batch_id = :b AND person_id = :p;
• Joining to the parent to retrieve request context:
  SELECT o.unit_code, o.unit_title, o.adv_stand_grant_stat FROM igs_da_out_unt_as o, igs_da_req_stdnts s WHERE o.batch_id = s.batch_id AND o.person_id = s.person_id;
• Filtering by grant status or approval date for audit reporting, and aggregating credit points by student.

Related Objects

The primary relationship is defined by the foreign key on BATCH_ID and PERSON_ID pointing to IGS_DA_REQ_STDNTS, the parent request-student table. Reporting and integration objects include the Degree Audit request and processing tables in the IGS schema, the student/person tables referenced by PERSON_ID, and institution and unit catalog objects referenced by the source-unit and institution columns. Standard EBS concurrency and audit handling applies through LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.