Results for “igs_da_ovrd_elt_level”

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

Overview

IGS_CA_DA_OVD_RULES_V is a seeded Oracle E-Business Suite view owned by the APPS schema and defined over the Student Systems (IGS) date-arithmetic rule configuration model. It exposes the override rules that control how individual date elements are calculated when the standard calendar or date-arithmetic engine cannot resolve a value deterministically. The view joins the override-rule table to a lookup so that each rule is returned alongside the human-readable meaning of its element code, which is registered under the lookup type IGS_DA_OVRD_ELT_LEVEL. This lookup type is the exact term a developer or analyst searches for when investigating how an override is applied at a particular element level.

Because the view resolves the lookup meaning and filters on the calling user's language via USERENV('LANG'), it behaves like a concurrent-program-friendly, presentation-ready data set. It is commonly used by institution-specific reports, diagnostic queries, and integration extracts that need to surface override logic without re-implementing the join to FND_LOOKUP_VALUES. The view is read-only in practice; rule maintenance is performed against the underlying transaction table, not through the view.

Underlying Base Objects

The view is defined over two objects, one of which is documented in the ETRM metadata and one of which is the standard lookup infrastructure table:

• IGS_CA_DA_OVD_RULES (CDR) — the base transaction table holding the date-arithmetic override rule definitions, including the element code, the SQL value used to resolve the element, the override flag, and the audit and closure columns.
• FND_LOOKUP_VALUES (LKUP) — the Application Object Library lookup values table, filtered to LOOKUP_TYPE = 'IGS_DA_OVRD_ELT_LEVEL', VIEW_APPLICATION_ID = 8405 (the IGS application), SECURITY_GROUP_ID = 0, and the session language.

The two are equated on CDR.ELEMENT_CODE = LKUP.LOOKUP_CODE. The view is therefore a restrictive inner join: override rules whose element code is not present as an enabled lookup value under the IGS_DA_OVRD_ELT_LEVEL lookup type will not be returned. No additional base objects are documented in the ETRM metadata for this view.

Key Columns

• ROWID — the row identifier of the underlying IGS_CA_DA_OVD_RULES row, exposed for update-capable frameworks.
• SYS_DATE_TYPE — the system date type to which the override rule applies.
• ELEMENT_CODE — the element-level code from the override rule table; the value matched against the lookup code.
• MEANING — the descriptive lookup meaning of the element code, sourced from FND_LOOKUP_VALUES.
• SQL_VAL — the SQL expression or value used to derive the element when the override is active.
• SQL_VAL_OVRD_FLAG — indicates whether the SQL value overrides the standard calculation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.
• CLOSED_IND — closure/end-dating indicator for the rule.

Common Use Cases and Queries

The view is typically queried to audit which date elements have override rules and to confirm the associated lookup meaning. A representative query lists active override rules for a given system date type:

• SELECT element_code, meaning, sql_val, sql_val_ovrd_flag FROM apps.igs_ca_da_ovd_rules_v WHERE closed_ind = 'N';
• SELECT sys_date_type, element_code, meaning FROM apps.igs_ca_da_ovd_rules_v WHERE element_code = :element_code;

Because the view already restricts to LOOKUP_TYPE = 'IGS_DA_OVRD_ELT_LEVEL', users searching for igs_da_ovrd_elt_level can query this view directly to confirm the relationship between the override rules and the lookup values, without writing the underlying join themselves.