Results for “elo_description”
21 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGS_EN_SU_ATTEMPT_H_ALL table, residing in the IGS schema and belonging to the Oracle Student System (IGS) product family, is a history (audit) table that records changes made to a student's unit attempt throughout its lifecycle. Where IGS_EN_SU_ATTEMPT_ALL stores the current state of a student's attempt at a unit of study, IGS_EN_SU_ATTEMPT_H_ALL preserves prior and successive versions of that record, capturing changes to status, location, class, assessment method, and other enrollment attributes. In Oracle EBS 12.1.1 it is documented with 52 columns; the structure is retained in 12.2.2 as part of the same product schema.
From a Data Vault modeling perspective, the mined FK structure classifies this object heuristically as a link, since it associates business entities (person, course, unit offering option) rather than functioning as a pure hub or satellite. This classification is a modeling suggestion only and should be validated against the actual enrollment reporting requirements of the institution.
Key Information Stored
The primary key is documented as IGS_AS_SU_ATTEMPT_H_ALL_PK, composed of PERSON_ID, COURSE_CD, UNIT_CD, HIST_START_DT, CAL_TYPE, and CI_SEQUENCE_NUMBER. Note that a unique index, IGS_EN_SU_ATTEMPT_H_ALL_PK, is documented with a different column set: PERSON_ID, COURSE_CD, UOO_ID, and HIST_START_DT. These business-key candidates uniquely identify a historical version of a unit attempt; the HIST_START_DT column is the effective-dating discriminator that separates versions. The most significant columns include:
- PERSON_ID – identifies the student (party) to whom the unit attempt belongs; part of the primary key and an FK to IGS_EN_SU_ATTEMPT_ALL and IGS_EN_STDNT_PS_ATT_ALL.
- COURSE_CD – the course of study under which the attempt is made.
- UNIT_CD and VERSION_NUMBER – the unit of study and its version.
- UOO_ID – the unit offering option that links the attempt to a specific teaching instance.
- HIST_START_DT / HIST_END_DT – effective-date range delimiting when this historical version was current.
- UNIT_ATTEMPT_STATUS – the status of the attempt at the point in time captured by this row.
- LOCATION_CD and UNIT_CLASS – teaching location and class group.
- ENROLLED_DT / DISCONTINUED_DT – enrollment and discontinuation dates.
- RULE_WAIVED_PERSON_ID / RULE_WAIVED_DT – who waived a rule and when; RULE_WAIVED_PERSON_ID is an FK to HZ_PARTIES.
- CAL_TYPE and CI_SEQUENCE_NUMBER – calendar type and calendar instance sequence, jointly identifying the teaching period.
- OVERRIDE_* columns (ENROLLED_CP, EFTSU, ACHIEVABLE_CP, OUTCOME_DUE_DT, CREDIT_REASON) – overridden enrollment and credit values.
Common Use Cases and Queries
The table is typically queried to reconstruct the change history of a student unit attempt, to audit status transitions, and to satisfy regulatory reporting of enrollment variations. A representative query retrieving all versions for a student and unit is:
SELECT person_id, course_cd, unit_cd, hist_start_dt, hist_end_dt,
unit_attempt_status, location_cd
FROM igs_en_su_attempt_h_all
WHERE person_id = :p_person_id
AND unit_cd = :p_unit_cd
ORDER BY hist_start_dt;
To find the currently effective version, filter on HIST_END_DT IS NULL. Reporting use cases include enrollment census reconciliation, status-change auditing, discontinuation analyses, and point-in-time enrollment extracts for government returns. Because rows are effective-dated, join to IGS_EN_SU_ATTEMPT_ALL on PERSON_ID, COURSE_CD, and UOO_ID to compare historical against current values.
Related Objects
- IGS_EN_SU_ATTEMPT_ALL – the current-state unit attempt; joined on PERSON_ID, COURSE_CD, UOO_ID.
- IGS_EN_STDNT_PS_ATT_ALL – the student program attempt; referenced via PERSON_ID.
- HZ_PARTIES – the trading community party; referenced via RULE_WAIVED_PERSON_ID for the rule waiver person.
- IGS_EN_SU_ATTEMPT_H_ALL_PK and IGS_AS_SU_ATTEMPT_H_ALL_PK – the unique index and primary key constraints that enforce version uniqueness.
- IGS_EN_SU_ATTEMPT_API (related Student System enrollment APIs) – the business interfaces that create and maintain attempt history rows.
-
This entity describes the history of changes made to a student unit attempt, including changes to status, location, class, etc.
-
Describes history of changes to student program attempt
-
View: IGS_EN_SU_ATTEMPT_H 12.1.1
IGS_EN_SU_ATTEMPT_H implements the student unit attempt.
APPS.IGS_EN_SU_ATTEMPT_H·↳ IGS_EN_SU_ATTEMPT_H_ALL·Explore IGS module →
-
View: IGS_AS_SC_ATTEMPT_H 12.1.1
This view is multi org view
APPS.IGS_AS_SC_ATTEMPT_H·↳ IGS_AS_SC_ATTEMPT_H_ALL·Explore IGS module →
-
View: IGS_EN_SU_ATTEMPT_H 12.2.2
IGS_EN_SU_ATTEMPT_H implements the student unit attempt.
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_SC_ATTEMPT_H 12.2.2
This view is multi org view
Not implemented in this database·Explore IGS module →
-
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'.