Search Results igs_rc_i_e_testtyps

Overview

The table IGS_RC_I_E_TESTTYPS is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. It functions as a junction or mapping table, establishing a critical business rule between an applicant's inquiry or entry status and the specific types of admission tests that may be required or relevant at that stage of the application lifecycle. Its primary role is to enforce and maintain the valid combinations of entry statuses and test types, ensuring data integrity and supporting the automated processes for managing applicant testing requirements within the recruitment and admissions workflow.

Key Information Stored

The table's structure is designed to manage the relationship between two key entities. The column INQ_ENTRY_STAT_ID is a foreign key that identifies a specific entry status from the IGS_RC_I_ENT_STATS table. The column ADMISSION_TEST_TYPE is a foreign key that identifies a specific type of admission test defined in the IGS_AD_TEST_TYPE table. The table's primary key is the surrogate key ENT_TEST_TYPE_ID, which uniquely identifies each mapping record. A unique key constraint on the combination of INQ_ENTRY_STAT_ID and ADMISSION_TEST_TYPE ensures that no duplicate status-test type relationships are created.

Common Use Cases and Queries

A primary use case is the validation and presentation of available test types during data entry or process automation when an applicant's entry status is updated. For instance, a concurrent program or form logic would query this table to determine which tests can be scheduled or are mandatory for an applicant in a "Provisional Admission" status. A typical reporting query might join this table to its parent tables to list all test type requirements associated with various entry statuses:

• SELECT estat.entry_status_code, atype.test_type_code, atype.description FROM igs_rc_i_e_testtyps map, igs_rc_i_ent_stats estat, igs_ad_test_type atype WHERE map.inq_entry_stat_id = estat.inq_entry_stat_id AND map.admission_test_type = atype.admission_test_type ORDER BY estat.entry_status_code;

Administrative use cases include the setup and maintenance of these relationships through the application's front-end, ensuring the testing workflow aligns with institutional policy.

Related Objects

IGS_RC_I_E_TESTTYPS has defined foreign key relationships with two fundamental tables in the Student System, as documented in the ETRM metadata:

• IGS_RC_I_ENT_STATS: This table stores the definitions of various inquiry and application entry statuses (e.g., "Inquiry Received," "Application Submitted"). The relationship is established via the column IGS_RC_I_E_TESTTYPS.INQ_ENTRY_STAT_ID referencing IGS_RC_I_ENT_STATS.
• IGS_AD_TEST_TYPE: This table is the master list of all admission tests (e.g., SAT, Subject Test, Entrance Exam). The relationship is established via the column IGS_RC_I_E_TESTTYPS.ADMISSION_TEST_TYPE referencing IGS_AD_TEST_TYPE.

These relationships are central to the table's purpose, as it exists solely to define the permissible links between records in these two parent entities.