Search Results igs_tr_item_all




Overview
Explore in AI Chat

Overview

The IGS_TR_ITEM_ALL table is a core data structure within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It serves as the master transactional table for recording and managing individual tracking items. Each row in this table represents a single, concrete instance of a defined tracking process that has been initiated for a specific student. A tracking process is a workflow mechanism used to monitor and manage student-related activities, such as application reviews, admission requirements, academic progress milestones, or disciplinary actions. The table's role is to persist the lifecycle state of each tracking item, link it to the relevant student and process definition, and provide a central point of reference for all related actions and data.

Key Information Stored

The table's primary key is the TRACKING_ID, a unique identifier for each tracking item instance. Two critical foreign keys define the tracking item's context: TRACKING_TYPE, which references IGS_TR_TYPE_ALL to identify the category or template of the tracking process, and TRACKING_STATUS, which references IGS_TR_STATUS to denote the item's current state (e.g., Open, In Progress, Closed, Cancelled). The table links to the person/party model via SOURCE_PERSON_ID and ORIGINATOR_PERSON_ID, connecting the tracking item to the student being tracked and the individual who initiated it, respectively. Additional columns typically store creation dates, last update dates, and other attributes that describe the specific occurrence of the tracking item for audit and management purposes.

Common Use Cases and Queries

A primary use case is generating reports on open tracking items for students within a specific program or of a certain type, such as all pending admission requirement verifications. Administrators may query the table to monitor workload or identify bottlenecks. Common SQL patterns involve joining to person (HZ_PARTIES) and tracking type tables. For example, to find all active tracking items for a student:

  • SELECT ti.tracking_id, tt.name type_name, ts.status FROM igs_tr_item_all ti, igs_tr_type_all tt, igs_tr_status ts WHERE ti.tracking_type = tt.tracking_type AND ti.tracking_status = ts.tracking_status AND ti.source_person_id = <STUDENT_PERSON_ID>;

Another key use case is integration, where downstream processes, like updating an application instance or a thesis examination record, consume or update the TRACKING_ID to reflect progress.

Related Objects

