Results for “igr_i_e_testtyps”
22 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGR_I_E_TESTTYPS is an Oracle E-Business Suite table owned by the IGS schema and delivered as part of the Student System (IGS) product family. It stores the test types that correspond to inquiry entry statuses within the student recruitment and admissions pipeline. In EBS 12.1.1 and 12.2.2 the table sits behind the inquiry and applicant entry configuration flows, where an institution defines which admission tests are valid for a given inquiry type and entry status combination.
From a Data Vault modeling perspective, the mined relationship metadata suggests classifying IGR_I_E_TESTTYPS as a link. The heuristic classification derives from its foreign key structure: the table does not merely extend a single parent hub but instead resolves relationships between inquiry type definitions and admission test type definitions. Its unique index on INQUIRY_TYPE_ID and ADMISSION_TEST_TYPE reinforces this interpretation, since that pairing constitutes a natural business key representing an association rather than a descriptive attribute set.
Key Information Stored
The documented physical schema contains ten columns. The most significant are:
- ENT_TEST_TYPE_ID — the surrogate primary key, enforced by IGR_I_E_TESTTYPS_PK. This is the internal identifier used by foreign keys from child records.
- INQUIRY_TYPE_ID — identifies the inquiry type to which the test type configuration applies; part of the business-key unique index.
- ADMISSION_TEST_TYPE — references IGS_AD_TEST_TYPE, identifying the specific admission test associated with the inquiry entry status; the second component of the business-key unique index.
- INQ_ENTRY_STAT_ID — links the row to the inquiry entry status that the test type serves, anchoring the configuration to a recruitment stage.
- CLOSED_IND — a status flag indicating whether the test type assignment is currently active or retired.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS who-column audit set, recording user identity and timestamps for insert and update activity.
The critical distinction is between ENT_TEST_TYPE_ID, the system-generated surrogate key, and the composite of INQUIRY_TYPE_ID plus ADMISSION_TEST_TYPE, which the unique index IGR_I_E_TESTTYPS_UK constrains as the business-key candidate. Reporting extracts should generally resolve the surrogate to its business key to remain portable across environments.
Common Use Cases and Queries
Typical usage centers on admissions configuration validation and inquiry funnel reporting. Administrators query this table to confirm which tests are offered for each inquiry type before opening an intake cycle. A representative validation query joins the table to the admission test definition:
SELECT t.ent_test_type_id, t.inquiry_type_id, t.admission_test_type, a.description FROM igr_i_e_testtyps t, igs_ad_test_type a WHERE t.admission_test_type = a.admission_test_type AND t.closed_ind = 'N';SELECT inquiry_type_id, COUNT(*) FROM igr_i_e_testtyps GROUP BY inquiry_type_id;— used to audit how many test types are attached to each inquiry type.SELECT * FROM igr_i_e_testtyps WHERE inquiry_type_id = :p_inquiry_type AND admission_test_type = :p_test;— resolves a row through the business-key unique index.
Extract routines commonly filter on LAST_UPDATE_DATE to identify configuration changes since the previous load, and integration interfaces frequently look up ENT_TEST_TYPE_ID for population into downstream registration or prospect tracking tables.
Related Objects
The documented foreign keys and inheritance relationships identify the following significant associated objects:
- IGS_AD_TEST_TYPE — referenced by IGR_I_E_TESTTYPS.ADMISSION_TEST_TYPE; the master definition of admission tests.
- Inquiry type definition objects — referenced by IGR_I_E_TESTTYPS.INQUIRY_TYPE_ID; the parent configuration of recruitment inquiry categories.
- Inquiry entry status objects — linked through INQ_ENTRY_STAT_ID, defining the pipeline stage for each test type assignment.
- IGR_I_E_TESTTYPS_PK and IGR_I_E_TESTTYPS_UK — the primary and unique indexes that enforce identity and business-key uniqueness respectively.
- Child tables referencing ENT_TEST_TYPE_ID — any dependent records that consume the surrogate key, which must be resolved before deleting configuration rows.
Because IGR_I_E_TESTTYPS functions as a link between inquiry type and admission test, its removal or modification propagates to any reporting layer that resolves inquiry-type test requirements for applicants.
-
Stores test types corresponding to inquiry entry status
-
TABLE: IGS.IGR_I_E_TESTTYPS 12.1.1
-
Table: IGR_I_E_TESTTYPS 12.2.2
Stores test types corresponding to inquiry entry status
Not implemented in this database·Explore IGS module →
-
View: IGR_I_E_TESTTYPS_V 12.1.1
Entry Status Test Type View
APPS.IGR_I_E_TESTTYPS_V·↳ IGR_I_E_TESTTYPS·↳ IGS_AD_TEST_TYPE·Explore IGS module →
-
View: IGR_I_E_TESTTYPS_V 12.2.2
Entry Status Test Type View
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_TEST_TYPE 12.2.2
Describes valid admission test types
Not implemented in this database·Explore IGS module →
-
Foreign Keys 12.2.2
-
Foreign Keys 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.