Results for “step_code”

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

Overview

IGS_AD_TEST_TYPE is a reference (setup) table in the Oracle E-Business Suite Student System (IGS) product family. It holds the master list of valid admission test types recognized by the institution, such as standardized tests (SAT, ACT, GRE, TOEFL) or institutionally defined entrance examinations. The table acts as the single source of truth that qualifies and validates any admission test configuration, applicant test result, or admissions test results record entered elsewhere in the IGS schema. Its rows are maintained during implementation and thereafter by admissions administrators rather than by day-to-day transactional users.

From a dimensional or Data Vault modeling perspective, the heuristic classification of this object is hub-leaning. That is, IGS_AD_TEST_TYPE behaves primarily as a hub: it defines a stable, uniquely identified business concept (the admission test type) around which multiple dependent child tables cluster. The six foreign keys that reference it reinforce this hub interpretation, while the descriptive attributes on the row (description, score type, processing step) can be modeled as satellites attached to that hub. This is offered as a modeling suggestion to be validated against project standards.

Key Information Stored

The table is documented with ten columns in the ETRM 12.1.1 physical schema. The most important of these are:

• ADMISSION_TEST_TYPE — the business key and the single-column primary key declared by IGS_AD_TEST_TYPE_PK. It is also the column exposed by the unique index IGS_AD_TEST_TYPE_U1, confirming it as the natural business-key candidate. Every child table joins back on this value.
• DESCRIPTION — the human-readable name of the test type used on admissions forms, letters, and reports.
• SCORE_TYPE — indicates the scoring convention or unit associated with the test, allowing results to be interpreted consistently across different instruments.
• STEP_CODE — identifies the admissions processing step or stage to which the test type belongs, supporting workflow sequencing.
• CLOSED_IND — a status flag that retires a test type from active use without deleting its history; closed rows remain valid for historical results.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns, which record who created or last changed each row and when, and which support change tracking and troubleshooting.

Note that the primary key is a natural business key rather than a system-generated surrogate; there is no separate sequence-driven ID column in the documented schema.

Common Use Cases and Queries

Typical scenarios include validating that an applicant test result references an active test type, building lookup lists for data entry, and reporting on test volumes by type or score category.

• Lookup value set population for admissions forms: SELECT admission_test_type, description FROM igs_ad_test_type WHERE closed_ind = 'N' ORDER BY description;
• Resolving descriptions on applicant test results: SELECT r.*, t.description FROM igs_ad_ps_apl_tst_rs r, igs_ad_test_type t WHERE r.admission_test_type = t.admission_test_type;
• Impact analysis before closing a test type — count dependent rows in each child table that still reference the value.
• Audit and change reporting using LAST_UPDATED_BY and LAST_UPDATE_DATE to identify recently reconfigured test types.

Related Objects

The table is referenced by six documented foreign keys, all on the ADMISSION_TEST_TYPE column:

• IGS_AD_SS_TEST_CONF — test configuration at the session/term level.
• IGS_AD_PS_APL_TST_RS — applicant test results captured during admissions processing.
• IGS_AD_TEST_RESULTS — general admission test results.
• IGS_AD_ENT_TEST_TYPS — entry/entrance test type assignments.
• IGR_I_E_TESTTYPS — prospect/test type mapping in the recruiting (IGR) schema.
• IGS_RC_I_E_TESTTYPS — recruiting test type mapping in the IGS schema.

Because all six relationships are inbound, IGS_AD_TEST_TYPE should be maintained first during setup and treated as read-only by downstream transactional processes. Deleting or renumbering its primary key values is not advisable once dependent admissions data exists.