Search Results expected_wl

Overview

IGS.IGS_PS_EXP_WL is an Oracle E-Business Suite table owned by the IGS (Student Systems / Higher Education) schema. Its FND Design Data identifier is IGS.IGS_PS_EXP_WL, and it is registered as VALID. The table stores the institutional-level setup data defining the expected workload associated with a given calendar category. Within the Oracle EBS 12.1.1 and 12.2.2 data model, it functions as an institutional configuration or lookup-style reference table that supports student workload planning and the classification of calendar categories such as Term (Load) and Academic calendar categories.

Physically, the table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10. Its unique index, IGS_PS_EXP_WL_PK, is stored in the APPS_TS_TX_IDX tablespace and enforces uniqueness on the CALENDAR_CAT column. From a Data Vault modeling perspective, the mined dependency structure classifies this object as hub-leaning: CALENDAR_CAT behaves as a natural business key that anchors a single hub of calendar-category-level workload configuration. Downstream associations, such as those recorded in IGS_PS_EMP_CATS_WL, behave as link or satellite structures referencing this hub. This classification is a modeling suggestion derived from the foreign-key topology rather than a declared EBS property.

Key Information Stored

The table contains eight documented columns. The most significant for functional and integration purposes are:

• CALENDAR_CAT — VARCHAR2(30). The calendar category at which expected workload is set at the institutional level. Permissible values include Term (Load) and Academic calendar categories. This column is both the business-key candidate and the sole column of the unique primary key index IGS_PS_EXP_WL_PK, making it the principal surrogate/business identifier for the row.
• CONTROL_NUM — NUMBER. Documented as no longer used; retained for backward compatibility.
• EXPECTED_WL — NUMBER. The expected workload for the given calendar category. Documented as obsolete, meaning it is retained in the physical schema but should not be treated as authoritative for new development or reporting.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns recording row creation and modification provenance, used for auditing, data lineage, and incremental extraction.

Because the unique index is defined on a single business column rather than a generated numeric sequence, CALENDAR_CAT serves simultaneously as the business key and the effective row identity, with CONTROL_NUM present but deprecated.

Common Use Cases and Queries

Typical usage centers on validating and reporting the configured set of calendar categories and any residual expected-workload values. A simple existence and category listing query is:

• SELECT CALENDAR_CAT, EXPECTED_WL FROM IGS.IGS_PS_EXP_WL ORDER BY CALENDAR_CAT;
• SELECT CALENDAR_CAT FROM IGS.IGS_PS_EXP_WL WHERE CALENDAR_CAT = 'Term';

Reporting scenarios include auditing which calendar categories are configured at institutional level, driving validation lists for downstream workload-entry or employee-category setup, and identifying rows whose EXPECTED_WL should be deprecated given the obsolete status of that column. Because the object is a hub-leaning reference table, it is commonly joined to dependent configuration tables on CALENDAR_CAT. Typical integration and ETL patterns use LAST_UPDATE_DATE for incremental pulls, and the table may be exposed through the IGS_PS_EXP_WL APPS synonym/view layer for concurrent programs and forms.

Related Objects

The documented dependency information records that IGS.IGS_PS_EXP_WL does not reference any other database object, but it is referenced by the following:

• IGS.IGS_PS_EMP_CATS_WL — joins on IGS_PS_EMP_CATS_WL.CAL_CAT_CODE = IGS_PS_EXP_WL.CALENDAR_CAT, establishing the employee-category workload association.
• APPS.IGS_PS_EXP_WL — the APPS-layer synonym/view through which the table is exposed to EBS application logic.

These referencing objects represent the principal consumers of the calendar-category configuration held in this table and constitute the primary join path for any query that enriches employee-category workload data with institutional-level calendar-category definitions.