Results for “meaning_status”
5 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_CA_STAT_LKUP_V is a seeded, read-only database view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It exposes calendar status definitions maintained within the academic calendar setup infrastructure, joining the calendar status base table to the Oracle EBS lookup mechanism so that the internal lookup code stored against each status row is presented alongside its user-facing meaning. In EBS 12.1.1 and 12.2.2 the object is delivered with status VALID as part of the standard IGS installation, and it is referenced by calendar configuration forms, concurrent programs, and reporting layers that require a denormalized, human-readable status descriptor.
The view is particularly relevant to technical and functional implementers searching on the column or lookup code s_cal_status, which is the seeded lookup code used to classify calendar statuses. It serves as the canonical translation layer between the code value persisted in IGS_CA_STAT and the meaning displayed to end users.
Underlying Base Objects
Although the ETRM registry documents no referenced base objects, the view text recorded in the object metadata identifies the two sources used in its definition:
- IGS_CA_STAT — the calendar status base table, aliased CS, which holds the authoritative status rows including the internal code, description, closed indicator, and standard WHO audit columns.
- IGS_LOOKUPS_VIEW — the Oracle EBS lookup view, aliased LKUP, which supplies the meaning associated with the seeded lookup type
CALENDAR_STATUS.
The two sources are joined on LKUP.LOOKUP_CODE = CS.S_CAL_STATUS with the constant filter LKUP.LOOKUP_TYPE = 'CALENDAR_STATUS', so only rows with a matching seeded lookup code are returned. Because IGS_LOOKUPS_VIEW is largely a lookup-code-validated projection over the underlying lookup tables, the view effectively behaves as a status table enriched with multilingual and meaning-based lookup attributes. No additional filtering or aggregation is applied.
Key Columns
- ROW_ID — the ROWID of the underlying IGS_CA_STAT row, exposed for direct row addressing in update and validation logic.
- CAL_STATUS — the primary calendar status identifier from IGS_CA_STAT.
- DESCRIPTION — the descriptive text attached to the status record.
- S_CAL_STATUS — the seeded lookup code that drives the join to the lookup view; this is the value commonly searched as s_cal_status.
- MEANING_STATUS — the lookup meaning returned from IGS_LOOKUPS_VIEW for the matching CALENDAR_STATUS lookup code, providing the readable status label.
- CLOSED_IND — indicates whether the calendar status represents a closed state.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO audit columns inherited from IGS_CA_STAT.
Common Use Cases and Queries
The view is typically used to populate LOVs and flexfield-backed fields with status values, to validate a submitted calendar status against the seeded CALENDAR_STATUS lookup set, and to produce reporting output where the lookup meaning is preferred over the stored code.
Listing all valid calendar statuses:
SELECT cal_status, s_cal_status, meaning_status, description FROM apps.igs_ca_stat_lkup_v ORDER BY meaning_status;
Resolving the meaning for a specific status code:
SELECT meaning_status FROM apps.igs_ca_stat_lkup_v WHERE s_cal_status = :p_status_code;
Identifying open (non-closed) statuses for downstream calendar processing:
SELECT cal_status, s_cal_status, meaning_status FROM apps.igs_ca_stat_lkup_v WHERE NVL(closed_ind,'N') = 'N';
Because the view performs no aggregation, queries remain light and can be joined directly to calendar or term tables on CAL_STATUS or S_CAL_STATUS. Callers should apply standard EBS multi-org and security considerations through the calling form or report, and should treat the view as read-only, since DML is not supported against a join view of this construction.
-
View: IGS_CA_STAT_LKUP_V 12.1.1
APPS.IGS_CA_STAT_LKUP_V·↳ IGS_CA_STAT·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
View: IGS_CA_STAT_LKUP_V 12.2.2
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.