Search Results unit_set_status




Overview
Explore in AI Chat

Overview

The IGS_EN_UNIT_SET_STAT table belongs to the IGS (Student System) product family within Oracle E-Business Suite, a module documented as obsolete in the ETRM repository but historically significant for institutions running legacy student administration data. The entity describes user-defined unit set statuses — for example "Current" or "Suspended" — that map back onto a smaller set of system-defined unit set statuses. This mapping layer gives implementers the flexibility to define a large number of presentation-level or institution-specific statuses while still consolidating them onto a limited set of internal, functional system statuses used by application logic.

The table is documented with nine physical columns in ETRM 12.1.1 and is owned by the IGS schema. Under the heuristic Data Vault classification mined from its foreign key structure, the object is characterized as standalone — that is, no outgoing or incoming FK relationships were detected in the documented metadata. In Data Vault modeling terms, this suggests treating the table as a self-contained reference or lookup entity rather than as a link or satellite of a larger hub, though a formal modeler may still choose to represent it as a small reference hub with an attached descriptive satellite if integration with other IGS reference data is desired.

Key Information Stored

The table's primary key is defined by the constraint IGS_EN_UNIT_SET_STAT_PK, which covers the UNIT_SET_STATUS column. A separate unique index, IGS_EN_UNIT_SET_STAT_U1, also covers UNIT_SET_STATUS, making that column both the surrogate primary key and the sole documented business-key candidate. This is an unusual but not unheard-of pattern in legacy Oracle data models, where a short coded identifier serves simultaneously as the technical key and the natural identifier.

  • UNIT_SET_STATUS — The primary key and business key; the user-defined status code that uniquely identifies each row.
  • S_UNIT_SET_STATUS — The mapped system unit set status. The "S_" prefix conventionally indicates the system-level counterpart to the user-defined value, enabling the mapping behavior described in the entity documentation.
  • DESCRIPTION — The human-readable description of the status, used in list-of-values displays and reports.
  • CLOSED_IND — A flag indicating whether the status represents a closed state, useful for filtering active versus closed unit sets.
  • CREATED_BY, CREATION_DATE — Standard WHO audit columns recording row creation.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent modification and the login session responsible for it.

Common Use Cases and Queries

Because this is a reference table, the most common access pattern is a lookup join from a unit set or related entity onto UNIT_SET_STATUS to retrieve DESCRIPTION and CLOSED_IND. Reporting queries frequently need to determine which user-defined statuses roll up to a given system status, for example to count unit sets in a "Suspended" state across the institution.

A typical query pattern:

  • SELECT uss.unit_set_status, uss.description, uss.closed_ind FROM igs_en_unit_set_stat uss WHERE NVL(uss.closed_ind,'N') = 'N' ORDER BY uss.description;
  • SELECT s_unit_set_status, COUNT(*) FROM igs_en_unit_set_stat GROUP BY s_unit_set_status; — used to verify that every user-defined status maps onto a valid system status.
  • A validation query to detect orphaned mappings: SELECT * FROM igs_en_unit_set_stat uss WHERE NOT EXISTS (SELECT 1 FROM igs_en_unit_set syst WHERE syst.unit_set_status = uss.s_unit_set_status);

In migration or conversion projects, this table is commonly extracted in full and reconciled against legacy student systems to ensure status code mappings are preserved.

Related Objects

