Results for “igs_tr_type_all”

44 results




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

Overview

IGS_TR_TYPE_ALL is the tracking type definition table within the Oracle EBS Student System (IGS) product family. It serves as the master reference for user-defined tracking types that institutions configure to monitor academic progress, admissions milestones, recruiting stages, and other student lifecycle events. Each user-defined tracking type is mapped back to a system-defined tracking type via the S_TRACKING_TYPE column, which allows the standard IGS tracking functionality to recognize and process institution-specific configurations without code modification.

From a dimensional modeling perspective, the FK relationship structure suggests this object behaves as a hub-leaning entity in a Data Vault design. Its primary key is referenced by four dependent tables spanning tracking steps, tracking items, and recruiting/panel mapping tables, indicating a stable, low-volatility reference list that distributes a shared business key across multiple satellites and links.

Key Information Stored

  • TRACKING_TYPE — The unique business identifier for each tracking type. Backed by unique index IGS_TR_TYPE_U1, making it the authoritative business key.
  • DESCRIPTION — The human-readable label displayed to end users when selecting or reporting on a tracking type.
  • S_TRACKING_TYPE — The system-defined tracking type to which the user-defined type is mapped; this is the column that drives native IGS processing logic.
  • TARGET_DAYS — The expected number of days allocated to complete steps of this tracking type, used for SLA and elapsed-time monitoring.
  • BUSINESS_DAYS_IND — Flag indicating whether TARGET_DAYS is measured in business days rather than calendar days.
  • SEQUENCE_IND — Flag controlling whether steps within the tracking type must be completed in a defined sequence.
  • CLOSED_IND — Indicates whether the tracking type is retired and no longer available for new assignments.
  • PUBLISH_IND — Governs whether the tracking type is exposed for use across modules or restricted to administrative setup.
  • ORG_ID — Multi-org operating unit discriminator, essential for row-level security in multi-org installations.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS WHO columns supporting audit and change-tracking.

The surrogate primary key is IGS_TR_TYPE_PK, effectively implemented over TRACKING_TYPE. Nine of the fourteen documented columns are metadata, flag, or audit fields; the functional payload is concentrated in the description, system mapping, timing, and status indicators.

Common Use Cases and Queries

The most frequent reporting requirement is retrieving active tracking types with their system equivalents for a given operating unit. A representative query pattern follows:

  • SELECT tracking_type, description, s_tracking_type, target_days, business_days_ind FROM igs_tr_type_all WHERE closed_ind = 'N' AND org_id = :p_org_id;
  • Joining to IGS_TR_TYPE_STEP_ALL on TRACKING_TYPE to enumerate the progression steps configured for each tracking type.
  • Joining to IGS_TR_ITEM_ALL to report actual tracking items assigned to students against their type definitions, enabling SLA analysis using TARGET_DAYS versus actual elapsed time.
  • Validating configuration completeness by comparing published (PUBLISH_IND = 'Y') tracking types against the system-defined mapping column to detect unmapped custom types.

Typical consumers include admissions and progression reporting, dashboards showing outstanding tracking items by type, and setup verification scripts during implementation or upgrade.

Related Objects

  • IGS_TR_TYPE_STEP_ALL — Defines ordered steps belonging to each tracking type; joins on TRACKING_TYPE.
  • IGS_TR_ITEM_ALL — Stores individual tracking items assigned to persons; the primary transactional child, joining on TRACKING_TYPE.
  • IGS_RE_THS_PNL_TYPE — Recruiting thesis/panel tracking type configuration; references TRACKING_TYPE.
  • IGS_RE_THS_PNL_MR_TP_ALL — Panel milestone-result mapping by tracking type; references TRACKING_TYPE.
  • IGS_LOOKUPS / system tracking type reference — Supplies the domain of values against which S_TRACKING_TYPE is validated.

All four dependent tables are documented foreign key consumers of TRACKING_TYPE, confirming this table's position at the center of the IGS tracking configuration model.