Results for “tracking_step_type”

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

Overview

IGS_TR_STEP_CTLG is an Oracle E-Business Suite 12.1.1 / 12.2.2 view owned by the APPS schema. It exposes the catalog of tracking steps used by the Oracle Student System (formerly the Oracle Higher Education product line), specifically the components associated with student tracking, admissions milestones, and related workflow progression. The view presents a secure, organization-filtered projection of the underlying IGS_TR_STEP_CTLG_ALL table, joined to the lookup values that decode the tracking step type. Its principal role is to provide a reporting and integration surface through which the tracking step catalog can be queried without exposing the raw multi-org table directly. Because the view enforces the current organization context through the USERENV('CLIENT_INFO') mechanism, it behaves as a multi-org secured object and returns only the rows relevant to the organization in which the session is operating.

Underlying Base Objects

The view is defined over two documented base objects. The primary source is IGS_TR_STEP_CTLG_ALL, aliased TRSC, which stores the tracking step catalog records across organizations. The secondary source is IGS_LOOKUP_VALUES, aliased LKUP, which supplies the translated meaning of the tracking step type. The join is performed between TRSC.S_TRACKING_STEP_TYPE and LKUP.LOOKUP_CODE, restricted to LKUP.LOOKUP_TYPE = 'TRACKING_STEP_TYPE'. This is the lookup type matching the search term "tracking_step_type" and is the source of the user-facing description of each step type. The organization filter is applied by comparing the ORG_ID of the base record against the organization value derived from the session client information, with a fallback of -99 when no organization is resolved. No other base objects are documented for this view.

Key Columns

• ROWID — the pseudo-column identifying the underlying IGS_TR_STEP_CTLG_ALL row, enabling direct row access for updates or drill-downs.
• ORG_ID — the operating unit / organization identifier used for multi-org security.
• STEP_CATALOG_ID — the surrogate primary key of the tracking step catalog entry.
• STEP_CATALOG_CD — the business code identifying the tracking step.
• DESCRIPTION — the descriptive text of the tracking step.
• ACTION_DAYS — the number of days associated with the action or milestone for the step.
• S_TRACKING_STEP_TYPE — the code representing the tracking step type, joined to the lookup.
• MEANING — the decoded, user-facing meaning of the tracking step type, sourced from IGS_LOOKUP_VALUES.
• PUBLISH_IND — indicator of whether the step is published.
• CLOSED_IND — indicator of whether the step catalog entry is closed.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Two positional NULL columns are also projected between the lookup meaning and PUBLISH_IND, reflecting a fixed column layout in the view definition.

Common Use Cases and Queries

The most frequent scenario is reporting the catalog of tracking steps together with their type descriptions, filtered by organization. The following query lists active, published tracking steps:

SELECT STEP_CATALOG_ID, STEP_CATALOG_CD, DESCRIPTION, MEANING, ACTION_DAYS
FROM APPS.IGS_TR_STEP_CTLG
WHERE PUBLISH_IND = 'Y' AND CLOSED_IND = 'N';

A second use case is decoding the tracking step type for a given catalog code. Because the view already performs the join to IGS_LOOKUP_VALUES, no additional lookup join is needed:

SELECT STEP_CATALOG_CD, S_TRACKING_STEP_TYPE, MEANING
FROM APPS.IGS_TR_STEP_CTLG
WHERE STEP_CATALOG_CD = :step_code;

Integration and validation extracts commonly select the full column list for a specific organization to load tracking step definitions into external workflow or notification engines. In all cases the query must be executed within a session whose client information resolves to a valid organization, otherwise the multi-org predicate in the view yields only the fallback organization rows.