Results for “igs_ru_ret_type”
35 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_RU_RET_TYPE is a reference (lookup) table within the Oracle E-Business Suite IGS – Student System module, a legacy component associated with the Oracle Student System product line that is documented as obsolete in ETRM for releases 12.1.1 and 12.2.2. The table holds the set of allowable return types used by the rules engine functionality of the Student System, providing the valid domain of values that other rule-definition objects reference when they must indicate what kind of value a named rule returns.
Because the entity is referenced by multiple dependent tables through a single business-key column, the ETRM Data Vault classification heuristic labels it hub-leaning. In Data Vault modeling terms, this suggests treating IGS_RU_RET_TYPE as a hub: a stable set of unique business keys (return type codes) around which descriptive and transactional satellites would be attached. This is a modeling suggestion rather than a functional statement about the delivered schema.
It is important to note that the ETRM metadata records this object as "Not implemented in this database." Consequently, the table may not physically exist in a given EBS 12.1.1 or 12.2.2 instance even though its definition persists in the data model documentation and dictionary. It should be treated as an obsolete or non-instantiated artifact, relevant primarily for historical data-model analysis, upgrade assessment, or legacy integration review.
Key Information Stored
The documented physical schema for this object includes seven columns, owned by the IGS schema. The principal column is the return type code itself, which serves both as the primary key and as the unique business key.
- S_RETURN_TYPE — The surrogate/primary key column and the unique business-key candidate. It holds the code identifying each allowed return type. A unique index, IGS_RU_RET_TYPE_U1, is defined on this column, and the primary key constraint IGS_RU_RET_TYPE_PK covers the same column. This is the column referenced by all foreign keys from dependent tables.
- FUNCTION_RETURN_IND — An indicator column associated with the return type definition, most likely indicating whether the return type corresponds to a function-style return. This is the only descriptive (non-audit) attribute documented beyond the key.
- CREATED_BY, CREATION_DATE — Standard Oracle EBS audit columns capturing the user and timestamp of row creation.
- LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns capturing the user, timestamp, and login session of the most recent modification.
The relative sparsity of descriptive columns reflects the table's role as a thin reference list: it exists primarily to constrain and validate the return type codes used elsewhere in the rules engine rather than to carry substantial business attributes. The audit columns follow the conventional Oracle Applications WHO-column pattern and would normally be maintained by database triggers or the application framework.
Common Use Cases and Queries
Because IGS_RU_RET_TYPE defines the valid domain of return types, the principal use cases center on validating, decoding, and reporting on return type values that appear in dependent rule and description tables. A typical lookup joins the reference table to its dependents on S_RETURN_TYPE:
- Decoding dependent records:
SELECT n.S_RETURN_TYPE, t.FUNCTION_RETURN_IND FROM IGS_RU_NAMED_RULE_GR n, IGS_RU_RET_TYPE t WHERE n.S_RETURN_TYPE = t.S_RETURN_TYPE; - Enumerating valid return types:
SELECT S_RETURN_TYPE, FUNCTION_RETURN_IND FROM IGS_RU_RET_TYPE ORDER BY S_RETURN_TYPE; - Orphan and integrity checks: Comparing the distinct S_RETURN_TYPE values stored in IGS_RU_NAMED_RULE_GR and IGS_RU_DESCRIPTION against the domain list in IGS_RU_RET_TYPE helps identify data-integrity exceptions.
- Reporting and extract: Reference lists such as this are commonly included in configuration extracts and migration scripts, since the allowed return types must exist before dependent rule rows can be populated.
- Legacy remediation: During upgrades or re-implementation from the obsolete Student System, this table is used to scope the return type domain that must be mapped into any replacement rules framework.
Related Objects
The ETRM metadata documents two dependent tables that reference IGS_RU_RET_TYPE through the S_RETURN_TYPE column. These constitute the primary relationship set for this object:
- IGS_RU_NAMED_RULE_GR — References IGS_RU_RET_TYPE via its S_RETURN_TYPE column. This is the named-rule grouping entity, and the foreign key ensures that any return type assigned to a named rule is one of the allowed types held in the reference table.
- IGS_RU_DESCRIPTION — Also references IGS_RU_RET_TYPE via S_RETURN_TYPE. This table holds descriptive content tied to return types and therefore depends on the reference list for valid key values.
No views or PL/SQL APIs are documented in the provided metadata for this object. Any joins to the table should be built on the S_RETURN_TYPE column, which is the sole documented relationship key. Because the object is flagged as obsolete and not implemented, integrators should verify the table's physical existence and column presence in the target 12.1.1 or 12.2.2 instance before relying on it in production SQL.
-
This entity holds the allowed return types
-
TABLE: IGS.IGS_RU_RET_TYPE 12.1.1
-
Table: IGS_RU_RET_TYPE 12.2.2
This entity holds the allowed return types
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_RU_VAL_RUD 12.1.1
-
Table: IGS_RU_DESCRIPTION 12.2.2
This entity displays description of rule
Not implemented in this database·Explore IGS module →
-
Table: IGS_RU_NAMED_RULE_GR 12.2.2
Named Rule Group.
Not implemented in this database·Explore IGS module →
-
Named Rule Group.
-
This entity displays description of rule
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA 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'.