Results for “residency_class_id”

7 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PE_RES_DTLS_ALL is a transactional table within the Oracle E-Business Suite Student System (IGS) product family. It stores the residency detail records associated with a person (student), capturing the classification, status, and evaluation history of residency determinations used by higher-education institutions for tuition assessment, fee calculation, and regulatory reporting. The table is documented as obsolete in later releases yet remains part of the 12.1.1 and 12.2.2 physical schema under the IGS owner, spanning 40 columns.

From a data-modeling perspective, the ETRM metadata classifies this object as satellite-leaning. Under Data Vault heuristics, this suggests IGS_PE_RES_DTLS_ALL behaves primarily as a descriptive satellite attached to a person hub (HZ_PARTIES) and to residency classification reference data, rather than as a standalone hub or a pure link. Each row enriches a person's core identity with time-bound residency attributes, which is characteristic satellite behavior.

Key Information Stored

The table is anchored by two documented unique indexes. IGS_PE_RES_DTLS_PK defines the surrogate primary key on RESIDENT_DETAILS_ID, a system-generated identifier. The second unique index, IGS_PE_RES_DTLS_U2 (the object referenced in the user's search), represents the business-key candidate and is composed of PERSON_ID, RESIDENCY_CLASS_CD, CAL_TYPE, and SEQUENCE_NUMBER. This composite key enforces that a person may hold only one substantive residency detail of a given class and calendar type at a specific sequence point.

  • RESIDENT_DETAILS_ID — surrogate primary key, unique per residency detail row.
  • PERSON_ID — foreign key to HZ_PARTIES, identifying the student or person to whom the residency record belongs.
  • RESIDENCY_CLASS_ID and RESIDENCY_CLASS_CD — foreign key references to IGS_PE_CODE_CLASSES, defining the residency classification applied.
  • RESIDENCY_STATUS_ID and RESIDENCY_STATUS_CD — references to IGS_PE_CODE_CLASSES describing the status of the residency determination.
  • CAL_TYPE and SEQUENCE_NUMBER — foreign key pair to IGS_CA_INST_ALL, tying the record to an academic calendar instance.
  • EVALUATION_DATE and EVALUATOR — capture when and by whom the residency determination was made.
  • START_DT and END_DT — effective-dating range for the residency detail.
  • ORG_ID — multi-org operating unit context.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard EBS descriptive flexfield (DFF) columns for institution-specific extensions.
  • CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — standard EBS audit trail columns.

Common Use Cases and Queries

Typical reporting scenarios include extracting a student's active residency classification for a given term, auditing changes made by evaluators, and feeding residency data into tuition and fee calculations. A representative query joining the business key to the person and calendar follows:

  • Retrieve residency details for a person: SELECT residency_class_cd, residency_status_cd, start_dt, end_dt FROM igs_pe_res_dtls_all WHERE person_id = :p_person_id AND SYSDATE BETWEEN start_dt AND NVL(end_dt, SYSDATE);
  • Join to HZ_PARTIES for student names: SELECT p.party_name, r.residency_class_cd FROM igs_pe_res_dtls_all r, hz_parties p WHERE r.person_id = p.party_id;
  • Resolve the calendar instance via IGS_CA_INST_ALL using CAL_TYPE and SEQUENCE_NUMBER to report residency by academic period.
  • Audit reporting against IGS_PE_RES_DTLS_H to identify historical changes keyed on PERSON_ID and RESIDENCY_CLASS_CD.

Related Objects

Significant related objects, based on documented foreign key relationships, include:

  • HZ_PARTIES — joined on PERSON_ID; the primary person/party master.
  • IGS_CA_INST_ALL — joined on CAL_TYPE and SEQUENCE_NUMBER; the academic calendar instance.
  • IGS_PE_CODE_CLASSES — referenced twice, via RESIDENCY_STATUS_ID and RESIDENCY_CLASS_ID, supplying classification codes.
  • IGS_PE_RES_DTLS_H — the history/audit table referencing this table on PERSON_ID and RESIDENCY_CLASS_CD.