Search Results system_date_type




Overview
Explore in AI Chat

Overview

IGSFV_CAL_PRD_EVNT_TYP_CONFIGS is a read-only view owned by the APPS schema in the Oracle E-Business Suite IGS (Student System) product family. It exposes the seeded system date types that drive date type configurations within the academic calendar model. The view consolidates date alias configuration data with the associated date alias definitions, presenting a single row per configured system date type. Because the database definition terminates with the WITH READ ONLY clause, the view is strictly a reporting and inquiry construct; it cannot be used as a DML target.

In EBS 12.1.1 and 12.2.2 the object remains a compatibility view. It is primarily consumed by calendar setup forms, validation routines, and downstream reporting where the seeded date type catalogue must be resolved. The view text also applies descriptive flexfield–style attribute references (the "_LA:..." tokens), which the Oracle Forms/BC4J layer resolves as list-of-values descriptors rather than as literal column data. This means column names appearing with the "_LA:" prefix in the underlying SQL are presentation-layer lookups, while the physical columns exposed to SQL are the friendly names listed in the view's column catalogue.

Underlying Base Objects

The view is defined over two IGS calendar base tables joined on the date alias:

The join predicate is DA.DATE_ALIAS = CA.DT_ALIAS. The ETRM entry lists no further documented referenced objects; the lookup value sets referenced by the "_LA:" tokens (IGS_LOOKUP_VALUES for IGS_MODULES and CAL_CAT) are resolved by the application tier and are not part of the view's SQL join graph.

Key Columns

Common Use Cases and Queries

The principal scenario is resolving the catalogue of seeded system date types and their validation and category restrictions, for example when troubleshooting calendar date entry or building a reporting extract. A representative query is:

  • SELECT system_date_type, system_date_type_desc, validation_procedure, one_per_cal_flag FROM igsfv_cal_prd_evnt_typ_configs ORDER BY system_date_type; — enumerates all seeded date types.
  • SELECT date_alias, date_alias_description, system_date_type FROM igsfv_cal_prd_evnt_typ_configs WHERE system_date_type = :p_type; — isolates the aliases bound to a specific date type.
  • SELECT DISTINCT owner_module, restricted_cal_category FROM igsfv_cal_prd_evnt_typ_configs; — summarises module and category coverage.

Because the view is read-only, it is appropriate for query-only responsibilities and personalisations; updates to configuration must target the underlying IGS_CA_DA_CONFIGS table through the supported IGS application forms.