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.
-
Holds the fields defined for each of the system return type
-
Table: IGS_HE_SYS_RT_CL_FLD 12.2.2
Holds the fields defined for each of the system return type
Not implemented in this database·Explore IGS module →
-
Full View for HESA extract data fields
APPS.IGSFV_HESA_EXT_RUN_DAT_FIELDS·↳ IGS_HE_EXT_RUN_DTLS·↳ IGS_HE_EX_RN_DAT_FD·↳ IGS_HE_SYS_RT_CL_FLD·Explore IGS module →
-
Table: IGS_HE_SYS_RT_CL_ASS 12.2.2
Stores associations codes for each field in a system return class
Not implemented in this database·Explore IGS module →
-
Table: IGS_HE_SYS_RTN_CLAS 12.2.2
Holds the predefined Return Classes - Student Return, Module Return, Combined Return
Not implemented in this database·Explore IGS module →
-
Stores associations codes for each field in a system return class
-
Full View for HESA extract data fields
Not implemented in this database·Explore IGS module →
-
12.1.1 DBA Data 12.1.1
-
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
-
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'.