Results for “element_code”

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

Overview

IGS_CA_DA_OVD_RULES_V is an Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product family. As documented in the ETRM metadata, its purpose is to "pick up overriding rules for system date types." The view functions as a reporting and validation layer over the base table IGS_CA_DA_OVD_RULES, combining override rule definitions with human-readable lookup meanings sourced from the FND_LOOKUP_VALUES table. In the context of Oracle EBS 12.1.1 and 12.2.2, this view is typically consumed by concurrent programs, forms, and integration interfaces that need to evaluate whether a given system date type is subject to an overriding rule and, if so, which element code, SQL validation logic, or flag governs that override. The view is recorded as VALID in the ETRM metadata and exposes a denormalized, lookup-decorated representation of the underlying rule records.

Underlying Base Objects

The view is defined over two documented base objects:

• IGS_CA_DA_OVD_RULES (aliased CDR) — the driving table holding the override rule definition, including system date type, element code, SQL validation, override flag, audit columns, and the closed indicator.
• FND_LOOKUP_VALUES (aliased LKUP) — the Oracle Application Object Library lookup table used to decode the element code into a meaningful description.

The join is established on CDR.ELEMENT_CODE = LKUP.LOOKUP_CODE with the filter LKUP.LOOKUP_TYPE = 'IGS_DA_OVRD_ELT_LEVEL', restricting the decoded lookups to the override element level lookup type. Additional lookup filters constrain the result set to the IGS application (VIEW_APPLICATION_ID = 8405), the standard security group (SECURITY_GROUP_ID = 0), and the session language (LANGUAGE = USERENV('LANG')). No other referenced base objects are documented.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_CA_DA_OVD_RULES row, useful for direct row addressing.
• SYS_DATE_TYPE — the system date type to which the override rule applies.
• ELEMENT_CODE — the override element-level code; this is the column most commonly searched by users and joins to the lookup code in FND_LOOKUP_VALUES.
• ELEMENT_MEANING — the descriptive meaning of the element code, derived from LKUP.MEANING.
• SQL_VAL — the SQL validation or value expression associated with the rule.
• SQL_VAL_OVRD_FLAG — indicates whether the SQL validation value overrides the default behavior.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.
• CLOSED_IND — indicates whether the override rule is closed or inactive.

Common Use Cases and Queries

Typical usage involves identifying active override rules for a system date type and presenting the decoded element meaning. The following query lists all overrides for a specific element code, filtering on the search term "element_code":

• SELECT sys_date_type, element_code, element_meaning, sql_val, closed_ind FROM apps.igs_ca_da_ovd_rules_v WHERE element_code = :p_element_code AND NVL(closed_ind,'N') = 'N';
• SELECT sys_date_type, element_code, element_meaning FROM apps.igs_ca_da_ovd_rules_v WHERE closed_ind = 'N' ORDER BY sys_date_type;

These queries support administrative review of override configuration, troubleshooting of date-type validation logic, and integration extracts where downstream systems require the human-readable element meaning alongside the technical code.