Search Results sys_fund_source_code

Overview

APPS.IGF_SE_AUTHORIZATION_V is a public view in the Oracle E-Business Suite Financial Aid (IGF) module, owned by the APPS schema and registered in FND Design Data as IGF.IGF_SE_AUTHORIZATION_V. It is classified as a public view, meaning Oracle documents it as suitable for custom reporting and integration requirements rather than restricting it to internal application use. Its stated purpose is to derive active work authorizations — the records that establish a student's eligibility to receive federal, state, or institutional work-study funds during a given award year.

The view consolidates authorization header data with denormalized person attributes and fully resolved lookup meanings, presenting fund source and fund type values as both raw codes and translatable names. This design allows report authors and integrators to avoid repeated joins to HZ_PARTIES and FND_LOOKUPS when constructing earnings or disbursement reporting. Consumers searching for the column sys_fund_source_code will find it here, exposed alongside its lookup description, sys_fund_source_name.

Underlying Base Objects

The ETRM metadata for release 12.2.2 does not document explicit referenced base objects for this view; no dependency list is published. Based on the column semantics and naming conventions, the view derives from the IGF work authorization entity (the table holding AUTHORIZATION_ID, PERSON_ID, AUTHORIZED_AMT, and the authorization date range), joined to HZ_PARTIES for person identity attributes such as first name, last name, birth date, and social security number, and to the fund definition entity supplying FUND_ID, FUND_CODE_TXT, fund source, and fund type. Lookup translations are resolved from FND_LOOKUPS for lookup types IGF_AW_FUND_SOURCE and IGF_AW_SYS_FUND_TYPE, while the award year context is drawn from the calendar type 'AWARD' and its sequence number. Specific base table names should be confirmed against the deployment's dependency metadata before being relied upon in production documentation.

Key Columns

• AUTHORIZATION_ID (NUMBER 15) — Unique identifier for the authorization; the primary key for reporting purposes.
• PERSON_ID (NUMBER 15) — Person identifier mapping to HZ_PARTIES.PARTY_ID.
• AUTHORIZED_AMT (NUMBER) — Amount authorized for the individual.
• AUTHORIZATION_DATE, AUTHORIZATION_START_DATE, AUTHORIZATION_END_DATE — Date of authorization and the effective start and end dates used to determine whether the authorization is active.
• PERSON_FIRST_NAME_TXT / PERSON_LAST_NAME_TXT (VARCHAR2 150) — Person name components.
• BIRTH_DATE, SOCIAL_SECURITY_NUMBER — Person demographics captured at authorization time.
• FUND_ID, FUND_CODE_TXT — Unique fund identifier and its user-configurable code.
• SYS_FUND_SOURCE_CODE (VARCHAR2 30) — System fund source. Documented valid values: ENDOWMENT, FEDERAL, INSTITUTIONAL, OUTSIDE, STATE.
• SYS_FUND_SOURCE_NAME (VARCHAR2 80) — Translatable meaning for the IGF_AW_FUND_SOURCE lookup code.
• FUND_TYPE_TXT, SYS_FUND_TYPE_CODE, SYS_FUND_TYPE_NAME — User-defined fund type and its system lookup code and meaning from IGF_AW_SYS_FUND_TYPE.
• AW_CAL_TYPE_TXT, AW_SEQUENCE_NUMBER — Award year calendar type (typically 'AWARD') and the calendar instance sequence number.

Common Use Cases and Queries

Typical uses include work-study eligibility reporting, fund source analysis for federal compliance, and integration extracts feeding payroll or third-party student systems. The view is particularly valuable when a report must display human-readable fund source descriptions rather than codes.

To list active authorizations by fund source:

SELECT authorization_id, person_id, person_last_name_txt,
       authorized_amt, sys_fund_source_code, sys_fund_source_name,
       authorization_start_date, authorization_end_date
 FROM apps.igf_se_authorization_v
 WHERE sys_fund_source_code = 'FEDERAL'
   AND SYSDATE BETWEEN authorization_start_date AND authorization_end_date;

To aggregate authorized amounts by fund source for an award year:

SELECT sys_fund_source_name, aw_sequence_number,
       SUM(authorized_amt) total_authorized, COUNT(*) auth_count
 FROM apps.igf_se_authorization_v
 WHERE aw_cal_type_txt = 'AWARD'
 GROUP BY sys_fund_source_name, aw_sequence_number;

Because the view is public and documented, custom reports and interfaces may query it directly; standard Oracle security and grants on APPS objects still apply.