Results for “igf_gr_rfms_all”

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

Overview

IGF_GR_RFMS_ALL is an obsolete Oracle EBS Financial Aid table belonging to the IGF product family. It is documented as an internal system table that stores Record File Management System (RFMS) data transmitted to the RFMS system, historically used for U.S. federal student aid origination and disbursement processing. The table is not implemented in the current database instance, meaning it exists in the data dictionary for legacy reference but is not actively populated by the 12.1.1 or 12.2.2 application code paths.

From a Data Vault modeling perspective, the foreign-key structure suggests a satellite-leaning classification. The table carries descriptive attributes about a discrete business event (an RFMS origination record) and depends on multiple upstream entities — awards, base records, calendar instances, and RFMS batch headers — rather than serving as a standalone hub or a pure associative link.

Key Information Stored

The table contains 63 documented columns in the 12.1.1 schema. The most significant include:

• ORIGINATION_ID — surrogate primary key and sole member of the unique index IGF_GR_RFMS_ALL_U1; a single-column business-key candidate.
• AWARD_ID, BASE_ID, RFMB_ID, CI_CAL_TYPE, CI_SEQUENCE_NUMBER — foreign keys anchoring the record to its award, base record, batch, and calendar instance.
• SYS_ORIG_SSN, SYS_ORIG_NAME_CD — originating student identifiers supplied to RFMS.
• EFC, SECONDARY_EFC, COA_AMOUNT, PELL_AMOUNT — need-analysis and award amounts used in origination calculations.
• TRANSACTION_NUM, ORIG_ACTION_CODE, ORIG_STATUS_DT — origination transaction identity and status tracking.
• VER_STATUS_CODE, ORIG_REJECT_CODE, ORIG_ED_USE_FLAGS — verification and rejection processing outcomes.
• ENROLLMENT_STATUS, ENROLLMENT_DT, ACADEMIC_CALENDAR, TOTAL_PYMT_PRDS — enrollment and payment-period context.
• PENDING_AMOUNT, REPORTING_PELL_CD, DOCUMENT_ID_TXT — outstanding balances and reporting identifiers.
• Standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ORG_ID).

Common Use Cases and Queries

Because the table is obsolete, most practical use involves historical reconciliation, audit reconstruction, or migration validation. Typical patterns join the satellite outward to its parents:

SELECT r.origination_id, r.transaction_num, a.award_id,
       r.pell_amount, r.ver_status_code, r.orig_status_dt
FROM   igf_gr_rfms_all r,
       igf_aw_award_all a
WHERE  r.award_id = a.award_id
AND    r.org_id = :p_org_id;

A second common query reconciles batch contents back to RFMS headers via RFMB_ID, and a third joins to IGF_GR_RFMS_DISB_ALL through ORIGINATION_ID to trace disbursements against a given origination. Reporting teams frequently filter on VER_STATUS_CODE and ORIG_ACTION_CODE to isolate rejected or pending records.

Related Objects

• IGF_AW_AWARD_ALL — joined on AWARD_ID; the parent award record.
• IGF_AP_FA_BASE_REC_ALL — joined on BASE_ID; the base financial aid record.
• IGS_CA_INST_ALL — joined on CI_CAL_TYPE and CI_SEQUENCE_NUMBER for calendar context.
• IGF_GR_RFMS_BATCH_ALL — joined on RFMB_ID; the RFMS batch header.
• IGF_GR_RFMS_DISB_ALL — references this table through ORIGINATION_ID, linking origination records to disbursement records.