Search Results igs_ca_da_ofst




Overview
Explore in AI Chat

Overview

The IGS_CA_DA_OFST table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS), specifically designed for academic calendar management. Its primary function is to define and store the relationship between two date aliases, establishing one as an offset of another. A date alias is a named, business-meaningful date within an academic calendar, such as "TERM_START" or "ENROLLMENT_DEADLINE." This table enables the system to calculate dynamic dates by defining rules like "FINAL_EXAM_WEEK begins 10 weeks after MIDTERM_WEEK." It is critical for automating date-sensitive academic processes. Notably, the provided ETRM metadata explicitly classifies the IGS product as "Obsolete," indicating this table belongs to a legacy module that may be deprecated or superseded in modern EBS implementations. Furthermore, the metadata states "Not implemented in this database," suggesting the specific instance of the documentation may be from an environment where this table was not deployed.

Key Information Stored

The table's structure is centered on linking two date aliases. The primary key is a composite of two columns, enforcing a unique relationship between any given pair. The most significant columns are:

  • DT_ALIAS: The base or reference date alias. This is the starting point for the offset calculation.
  • OFFSET_DT_ALIAS: The target date alias, which is defined as being a specific offset (e.g., +7 days, -1 month) from the base DT_ALIAS. The actual offset value (the number of days or other units) is not stored in this table but is likely managed through a related structure or application logic.

These two columns also serve as foreign keys, each referencing the IGS_CA_DA (Date Alias) table to ensure data integrity and valid alias names.

Common Use Cases and Queries

This table is utilized by academic calendar setup and scheduling engines. A common use case is generating a complete academic calendar for a term: by defining a chain of offset relationships from a single anchor date (e.g., "SEMESTER_1_START"), the system can programmatically derive dozens of subsequent critical dates. For reporting, one might query to understand all date dependencies. A typical SQL pattern would involve self-joining or querying related tables to traverse these relationships.

Sample Query: Find all offset aliases for a base date alias
SELECT offset_dt_alias FROM igs_ca_da_ofst WHERE dt_alias = 'TERM_BEGIN';
Sample Query: List all defined date alias relationships
SELECT da1.description AS base_date, da2.description AS offset_date FROM igs_ca_da_ofst ofst JOIN igs_ca_da da1 ON ofst.dt_alias = da1.dt_alias JOIN igs_ca_da da2 ON ofst.offset_dt_alias = da2.dt_alias;

Related Objects

The IGS_CA_DA_OFST table exists within a tightly integrated schema for calendar management. Its primary relationships are:

  • IGS_CA_DA (Date Alias): This is the parent table, referenced twice via foreign key constraints from both the DT_ALIAS and OFFSET_DT_ALIAS columns. It stores the master list of all date alias definitions.
  • IGS_CA_DA_OFFCNT: This table references IGS_CA_DA_OFST, likely storing the specific count or magnitude (e.g., +10, -5) and the unit of measure (days, weeks) for the offset relationship defined in IGS_CA_DA_OFST. The foreign key uses the composite primary key (DT_ALIAS, OFFSET_DT_ALIAS).

Given the obsolete status of the module, development of new integrations or reports using this table is not recommended. Any necessary access should be handled with caution, considering potential migration paths to successor applications.

  • Table: IGS_CA_DA_OFST 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CA_DA_OFST,  object_name:IGS_CA_DA_OFST,  status:VALID,  product: IGS - Student System ,  description: Describes the relationship between one date alias and another ,  implementation_dba_data: IGS.IGS_CA_DA_OFST , 

  • Table: IGS_CA_DA 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CA_DA,  object_name:IGS_CA_DA,  status:VALID,  product: IGS - Student System ,  description: Describes available date alias types ,  implementation_dba_data: IGS.IGS_CA_DA , 

  • Table: IGS_CA_DA_OFFCNT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CA_DA_OFFCNT,  object_name:IGS_CA_DA_OFFCNT,  status:VALID,  product: IGS - Student System ,  description: Describes the set of constraints to be applied when applying an offset to generate a date alias value from another date alias ,  implementation_dba_data: IGS.IGS_CA_DA_OFFCNT , 

  • View: IGSFV_CAL_PRD_EVNTYP_OFST_CONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_CAL_PRD_EVNTYP_OFST_CONS,  object_name:IGSFV_CAL_PRD_EVNTYP_OFST_CONS,  status:VALID,  product: IGS - Student System ,  description: This is the full view for the entity Calendar Per Evnt Type Offset Constraint which describes the set of constraints to be applied when applying an offset to generate a date alias value from another date alias. ,  implementation_dba_data: APPS.IGSFV_CAL_PRD_EVNTYP_OFST_CONS , 

  • View: IGSFV_CAL_PRD_EVNT_TYPE_OFSTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_CAL_PRD_EVNT_TYPE_OFSTS,  object_name:IGSFV_CAL_PRD_EVNT_TYPE_OFSTS,  status:VALID,  product: IGS - Student System ,  description: This is the full view for the entity Calendar Period Event Type Offsets that describes the offset relationship between two date aliases. Offset values are used to derive the date alias value from the related date alias value. ,  implementation_dba_data: APPS.IGSFV_CAL_PRD_EVNT_TYPE_OFSTS , 

  • View: IGSBV_CAL_PRD_EVNTYP_OFST_CONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_CAL_PRD_EVNTYP_OFST_CONS,  object_name:IGSBV_CAL_PRD_EVNTYP_OFST_CONS,  status:VALID,  product: IGS - Student System ,  description: This is the base view for the entity Calendar Per Event Type Offset Constraint which describes the set of constraints to be applied when applying an offset to generate a date alias value from another date alias. ,  implementation_dba_data: APPS.IGSBV_CAL_PRD_EVNTYP_OFST_CONS , 

  • View: IGSBV_CAL_PRD_EVNT_TYPE_OFSTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_CAL_PRD_EVNT_TYPE_OFSTS,  object_name:IGSBV_CAL_PRD_EVNT_TYPE_OFSTS,  status:VALID,  product: IGS - Student System ,  description: This is the base view for the entity Calendar Period Event Type Offsets that describes the offset relationship between two date aliases. Offset values are used to derive the date alias value from the related date alias value. ,  implementation_dba_data: APPS.IGSBV_CAL_PRD_EVNT_TYPE_OFSTS ,