Results for “igf_ap_css_interface”

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

Overview

The IGF_AP_CSS_INTERFACE view belongs to the IGF (Financial Aid) product family within Oracle E-Business Suite, a module documented in ETRM as obsolete in both the 12.1.1 and 12.2.2 releases. Its stated purpose is to retrieve Interface CSS Profile records — that is, College Scholarship Service (CSS) financial aid profile data captured for importation, processing, and reconciliation against a student's financial aid application. The view acts as a presentation and staging layer over the underlying CSS interface entity, flattening a wide denormalized set of demographic, need-analysis, income, asset, and parental contribution attributes into a single queryable relational shape.

In the context of Oracle EBS reporting and integration, the view serves the classic interface-reader role: downstream processes, concurrent programs, or external data extracts query the view rather than the raw interface table so that column naming, ordering, and data-type semantics remain stable. Because the object is documented as "Not implemented in this database," the view exists as a definitional artifact only; it was never deployed in the implementation captured by the ETRM extract. Practitioners should treat it as legacy metadata rather than a live queryable object.

Underlying Base Objects

The ETRM metadata for this view records no referenced base objects and no owner. In standard EBS data-dictionary practice, a view named IGF_AP_CSS_INTERFACE would conventionally be defined over a table of the same stem, IGF_AP_CSS_INTERFACE (the Apostrophe naming pattern used throughout the IGF schema). The supplied view text confirms this: it is a simple projection of a fixed column list with the sole transformation being SELECT ROWID ROW_ID, which exposes the physical row identifier as a pseudo-key for the underlying interface record. No joins, filters, aggregations, or function calls appear in the definition, so the view is a one-to-one, row-for-row mirror of its base table.

Since no base objects are documented, referential integrity to student, person, or organization records cannot be confirmed from the ETRM extract. The presence of ORG_ID indicates the view is partitioned by operating unit, consistent with multi-org enabled EBS interface design.

Key Columns

The view exposes a broad column set typical of a CSS Profile interface. Its principal columns include:

• ROW_ID — the ROWID pseudo-column, providing a unique physical handle to each interface row.
• CSS_ID, CSS_ID_NUMBER, ORG_ID — the primary identifier, external CSS identifier, and operating unit.
• RECORD_STATUS — the state of the interface record (for example, ready, processed, or in error).
• COLLEGE_CODE, ACADEMIC_YEAR, STU_RECORD_TYPE, REGISTRATION_TYPE, APPLICATION_TYPE — institutional and reporting context.
• Receipt date columns (REGISTRATION_RECEIPT_DATE, APPLICATION_RECEIPT_DATE, ASR_RECEIPT_DATE, ELECTRONIC_EXTRACT_DATE) — audit trail of document receipt.
• Student identity and demographics — LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, DATE_OF_BIRTH, SOCIAL_SECURITY_NUMBER, address and telephone fields.
• Need-analysis and household fields — FINANCIAL_AID_STATUS, MARITAL_STATUS, HOUSEHOLD_SIZE, NUMBER_IN_COLLEGE, YEAR_IN_COLLEGE.
• Income, tax, and asset fields — ADJUSTED_GROSS_INC, US_TAX_PAID, ITEMIZED_DEDUCTIONS, STU_INCOME_WORK, SPOUSE_INCOME_WORK, INVEST_VALUE, HOME_VALUE, BUS_FARM_VALUE, TRUST_AMOUNT.
• Parental contribution fields (the P_ prefix set) — P_HOUSEHOLD_SIZE, P_NUMBER_IN_COLLEGE, P_MARITAL_STATUS, P_CHILD_SUPP_PAID, P_REPAY_ED_LOANS, P_TUIT_PAID_AMOUNT.

The FNAR columns (ORIGINAL_FNAR_COMPUTE, REVISION_FNAR_COMPUTE_DATE) reference the Federal Need Analysis Methodology computation, tying the record to need-analysis recalculation.

Common Use Cases and Queries

The view's canonical use is retrieval of interface records for validation, extraction, or reconciliation. Typical queries include:

• Selecting unprocessed interface records: SELECT CSS_ID, RECORD_STATUS, ACADEMIC_YEAR FROM IGF_AP_CSS_INTERFACE WHERE RECORD_STATUS = 'NEW'.
• Producing a financial aid extract: SELECT LAST_NAME, FIRST_NAME, ADJUSTED_GROSS_INC, FINANCIAL_AID_STATUS FROM IGF_AP_CSS_INTERFACE WHERE ORG_ID = :p_org_id.
• Auditing receipt timeliness: SELECT CSS_ID, APPLICATION_RECEIPT_DATE, ELECTRONIC_EXTRACT_DATE FROM IGF_AP_CSS_INTERFACE WHERE APPLICATION_RECEIPT_DATE IS NULL.
• Need-analysis reconciliation: selecting ORIGINAL_FNAR_COMPUTE against REVISION_FNAR_COMPUTE_DATE to identify recalculated records.

Because the object is marked obsolete and is not implemented in the documented database, these queries should be treated as illustrative of legacy behavior. Any migration effort should verify against a live source under the corresponding IGF schema tables before reuse.