Search Results res_status_desc

Overview

IGS_PE_TEACH_PERIODS_V is a reporting view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It presents teaching period assignments for persons — typically academic staff or instructors — together with the calendar context and the residency status description associated with each assignment. The view is a denormalized read-only construct intended for inquiry, reporting, and integration scenarios where consumers require a flat, human-readable representation of teaching period data without navigating the underlying normalized model.

The object name reflects its functional lineage. The suffix "TEACH_PERIODS" denotes the teaching period entity, while the lookup type referenced within the view text, PE_TEA_PER_RES, corresponds to the search term "pe_tea_per_res" and governs the residency status values surfaced by the view. In Oracle EBS 12.1.1 and 12.2.2 the view remains VALID in the APPS schema and is delivered as part of the standard IGS installation.

Underlying Base Objects

The view is defined over five base objects, joined through the following relationships:

• IGS_PE_TEACH_PERIODS_ALL — the primary driving table, aliased TP, supplying teaching period identifiers, person identifiers, calendar type, sequence number, residency status code, and standard WHO columns.
• IGS_CA_INST_ALL — aliased CI, the calendar instance table, joined on both SEQUENCE_NUMBER and CAL_TYPE to supply the calendar alternate code and description.
• IGS_LOOKUP_VALUES (aliased CC) — joined on LOOKUP_CODE = TP.TEACH_PERIOD_RESID_STAT_CD with LOOKUP_TYPE = 'PE_TEA_PER_RES', providing the meaning of the residency status.
• IGS_CA_TYPE — aliased TYP, joined on CAL_TYPE, supplying the calendar category code S_CAL_CAT.
• IGS_LOOKUP_VALUES (aliased CAL_CAT) — a second reference to the lookup view joined on LOOKUP_TYPE = 'CAL_CAT' against TYP.S_CAL_CAT, resolving the calendar category meaning.

Because the view joins IGS_PE_TEACH_PERIODS_ALL and IGS_CA_INST_ALL — both of which are "_ALL" tables in the IGS data model — the view is not ORG-striped and returns teaching period records across all business units represented in those tables.

Key Columns

• ROW_ID — the row identifier of the underlying teaching period record; useful for direct back-references to the base table.
• TEACHING_PERIOD_ID — the unique surrogate key of the teaching period assignment.
• PERSON_ID — the party/person identifier of the assigned staff member.
• PERSON_NUMBER — exposed as NULL in the view text; consumers requiring the person number must join to person tables independently.
• ALTERNATE_CODE and CALENDAR_DESC — the calendar alternate code and description drawn from IGS_CA_INST_ALL.
• TEACH_PERIOD_RESID_STAT_CD and RES_STATUS_DESC — the residency status code on the assignment and its translated meaning from lookup type PE_TEA_PER_RES.
• START_DATE and END_DATE — exposed as NULL placeholders; actual period dates are not materialized by this view.
• CAL_TYPE, SEQUENCE_NUMBER — calendar type and sequence identifiers that link the record to the calendar instance.
• CALENDAR_CATEGORY — the translated calendar category meaning derived from lookup type CAL_CAT.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical usage involves reporting teaching assignments by calendar and residency status, validating lookup translation of PE_TEA_PER_RES, and exposing teaching period data to external scheduling or HR systems. A representative query follows:

SELECT teaching_period_id, person_id, res_status_desc, calendar_desc, calendar_category FROM apps.igs_pe_teach_periods_v WHERE cal_type = :p_cal_type ORDER BY calendar_category, person_id;

Because PERSON_NUMBER, START_DATE, and END_DATE are returned as NULL, any report requiring those attributes must join to the person and calendar date tables separately. Filtering on residency status should use the code column for index alignment and the description column for display only.