Search Results igs_ca_da_offcnt




Overview
Explore in AI Chat

Overview

The IGS_CA_DA_OFFCNT table is a data definition object within the Oracle E-Business Suite (EBS) Student System (IGS) module, which is now designated as obsolete. Its core function is to manage the rules governing date alias calculations. Specifically, it stores constraints that dictate how a date alias value should be derived by applying an offset to another date alias. This mechanism is essential for automating complex academic calendar calculations, such as determining a course drop deadline by offsetting a certain number of days from the semester start date. The table's metadata indicates it was not implemented in the referenced database, suggesting it may represent a planned or legacy data model component that was not fully deployed in the documented EBS 12.1.1 / 12.2.2 instances.

Key Information Stored

The table's structure is defined by a composite primary key, which identifies a unique constraint rule. The key columns are DT_ALIAS, OFFSET_DT_ALIAS, and S_DT_OFFSET_CONSTRAINT_TYPE. The DT_ALIAS column likely stores the identifier for the target date alias being calculated. The OFFSET_DT_ALIAS column holds the identifier for the source date alias from which the offset is applied. The S_DT_OFFSET_CONSTRAINT_TYPE column specifies the type of constraint to be enforced during the offset calculation. This constraint type would define the rule's logic, potentially restricting the calculation to specific days of the week, excluding holidays, or applying other calendar-based business rules.

Common Use Cases and Queries

In a functional Student System, this table would be queried by processes that generate academic calendar dates. A typical use case involves a batch job constructing a term schedule: for each required date alias (e.g., "FEE_DUE_DATE"), the system would query IGS_CA_DA_OFFCNT to find its source alias ("TERM_START") and the applicable constraint, then apply the defined offset from the IGS_CA_DA_OFST table. A sample analytical query might join these tables to report all defined offset rules:

  • SELECT cnt.dt_alias, cnt.offset_dt_alias, cnt.s_dt_offset_constraint_type, ofst.offset_value, ofst.uom
  • FROM igs_ca_da_offcnt cnt
  • JOIN igs_ca_da_ofst ofst ON cnt.dt_alias = ofst.dt_alias AND cnt.offset_dt_alias = ofst.offset_dt_alias;

Given the "not implemented" status, direct operational use cases or data manipulation language (DML) in these EBS versions would be non-existent.

Related Objects

The primary related object is the IGS_CA_DA_OFST (Date Alias Offset) table, as defined by the foreign key relationship. The IGS_CA_DA_OFFCNT table references IGS_CA_DA_OFST on the combination of DT_ALIAS and OFFSET_DT_ALIAS columns. This relationship indicates that for a given offset pair defined in IGS_CA_DA_OFST, one or more constraint rules in IGS_CA_DA_OFFCNT can be applied. The table itself is part of the broader Calendar (CA) sub-module within the obsolete Student System, and it would logically interact with core date alias and calendar definition tables, though specific dependencies are not listed in the provided metadata.

  • 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 , 

  • 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 , 

  • View: IGS_CA_DA_OFFCNT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_CA_DA_OFFCNT_V,  object_name:IGS_CA_DA_OFFCNT_V,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_CA_DA_OFFCNT_V , 

  • 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: 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 ,