Search Results ytdor_id




Overview
Explore in AI Chat

Overview

The IGF_GR_YTD_ORIG_ALL table resides in the IGF — Financial Aid product family within Oracle E-Business Suite 12.1.1 / 12.2.2. Its documented purpose is to store year-to-date origination data, meaning cumulative Title IV / Pell Grant origination attributes reported to or returned from the federal Common Origination and Disbursement (COD) process. The metadata explicitly marks the module as Obsolete and states that the object is not implemented in this database, so it exists primarily as a legacy schema artifact rather than an actively maintained table.

The table is owned by the IGF schema and contains 60 documented columns, keyed by the surrogate identifier YTDOR_ID. From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification: the table predominantly stores descriptive, time-stamped descriptive context (origination details, disbursement dates, batch identifiers) that hangs off a parent business key rather than acting as a hub or a pure association link.

Key Information Stored

The primary key constraint IGF_GR_YTD_ORIG_ALL_PK and the unique index IGF_GR_YTD_ORIG_ALL_U1 both key on YTDOR_ID. In the schema documented here, that column is simultaneously the surrogate PK and the sole documented business-key candidate, which is unusual in an operational ETRM design and reinforces the obsolete/legacy nature of the object.

Common Use Cases and Queries

Because the object is documented as obsolete and not implemented, practical use falls into two categories: historical data migration/extraction and schema archaeology. A typical lookup by the searched term ytdor_id retrieves a single origination satellite row, while analytical queries aggregate YTD disbursements by student or by calendar.

  • Point lookup: SELECT * FROM igf.igf_gr_ytd_orig_all WHERE ytdor_id = :ytdor_id;
  • Aggregation by student: SELECT ssn, SUM(ytd_disb_amt) FROM igf.igf_gr_ytd_orig_all GROUP BY ssn;
  • Batch reconciliation: SELECT batch_id, COUNT(*), SUM(accpt_awd_amt) FROM igf.igf_gr_ytd_orig_all GROUP BY batch_id;
  • Calendar-level reporting by joining the calendar instance columns to IGS_CA_INST_ALL.

Reporting is best limited to archival or audit reconciliation of federal aid origination, since no live process is documented to populate the table.

Related Objects

The single documented foreign key anchors this table to the academic calendar instance hierarchy. Other relationships are inferred from the origination and batch columns.

  • IGS_CA_INST_ALL — referenced via IGF_GR_YTD_ORIG_ALL.CI_CAL_TYPE and IGF_GR_YTD_ORIG_ALL.CI_SEQUENCE_NUMBER.
  • IGF_GR_ORIG_ALL — the presumed parent origination table joined through ORIGINATION_ID.
  • IGF_GR_YTD_DISB_ALL — the disbursement counterpart sharing the origination key.
  • IGF_AP_GR_* interfaces and the COD batch staging tables linked via BATCH_ID.
  • The WHO/concurrent columns tie each row to FND_USER and FND_CONCURRENT_REQUESTS.