Results for “igs_en_atd_type_all_pk”

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

Overview

IGS_EN_ATD_TYPE_ALL is a foundational reference table in the Oracle EBS IGS — Student System product family. It describes the available university program attendance types (for example, full-time, part-time, or other institutionally defined load categories). Each row represents a valid attendance type that can be assigned to applicants, students, program enrollments, fee assessments, and regulatory reporting records throughout the student lifecycle.

The table is owned by the IGS schema and is classified as VALID in the ETRM metadata for both 12.1.1 and 12.2.2. From a heuristic Data Vault modeling perspective, the metadata identifies this object as hub-leaning. This classification is a modeling suggestion only: the table behaves as a business-key hub because it holds a stable, uniquely identifiable reference list (ATTENDANCE_TYPE) that is referenced by a large number of dependent tables as a foreign key.

Key Information Stored

The table contains 13 documented columns. The most significant are:

• ATTENDANCE_TYPE — The primary business key and the column referenced by nearly every child table. It is enforced by the primary key IGS_EN_ATD_TYPE_ALL_PK and by the unique index IGS_EN_ATD_TYPE_ALL_U1, making it the singular unique business-key candidate.
• DESCRIPTION — The human-readable name of the attendance type.
• GOVT_ATTENDANCE_TYPE — The value mapped to government or regulatory reporting categories.
• LOWER_ENR_LOAD_RANGE and UPPER_ENR_LOAD_RANGE — The enrollment load boundaries that define the attendance type.
• RESEARCH_PERCENTAGE — Load or effort attributable to research activity.
• CLOSED_IND — A flag indicating whether the attendance type is inactive or unavailable for new assignments.
• ORG_ID — The operating unit context, supporting multi-organization (partitioned) data access.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

No separate surrogate numeric key is documented; ATTENDANCE_TYPE functions as both the business key and the primary key. Note that the table name carries the _ALL suffix, indicating it may be partitioned by ORG_ID, so queries should be scoped carefully in multi-org environments.

Common Use Cases and Queries

Because so many downstream tables reference ATTENDANCE_TYPE, this table is frequently joined to resolve descriptive labels in student records, fee assessments, prospects, and 1098-T reporting.

A typical lookup pattern:

• SELECT attendance_type, description FROM igs_en_atd_type_all WHERE closed_ind = 'N' ORDER BY description;
• Joining to student attendance history: SELECT a.attendance_type, t.description FROM igs_re_cdt_att_hist_all a JOIN igs_en_atd_type_all t ON t.attendance_type = a.attendance_type;
• Resolving fee assessment rates: join IGS_FI_FEE_AS_RATE or IGS_FI_FEE_AS_RT on ATTENDANCE_TYPE to label fee schedules by load category.
• Financial aid reporting via IGF_AP_FA_ANT_DATA (the object a user searching igf_ap_fa_ant_data may be tracing), which references this table through ATTENDANCE_TYPE.

Related Objects

The metadata documents a broad set of foreign-key relationships. The most significant referencing objects include:

• IGS_AD_PS_APPL_INST_ALL — via ATTENDANCE_TYPE (applicant institution data).
• IGS_PS_OFR_OPT_ALL — via ATTENDANCE_TYPE (program offering options).
• IGS_RE_CDT_ATT_HIST_ALL — via ATTENDANCE_TYPE (student attendance history).
• IGS_FI_FEE_AS_RATE — via ATTENDANCE_TYPE (fee assessment rates).
• IGF_AP_FA_ANT_DATA — via ATTENDANCE_TYPE (financial aid anticipated data).
• IGS_FI_1098T_ATS — via ATTENDANCE_TYPE (1098-T tax reporting).
• IGS_PR_RU_OU_ALL and IGS_PR_OU_TYPE_ALL — via restricted attendance type columns.

In total, more than twenty tables reference this hub, confirming its role as a central reference object in the Student System data model.