Search Results igf_ap_housing_map_pk

Overview

The IGF_AP_HOUSING_MAP table is an Oracle E-Business Suite object belonging to the IGF — Financial Aid product family, which is classified in the ETRM documentation as Obsolete. The table defines a housing status mapping between the Oracle Student System (OSS) and Financial Aid (FA), allowing the institution to translate a housing status code captured in the student system into an award-phase housing plan code used by the financial aid engine. In 12.1.1 and 12.2.2 file systems where it exists, the object is owned by the IGF schema and is documented with nine physical columns. ETRM records note that the table is Not implemented in this database, meaning it may be absent, empty, or present only as a seeded definition depending on the installation and patch level.

From a data-vault modeling perspective, the ETRM metadata heuristically classifies this object as satellite-leaning. This classification is a modeling suggestion rather than a physical constraint: the table functions primarily as a descriptive lookup that records the housing-plan attribute associated with a business key formed by calendar type, sequence number, and housing status code, rather than acting as an independent entity hub or a pure association link.

Key Information Stored

The documented physical schema of IGF_AP_HOUSING_MAP contains nine columns. The most significant of these are:

• CI_CAL_TYPE — Calendar type identifier; the leading component of both the primary key and the foreign key to IGS_CA_INST_ALL. Identifies the academic calendar context in which the housing mapping applies.
• CI_SEQUENCE_NUMBER — Calendar instance sequence number; the second component of the primary key and the FK pair to IGS_CA_INST_ALL. Together with the calendar type it identifies a specific calendar instance (for example an academic year or term).
• HOUSING_STAT_CODE — The housing status code from OSS; the third component of the primary key and the value being mapped.
• AP_HOUSE_PLAN_CODE — The award-phase housing plan code emitted by financial aid when the corresponding housing status is matched. This is the effective payload of the mapping and the column typically consumed by downstream FA processing and reporting.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO columns capturing row-level audit history and the login context of the last change.

The surrogate primary key per ETRM is IGF_AP_HOUSING_MAP_PK. The documented unique index — and therefore the business-key candidate — is the composite of CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and HOUSING_STAT_CODE. No separate single-column surrogate column is documented; the PK is a natural concatenated key.

Common Use Cases and Queries

Typical usage centers on translating OSS housing status into the FA housing plan during award processing, and on validating mapping completeness across calendar instances. Common patterns include:

• Looking up the housing plan code for a given status and calendar instance. Example: SELECT AP_HOUSE_PLAN_CODE FROM IGF_AP_HOUSING_MAP WHERE CI_CAL_TYPE = :cal_type AND CI_SEQUENCE_NUMBER = :seq AND HOUSING_STAT_CODE = :stat_code;
• Auditing which housing statuses exist per term: SELECT CI_CAL_TYPE, CI_SEQUENCE_NUMBER, HOUSING_STAT_CODE, AP_HOUSE_PLAN_CODE FROM IGF_AP_HOUSING_MAP ORDER BY 1,2,3;
• Join-based reporting against calendar instances: SELECT m.* FROM IGF_AP_HOUSING_MAP m, IGS_CA_INST_ALL c WHERE m.CI_CAL_TYPE = c.CI_CAL_TYPE AND m.CI_SEQUENCE_NUMBER = c.CI_SEQUENCE_NUMBER;
• Reconciliation of mapping coverage by comparing distinct statuses against the financial aid housing plan reference set.

Related Objects

• IGS_CA_INST_ALL — The documented foreign key target, joined on CI_CAL_TYPE and CI_SEQUENCE_NUMBER. It supplies the calendar instance definition for each mapping row.
• IGF_AP_HOUSING_MAP_PK — The primary/unique index enforcing uniqueness of calendar type, sequence number, and housing status code.
• Financial aid housing plan reference tables (IGF/FA award housing objects) — Consume AP_HOUSE_PLAN_CODE to resolve award housing treatment.
• OSS student housing status reference objects — Supply the source HOUSING_STAT_CODE values.
• Standard WHO audit columns reference the EBS application user and login context via FND_USER and related session objects.

Because the object is documented as obsolete and not implemented in the reference database, implementation plans and queries should first confirm existence and row counts in the target instance before relying on the mapping.