Search Results prg_cd

Overview

The IGS_CA_DA_OVD_VALS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Global Systems (IGS) module, which typically handles academic functionality. This table is central to the management of date overrides within the academic calendar. Its primary role is to store mappings that allow a standard system date alias to be overridden with a specific, user-defined date alias for a particular organizational element, such as a program type or an organizational unit. This enables flexible and context-specific date calculations across different academic hierarchies and entities.

Key Information Stored

The table stores the relationships between system dates, organizational elements, and their custom date aliases. Key columns include:

• OVRD_VAL_ID: A mandatory, unique primary key (PK) for the table, populated by a sequence.
• SYS_DATE_TYPE: The seed or base System Date Type that is being overridden.
• ELEMENT_CODE: A foreign key (FK) to a lookup defining the type of overriding element (e.g., ORG for Org Unit, PROG_TYPE for Program Type).
• ELEMENT_CODE_VALUE: The specific value of the overriding element (e.g., 'UG' for Undergraduate, 'SCHOOL_LAW').
• DATE_ALIAS: The user-assigned Date Alias that replaces the standard system date alias for the specified element combination.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit tracking.

Common Use Cases and Queries

This table is primarily used to support academic calendar configurations where standard dates need exceptions. A common use case is defining a different semester start date alias for a specific undergraduate program ('UG') compared to the university-wide default. The table is queried by the application's calendar engine to resolve the correct date alias for a given context. A fundamental query to retrieve all override mappings is provided in the ETRM:

SELECT OVRD_VAL_ID, SYS_DATE_TYPE, ELEMENT_CODE, ELEMENT_CODE_VALUE, DATE_ALIAS FROM IGS.IGS_CA_DA_OVD_VALS;

For reporting or troubleshooting, one might join this table to relevant lookup tables (based on ELEMENT_CODE) to get descriptive names. A typical pattern is to query overrides for a specific element, such as all program type overrides: SELECT * FROM IGS_CA_DA_OVD_VALS WHERE ELEMENT_CODE = 'PROG_TYPE'; Direct data manipulation via DML is not recommended, as changes are typically managed through dedicated EBS forms and APIs.

Related Objects

As per the dependency information, the IGS_CA_DA_OVD_VALS table is referenced by an APPS synonym named IGS_CA_DA_OVD_VALS, which is the standard access point for the application code. It is indexed by two unique indexes: IGS_CA_DA_OVD_VAL_PK (on OVRD_VAL_ID) and IGS_CA_DA_OVD_VAL_U1 (on SYS_DATE_TYPE, ELEMENT_CODE, ELEMENT_CODE_VALUE), enforcing data integrity for the override rules. The ELEMENT_CODE column is a foreign key to an unspecified lookup table that defines valid element types (ORG, PROG_TYPE, PRG_CD). The table's data is logically related to the core academic calendar and date alias setup tables within the IGS schema.