Results for “unit_pts_earn_achieved”
3 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_DA_OUT_UNT_EN is a table within the IGS (Student System) product family of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. The object belongs to a module that Oracle has classified as obsolete, and the ETRM metadata records it as "Not implemented in this database," meaning that in a standard installation the physical table is not created. Its documented purpose is to store the outgoing Enrollment units for a student within a Degree Audit Request. In functional terms, the table captures the enrollment unit records that are extracted from the student system and exported to an external degree audit engine, so that an external evaluation of a student's academic progress can be performed against the institution's program requirements.
From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. The table is keyed primarily by an association rather than by a standalone business entity, and it carries a wide set of descriptive, context-bearing attributes. This suggests it is best modeled as a satellite attached to a parent link or hub representing the degree audit request for a student, rather than as an independent hub in its own right.
Key Information Stored
The physical schema documented for 12.1.1 records 88 columns owned by the IGS schema. The primary key is IGS_DA_OUT_UNT_EN_PK, composed of BATCH_ID, PERSON_ID, and UNIT_SEQ_NUM. A unique index, IGS_DA_OUT_UNT_EN_U1, is defined on the identical column set, making it the documented business-key candidate for the row.
- BATCH_ID, PERSON_ID, UNIT_SEQ_NUM — the composite identifier: the degree audit batch, the student, and the sequence number of the unit within the batch.
- HOME_INST_ID, HOME_INST_ALT_ID — the home institution of the student and its alternate identifier.
- UNIT_INSITUTION_ID, ALT_INSTITUTION_ID — the institution that delivered the unit, with alternate identifier.
- TEACHING_PERIOD, UNIT_CODE, UNIT_VERSION — the academic period of study and the coded identity and version of the unit.
- UNIT_TITLE, SHORT_TITLE, UNIT_LEVEL, UNIT_CLASS — descriptive attributes of the unit, including its level and classification.
- UNIT_ATTEMPT_STATUS, UNIT_GRADE, UNIT_MARK, GRADING_SCHEMA — the outcome of the attempt, including the grade awarded and the grading schema under which it was assessed.
- UNIT_CREDIT_PTS, ACHIEVABLE_CRED_PTS, UNIT_PTS_EARN_ACHIEVED — credit point values for the unit, the points achievable, and the points actually earned.
- EQUIV_FULL_STUDENT_UNIT, OVERRIDE_EFTSU — the equivalent full-time student unit load and any overriding value.
- REPEAT_IND and the REP_MAX_* columns — repeat attempt indicators and maximum repeat allowances.
- AWARD_PROG_IND — indicates whether the unit counts toward an award program.
- BASIC_UNIT_DET1–20, UNIT_SEC_DET1–20 — two sets of twenty generic detail columns for institution-specific attributes.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
Common Use Cases and Queries
The primary use case is extracting a student's enrollment history for transmission to an external degree audit processor. A typical query retrieves all outgoing units for a given batch and person:
SELECT BATCH_ID, PERSON_ID, UNIT_SEQ_NUM, UNIT_CODE, UNIT_TITLE,
UNIT_GRADE, UNIT_CREDIT_PTS, UNIT_PTS_EARN_ACHIEVED
FROM IGS_DA_OUT_UNT_EN
WHERE BATCH_ID = :batch_id
AND PERSON_ID = :person_id
ORDER BY UNIT_SEQ_NUM;
Reporting scenarios include totalling earned credit points per student per period, identifying units flagged as repeat attempts, and reconciling achievable against earned points for a batch. Joining to IGS_DA_REQ_STDNTS on BATCH_ID and PERSON_ID restricts the result set to students actually registered within the degree audit request. Because the table is documented as not implemented, any such statement should be validated against the actual installation before deployment.
Related Objects
The documented foreign key relationship is the principal dependency. IGS_DA_OUT_UNT_EN.BATCH_ID and PERSON_ID together reference IGS_DA_REQ_STDNTS, the table holding the degree audit request students. This parent-child relationship means the enrollment units cannot exist without the corresponding request student record. Practically, queries and reports will typically join these two tables, and the parent table should be considered required for any meaningful extraction of the outgoing unit data. Beyond this documented relationship, other objects in the IGS degree audit area — such as incoming unit tables and the batch control records that govern the audit run — form the surrounding context in which this table operates.
-
Storage for the outgoing Enrollment units for the student in the Degree Audit Request
-
TABLE: IGS.IGS_DA_OUT_UNT_EN 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.