Search Results igs_ad_tac_ausced_as_u1

Overview

The IGS.IGS_AD_TAC_AUSCED_AS table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the IGS (iGrad Student) product family, which manages tertiary education processes. It functions as a master list of valid assessment types for Australian secondary education, as defined and used by Tertiary Admissions Centers (TACs). Its primary role is to maintain a controlled, standardized set of codes that classify the various types of secondary education assessments (e.g., final year scores, subject rankings) accepted during the student admissions lifecycle. This ensures data integrity and consistency when recording and processing applicant educational history within the system.

Key Information Stored

The table stores a concise set of attributes for each assessment type. The primary and most critical column is TAC_AUS_SCNDRY_EDU_ASS_TYPE, a 10-character VARCHAR2 code that uniquely identifies the assessment type. The DESCRIPTION column (VARCHAR2(60)) provides the human-readable explanation for the code. A significant control column is CLOSED_IND (VARCHAR2(1)), which acts as an active/inactive flag; setting it to 'Y' prevents the code from being used in new transactional records while preserving referential integrity for historical data. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing purposes.

Common Use Cases and Queries

This table is primarily used in two contexts: setup/maintenance and operational reporting. Administrators use it to configure the list of acceptable Australian secondary education assessment types within the application. For operational staff and reports, it provides the descriptive labels for codes stored in transactional tables. A common query retrieves all active assessment types for use in a lookup or validation list:

• SELECT TAC_AUS_SCNDRY_EDU_ASS_TYPE, DESCRIPTION FROM IGS.IGS_AD_TAC_AUSCED_AS WHERE NVL(CLOSED_IND, 'N') = 'N' ORDER BY 1;

Another frequent use case is joining this table to transactional data to generate meaningful reports on applicant backgrounds. The base query for extracting all data from the table, as per the ETRM, is:

• SELECT TAC_AUS_SCNDRY_EDU_ASS_TYPE, DESCRIPTION, CLOSED_IND, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGS.IGS_AD_TAC_AUSCED_AS;

Related Objects

Based on the provided relationship data, IGS_AD_TAC_AUSCED_AS serves as a parent reference table in a key foreign key relationship. Its primary key column, TAC_AUS_SCNDRY_EDU_ASS_TYPE, is referenced by the IGS_AD_AUSE_ED_AS_TY table. This indicates that transactional records storing Australian secondary education assessment details for applicants (likely in IGS_AD_AUSE_ED_AS_TY) must use a value defined in this master table. There are no dependencies where this table references other objects, confirming its role as a standalone source of reference data. The unique index IGS_AD_TAC_AUSCED_AS_U1 on the TAC_AUS_SCNDRY_EDU_ASS_TYPE column enforces the primary key constraint.