Results for “igf_ap_pers_note”

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

Overview

IGF_AP_PERS_NOTE is a Financial Aid (IGF) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 releases. It stores institution-defined note types that pertain either to an individual student or to a specific award year processed through the Financial Aid base record structures. In practice, the table functions as an annotation repository, allowing financial aid administrators to associate free-text or coded remarks—such as counseling notes, verification observations, or award-year commentary—with the parent aid record.

Per the mined foreign-key topology, the table exhibits the characteristics of a Data Vault link construct. It joins an aid-year base record (IGF_AP_FA_BASE_REC_ALL) to a person note type reference (IGS_PE_NOTE_TYPE), capturing the relationship between an award-year entity, a student, and an institution-defined note classification. This classification is a heuristic modeling suggestion rather than a documented design statement, and the presence of descriptive attributes (SHORT_DESC) also gives the row satellite-like characteristics.

Key Information Stored

The table is documented with ten columns in the ETRM 12.1.1 physical schema. The most consequential are:

• REFERENCE_NUMBER — the surrogate primary key (IGF_AP_PERS_NOTE_PK) and also the business-key candidate exposed through unique index IGF_AP_PERS_NOTE_U1. It uniquely identifies each note instance.
• BASE_ID — foreign key to IGF_AP_FA_BASE_REC_ALL, anchoring the note to the financial aid base record for the student and award year.
• PE_NOTE_TYPE — foreign key to IGS_PE_NOTE_TYPE, supplying the institution-defined note type code (for example, verification, counseling, or academic progress).
• SHORT_DESC — the short description or text of the note itself.
• REC_RESP — the responsible party or record responsibility field, indicating who owns or manages the note.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns providing who/when insert and update traceability.

The surrogate primary key (REFERENCE_NUMBER) is a system-generated identifier, whereas the natural business identity of a note is defined by the combination of BASE_ID and PE_NOTE_TYPE together with the note content.

Common Use Cases and Queries

Typical scenarios include reviewing all notes for a student's award year, listing notes of a specific institution-defined type, and auditing note maintenance by user or date. Sample join patterns:

• Notes for a base record: SELECT p.REFERENCE_NUMBER, p.PE_NOTE_TYPE, p.SHORT_DESC, p.REC_RESP FROM IGF.IGF_AP_PERS_NOTE p WHERE p.BASE_ID = :base_id ORDER BY p.CREATION_DATE DESC;
• Decoding note types: SELECT p.REFERENCE_NUMBER, n.DESCRIPTION, p.SHORT_DESC FROM IGF.IGF_AP_PERS_NOTE p, IGS.IGS_PE_NOTE_TYPE n WHERE p.PE_NOTE_TYPE = n.PE_NOTE_TYPE;
• Full context by student and award year: join IGF_AP_FA_BASE_REC_ALL to the person and award-year tables using BASE_ID, then join to IGS_PE_NOTE_TYPE.
• Audit reporting: filter on LAST_UPDATED_BY and LAST_UPDATE_DATE to extract notes modified within a reporting period.

Reporting use cases include verification tracking, financial aid counseling logs, and audit trails for award-year decisions.

Related Objects

The significant related objects are the tables connected through the documented foreign keys and primary key:

• IGF_AP_FA_BASE_REC_ALL — parent base record; joined on BASE_ID = IGF_AP_PERS_NOTE.BASE_ID.
• IGS_PE_NOTE_TYPE — note type reference; joined on PE_NOTE_TYPE.
• IGF_AP_PERS_NOTE_PK / IGF_AP_PERS_NOTE_U1 — primary key constraint and unique index on REFERENCE_NUMBER.
• IGF_AP_FA_BASE_REC_ALL dependent financial aid award-year tables that inherit the base-record context.
• Oracle EBS audit/security objects (FND_USER via CREATED_BY and LAST_UPDATED_BY) used for traceability reporting.

Because BASE_ID carries the student and award-year context, any object or report joining to IGF_AP_FA_BASE_REC_ALL can incorporate personal notes through this table.