Search Results award_ci

Overview

IGFFV_STUDENT_AUTHORIZATIONS is a read-only Oracle EBS view owned by the APPS schema and documented within the ETRM (Enterprise Training and Resource Management) module. It presents student financial authorization data combined with biographical, visa, fund, and award context — a denormalized reporting surface built from the IGF_SE_AUTH base table and several supporting master and instance tables. The leading "IGFFV" prefix denotes a view (as opposed to "IGF" for base tables), and the object carries the WITH READ ONLY clause, confirming that it is intended strictly for query and reporting purposes rather than transactional DML.

In Oracle EBS 12.1.1 and 12.2.2, this view serves as a convenient single-source projection for reporting on student award authorizations, thresholds, accepted amounts, and fund allocations. It eliminates the need for report authors to hand-join five separate tables, and it is particularly relevant when the user searches for award_ci, which corresponds to the AWARD_CI alias derived from IGS_CA_INST_ALL.

Underlying Base Objects

The ETRM metadata documents that the view's FROM clause references five objects:

• IGF_SE_AUTH SEAUT — the primary source of student authorization rows (aliased SEAUT).
• IGF_AW_FUND_MAST_ALL FMAST — the award fund master, providing FUND_CODE and DESCRIPTION and the award calendar instance linkage.
• IGS_CA_INST_ALL AWARD_CI — the award calendar instance, joined via FMAST.CI_CAL_TYPE and FMAST.CI_SEQUENCE_NUMBER, supplying ALTERNATE_CODE for the award calendar. This is the alias referenced by the user's search term "award_ci".
• IGS_CA_INST_ALL LOAD_CI — a second instance of the same calendar instance table, joined via SEAUT.LD_CAL_TYPE and SEAUT.LD_SEQUENCE_NUMBER, supplying the load calendar's ALTERNATE_CODE.
• HZ_PARTIES HZ — the trading community party table, joined on HZ.PARTY_ID = SEAUT.PERSON_ID, supplying PARTY_NUMBER.

The join is anchored on SEAUT.FUND_ID = FMAST.FUND_ID, with two calendar lookups and a party lookup layered on top. No other base objects are documented beyond these five.

Key Columns

The SELECT list exposes a wide range of student attributes and authorization facts:

• Biographical fields: FLAG, FIRST_NAME, LAST_NAME, ADDRESS1–ADDRESS4, CITY, STATE, PROVINCE, COUNTY, COUNTRY, SEX, BIRTH_DT, SSN_NO, MARITAL_STATUS.
• Visa fields: VISA_TYPE, VISA_CATEGORY, VISA_NUMBER, VISA_EXPIRY_DT, ENTRY_DATE.
• Threshold and amount fields: THRESHOLD_PERCT, THRESHOLD_VALUE, ACCEPTED_AMNT. Two NULL literals appear between ENTRY_DATE and THRESHOLD_PERCT and again after THRESHOLD_VALUE, representing placeholder columns retained for positional compatibility.
• Calendar instance fields: AW_CAL_TYPE, AW_SEQUENCE_NUMBER (award calendar), LD_CAL_TYPE, LD_SEQUENCE_NUMBER (load calendar), plus AWARD_CI.ALTERNATE_CODE and LOAD_CI.ALTERNATE_CODE.
• Fund and party fields: FUND_CODE, DESCRIPTION (from FMAST), PARTY_NUMBER (from HZ_PARTIES).
• Keys and audit fields: AUTH_ID, PERSON_ID, FUND_ID, SEQUENCE_NO, AWARD_ID, AUTHORIZATION_DATE, NOTIFICATION_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical applications include authorization registers, fund allocation reports, visa compliance checks, and variance analysis between threshold and accepted amounts.

SELECT AUTH_ID, PERSON_ID, FIRST_NAME, LAST_NAME,
       FUND_CODE, ACCEPTED_AMNT, THRESHOLD_VALUE,
       AWARD_CI_ALTERNATE_CODE
FROM   APPS.IGFFV_STUDENT_AUTHORIZATIONS;

Filtering by the award calendar alternate code (the "award_ci" term) narrows output to a specific award period:

SELECT AUTH_ID, PERSON_ID, PARTY_NUMBER, FUND_CODE
FROM   APPS.IGFFV_STUDENT_AUTHORIZATIONS
WHERE  AWARD_CI_ALTERNATE_CODE = '2024'
ORDER  BY LAST_NAME, FIRST_NAME;

Because the view is read-only, all DML must target the underlying base tables (IGF_SE_AUTH and IGF_AW_FUND_MAST_ALL) rather than the view itself.