Results for “element_code_val_desc”

13 results




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

Overview

IGS_CA_DA_PRC_OVD_VALS_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to "pickup system date type calendar date alias overridden program versions." In practical terms, the view resolves override values that have been defined at the calendar-date-alias level for specific academic program versions, joining those overrides to the program version description and to the seeded lookup that identifies the override element level. The view is read-only by design and is intended for inquiry, reporting, and integration extracts rather than for transactional data entry. It is validated and present in both EBS 12.1.1 and 12.2.2, where the object definition is materially the same. Because it exposes denormalized, human-readable attributes such as the lookup meaning and the formatted course code and version number, it is well suited to concurrent-program extracts, BI Publisher data models, and ad hoc SQL against the Student System schema. The search term "igs_da_ovrd_elt_level" corresponds to the lookup type that this view consumes, confirming that the user is examining the override-element-level mechanism for calendar date aliases.

Underlying Base Objects

The view is defined over three base objects:

  • IGS_CA_DA_OVD_VALS — the primary table holding the calendar-date-alias override values, aliased as VAL. It supplies the override value identifier, system date type, element code, element code value, date alias, and audit columns.
  • IGS_PS_VER_ALL — the program version view/table, aliased as PSV. It supplies COURSE_CD, VERSION_NUMBER, and TITLE, enriching each override with the corresponding program version description.
  • IGS_LOOKUP_VALUES — the seeded lookup values table, aliased as LKUP. It is filtered to LOOKUP_TYPE = 'IGS_DA_OVRD_ELT_LEVEL' and supplies the MEANING for each element code.

The join between the override table and the program version is keyed on a composite element code value string. The program course code is extracted with SUBSTR(ELEMENT_CODE_VALUE, 1, INSTR(ELEMENT_CODE_VALUE,'/')-1), and the version number with SUBSTR(ELEMENT_CODE_VALUE, INSTR(ELEMENT_CODE_VALUE,'/')+1). This composite parsing means any maintenance of the ELEMENT_CODE_VALUE format directly affects the rows returned by the view. The lookup join is a simple equality on ELEMENT_CODE = LOOKUP_CODE, scoped by the IGS_DA_OVRD_ELT_LEVEL lookup type.

Key Columns

  • ROW_ID / ROWID — the physical row identifier of the underlying override record, useful for de-duplication or drill-back.
  • OVRD_VAL_ID — primary key of the override value record.
  • SYS_DATE_TYPE — the system date type to which the override applies.
  • ELEMENT_CODE — the override element level code, resolved to a lookup meaning.
  • ELEMENT_MEANING — the decoded lookup meaning from IGS_LOOKUP_VALUES for the IGS_DA_OVRD_ELT_LEVEL lookup type.
  • ELEMENT_CODE_VALUE — the composite "COURSE_CD/VERSION_NUMBER" string used to join to the program version.
  • ELEMENT_CODE_VAL_DESC, TITLE — the program version title, exposed for reporting readability.
  • DATE_ALIAS — the calendar date alias against which the override is recorded.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns for change tracking and data lineage.

Common Use Cases and Queries

The view is typically used to report which calendar date aliases have overridden program versions, and at which element level, for a given system date type or date alias. Typical query patterns include:

  • Listing all overrides for a specific date alias: SELECT element_meaning, element_code_value, date_alias FROM igs_ca_da_prc_ovd_vals_v WHERE date_alias = :p_alias;
  • Isolating overrides for a program version: SELECT date_alias, element_meaning FROM igs_ca_da_prc_ovd_vals_v WHERE element_code_value = 'PROG_CD/1.0';
  • Auditing recent changes: SELECT ovrd_val_id, last_updated_by, last_update_date FROM igs_ca_da_prc_ovd_vals_v WHERE last_update_date >= TRUNC(SYSDATE)-30;
  • Driving a BI Publisher extract keyed on SYS_DATE_TYPE and DATE_ALIAS for calendar validation reports.

Because the view performs the element-level decode and program-version join, consumers avoid replicating the SUBSTR/INSTR parsing logic in their own SQL, reducing the risk of inconsistent results across reports and interfaces.