Results for “reference_code”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view IGSBV_USEC_OCCUR_REFERENCES is a base database view owned by the APPS schema within the Oracle E-Business Suite Student System product (IGS). Its documented role is to expose the reference information associated with unit section occurrences — the discrete scheduled or deliverable instances of a unit section in an academic term. The view is defined as a read-only projection over a single underlying table and does not perform joins, aggregation, or transformation beyond column aliasing.
Because it is a business view ("BV") prefixed object, it is intended as a stable, presentation-layer interface for reporting, concurrent programs, and integration extracts that must retrieve occurrence reference codes and their descriptions without querying the base transactional table directly. In Oracle EBS 12.1.1 and 12.2.2 the object remains VALID and is shipped as part of the APPS edition of the IGS schema.
Underlying Base Objects
The view is defined over a single table, IGS_PS_USEC_OCUR_REF, aliased as UOR in the view text. The documented DDL is a straight column mapping with a WITH READ ONLY clause, which prevents DML through the view and enforces its use strictly for query access. No other base tables, synonyms, or views are referenced in the documented definition.
Each row of the base table represents one reference attached to one unit section occurrence, joined logically by the UNIT_SECTION_OCCURRENCE_ID foreign key to the unit section occurrence entity. The ETRM metadata for 12.2.2 documents no additional referenced base objects, so the relationship between the view and the underlying data model is one-to-one at the row level.
Key Columns
REFERENCE_CODE_TYPE— Classifies the nature of the reference, allowing multiple reference categories to coexist for the same occurrence.REFERENCE_CODE— The coded value of the reference, typically resolving to a lookup or reference-code definition elsewhere in the Student System.REFERENCE_CODE_DESCRIPTION— The descriptive text for the reference code. This is the column most often targeted by users searching for "reference_code_description", and it is exposed under exactly that name in the view even though the base column isREFERENCE_CODE_DESC.UNIT_SEC_OCCUR_REFERENCE_ID— Primary identifier for the occurrence reference record.UNIT_SECTION_OCCURRENCE_ID— Foreign key linking the reference to its parent unit section occurrence.CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE— Standard Oracle EBS audit columns capturing who created and last modified the row and when.
Common Use Cases and Queries
Typical uses include extracting all references for a given occurrence, validating that required reference types exist before a scheduling process runs, and producing descriptive reports that translate coded references for academic administrators.
Retrieve all references for a specific occurrence:
SELECT reference_code_type, reference_code, reference_code_description
FROM apps.igsbv_usec_occur_references
WHERE unit_section_occurrence_id = :occurrence_id;
List distinct reference descriptions by type for a term:
SELECT DISTINCT reference_code_type, reference_code_description
FROM apps.igsbv_usec_occur_references
ORDER BY reference_code_type, reference_code_description;
Audit recently changed reference data:
SELECT unit_sec_occur_reference_id, reference_code_description,
last_updated_by, last_update_date
FROM apps.igsbv_usec_occur_references
WHERE last_update_date >= SYSDATE - 30;
Because the view is read-only and single-table, these queries are inexpensive and safe for ad hoc reporting and integration extracts against both 12.1.1 and 12.2.2 environments.
-
Base View for Unit Section Occurrence Reference
Not implemented in this database·Explore IGS module →
-
View: IGS_PS_USEC_OCUR_REF_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_PS_US_REQ_REF_CD_V 12.2.2
Not implemented in this database·Explore IGS module →
-
Full View for Unit Section Occurrence Reference
Not implemented in this database·Explore IGS module →
-
View: IGS_PS_USEC_REF_CD_V 12.2.2
Not implemented in this database·Explore IGS module →
-
This is a full view, which describes a reference code or codes that relates to the program.
Not implemented in this database·Explore IGS module →
-
View: IGS_PS_UNITREQREF_CD_V 12.2.2
Not implemented in this database·Explore IGS module →
-
This is a base view, which describes a reference code or codes that relates to the program.
Not implemented in this database·Explore IGS module →
-
Table: IGS_PS_UNITREQREF_CD 12.2.2
This table contains information about Unit Requirements Reference Codes
Not implemented in this database·Explore IGS module →
-
Table: IGS_PS_USEC_OCUR_REF 12.2.2
Entity to capture the Occurrences of a Unit Section.
Not implemented in this database·Explore IGS module →
-
Table: IGS_PS_US_REQ_REF_CD 12.2.2
This table contains information about Unit Section Requirements Reference Codes.
Not implemented in this database·Explore IGS module →
-
Table: IGS_PS_USEC_REF_CD 12.2.2
Entity to capture the relation between Unit Sections Reference and Reference codes.
Not implemented in this database·Explore IGS module →
-
This is the base view, which describes reference code or codes related to the unit.
Not implemented in this database·Explore IGS module →
-
View: IGSFV_USEC_REFERENCES 12.2.2
This is the full view, which describes the relation between unit sections reference and reference codes
Not implemented in this database·Explore IGS module →
-
This is the full view, which describes reference code or codes related to the unit.
Not implemented in this database·Explore IGS module →
-
View: IGSBV_USEC_REFERENCES 12.2.2
This is the base view, which describes the relation between unit sections reference and reference codes
Not implemented in this database·Explore IGS module →
-
Student Unit Attempt Reference Codes
Not implemented in this database·Explore IGS module →
-
Student Unit Attempt Reference Codes
Not implemented in this database·Explore IGS module →