Results for “sql_validation_ovrd_flag”

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

Overview

IGSFV_CAL_SYS_DT_TYP_OVRD_RLS is an APPS-owned, read-only view within the IGS (Student System) product family of Oracle E-Business Suite, available in 12.1.1 and 12.2.2. Its documented purpose is to expose the overriding rules associated with seeded system date types in the institution's academic calendar configuration. The view is defined with a WITH READ ONLY clause, confirming that it is intended strictly for query and reporting access rather than for transactional maintenance; the underlying configuration is maintained through the base tables.

In the context of a "sql_validation" search, this view is significant because it surfaces the SQL_VALIDATION column, which stores the SQL fragment used to validate a date or value against an override element. Reporting and integration consumers frequently query this view to audit, document, or troubleshoot the validation logic applied to system date types without needing to join the base tables directly.

Underlying Base Objects

Although the ETRM view metadata lists no referenced base objects explicitly, the documented view text identifies two IGS_CA tables that constitute its definition:

• IGS_CA_DA_OVD_RULES (aliased OVD) — the driving table holding the override rules, including the system date type, override element, SQL validation, override flag, and closed indicator.
• IGS_CA_DA_CONFIGS (aliased DA) — the configuration table supplying the system date type description via a join on SYS_DATE_TYPE.

The join condition is OVD.SYS_DATE_TYPE = DA.SYS_DATE_TYPE, meaning the view returns one row per override rule joined to its corresponding system date type configuration. The "_LA:" literal in the select list is an EBS descriptive/flexfield-style lookup reference directing consumers to IGS_LOOKUP_VALUES with lookup type IGS_DA_OVRD_ELT_LEVEL for the override element meaning.

Key Columns

• SYSTEM_DATE_TYPE — the seeded system date type identifier (SYS_DATE_TYPE in the base table) that anchors the override rule.
• _LA:OVERRIDE_ELEMENT — the override element, resolved through lookup type IGS_DA_OVRD_ELT_LEVEL (ELEMENT_CODE).
• SQL_VALIDATION — the SQL validation expression (SQL_VAL in the base table) applied by the override rule; the column central to validation-oriented inquiries.
• SQL_VALIDATION_OVRD_FLAG — indicates whether the SQL validation is being overridden for the date type.
• CLOSED_INDICATOR — denotes whether the override rule is closed (inactive).
• SYSTEM_DATE_TYPE_DESC — descriptive text sourced from IGS_CA_DA_CONFIGS.DESCRIPTION.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical scenarios include auditing which system date types carry SQL validation logic, confirming whether validation overrides are active, and extracting validation expressions for documentation or migration review.

• List active validation rules: SELECT SYSTEM_DATE_TYPE, SQL_VALIDATION FROM APPS.IGSFV_CAL_SYS_DT_TYP_OVRD_RLS WHERE CLOSED_INDICATOR = 'N';
• Find overridden validations: SELECT SYSTEM_DATE_TYPE, SQL_VALIDATION FROM APPS.IGSFV_CAL_SYS_DT_TYP_OVRD_RLS WHERE SQL_VALIDATION_OVRD_FLAG = 'Y';
• Audit change history: SELECT SYSTEM_DATE_TYPE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM APPS.IGSFV_CAL_SYS_DT_TYP_OVRD_RLS ORDER BY LAST_UPDATE_DATE DESC;

Because the view is read-only, all maintenance of override rules must be performed on IGS_CA_DA_OVD_RULES. Queries should be schema-qualified with APPS and executed under a responsibility with appropriate IGS data access.