Search Results auth_id




Overview
Explore in AI Chat

Overview

IGF_SE_EARNINGS_SUMMARY_V is a reporting view owned by the APPS schema within the IGF (Financial Aid) product family of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It exposes computed figures describing a student's fund payment and disbursement activity for the Federal Work Study (FWS) program, and is consumed by the Student Employment component to present awarded amounts, cumulative earnings, remaining balances, and the percentage of the award that has been disbursed. Rather than storing data, the view performs the aggregation at query time, returning one summarized row per award base record, fund, and load calendar period. Its role is therefore primarily read-only reporting and integration: downstream pages, concurrent programs, and custom extracts can select from it without replicating the award-versus-disbursement arithmetic themselves.

Underlying Base Objects

The view text identifies three referenced objects: IGF_AW_AWARD_V, IGF_AW_AWD_DISB, and IGS_CA_INST. IGF_AW_AWARD_V supplies the award header context, contributing BASE_ID and FUND_ID together with the FED_FUND_CODE used as a filter. IGF_AW_AWD_DISB supplies the disbursement detail rows from which gross, accepted, and paid amounts are aggregated. IGS_CA_INST supplies the calendar instance attributes CAL_TYPE, SEQUENCE_NUMBER, and ALTERNATE_CODE, joined to the disbursement rows on LD_CAL_TYPE and LD_SEQUENCE_NUMBER. The three objects are joined on AWARD_ID between the award view and the disbursement table, and on calendar type and sequence number between the disbursement table and the calendar instance. The ETRM metadata documents no additional base objects beyond these.

Key Columns

  • BASE_ID, FUND_ID — identify the award base record and the fund to which the earnings summary belongs.
  • LD_CAL_TYPE, LD_SEQUENCE_NUMBER, LD_ALTERNATE_CODE — identify the load calendar period and its friendly alternate code.
  • AWARD_AMOUNT — the accepted disbursement total where any accepted amount exists, otherwise the gross disbursement total, defaulting to zero.
  • EARNINGS_TILL_DATE — the sum of DISB_PAID_AMT, representing funds actually paid to date.
  • REMAINING_AMOUNT — the arithmetic difference between AWARD_AMOUNT and EARNINGS_TILL_DATE.
  • PROGRESS_TO_LIMIT — the percentage of the award consumed, computed as ROUND(EARNINGS_TILL_DATE/AWARD_AMOUNT) * 100.
  • NOTIFICATION_SENT, NOTIFICATION_DATE — placeholder columns projected as NULL.
  • AUTH_ID, AUTH_DATE — authorization columns projected as NULL in the outer query. These placeholders are relevant to users searching on "auth_id," since the view exposes the column but does not populate it.

Common Use Cases and Queries

Typical usage centers on monitoring FWS disbursement against award ceilings. Because the FED_FUND_CODE filter is fixed to 'FWS' inside the inline view, only work study awards are returned. A simple listing of outstanding balances can be produced as follows:

  • SELECT fund_id, ld_alternate_code, award_amount, earnings_till_date, remaining_amount, progress_to_limit FROM igf_se_earnings_summary_v WHERE remaining_amount > 0 ORDER BY fund_id;
  • SELECT base_id, fund_id, progress_to_limit FROM igf_se_earnings_summary_v WHERE progress_to_limit >= 100; — identifies students who have reached or exceeded their award limit.
  • SELECT auth_id, auth_date FROM igf_se_earnings_summary_v; — will always return NULL for both columns, confirming that authorization data is not sourced by this view.

Queries should account for the possibility of a zero AWARD_AMOUNT, which can cause a division-by-zero condition in the PROGRESS_TO_LIMIT expression; filtering or NVL protection is advisable in production extracts.

  • View: IGF_SE_EARNINGS_SUMMARY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SE_EARNINGS_SUMMARY_V,  object_name:IGF_SE_EARNINGS_SUMMARY_V,  status:VALID,  product: IGF - Financial Aid ,  description: The entity is used to display the computed information about students funds payment/disbursement details. Thiswill be used by Student Employment to display computed figures for the fund payment and its percentage disbursement with respect t ,  implementation_dba_data: APPS.IGF_SE_EARNINGS_SUMMARY_V , 

  • View: IGF_SE_PAYMENT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SE_PAYMENT_V,  object_name:IGF_SE_PAYMENT_V,  status:VALID,  product: IGF - Financial Aid ,  description: The entity holds the payroll details that will be uploaded through a payment upload process. Data source for this will be the interface table .. User can also manually enter or update external payroll details. ,  implementation_dba_data: APPS.IGF_SE_PAYMENT_V , 

  • Table: IGF_SE_PAYMENT_INT 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_SE_PAYMENT_INT,  object_name:IGF_SE_PAYMENT_INT,  status:VALID,  product: IGF - Financial Aid ,  description: This entity is an Interface table that stores the payment details. The external HRMS system will upload data in this table. Later FA process will pick data from this table and upload it into IGF_SE_PAYMENT table. ,  implementation_dba_data: IGF.IGF_SE_PAYMENT_INT , 

  • View: IGF_SE_WORK_AWD_PRG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SE_WORK_AWD_PRG_V,  object_name:IGF_SE_WORK_AWD_PRG_V,  status:VALID,  product: IGF - Financial Aid ,  description: View that holds student work award progress information in an award year ,  implementation_dba_data: APPS.IGF_SE_WORK_AWD_PRG_V , 

  • View: IGF_SE_AWD_DISB_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SE_AWD_DISB_V,  object_name:IGF_SE_AWD_DISB_V,  status:VALID,  product: IGF - Financial Aid ,  description: Retrives all the award disbursement details for the student employment awards ,  implementation_dba_data: APPS.IGF_SE_AWD_DISB_V , 

  • View: IGF_SE_AUTH_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SE_AUTH_V,  object_name:IGF_SE_AUTH_V,  status:VALID,  product: IGF - Financial Aid ,  description: The entity contains the authorization details sent to the interface layer. This entity also at the same time has the history or inactive authorization records. At one line only one authorization record can remain active. ,  implementation_dba_data: APPS.IGF_SE_AUTH_V , 

  • View: IGF_AW_AWD_DISB 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_AW_AWD_DISB,  object_name:IGF_AW_AWD_DISB,  status:VALID,  product: IGF - Financial Aid ,  implementation_dba_data: APPS.IGF_AW_AWD_DISB , 

  • View: IGF_AW_AWD_DISB_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_AW_AWD_DISB_V,  object_name:IGF_AW_AWD_DISB_V,  status:VALID,  product: IGF - Financial Aid ,  description: Stores details of each disbursement ,  implementation_dba_data: APPS.IGF_AW_AWD_DISB_V , 

  • Lookup Type: IGF_GE_PARAMETERS 12.1.1

    product: IGF - Financial Aid ,  meaning: Concurrent Job Parameters ,  description: Concurrent Job Parameters ,