Results for “ld_start_dt”
49 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGF_AW_AWD_APT_V is a reporting view within the Oracle E-Business Suite Financial Aid module (product code IGF). The ETRM metadata describes it as the "Award Periods Terms View," indicating that it consolidates award period definitions with their associated academic terms and load calendars. In the EBS 12.1.1 and 12.2.2 releases, IGF is flagged as obsolete, meaning the module is retained for backward compatibility with legacy Financial Aid deployments but is no longer actively enhanced. The view is documented as "Not implemented in this database," so its population depends entirely on whether the underlying Financial Aid base tables exist in a given environment.
The view's primary role is to expose award period attributes alongside calendar-term attributes, allowing report writers and integration developers to join award-level data to institutional calendar instances without writing the multi-table join themselves. This is particularly useful when producing award disbursement schedules, term-based eligibility reports, or extracts that must map award periods to both the academic year and the load (disbursement) term calendars.
Underlying Base Objects
The view is defined over four base objects:
- IGF_AW_AWARD_PRD AP — the award period header table, supplying award period code, description, calendar instance, and the BBAY_FLAG.
- IGF_AW_AWD_PRD_TERM APT — the award period-to-term association table, supplying the load calendar type and sequence number.
- IGS_CA_INST AY — the calendar instance table aliased as AY, supplying alternate code, start date, and end date for the award (academic year) calendar instance.
- IGS_CA_INST LD — the same calendar instance table aliased as LD, supplying the corresponding attributes for the load/disbursement calendar instance.
The joins are constructed on composite keys: CI_CAL_TYPE plus CI_SEQUENCE_NUMBER link the award period to the award period term record, and the award period calendar instance is resolved through IGS_CA_INST. A second join resolves the load calendar instance via LD_CAL_TYPE and LD_SEQUENCE_NUMBER. No referenced base objects are separately documented in the ETRM metadata, so the view text itself remains the authoritative definition.
Key Columns
- ROW_ID — the ROWID of the award period row, useful for direct row addressing.
- CI_CAL_TYPE, CI_SEQUENCE_NUMBER — identify the award (academic) calendar instance.
- CI_ALTERNATE_CODE, CI_START_DT, CI_END_DT — the alternate code and effective dates of the award calendar instance.
- AWARD_PRD_CD, AWARD_PRD_DESC — the award period code and its description.
- BBAY_FLAG — the flag associated with the award period. In Financial Aid terminology, "BBAY" denotes a Borrower-Based Academic Year, used for loan processing where the academic year is defined by the borrower's enrollment rather than a fixed institutional calendar. This is the column referenced by the searched term "bbay_flag."
- LD_CAL_TYPE, LD_SEQUENCE_NUMBER — identify the load/disbursement calendar instance.
- LD_ALTERNATE_CODE, LD_START_DT, LD_END_DT — the alternate code and effective dates of the load calendar instance.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.
Common Use Cases and Queries
Typical scenarios include identifying award periods flagged as Borrower-Based Academic Years, reconciling award periods to their award and load calendar instances, and building term-level award extracts for downstream reporting. A simple query to isolate BBAY-flagged award periods follows:
SELECT award_prd_cd, award_prd_desc, bbay_flag, ci_alternate_code, ld_alternate_code FROM igf_aw_awd_apt_v WHERE bbay_flag = 'Y';
A second pattern joins the view back to disbursement or loan tables using AWARD_PRD_CD and the calendar instance keys, enabling award-to-disbursement traceability. Because the Financial Aid module is obsolete in 12.1.1 and 12.2.2, DBAs should confirm object availability before relying on the view in production queries.
-
View: IGF_AW_AWD_APT_V 12.1.1
Award Periods Terms View
APPS.IGF_AW_AWD_APT_V·↳ IGF_AW_AWARD_PRD·↳ IGF_AW_AWD_PRD_TERM·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AW_STUD_AWDS_V 12.1.1
Stores the Load Calendar wise Sum of Award Amount and Paid Amount for a Student
APPS.IGF_AW_STUD_AWDS_V·↳ IGF_AW_AWARD·↳ IGF_AW_AWD_DISB·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AW_COA_LD_V 12.1.1
Stores the relation between Cost of Attendance Code and Load Calendar
APPS.IGF_AW_COA_LD_V·↳ IGF_AW_COA_LD·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AP_EFC_TERM_V 12.1.1
-
View: IGF_AW_COA_TERM_TOT_V 12.1.1
Stores cost of attendance amount split for a term
APPS.IGF_AW_COA_TERM_TOT_V·↳ IGF_AW_COA_ITM_TERMS·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AP_FA_ANT_DATA_V 12.1.1
Financial Aid Base Record Anticipated Data View
APPS.IGF_AP_FA_ANT_DATA_V·↳ IGF_AP_FA_ANT_DATA·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AW_LOAD_CAL_V 12.1.1
APPS.IGF_AW_LOAD_CAL_V·↳ IGS_CA_INST·↳ IGS_CA_TYPE_V·Explore IGF module →
-
View: IGF_AW_AWD_DISB_V 12.1.1
Stores details of each disbursement
APPS.IGF_AW_AWD_DISB_V·↳ IGF_AW_AWD_DISB·↳ IGF_AW_AWD_RVSN_RSN·↳ IGF_AW_GEN·Explore IGF module →
-
View: IGF_AW_AWDS_SUM_V 12.1.1
Summarized awards based on Load Calendar
APPS.IGF_AW_AWDS_SUM_V·↳ IGF_AW_AWARD·↳ IGF_AW_AWD_DISB·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AW_AWD_LD_CAL_V 12.1.1
Retrieves all the load calendars that fall within an award year
APPS.IGF_AW_AWD_LD_CAL_V·↳ IGS_CA_INST·↳ IGS_CA_INST_REL·↳ IGS_CA_TYPE·Explore IGF module →
-
Stores the Cost of Attendance Objects across load calendars.
APPS.IGF_AW_CIT_LD_OVERIDE_V·↳ IGF_AW_CIT_LD_OVERIDE·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AW_TERM_MAP_V 12.1.1
FA125_3160568_CS_DP1.doc - Obsolete
APPS.IGF_AW_TERM_MAP_V·↳ IGF_AW_TERM_MAP·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AW_COA_ITM_TERMS_V 12.1.1
Stores amount split setup for a given cost of attendance item
APPS.IGF_AW_COA_ITM_TERMS_V·↳ IGF_AW_COA_ITM_TERMS·↳ IGF_AW_ITEM·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_DB_AWD_DISB_V 12.1.1
Award disbursement details
APPS.IGF_DB_AWD_DISB_V·↳ IGF_AW_AWARD_V·↳ IGF_AW_AWD_DISB_V·↳ IGF_AW_GEN·Explore IGF module →
-
VIEW: APPS.IGF_AP_EFC_TERM_V 12.1.1
-
VIEW: APPS.IGF_AW_AWD_APT_V 12.1.1
-
VIEW: APPS.IGF_AW_AWDS_SUM_V 12.1.1
-
VIEW: APPS.IGF_AW_COA_LD_V 12.1.1
-
VIEW: APPS.IGF_AW_LOAD_CAL_V 12.1.1
-
View: IGF_AW_TERM_MAP_V 12.2.2
FA125_3160568_CS_DP1.doc - Obsolete
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_AWD_LD_CAL_V 12.2.2
Retrieves all the load calendars that fall within an award year
Not implemented in this database·Explore IGF module →
-
View: IGF_AP_EFC_TERM_V 12.2.2
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_COA_LD_V 12.2.2
Stores the relation between Cost of Attendance Code and Load Calendar
Not implemented in this database·Explore IGF module →
-
View: IGF_AP_FA_ANT_DATA_V 12.2.2
Financial Aid Base Record Anticipated Data View
Not implemented in this database·Explore IGF module →
-
Stores the Cost of Attendance Objects across load calendars.
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_LOAD_CAL_V 12.2.2
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_STUD_AWDS_V 12.2.2
Stores the Load Calendar wise Sum of Award Amount and Paid Amount for a Student
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_COA_TERM_TOT_V 12.2.2
Stores cost of attendance amount split for a term
Not implemented in this database·Explore IGF module →
-
VIEW: APPS.IGF_AW_TERM_MAP_V 12.1.1
-
View: IGF_AW_AWDS_SUM_V 12.2.2
Summarized awards based on Load Calendar
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_AWD_APT_V 12.2.2
Award Periods Terms View
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_COA_ITM_TERMS_V 12.2.2
Stores amount split setup for a given cost of attendance item
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_AWD_DISB_V 12.2.2
Stores details of each disbursement
Not implemented in this database·Explore IGF module →
-
VIEW: APPS.IGF_AW_AWD_DISB_V 12.1.1
-
View: IGF_DB_AWD_DISB_V 12.2.2
Award disbursement details
Not implemented in this database·Explore IGF module →
-
VIEW: APPS.IGF_DB_AWD_DISB_V 12.1.1
-
PACKAGE: APPS.IGF_AP_GEN 12.1.1
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program