The documented FK mining classifies this table as standalone, meaning no formal foreign keys were detected in the ETRM metadata. In practice, the S_UNIT_SET_STATUS column is intended to reference the system-level unit set status definition, most plausibly held in the IGS_EN_UNIT_SET or IGS_EN_UNIT_SET_STATUS tables within the same IGS schema, joined on the unit set status code. Downstream, unit set entities that carry a status column depend on this table to resolve user-facing descriptions, and any IGS unit set inquiry or validation API that accepts a status parameter will resolve against UNIT_SET_STATUS. Because the module is obsolete, consumers integrating with EBS 12.1.1 or 12.2.2 should confirm the current state of these companion tables in their specific instance before relying on the mapping relationship.

  • Table: IGS_EN_UNIT_SET_STAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_UNIT_SET_STAT,  object_name:IGS_EN_UNIT_SET_STAT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the user-defined unit set statuses. e.g. Current, Suspended. These map back onto the system unit set statuses, to provide the system with the ability to have a large number of statuses which map back to the system fun ,  implementation_dba_data: IGS.IGS_EN_UNIT_SET_STAT , 

  • Table: IGS_EN_UNIT_SET_HIST_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_UNIT_SET_HIST_ALL,  object_name:IGS_EN_UNIT_SET_HIST_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the history of change to a unit set version. ,  implementation_dba_data: IGS.IGS_EN_UNIT_SET_HIST_ALL , 

  • Table: IGS_EN_UNIT_SET_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_UNIT_SET_ALL,  object_name:IGS_EN_UNIT_SET_ALL,  status:VALID,  product: IGS - Student System ,  description: This field describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules which govern its completion via the Rules Sub-system. ,  implementation_dba_data: IGS.IGS_EN_UNIT_SET_ALL , 

  • View: IGS_EN_UNIT_SET_HIST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_EN_UNIT_SET_HIST_V,  object_name:IGS_EN_UNIT_SET_HIST_V,  status:VALID,  product: IGS - Student System ,  description: This view is used to merge unit set history with the current unit set details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods. ,  implementation_dba_data: APPS.IGS_EN_UNIT_SET_HIST_V , 

  • View: IGSBV_CONCENTRATIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_CONCENTRATIONS,  object_name:IGSBV_CONCENTRATIONS,  status:VALID,  product: IGS - Student System ,  description: This view describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules, which govern its completion via the Rules Sub-system. - Obsolete ,  implementation_dba_data: APPS.IGSBV_CONCENTRATIONS , 

  • View: IGSBV_PROG_CONCENTRATIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_PROG_CONCENTRATIONS,  object_name:IGSBV_PROG_CONCENTRATIONS,  status:VALID,  product: IGS - Student System ,  description: This entity describes a unit-set, being a logical sub-grouping of program. eg .Major, Minor, Stream, Strand. A unit-set is typically related to the rules which governs its completion via the Rules Sub-system. ,  implementation_dba_data: APPS.IGSBV_PROG_CONCENTRATIONS , 

  • View: IGS_EN_UNIT_SET_HIST 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_EN_UNIT_SET_HIST,  object_name:IGS_EN_UNIT_SET_HIST,  status:VALID,  product: IGS - Student System ,  description: This view describes the history of changes to a given unit set. ,  implementation_dba_data: APPS.IGS_EN_UNIT_SET_HIST , 

  • View: IGS_EN_UNIT_SET 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_EN_UNIT_SET,  object_name:IGS_EN_UNIT_SET,  status:VALID,  product: IGS - Student System ,  description: The code of a unit set. Unit sets comprise lists of units or rules. ,  implementation_dba_data: APPS.IGS_EN_UNIT_SET , 

  • View: IGS_EN_UNIT_SET_ACTIVE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_EN_UNIT_SET_ACTIVE_V,  object_name:IGS_EN_UNIT_SET_ACTIVE_V,  status:VALID,  product: IGS - Student System ,  description: IGS_EN_UNIT_SET_ACTIVE_V describes the active unit sets that are available for a given specific period. ,  implementation_dba_data: APPS.IGS_EN_UNIT_SET_ACTIVE_V , 

  • View: IGS_PS_OFR_UNIT_SET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_OFR_UNIT_SET_V,  object_name:IGS_PS_OFR_UNIT_SET_V,  status:VALID,  product: IGS - Student System ,  description: Manually created ,  implementation_dba_data: APPS.IGS_PS_OFR_UNIT_SET_V , 

  • View: IGS_EN_UNIT_SET_VALID_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_EN_UNIT_SET_VALID_V,  object_name:IGS_EN_UNIT_SET_VALID_V,  status:VALID,  product: IGS - Student System ,  description: This view provides valid unit sets for student, and or an option to reselect unit set that student had previously. ,  implementation_dba_data: APPS.IGS_EN_UNIT_SET_VALID_V , 

  • View: IGS_AS_SUSA_INQ_V 12.1.1

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

  • View: IGS_PR_SCA_US_V 12.1.1

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

  • View: IGSFV_CONCENTRATIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_CONCENTRATIONS,  object_name:IGSFV_CONCENTRATIONS,  status:VALID,  product: IGS - Student System ,  description: This view describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules, which govern its completion via the Rules Sub-system. - Obsolete ,  implementation_dba_data: APPS.IGSFV_CONCENTRATIONS , 

  • View: IGSFV_PROG_CONCENTRATIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PROG_CONCENTRATIONS,  object_name:IGSFV_PROG_CONCENTRATIONS,  status:VALID,  product: IGS - Student System ,  description: This entity describes a unit-set, being a logical sub-grouping of program. eg .Major, Minor, Stream, Strand. A unit-set is typically related to the rules which governs its completion via the Rules Sub-system. ,  implementation_dba_data: APPS.IGSFV_PROG_CONCENTRATIONS , 

  • View: IGS_EN_SUSA_PARENT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_EN_SUSA_PARENT_V,  object_name:IGS_EN_SUSA_PARENT_V,  status:VALID,  product: IGS - Student System ,  description: This view determines the unit sets that are able to be linked as a parent for a student unit set attempt. The exists field is an indicator to show if the parent exists as a student unit set attempt. If not, then it will need to be created b ,  implementation_dba_data: APPS.IGS_EN_SUSA_PARENT_V , 

  • View: IGS_PS_OFR_OPT_UNIT_SET_V 12.1.1

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