Results for “element_code_value”
5 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view IGS_CA_DA_PRT_OVD_VALS_V belongs to the Oracle EBS IGS — Student System product family, a module now classified as obsolete. Its documented purpose is to "pickup system date type calendar date alias overridden program types." In practical terms, the view resolves override records defined at the program-type (course-type) level for calendar date aliases, joining the raw override values stored in the transactional override table against the program-type definition and the date-alias override level lookup.
The primary search term associated with this object, igs_da_ovrd_elt_level, is an IGS lookup type. The view filters IGS_LOOKUP_VALUES on this exact lookup type to restrict rows to those overrides that operate at the element (program-type) level, thereby excluding overrides expressed at other levels. Reporting and integration use cases centre on determining, for a given system date type and date alias, which program types carry an overridden date value and what that override means textually.
Underlying Base Objects
ETRM metadata for this view documents no referenced base objects explicitly, but the embedded view text identifies the three tables driving the query:
- IGS_CA_DA_OVD_VALS — the alias
VALin the view text; holds the actual calendar date alias override values, keyed byOVRD_VAL_ID, withSYS_DATE_TYPE,ELEMENT_CODEandDATE_ALIAS. - IGS_PS_TYPE_ALL — aliased
PSC; the program (course) type definition table, supplyingCOURSE_TYPEandDESCRIPTION. - IGS_LOOKUP_VALUES — aliased
LKUP; the lookup value table, filtered toLOOKUP_TYPE = 'IGS_DA_OVRD_ELT_LEVEL'and joined onLOOKUP_CODEto the override element code.
The joins are inner joins: VAL.ELEMENT_CODE_VALUE = PSC.COURSE_TYPE links the override to a valid program type, and VAL.ELEMENT_CODE = LKUP.LOOKUP_CODE constrained by the specified lookup type links the override to a recognized element level. Rows whose element code is not a valid IGS_DA_OVRD_ELT_LEVEL lookup value, or whose element code value is not a current program type, are excluded from the result set.
Key Columns
- ROW_ID / ROWID — the physical row identifier from the override table; exposed as
VAL.ROWID. - OVRD_VAL_ID — unique identifier of the override value record.
- SYS_DATE_TYPE — the system date type to which the override applies.
- ELEMENT_CODE — the override element level code, resolved against the
IGS_DA_OVRD_ELT_LEVELlookup. - MEANING — the lookup value meaning associated with
ELEMENT_CODE, providing a readable label for the override level. - COURSE_TYPE (from
IGS_PS_TYPE_ALL) — the program type carrying the override. - DESCRIPTION — the descriptive name of that program type.
- ELEMENT_CODE_VALUE / ELEMENT_CODE_VAL_DESC — listed as columns of the view, representing the program-type code value and its description.
- DATE_ALIAS — the calendar date alias whose value is being overridden.
- Audit columns —
CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN.
Common Use Cases and Queries
Typical uses include auditing which program types override a given date alias, validating that element codes map to the intended override level, and feeding downstream date derivation logic in the student system.
SELECT ovrd_val_id,
sys_date_type,
element_code,
meaning,
course_type,
description,
date_alias
FROM igs_ca_da_prt_ovd_vals_v
WHERE sys_date_type = :p_sys_date_type
AND date_alias = :p_date_alias
ORDER BY course_type;
To list overrides for a single program type:
SELECT date_alias, element_code, meaning
FROM igs_ca_da_prt_ovd_vals_v
WHERE course_type = :p_course_type;
Note that the metadata states "Not implemented in this database," and the view belongs to an obsolete module; in 12.1.1 and 12.2.2 environments the object may be absent or replaced by the IGS successors (for example, the Student Information/Student Management rebranding). Confirm existence via ALL_VIEWS before relying on it in concurrent programs or integrations.
-
View to pickup system date type calendar date alias overridden program types
Not implemented in this database·Explore IGS module →
-
To identify Date Alias Overrides for a system date type at the level of Application type
Not implemented in this database·Explore IGS module →
-
Table: IGS_CA_DA_OVD_VALS 12.2.2
This entity will store the overridden date type information for the seeded system date types.
Not implemented in this database·Explore IGS module →
-
View to pickup system date type calendar date alias overridden org unit
Not implemented in this database·Explore IGS module →
-
View to pickup system date type calendar date alias overridden program versions
Not implemented in this database·Explore IGS module →