Results for “igs_he_sys_rt_cl_fld”

29 results




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

Overview

The IGS_HE_SYS_RT_CL_FLD table belongs to the IGS (Student System) product family within Oracle E-Business Suite and is documented as obsolete in the ETRM reference for releases 12.1.1 and 12.2.2. Its stated purpose is to hold the field definitions associated with each system return type used by the Higher Education student system. In practical terms, the table acts as a metadata catalogue: each row describes a single field belonging to a system return class, giving applications the ability to describe, validate, and render return-type payloads dynamically rather than hard-coding them.

The object is not implemented in the reference database and is flagged obsolete, so it should be treated as legacy or dormant in current 12.1.1 and 12.2.2 environments. From a dimensional or Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification: the table carries descriptive attributes (field name, datatype, length, mandatory flags) that qualify a parent entity rather than defining a hub or link. The parent qualifying context is the system return class type.

Key Information Stored

The table is owned by the IGS schema and contains thirteen documented columns. Its primary key is the constraint IGS_HE_SYS_RT_CL_FLD_PK, defined over the composite of SYSTEM_RETURN_CLASS_TYPE and FIELD_NUMBER. A separate unique index, IGS_HE_SYS_RT_CL_FLD_U1, carries the same two columns, making them the business-key candidate that identifies a field definition uniquely within its return class. Notable columns include:

  • SYSTEM_RETURN_CLASS_TYPE — the parent system return class to which the field belongs; part of the primary key and the leading foreign-key column.
  • FIELD_NUMBER — ordinal position of the field within the return class; completes the primary key.
  • FIELD_NAME — the descriptive label or identifier of the defined field.
  • FIELD_DESCRIPTION — free-text explanation of the field's meaning.
  • DATATYPE — the data type of the field, used for validation and formatting.
  • LENGTH — the permitted length of the field value.
  • MANDATORY_FLAG — indicates whether a value for the field is required.
  • CLOSED_FLAG — denotes whether the field definition is closed or inactive.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns capturing who created and last modified each row.

Because SYSTEM_RETURN_CLASS_TYPE and FIELD_NUMBER form both the primary key and the unique business key, there is no single-column surrogate key in the documented schema.

Common Use Cases and Queries

Where this table is populated, it supports configuration reporting and dynamic rendering of system return structures. A typical query retrieves all fields for a given return class in order:

  • SELECT FIELD_NUMBER, FIELD_NAME, DATATYPE, LENGTH, MANDATORY_FLAG FROM IGS_HE_SYS_RT_CL_FLD WHERE SYSTEM_RETURN_CLASS_TYPE = :type ORDER BY FIELD_NUMBER;
  • A validation-oriented query lists mandatory fields: SELECT * FROM IGS_HE_SYS_RT_CL_FLD WHERE MANDATORY_FLAG = 'Y' AND CLOSED_FLAG = 'N';
  • A join to the parent class table links field definitions to their owning return class for descriptive reporting.

Given the obsolete status, migration or impact-analysis queries are equally relevant, identifying whether any customizations still reference these field definitions before the object is retired.

Related Objects

The FK metadata identifies the principal relationships surrounding this table:

  • IGS_HE_SYS_RTN_CLAS — the parent table referenced by IGS_HE_SYS_RT_CL_FLD.SYSTEM_RETURN_CLASS_TYPE, supplying the return class definition.
  • IGS_HE_SYS_RT_CL_ASS — a dependent table that references this object through SYSTEM_RETURN_CLASS_TYPE and FIELD_NUMBER, indicating an assignment subtype built on these field definitions.

Together, these relationships confirm the table's role as a field-level satellite beneath the system return class, with the assignment table extending it. Because the product is obsolete, related views and public APIs are unlikely to be documented or supported.