Results for “igf_ap_pr_prg_type”

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

Overview

IGF_AP_PR_PRG_TYPE is a Financial Aid configuration table within the Oracle E-Business Suite IGF (Financial Aid) module. It stores basic information about year-specific Program Types that can be used to define Grade Levels for a specific program type's class standing. In the context of the Oracle EBS 12.1.1 and 12.2.2 releases, the object is documented as obsolete and is not implemented in the reference database, meaning it should be treated as a legacy or dormant artifact rather than an active operational table. Its purpose during active use was to anchor the relationship between an academic program type, its calendar context, and the schedule used to determine class standing.

The ETRM relationship metadata classifies this object with a satellite-leaning Data Vault heuristic. This suggests a modeling approach in which IGF_AP_PR_PRG_TYPE behaves as a descriptive satellite attached to a business hub or link, carrying context attributes (calendar type, sequence number, schedule reference) rather than serving as an independent hub of business keys. The classification is heuristic and mined from foreign key structure, so it should be regarded as a design suggestion rather than a canonical modeling decision.

Key Information Stored

The physical schema for this table in the 12.1.1 documentation comprises nine columns, four of which are descriptive and five of which are standard WHO audit columns. The most significant data-bearing columns are:

• PPT_ID — The surrogate primary key, defined by the unique index IGF_AP_PR_PRG_TYPE_PK. This column uniquely identifies each program type record and is the value propagated to dependent tables.
• IGS_PR_CS_SCHDL_ID — Foreign key to IGS_PR_CS_SCHDL, referencing the class standing schedule that governs how a student's class standing is derived for the program type.
• CAL_TYPE — Foreign key component referencing IGS_CA_INST_ALL, identifying the calendar type under which the program type is valid. This establishes the academic calendar context of the record.
• SEQUENCE_NUMBER — An ordering attribute that, together with IGS_PR_CS_SCHDL_ID and CAL_TYPE, forms the business-key candidate unique index IGF_AP_PR_PRG_TYPE_U1. It provides a deterministic ordering or disambiguation of records sharing the same schedule and calendar type.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle WHO audit columns capturing insert and update metadata for row-level traceability.

The distinction between the surrogate key (PPT_ID) and the business-key candidate (IGS_PR_CS_SCHDL_ID, CAL_TYPE, SEQUENCE_NUMBER) is important: joins and lookups driven by business meaning should normally target the unique index columns, while referential integrity from child tables targets the surrogate PPT_ID.

Common Use Cases and Queries

Because the table is obsolete and unimplemented in the documented database, practical usage today is limited to historical data retrieval, migration analysis, and impact assessment. Typical scenarios include identifying which class standing schedule applies to a given calendar type for a program type, and mapping legacy program type records forward into currently supported Financial Aid structures.

A representative query joining to the class standing schedule and calendar instance tables follows:

• SELECT p.PPT_ID, p.CAL_TYPE, p.SEQUENCE_NUMBER, p.IGS_PR_CS_SCHDL_ID FROM IGF_AP_PR_PRG_TYPE p WHERE p.CAL_TYPE = :cal_type ORDER BY p.SEQUENCE_NUMBER;
• SELECT m.PPT_ID, m.* FROM IGF_AP_CLASS_STD_MAP m WHERE m.PPT_ID = :ppt_id;

Reporting use cases center on reconciliation of program type configuration against class standing mappings, and on auditing the uniqueness of the (IGS_PR_CS_SCHDL_ID, CAL_TYPE, SEQUENCE_NUMBER) combination where legacy records were loaded.

Related Objects

The following objects are the most significant relationships documented for this table:

• IGF_AP_CLASS_STD_MAP — References IGF_AP_PR_PRG_TYPE via IGF_AP_CLASS_STD_MAP.PPT_ID, mapping program types to class standing definitions. This is the principal dependent table.
• IGS_PR_CS_SCHDL — Referenced by IGF_AP_PR_PRG_TYPE.IGS_PR_CS_SCHDL_ID, providing the class standing schedule definition.
• IGS_CA_INST_ALL — Referenced by IGF_AP_PR_PRG_TYPE.CAL_TYPE, supplying calendar instance and calendar type context for the program type record.

These three relationships, combined with the primary key and unique index definitions, constitute the complete documented integration surface for IGF_AP_PR_PRG_TYPE.