Search Results igs_ad_ause_ed_as_ty

Overview

The table IGS_AD_AUSE_ED_AS_TY is a core reference table within the Oracle E-Business Suite Student System (IGS) module, specifically supporting admissions functionality. Its primary role is to define and maintain user-defined assessment types for secondary education within the Australian educational context. This table acts as a master list of valid assessment types, such as final exams, coursework, or practical assessments, which are used to categorize and evaluate an applicant's secondary education records. By centralizing these definitions, the table ensures data integrity and consistency across the admissions process, enabling accurate evaluation of academic backgrounds against institutional requirements in releases 12.1.1 and 12.2.2.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the structure is defined by its primary and foreign key relationships. The central column is AUS_SCNDRY_EDU_ASS_TYPE, which serves as the primary key. This column stores the unique code or identifier for each user-defined secondary education assessment type. The table's description confirms it holds descriptive information for these types, implying the likely presence of columns for a description, effective dates, and potentially an inactive indicator. The foreign key column TAC_AUS_SCNDRY_EDU_ASS_TYPE links to tertiary admissions center data, suggesting the table may also store mapping information to external standardized codes.

Common Use Cases and Queries

This table is primarily referenced in scenarios involving the setup and processing of applicant secondary education history. Common use cases include the configuration of valid assessment types during system implementation, the validation of assessment data entered against an applicant's academic record, and reporting on applicant qualifications by assessment type. A typical query would involve joining this table to related transactional data to retrieve descriptive information.

• Retrieving All Active Assessment Types: SELECT aus_scndry_edu_ass_type, description FROM igs_ad_ause_ed_as_ty WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
• Validating an Applicant's Record: SELECT s.* FROM igs_ad_aus_sec_edu s, igs_ad_ause_ed_as_ty t WHERE s.aus_scndry_edu_ass_type = t.aus_scndry_edu_ass_type AND s.person_id = :p_person_id;

Related Objects

The IGS_AD_AUSE_ED_AS_TY table is integral to the data model, with documented relationships to several other key tables. Its primary key is referenced as a foreign key in multiple transactional tables, establishing its role as a parent reference entity.

• Referenced by this table (Outgoing FK): The column TAC_AUS_SCNDRY_EDU_ASS_TYPE references the IGS_AD_TAC_AUSCED_AS table, linking user-defined types to Tertiary Admissions Centre (TAC) definitions.
• References this table (Incoming FKs):
  • IGS_AD_AUS_SEC_EDU via column AUS_SCNDRY_EDU_ASS_TYPE: This is the primary transactional table storing an applicant's secondary education details.
  • IGS_AS_TYPGOV_SCORMP via column SCNDRY_EDU_ASS_TYPE: Likely relates assessment types to scoring components or government reporting.
  • IGS_AD_AUS_SEC_ED_SU via column SUBJECT_ASS_TYPE: Associates assessment types with specific subjects within secondary education.