Search Results igf_se_auth_pk

Overview

The IGF_SE_AUTH table belongs to the IGF (Financial Aid) product family, which is documented as obsolete in Oracle E-Business Suite. In the context of EBS 12.1.1 and 12.2.2, this table was originally designed to store authorization details that were transmitted to the interface layer. The entity functioned as an interface table, accumulating authorization records passed to downstream processing while simultaneously preserving the history of inactive or superseded authorizations. A defining business rule is that only one authorization record may remain active for a given line at any point in time, which makes the table a time-versioned staging construct rather than a pure reference table.

The ETRM metadata indicates that this object is not implemented in the current database. Because it is documented as obsolete, DBAs and developers should generally expect no data and no runtime dependency, though the physical definition may persist for upgrade compatibility. From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is standalone, meaning the table neither behaves as a dependent satellite nor anchors a broad hub-and-link network. It can be treated as an independent staging or interface entity whose relationships are limited to a small number of outbound references.

Key Information Stored

The documented physical schema for ETRM 12.1.1 contains 48 columns under the IGF owner. The surrogate primary key is defined by the constraint IGF_SE_AUTH_PK on the SEQUENCE_NO column, and a unique index IGF_SE_AUTH_U1 also exists on SEQUENCE_NO, confirming it as the primary business-key candidate. Among the remaining columns, the most significant in practice include:

• AUTH_ID — the authorization identifier, which also participates in the foreign key to JTF_XML_INV_AUTHS.
• AWARD_ID — the award reference, linking the record to IGF_AW_AWARD_ALL.
• PERSON_ID — the party identifier for the individual associated with the authorization.
• FIRST_NAME, LAST_NAME, ADDRESS1–ADDRESS4, CITY, STATE, PROVINCE, COUNTY, COUNTRY — denormalized party and address attributes captured at the time the authorization was generated.
• SEX, BIRTH_DT, SSN_NO, MARITAL_STATUS — demographic elements used for eligibility determination.
• VISA_TYPE, VISA_CATEGORY, VISA_NUMBER, VISA_EXPIRY_DT, ENTRY_DATE — immigration-related data relevant to financial aid eligibility.
• FUND_ID, ACCEPTED_AMNT, AUTHORIZATION_DATE, NOTIFICATION_DATE — funding source, monetary value, and lifecycle timestamps.
• FLAG — a status indicator used to distinguish the single active record from historical rows.
• Standard WHO columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and REQUEST_ID provide audit and concurrent-program traceability.

Common Use Cases and Queries

Because the table is obsolete and not implemented, its practical value in an active 12.1.1/12.2.2 environment is primarily historical or migration-oriented. Typical scenarios include auditing legacy authorizations, correlating authorization history with award and fund records, and confirming that only one active row exists per line.

Identifying the active record for a given line and award follows a pattern such as:

• SELECT * FROM igf_se_auth WHERE flag = 'Y' AND award_id = :p_award_id;
• SELECT sequence_no, auth_id, award_id, accepted_amnt FROM igf_se_auth WHERE person_id = :p_person_id ORDER BY authorization_date DESC;
• SELECT auth_id, COUNT(*) FROM igf_se_auth GROUP BY auth_id HAVING COUNT(*) > 1; to detect multiple active records as a data quality check.

Reporting use cases generally involve reconciling authorization counts and amounts by fund, award calendar, or date range, joined to IGF_AW_AWARD_ALL for award context.

Related Objects

The documented foreign keys anchor the table to two parent entities, and these are the most significant related objects:

• JTF_XML_INV_AUTHS — referenced through IGF_SE_AUTH.AUTH_ID; provides the XML authorization envelope metadata.
• IGF_AW_AWARD_ALL — referenced through IGF_SE_AUTH.AWARD_ID; supplies award-level information for financial aid processing.
• IGF_SE_AUTH_PK / IGF_SE_AUTH_U1 — the primary key and unique index, both defined on SEQUENCE_NO.
• IGF_AW_AWARD_ALL and JTF_XML_INV_AUTHS should be treated as the principal join partners in any legacy query or migration assessment.

Given its obsolete status, no Oracle-provided APIs or active views are expected to depend on this table; any dependency should be verified against the specific instance before relying on it.