IGS_TR_ITEM_ALL has extensive relationships within the Student System. It is the parent table for several key transactional entities, including IGS_TR_ITEM_NOTE (for notes), IGS_TR_STEP (for process steps), and IGS_TR_GROUP_MEMBER (for grouping items). Crucially, it is referenced by major application tables, demonstrating its central role: IGS_AD_APLINS_ADMREQ (Admission Requirements), IGS_AD_PS_APPL_INST_ALL (Application Instances), IGS_AS_SU_ATMPT_ITM (Assessment Items), and IGS_RE_THESIS_EXAM (Thesis Examinations). Its definitions are governed by IGS_TR_TYPE_ALL and IGS_TR_STATUS, and it links to the Trading Community Architecture via HZ_PARTIES for person data.

  • Table: IGS_TR_ITEM_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_TR_ITEM_ALL,  object_name:IGS_TR_ITEM_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes each occurrence of a tracking process for a particular student. ,  implementation_dba_data: IGS.IGS_TR_ITEM_ALL , 

  • Table: IGS_AD_PS_APPL_INST_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_PS_APPL_INST_ALL,  object_name:IGS_AD_PS_APPL_INST_ALL,  status:VALID,  product: IGS - Student System ,  description: Holds the request for program entry for an admission period ,  implementation_dba_data: IGS.IGS_AD_PS_APPL_INST_ALL , 

  • Table: IGS_TR_GROUP_MEMBER 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_TR_GROUP_MEMBER,  object_name:IGS_TR_GROUP_MEMBER,  status:VALID,  product: IGS - Student System ,  description: IGS_TR_GROUP_MEMBER describes the tracking items that are members in a tracking grouping. ,  implementation_dba_data: IGS.IGS_TR_GROUP_MEMBER , 

  • Table: IGS_TR_ITEM_NOTE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_TR_ITEM_NOTE,  object_name:IGS_TR_ITEM_NOTE,  status:VALID,  product: IGS - Student System ,  description: This table will store references to notes held against a tracking item. ,  implementation_dba_data: IGS.IGS_TR_ITEM_NOTE , 

  • Table: IGS_TR_STATUS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_TR_STATUS,  object_name:IGS_TR_STATUS,  status:VALID,  product: IGS - Student System ,  description: This entity describes the user-defined tracking statuses. These map back to the system-defined tracking statuses which are recognized by system functionality. ,  implementation_dba_data: IGS.IGS_TR_STATUS , 

  • Table: IGS_TR_TYPE_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_TR_TYPE_ALL,  object_name:IGS_TR_TYPE_ALL,  status:VALID,  product: IGS - Student System ,  description: 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. ,  implementation_dba_data: IGS.IGS_TR_TYPE_ALL , 

  • Table: IGS_RE_THESIS_EXAM 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_RE_THESIS_EXAM,  object_name:IGS_RE_THESIS_EXAM,  status:VALID,  product: IGS - Student System ,  description: This entity describes the thesis examination and its actions ,  implementation_dba_data: IGS.IGS_RE_THESIS_EXAM , 

  • Table: IGS_CO_OU_CO_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CO_OU_CO_ALL,  object_name:IGS_CO_OU_CO_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes link between person and correspondence item ,  implementation_dba_data: IGS.IGS_CO_OU_CO_ALL , 

  • Table: IGS_AD_APLINS_ADMREQ 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_APLINS_ADMREQ,  object_name:IGS_AD_APLINS_ADMREQ,  status:VALID,  product: IGS - Student System ,  description: Contains data used to link table for application instances and admission requirements related tracking types (application instance + tracking type = tracking item) ,  implementation_dba_data: IGS.IGS_AD_APLINS_ADMREQ , 

  • Table: IGS_AD_PS_APLINSTUNT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_PS_APLINSTUNT_ALL,  object_name:IGS_AD_PS_APLINSTUNT_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes admission program unit applications or admission non-award unit applications ,  implementation_dba_data: IGS.IGS_AD_PS_APLINSTUNT_ALL , 

  • Table: IGS_AS_SU_ATMPT_ITM 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_SU_ATMPT_ITM,  object_name:IGS_AS_SU_ATMPT_ITM,  status:VALID,  product: IGS - Student System ,  description: Describes assessment item allocated to student unit attempt, either manually or by unit's default assessment items ,  implementation_dba_data: IGS.IGS_AS_SU_ATMPT_ITM , 

  • Table: IGS_TR_STEP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_TR_STEP,  object_name:IGS_TR_STEP,  status:VALID,  product: IGS - Student System ,  description: This entity describes a particular step of a tracking item. The steps may be the default steps which have been setup for each tracking type or they may be additional or alternate steps defined by a user. ,  implementation_dba_data: IGS.IGS_TR_STEP , 

  • View: IGS_TR_ITEM 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_TR_ITEM,  object_name:IGS_TR_ITEM,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_TR_ITEM , 

  • View: IGSFV_AD_ADM_APPL_REQ 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_AD_ADM_APPL_REQ,  object_name:IGSFV_AD_ADM_APPL_REQ,  status:VALID,  product: IGS - Student System ,  description: Contains data used to link tables for application instances and admission requirements related tracking items. ,  implementation_dba_data: APPS.IGSFV_AD_ADM_APPL_REQ , 

  • View: IGSFV_ADM_PRG_APPL_UNIT 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_ADM_PRG_APPL_UNIT,  object_name:IGSFV_ADM_PRG_APPL_UNIT,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGSFV_ADM_PRG_APPL_UNIT , 

  • View: IGSFV_AS_SU_ATMPT_AST_ITEMS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_AS_SU_ATMPT_AST_ITEMS,  object_name:IGSFV_AS_SU_ATMPT_AST_ITEMS,  status:VALID,  product: IGS - Student System ,  description: Describes assessment item allocated to student unit attempt, either manually or by unit's default assessment items. ,  implementation_dba_data: APPS.IGSFV_AS_SU_ATMPT_AST_ITEMS ,