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_DAYSis 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_ALLonTRACKING_TYPEto enumerate the progression steps configured for each tracking type. - Joining to
IGS_TR_ITEM_ALLto report actual tracking items assigned to students against their type definitions, enabling SLA analysis usingTARGET_DAYSversus 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_TYPEis 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.
-
This entity describes the user-defined tracking types which exist within the system. They are mapped back to the system defined tracking types which are recognized by the system functionality.
-
TABLE: IGS.IGS_TR_TYPE_ALL 12.1.1
-
Table: IGS_TR_TYPE_ALL 12.2.2
This entity describes the user-defined tracking types which exist within the system. They are mapped back to the system defined tracking types which are recognized by the system functionality.
Not implemented in this database·Explore IGS module →
-
View: IGSFV_AD_ADM_APPL_REQ 12.1.1
Contains data used to link tables for application instances and admission requirements related tracking items.
APPS.IGSFV_AD_ADM_APPL_REQ·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_AD_APLINS_ADMREQ·Explore IGS module →
-
This entity describes the various member types of a thesis examination panel
Not implemented in this database·Explore IGS module →
-
Table: IGS_TR_TYPE_STEP_ALL 12.2.2
This entity describes the default steps which are held for each tracking type.
Not implemented in this database·Explore IGS module →
-
Table: IGS_RE_THS_PNL_TYPE 12.2.2
This table describes the types of thesis panels which can be used for thesis examinations.
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_TR_TYPE 12.1.1
-
Table: IGS_TR_ITEM_ALL 12.2.2
Describes each occurrence of a tracking process for a particular student.
Not implemented in this database·Explore IGS module →
-
View: IGS_TR_TYPE 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGSFV_AD_ADM_APPL_REQ 12.2.2
Contains data used to link tables for application instances and admission requirements related tracking items.
Not implemented in this database·Explore IGS module →
-
This table describes the types of thesis panels which can be used for thesis examinations.
-
This entity describes the various member types of a thesis examination panel
-
Describes step types which define processing for admission category or admission process type
-
VIEW: APPS.IGS_TR_TYPE 12.1.1
-
This entity describes the default steps which are held for each tracking type.
-
Describes each occurrence of a tracking process for a particular student.
-
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
-
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'.
-
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'.