Search Results igf_se_auth_n1

Overview

The IGF.IGF_SE_AUTH table is a student financial aid authorization object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the IGF schema. It resides in the APPS_TS_TX_DATA tablespace and stores person-level authorization records tied to awards, capturing biographical, demographic, tax, visa, and monetary eligibility attributes used by Oracle's Student Aid and Financial Aid processing modules. The object is flagged as Oracle Internal Use Only; access is supported only through standard Oracle Applications programs rather than direct SQL.

From a Data Vault modeling perspective, the documented schema structure suggests this object behaves as a standalone satellite. It carries descriptive changeable attributes (name, address, demographic, and financial fields) anchored by the surrogate key SEQUENCE_NO, with AUTH_ID and AWARD_ID acting as foreign references. The heuristic classification as "standalone" reflects the absence of parent-child satellite hierarchies in the FK metadata.

Key Information Stored

The table contains 48 documented columns. The most significant for functional and reporting purposes include:

• SEQUENCE_NO — Number(15) surrogate primary key (IGF_SE_AUTH_PK) and the column behind the unique index IGF_SE_AUTH_U1. It uniquely identifies each authorization record.
• AUTH_ID — Number(15) authorization identifier, foreign key referencing JTF_XML_INV_AUTHS.
• AWARD_ID — Number(15) foreign key to IGF_AW_AWARD_ALL; supports index IGF_SE_AUTH_N1 (nonunique).
• FLAG — Indicates which AUTH_ID is currently ACTIVE or INACTIVE.
• PERSON_ID — Unique person identifier linking the record to the underlying person record.
• FIRST_NAME / LAST_NAME — Student name attributes (VARCHAR2 150 each).
• SSN_NO — Social Security Number, VARCHAR2(20), used for tax and identity validation.
• BIRTH_DT / SEX / MARITAL_STATUS — Demographic attributes required for tax-dependent determinations.
• VISA_TYPE / VISA_CATEGORY / VISA_NUMBER / VISA_EXPIRY_DT — Immigration status details affecting eligibility.
• FUND_ID, MIN_HR_RATE, MAX_HR_RATE, THRESHOLD_PERCT, THRESHOLD_VALUE, GOVT_SHARE_PERCT, SALARY_BASED, ACCEPTED_AMNT — Financial eligibility and funding attributes.
• AW_CAL_TYPE / AW_SEQUENCE_NUMBER / LD_CAL_TYPE / LD_SEQUENCE_NUMBER — Award and loan calendar references.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard WHO columns and concurrent program audit fields.
• AUTHORIZATION_DATE, NOTIFICATION_DATE — Dates marking authorization and notification events.

Common Use Cases and Queries

Typical scenarios involve reporting active aid authorizations for a student, reconciling awards against authorization records, and validating visa or tax eligibility for disbursement. A common query pattern joins IGF_SE_AUTH to IGF_AW_AWARD_ALL on AWARD_ID and filters on FLAG:

• SELECT a.SEQUENCE_NO, a.PERSON_ID, a.FIRST_NAME, a.LAST_NAME, a.ACCEPTED_AMNT, w.AWARD_ID FROM IGF.IGF_SE_AUTH a, IGF.IGF_AW_AWARD_ALL w WHERE a.AWARD_ID = w.AWARD_ID AND a.FLAG = 'ACTIVE';
• Visa monitoring: SELECT PERSON_ID, VISA_TYPE, VISA_EXPIRY_DT FROM IGF.IGF_SE_AUTH WHERE VISA_EXPIRY_DT < SYSDATE;
• Point-lookup by surrogate key using the unique index: SELECT * FROM IGF.IGF_SE_AUTH WHERE SEQUENCE_NO = :seq_no;
• Eligibility reporting keyed by funding source and threshold values for institutional, state, or federal reporting extracts.

Related Objects

• IGF.IGF_AW_AWARD_ALL — referenced by AWARD_ID; the primary award definition table for financial aid awards.
• JTF_XML_INV_AUTHS — referenced by AUTH_ID; stores authorization/authority records consumed by XML invoice and authorization processing.
• IGF_SE_AUTH_U1 — unique index on SEQUENCE_NO, used for point lookups and uniqueness enforcement.
• IGF_SE_AUTH_N1 — nonunique index on AWARD_ID, supporting award-based joins and reporting.
• PER_PEOPLE_F / FND_PERSON — implied by PERSON_ID for person-level demographic reconciliation.
• FND_CONCURRENT_REQUESTS — implied by REQUEST_ID for concurrent program traceability.

Because the object is Oracle Internal Use Only, references should route through supported Oracle Applications APIs rather than direct DML.