Search Results step_code

Overview

The IGS_AD_TEST_TYPES_V view is a reporting and integration object within the IGS (Student System) product family of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It presents consolidated information about admission test types used by an institution — for example, standardized or locally defined tests whose results inform admissions decisions. The view resolves descriptive and lookup values that would otherwise require joins at the application or reporting layer, exposing human-readable meanings alongside the underlying coded values.

Because it is a view rather than a base table, IGS_AD_TEST_TYPES_V is intended for read-only consumption. It is commonly used in queries, extracts, and integration interfaces that need to report on the configured test types in the student system without directly navigating the normalized base tables. This makes it suitable for operational reporting, data validation, and downstream feeds into admissions processing.

Underlying Base Objects

The view is owned by the APPS schema and is defined over three objects:

• IGS_AD_TEST_TYPE TT — the primary base table holding admission test type definitions, including the test type identifier, description, step code, score type, status flag, and standard audit columns.
• IGS_TR_STEP_CTLG SC — joined via an outer join on TT.STEP_CODE = SC.STEP_CATALOG_CD(+) to retrieve the step catalog description, which may be absent if no catalog match exists.
• IGS_LOOKUPS_VIEW LV — joined on TT.SCORE_TYPE = LV.LOOKUP_CODE restricted to LV.LOOKUP_TYPE='TEST_SCORE_TYPE', supplying the meaningful value for the score type.

The ETRM metadata does not document any additional referenced objects beyond these three. The outer join to the step catalog and the inner join to the lookup view mean that rows will appear only where a matching lookup exists, while step code descriptions may be null.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_AD_TEST_TYPE record, useful for direct row identification.
• ADMISSION_TEST_TYPE — the identifier of the admission test type.
• DESCRIPTION — the descriptive text for the test type.
• STEP_CODE / STEP_CODE_DESC — the associated step catalog code and its full description.
• SCORE_TYPE — the coded score type for the test (for example, a grading or scoring scheme).
• SCORE_TYPE_MEANING — the user-facing meaning of the score type, sourced from the TEST_SCORE_TYPE lookup. This is the column most relevant to the common search term "score_type_meaning".
• CLOSED_IND — indicates whether the test type is closed or inactive.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns inherited from the base table.

Common Use Cases and Queries

Typical usages include resolving score type meanings for reporting, filtering out closed test types, and joining to other admissions objects by admission test type or step code.

• List all active admission test types with readable score types:

  SELECT admission_test_type, description, score_type_meaning
  FROM   igs_ad_test_types_v
  WHERE  closed_ind = 'N';

• Look up the meaning for a specific score type:

  SELECT admission_test_type, score_type, score_type_meaning
  FROM   igs_ad_test_types_v
  WHERE  score_type = :p_score_type;

• Report on test types grouped by step catalog description:

  SELECT step_code, step_code_desc, COUNT(*)
  FROM   igs_ad_test_types_v
  GROUP  BY step_code, step_code_desc
  ORDER  BY step_code;

These queries support admissions reporting, configuration review, and integration extracts within the IGS Student System.