Results for “igs_re_cdt_att_hist_all”

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

Overview

The IGS_RE_CDT_ATT_HIST_ALL table belongs to the IGS product family (Student System) within Oracle E-Business Suite and is documented for releases 12.1.1 and 12.2.2. Its purpose is to record the history of attendance for a research student across the full duration of their candidature. Each record captures both the attendance type and the attendance percentage applicable during a defined historical window, allowing the institution to maintain a consolidated, time-stamped view of how a candidate's attendance status evolved over time.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying this object as a link. It sits between a research candidature and an attendance type, resolving the many-to-many relationship between candidates and attendance classifications while also carrying descriptive history attributes. Note that the ETRM metadata explicitly states the table is "Not implemented in this database" for the reference environment, so it should be treated as an obsolete or reference-only object in the shipping product. Its logical definition, however, remains valuable for understanding the IGS research-tracking data model.

Key Information Stored

The table contains 13 documented columns. The most significant are summarized below.

• PERSON_ID — Identifies the research student (candidate). Part of the composite primary key and a foreign key to IGS_RE_CANDIDATURE_ALL.
• CA_SEQUENCE_NUMBER — The candidature sequence number, tying the attendance record to a specific candidature span. Part of the primary key and part of the candidature foreign key.
• SEQUENCE_NUMBER — A per-candidate history sequence, giving each attendance-history row a unique ordering within the candidature. Together with the two columns above it forms the primary key.
• HIST_START_DT and HIST_END_DT — The effective date boundaries for which the recorded attendance type and percentage applied.
• ATTENDANCE_TYPE — The nature of attendance recorded for the period; a foreign key to IGS_EN_ATD_TYPE_ALL.
• ATTENDANCE_PERCENTAGE — The numeric percentage of attendance for that period, enabling consolidated reporting of attendance behavior.
• ORG_ID — The operating unit column, indicating multi-org (business group) partitioning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last amended each row and when.

The surrogate primary key is IGS_RE_CDT_ATT_HIST_PK, defined over (PERSON_ID, CA_SEQUENCE_NUMBER, SEQUENCE_NUMBER). A unique index, IGS_RE_CDT_ATT_HIST_ALL_U1, covers the same three columns, making them the documented business-key candidate.

Common Use Cases and Queries

Typical usage centers on research-candidate reporting: reconstructing a candidate's attendance timeline, measuring attendance percentages over a candidature, and auditing changes against attendance-type classifications.

• Latest attendance snapshot per candidate. Use a correlated subquery or analytic function to pick the row with the maximum SEQUENCE_NUMBER (or the latest HIST_START_DT) per PERSON_ID and CA_SEQUENCE_NUMBER.
• Attendance timeline. Select HIST_START_DT, HIST_END_DT, ATTENDANCE_TYPE and ATTENDANCE_PERCENTAGE ordered by SEQUENCE_NUMBER to display the full history for one candidature.
• Attendance-type distribution. Join ATTENDANCE_TYPE to IGS_EN_ATD_TYPE_ALL to report counts and average percentages grouped by the attendance-type description.
• Multi-org filtering. Always constrain by ORG_ID in EBS reports to respect operating-unit security.

A representative pattern: SELECT h.person_id, h.ca_sequence_number, h.sequence_number, h.hist_start_dt, h.hist_end_dt, h.attendance_type, h.attendance_percentage FROM igs_re_cdt_att_hist_all h WHERE h.org_id = :org_id AND h.person_id = :person_id ORDER BY h.sequence_number;

Related Objects

• IGS_RE_CANDIDATURE_ALL — Parent of the candidate identity and candidature span; joined on PERSON_ID and CA_SEQUENCE_NUMBER.
• IGS_EN_ATD_TYPE_ALL — Attendance-type reference; joined on ATTENDANCE_TYPE to translate codes into descriptions.
• IGS_RE_CDT_ATT_HIST_PK — Primary-key constraint over PERSON_ID, CA_SEQUENCE_NUMBER, SEQUENCE_NUMBER.
• IGS_RE_CDT_ATT_HIST_ALL_U1 — Unique index confirming the same three columns as the business key.
• Student System (IGS) research entity and API layer — Any packaged APIs or concurrent programs that maintain candidature attendance would depend on this table; however, because it is documented as not implemented, confirm actual occupancy in a given 12.1.1 or 12.2.2 instance before relying on it.