Search Results igf_gr_ver_stat_cd

Overview

APPS.IGF_GR_RFMS_V is a reporting and integration view in the Oracle E-Business Suite Financial Aid module (IGF — the Student Financial Aid / Title IV processing components that ship with EBS 12.1.1 and 12.2.2). It presents Records for Financial Management System (RFMS) data — the Title IV origination and disbursement records exchanged for Pell Grant and Direct Loan processing — alongside the corresponding Common Line (CI) calendar attributes and student personal information.

The view is designed as a flat, denormalized presentation layer: it joins the RFMS transaction record to its coded lookup descriptions (verification status, enrollment status, payment method, academic calendar, origination status, and increased Federal Pell recipient status), so that concurrent programs, extracts, and inquiry forms can display human-readable values without repeatedly joining the lookup infrastructure. The user search term igf_gr_orig_status corresponds directly to a lookup type consumed inside this view: IGF_GR_ORIG_STATUS is used to decode RFMS.ORIG_ACTION_CODE into an origination status description. Other lookups used include IGF_GR_VER_STAT_CD, IGF_GR_SEC_EFC_CD, IGF_GR_RFMS_ENROL_STAT, IGF_GR_ACAD_CAL, IGF_GR_PAYMENT_METHOD, and IGF_GR_STU_INCARCE_STATUS.

Underlying Base Objects

Although the ETRM metadata records no documented base objects, the view text explicitly references the following sources:

• IGF_GR_RFMS (aliased RFMS) — the driving table containing the RFMS origination/disbursement record.
• CI — the Common Line / calendar instance providing ALTERNATE_CODE, START_DT, and END_DT.
• ISIR — the ISIR record, used to derive the composite TRANSACTION_NUM_DESC from ORIGINAL_SSN, ORIG_NAME_ID, and TRANSACTION_NUM.
• RFMB — the RFMS batch table supplying BATCH_ID and RFMS_PROCESS_DT.
• PE — the person/student record supplying PERSON_NUMBER and formatted name.
• IGF_AW_GEN — the generic lookup package function LOOKUP_DESC, invoked for each coded column.

The view therefore conforms to the RFMS batch → RFMS record → ISIR/CI/person model, joining on the RFMS foreign keys (base, award, RFMB, ISIR identifiers).

Key Columns

• ROW_ID, ORIGINATION_ID, TRANSACTION_NUM, TRANSACTION_NUM_DESC — record identity and the ISIR-based transaction description.
• ORIG_ACTION_CODE and its decoded description via IGF_GR_ORIG_STATUS — the origination action/status of the record.
• ORIG_STATUS_DT, ORIG_REJECT_CODE, ORIG_ED_USE_FLAGS — origination status detail and Department of Education use flags.
• VER_STATUS_CODE (decoded via IGF_GR_VER_STAT_CD), EFC, SECONDARY_EFC, SECONDARY_EFC_CD — verification and expected family contribution values.
• PELL_AMOUNT, FT_PELL_AMOUNT, PENDING_AMOUNT, COA_AMOUNT — award and cost-of-attendance amounts.
• ENROLLMENT_STATUS, ENROLLMENT_DT, ACADEMIC_CALENDAR, PAYMENT_METHOD, TOTAL_PYMT_PRDS — enrollment, calendar, and disbursement attributes with decoded descriptions.
• INCRCD_FED_PELL_RCP_CD (decoded via IGF_GR_STU_INCARCE_STATUS) — increased Federal Pell recipient status.
• BATCH_ID, RFMS_PROCESS_DT, BASE_ID, AWARD_ID, RFMB_ID, REP_PELL_ID — linking keys to base, award, and batch contexts.
• Who-columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, REQUEST_ID.

Common Use Cases and Queries

Typical scenarios include Title IV origination tracking, verification status reporting, and reconciliation of Pell awards against COD records. A simple query filtering by origination status description:

• SELECT origination_id, transaction_num, transaction_num_desc, orig_action_code FROM apps.igf_gr_rfms_v WHERE orig_action_code = :p_status;
• To surface the decoded status text, reference the lookup-derived column produced from IGF_GR_ORIG_STATUS.
• Batch-level listing: SELECT batch_id, rfms_process_dt, person_number, efc, pell_amount FROM apps.igf_gr_rfms_v WHERE batch_id = :p_batch ORDER BY person_number;
• Award reconciliation: SELECT award_id, base_id, coa_amount, pell_amount, pending_amount, enrollment_status FROM apps.igf_gr_rfms_v WHERE award_id = :p_award;

Because the view exposes both coded and decoded values without volatile joins, it is suitable for BI Publisher extracts, OBIEE/OTBI federated queries, and custom concurrent programs where descriptive RFMS status output is required.