Search Results ap_house_plan_code

Overview

IGF_AP_HOUSING_MAP_V is a reporting view in the Oracle E-Business Suite application schema APPS, owned by the Oracle Student System / Financial Aid (IGF) product family. In releases 12.1.1 and 12.2.2 the view exposes the contents of the IGF_AP_HOUSING_MAP base table in a denormalized, lookup-resolved form. The base mapping table associates an award-year or academic-period context (CI_CAL_TYPE and CI_SEQUENCE_NUMBER) with a housing status code and an "AP house plan code". The view joins these raw codes against lookup views so that meaningful descriptions (the MEANING columns) are returned alongside the stored values, and it joins the calendar instance to attach the period start date, end date, and alternate code.

The name is derived from "IGF" (Financial Aid), "AP" (Award Period / Aid Payment processing), and "HOUSING_MAP" (the housing-status-to-house-plan mapping). The suffix _V identifies it as a view rather than a table. It functions as a read-only presentation layer used by reports, concurrent programs, and interfaces that need housing mapping data without embedding the lookup join logic themselves.

Underlying Base Objects

The view text defines four referenced objects:

• IGF_AP_HOUSING_MAP APM — the driving base table holding the mapping rows, keyed by calendar type, sequence number, housing status code, and AP house plan code, together with the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).
• IGS_LOOKUPS_VIEW IGS — filtered by LOOKUP_TYPE = 'PE_TEA_PER_RES'; supplies the MEANING of the housing status code. The literal 'PE_TEA_PER_RES' indicates a lookup on person/period residence or residency-related values, which explains why that string is commonly matched when searching for this view.
• IGF_LOOKUPS_VIEW IGF — filtered by LOOKUP_TYPE = 'IGF_SCHOOL_HOUSE_TYPE'; supplies the MEANING of the AP house plan code (the school's housing plan classification).
• IGS_CA_INST CA — the calendar instance table, joined on CAL_TYPE and SEQUENCE_NUMBER, supplying START_DT, END_DT, and ALTERNATE_CODE for the referenced academic period.

The join is expressed in the legacy Oracle outer-join-free comma syntax, meaning an inner join: a mapping row is returned only when matching lookup definitions and a matching calendar instance exist. The ETRM metadata records no additional documented base objects beyond these four.

Key Columns

• ROWID — the base-table row identifier for IGF_AP_HOUSING_MAP, exposed for row-level addressing.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER — the calendar type and instance sequence identifying the academic period.
• START_DT, END_DT, ALTERNATE_CODE — the period start and end dates and the alternate calendar code from IGS_CA_INST.
• HOUSING_STAT_CODE, IGS.MEANING — the stored housing status code and its decoded meaning from the PE_TEA_PER_RES lookup.
• AP_HOUSE_PLAN_CODE, IGF.MEANING — the stored AP house plan code and its decoded meaning from the IGF_SCHOOL_HOUSE_TYPE lookup.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit columns carried through from the base table.

Common Use Cases and Queries

The view is typically queried to list current housing mappings for a given award period, or to resolve a status code to its descriptive meaning for reporting. A representative query restricts to one calendar instance while displaying both decoded meanings:

SELECT housing_stat_code,
       igs_meaning,
       ap_house_plan_code,
       igf_meaning,
       start_dt,
       end_dt
FROM   apps.igf_ap_housing_map_v
WHERE  ci_cal_type = :p_cal_type
AND    ci_sequence_number = :p_sequence_number;

A second common pattern resolves a single stored mapping to confirm the lookup text returned for PE_TEA_PER_RES, and a third pattern filters on ALTERNATE_CODE when reporting spans multiple institutions or calendar conventions. Because the view pre-joins both lookup views and the calendar instance, it removes the need for callers to replicate the PE_TEA_PER_RES and IGF_SCHOOL_HOUSE_TYPE lookup logic, ensuring consistent decoded output across financial aid reports and integration extracts in both 12.1.1 and 12.2.2.