Search Results external_reference_desc

Overview

The view IGS_PE_PERS_ENCUMB_V belongs to the IGS product family — the Oracle Student System module set. Within the ETRM documentation it is classified as IGS - Student System (Obsolete), and the metadata records it as "Not implemented in this database." Its purpose is to present person-level encumbrances (holds, blocks, or restrictions placed against an individual) together with the descriptive attributes needed for reporting: who the encumbrance applies to, who authorised it, the authorising responsibility, its validity window, and any external reference. The view is a denormalised, read-oriented projection rather than a base transactional entity.

For users searching on person_number, this view is significant because it exposes the person number twice: once for the encumbered person and once for the authorising person. This makes it directly usable in reports that need to identify people by their human-readable student or person identifier rather than by internal PERSON_ID surrogate keys.

Underlying Base Objects

The view text joins a single base table with four supporting objects:

• IGS_PE_PERS_ENCUMB E — the driving base table holding the encumbrance records themselves.
• IGS_PE_PERSON_BASE_V P1 — supplies the person number of the encumbered person; joined on E.PERSON_ID = P1.PERSON_ID (inner join).
• IGS_PE_PERSON_BASE_V P2 — supplies the person number of the authorising person; joined on E.AUTHORISING_PERSON_ID = P2.PERSON_ID (+) (outer join, so encumbrances without an authoriser are retained).
• FND_RESPONSIBILITY_VL R — resolves the authorising responsibility name; outer-joined on E.AUTH_RESP_ID = R.RESPONSIBILITY_ID (+).
• IGS_LOOKUP_VALUES L1 — decodes the external reference code; outer-joined with L1.LOOKUP_TYPE (+) = 'PE_EXT_REF'.

No referenced base objects were separately documented in the ETRM metadata, so the joins above are derived from the published view text. The outer joins make the view tolerant of missing authorisers, responsibilities, or external reference lookups.

Key Columns

• ROW_ID — row identifier from the base encumbrance record.
• PERSON_ID / PERSON_NUMBER — internal key and person number of the encumbered person (from P1).
• AUTHORISING_PERSON_ID / AUTHORISING_PERSON_NUMBER — the person who raised or approved the encumbrance (from P2).
• ENCUMBRANCE_TYPE — classification of the encumbrance.
• CAL_TYPE — calendar type associated with the encumbrance.
• SEQUENCE_NUMBER — sequencing within the encumbrance set.
• START_DT / EXPIRY_DT — the validity window of the encumbrance.
• COMMENTS — free-text notes.
• SPO_COURSE_CD / SPO_SEQUENCE_NUMBER — course and sequence linkage for student programme offerings.
• AUTH_RESP_ID / AUTH_RESP_NAME — authorising responsibility key and decoded name.
• EXTERNAL_REFERENCE / EXTERNAL_REFERENCE_DESC — external code and its PE_EXT_REF lookup meaning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include institutional reporting on active student holds, auditing who authorised each encumbrance, and integration extracts that publish encumbrance data keyed by person number.

SELECT person_number,
       encumbrance_type,
       start_dt,
       expiry_dt,
       authorising_person_number,
       auth_resp_name
FROM   igs_pe_pers_encumb_v
WHERE  person_number = :p_person_number
AND    TRUNC(SYSDATE) BETWEEN start_dt AND NVL(expiry_dt, TRUNC(SYSDATE));

Because the module is flagged obsolete and the view is recorded as not implemented in the documented database, any code depending on it should be reviewed against the target 12.1.1 or 12.2.2 instance before deployment.