Search Results parenthesis_ind

Overview

IGS.IGS_RU_TURIN_FNC is a reference and configuration table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the IGS schema. The table holds "turin functions" — rule-expression function definitions used by Oracle's Student Systems and related rule-processing utilities. In practical terms, it acts as a master dictionary of the turin function names that can appear in rule descriptions, together with a sequence number that positions each function within a rule and a parenthesis indicator that governs how the function is grouped or enclosed when the rule text is parsed or rendered.

Based on the ETRM relationship data, the object is classified heuristically as hub-leaning. This should be treated as a modeling suggestion rather than a documentation statement: the table behaves like a hub because it holds distinct, stable business keys (the turin function name) that are referenced by multiple dependent tables. Its uniqueness is enforced by a single-column primary key, and foreign-key relationships flow both inbound and outbound, which is consistent with hub semantics rather than a pure transactional satellite.

Storage is configured on tablespace APPS_TS_TX_DATA with PCTFREE 10, and indexes reside in APPS_TS_TX_IDX. Status is VALID in the documented environment. The table contains eight documented columns and does not reference any database object within the IGS schema itself, though it is referenced by several APPS-level objects.

Key Information Stored

The table's most important columns, drawn directly from the documented metadata, are:

• S_TURIN_FUNCTION (VARCHAR2, length 10, mandatory) — the turin function name; this is the single-column primary key IGS_RU_TURIN_FNC_PK and the business-key candidate formalized by unique index IGS_RU_TURIN_FNC_U1.
• RUD_SEQUENCE_NUMBER (NUMBER) — the rule description number that orders the function within a rule definition. A non-unique index, IGS_RU_TURIN_FNC_N1, exists on this column, indicating it is a frequent filter or ordering predicate.
• PARENTHESIS_IND (VARCHAR2) — the parenthesis indicator, which controls whether and how the function is enclosed in parentheses when the rule is evaluated or displayed. This is the column the user searched for.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who columns present on nearly all EBS transactional and setup tables; these support auditing, data lineage, and concurrency tracking.

Because S_TURIN_FUNCTION is both the primary key and the unique-index column, it is unambiguously the surrogate/primary identifier for a turin function record. PARENTHESIS_IND is a numeric-coded flag rather than a free-text field, so its values should be decoded against the relevant lookup before being used in reporting.

Common Use Cases and Queries

Typical usage centers on rule maintenance and rule-expression reporting. Common scenarios include listing all turin functions with their sequence ordering, identifying which functions carry a parenthesis indicator, and auditing recently changed rule functions.

• Enumerate all functions and their grouping flags:
  • SELECT S_TURIN_FUNCTION, RUD_SEQUENCE_NUMBER, PARENTHESIS_IND FROM IGS.IGS_RU_TURIN_FNC ORDER BY RUD_SEQUENCE_NUMBER;
• Find functions that are parenthesized: SELECT S_TURIN_FUNCTION FROM IGS.IGS_RU_TURIN_FNC WHERE PARENTHESIS_IND = 'Y';
• Audit recent changes: SELECT S_TURIN_FUNCTION, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGS.IGS_RU_TURIN_FNC WHERE LAST_UPDATE_DATE > SYSDATE - 30;

Because RUD_SEQUENCE_NUMBER is indexed, filters and ordering on that column perform efficiently. The unique index supports rapid point lookups by function name, which is the most common access path for parent-record lookups from dependent tables.

Related Objects

The following objects are the most significant reference points, based on the documented dependencies:

• IGS.IGS_RU_DESCRIPTION — referenced by IGS_RU_TURIN_FNC via RUD_SEQUENCE_NUMBER, and also references back to IGS_RU_TURIN_FNC through S_TURIN_FUNCTION; this is the primary join path for rule description content.
• IGS_RU_ITEM — references the parent hub through the TURIN_FUNCTION column, linking individual rule items to their function definitions.
• IGS_RU_TURIN_FNC_PK — the primary key constraint on S_TURIN_FUNCTION.
• IGS_RU_TURIN_FNC_U1 — the unique index on S_TURIN_FUNCTION.
• IGS_RU_TURIN_FNC_N1 — the non-unique index on RUD_SEQUENCE_NUMBER.

Any API or form that maintains rule descriptions or rule items will read and write this table indirectly, so modifications should be performed through the supported Student Systems rule maintenance interfaces rather than by direct DML.