Results for “guarantee_amt”

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

Overview

IGFBV_FFELP_ORIG_RESPONSES is the base view for the entity that holds FFELP (Federal Family Education Loan Program) Origination Response details within the Oracle E-Business Suite. It belongs to the IGF — Financial Aid product family, which Oracle has designated as obsolete, meaning it is retained for historical reference and possibly legacy data migration but is no longer actively supported under EBS 12.1.1 or 12.2.2.

The view exposes a flat, denormalized projection of borrower, student, loan, guarantor, and lender attributes returned during the loan origination response cycle between schools/lenders and guarantors. As a reportable interface-layer object, it is intended to surface a single row per origination response, allowing downstream reporting or integration processes to reference origination response details without joining the constituent staging tables directly.

Notably, ETRM metadata records "Not implemented in this database" for this object, indicating that in 12.2.2 the view is not physically created in the environment captured. The view text, however, is fully documented and should be relied upon as the canonical definition.

Underlying Base Objects

The view text references a single driving table alias, RESP1, from which all columns are projected. No base tables are formally documented under "Referenced base objects," leaving the physical table name implicit; based on the alias and the Financial Aid model, RESP1 corresponds to an FFELP origination response staging entity. Several columns are derived from lookups rather than physical columns, using the decode-style construct:

• '_LA:RESP1.B_CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CITIZENSHIP_STAT:MEANING'
• '_LA:RESP1.B_DEFAULT_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_P_DEFAULT_STATUS:MEANING'
• '_LA:RESP1.S_DEFAULT_CODE:IGF_LOOKUPS_VIEW:IGF_SL_S_DEFAULT_STATUS:MEANING'
• '_LA:RESP1.GRADE_LEVEL_CODE:IGF_LOOKUPS_VIEW:IGF_AP_GRADE_LEVEL:MEANING'
• '_LA:RESP1.ENROLLMENT_CODE:IGF_LOOKUPS_VIEW:IGF_SL_CL_ENROL_STATUS:MEANING'

These derived lookups resolve coded values (e.g., citizenship, default status, grade level, enrollment status) into their human-readable meaning via IGF_LOOKUPS_VIEW.

Key Columns

• REC_CODE / REC_TYPE_IND — Record code and type indicator identifying the origination response record.
• B_* — Borrower attributes: name, SSN, permanent address, phone, date of birth, citizenship status, state of legal residence, and legal residence date.
• S_* — Student attributes: name, SSN, date of birth, citizenship status, default code, and signature code.
• LOAN_NUMBER / CL_SEQ_NUMBER — Loan identifier and sequence number.
• CL_LOAN_TYPE / REQ_LOAN_AMT — Requested loan type and amount.
• GUARANTOR_ID / GUARANTEE_DATE / GUARANTEE_AMT — Guarantor identity and the guarantee date/amount. GUARANTEE_DATE is the primary column of interest when users search "guarantee_date," reflecting the date the guarantor approved the loan guarantee.
• LENDER_ID, FLS/FLU/FLP_APPROVED_AMT, ALT_APPROVED_AMT — Lender identity and approved (subsidized, unsubsidized, PLUS, alternative) amounts.
• LOAN_PER_BEGIN_DATE / LOAN_PER_END_DATE — Loan period boundaries.
• COA_AMT, EFC_AMT, EST_FA_AMT, FLS_CERT_AMT, FLU_CERT_AMT, FLP_CERT_AMT — Cost of attendance, expected family contribution, estimated financial aid, and certified loan amounts.

Common Use Cases and Queries

Because the view is obsolete, use cases center on historical reporting and audit reconstruction, particularly correlating guarantee activity with borrower and loan attributes:

• Reporting all origination responses with a given guarantee date for reconciliation.
• Auditing guarantee amounts against certified loan amounts.
• Migrating legacy FFELP originations to a successor system.

A representative query filtering on the searched column:

SELECT LOAN_NUMBER, CL_SEQ_NUMBER, B_LAST_NAME, GUARANTOR_ID, GUARANTEE_DATE, GUARANTEE_AMT
FROM IGFBV_FFELP_ORIG_RESPONSES
WHERE GUARANTEE_DATE BETWEEN :p_from_date AND :p_to_date;

Given the "not implemented" status, confirm view existence at the database level (ALL_VIEWS) before relying on it in any 12.1.1 or 12.2.2 query.