Search Results igsfv_cal_prd_evnt_type_ofsts

Overview

The view IGSFV_CAL_PRD_EVNT_TYPE_OFSTS (owner APPS) is a full-view entity within the Oracle E-Business Suite Student System product (IGS). It exposes the Calendar Period Event Type Offsets entity, which defines offset relationships between two date aliases. In the Oracle EBS academic calendar model, a date alias represents a named, resolvable calendar date (for example, an event type such as "term start" or "census date"). The offset entity captures the rule by which the value of one date alias is derived relative to another date alias, expressed in days, weeks, months, or years.

As a "full view," this object presents the complete set of columns for the entity, including both the functional offset definition and the standard Oracle WHO audit columns. This makes it suitable for reporting, integration extracts, and downstream date computation logic where the derivation rules among calendar period event types must be surfaced. The view is defined with the WITH READ ONLY clause, so it is intended strictly for query and reporting access; no DML is permitted through it. Status is documented as VALID in the APPS schema.

Underlying Base Objects

Although the ETRM 12.2.2 projected metadata lists no referenced base objects, the documented view text identifies the underlying tables explicitly:

• IGS_CA_DA_OFST — the base table holding the offset definition rows; it supplies the date alias, offset date alias, and the day/week/month/year offset values.
• IGS_CA_DA (aliased DA1) — the date alias definition table; joined on DA.DT_ALIAS = DA1.DT_ALIAS to retrieve the description of the primary date alias.
• IGS_CA_DA (aliased DA2) — the same date alias table, joined on DA.OFFSET_DT_ALIAS = DA2.DT_ALIAS to retrieve the description of the related (offset) date alias.

The view therefore performs a self-join of the date alias table in addition to its join to the offset table. Both joins are inner joins, so a row is returned only when the primary date alias and the offset date alias both resolve to valid IGS_CA_DA entries.

Key Columns

• DATE_ALIAS — the primary date alias whose value is being derived.
• OFFSET_DATE_ALIAS — the related date alias from which the primary value is derived.
• NUMBER_OF_DAY_OFFSET — day-based offset applied to the related date alias.
• NUMBER_OF_WEEK_OFFSET — week-based offset.
• NUMBER_OF_MONTH_OFFSET — month-based offset.
• NUMBER_OF_YEAR_OFFSET — year-based offset.
• DATE_ALIAS_DESCRIPTION — description of the primary date alias, sourced from IGS_CA_DA (DA1).
• OFFSET_DATE_ALIAS_DESCRIPTION — description of the related date alias, sourced from IGS_CA_DA (DA2).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit (WHO) columns propagated from the offset table.

Common Use Cases and Queries

Typical uses include validating calendar offset configuration, generating extracts of date derivation rules, and supporting date-alias computation in student calendar or enrolment processes. Because the view is read-only, it is safe for ad-hoc and reporting queries.

List all offsets with their alias descriptions:

SELECT date_alias,
       offset_date_alias,
       number_of_day_offset,
       number_of_week_offset,
       number_of_month_offset,
       number_of_year_offset
FROM   apps.igsfv_cal_prd_evnt_type_ofsts;

Retrieve offsets for a specific alias:

SELECT *
FROM   apps.igsfv_cal_prd_evnt_type_ofsts
WHERE  date_alias = :p_date_alias;

Find aliases derived with a positive day offset:

SELECT date_alias, offset_date_alias, number_of_day_offset
FROM   apps.igsfv_cal_prd_evnt_type_ofsts
WHERE  number_of_day_offset > 0
ORDER  BY date_alias;

Queries should be run against the APPS schema or through a synonym resolved to APPS, consistent with standard EBS object access conventions.