Results for “fee_category”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGSFV_STUDENT_PROGRAM_TERMS is a read-only view within the Oracle E-Business Suite (EBS) IGS — Student System product family. In EBS 12.1.1 and 12.2.2, IGS is delivered as an obsolete, legacy module retained for backward compatibility; its schema objects persist even though most functionality has been superseded by Oracle Student Financial Planning and related higher-education products. The view presents a consolidated, denormalized picture of a student's program and term enrollment record, joining the core student program/term allocation table to descriptive reference tables so that codes are surfaced alongside their human-readable descriptions. Because IGS is obsolete, the view is documented in the ETRM but flagged as "Not implemented in this database," meaning the object may not exist in every EBS instance depending on whether the IGS schema was ever installed or later dropped.
Underlying Base Objects
Although the documented metadata lists no referenced base objects in ETRM 12.2.2, the view text explicitly identifies its driving and joined tables. The primary table is IGS_EN_SPA_TERMS (aliased SPAT), which stores student program term records keyed by TERM_RECORD_ID. It is outer- or inner-joined to a set of reference and descriptive tables:
- HZ_PARTIES (HP) — party/person name via PERSON_ID = PARTY_ID.
- IGS_PS_VER_ALL (PV) — program version and title via PROGRAM_CD/VERSION_NUMBER.
- IGS_CA_INST_ALL (CI) — calendar instance start/end dates and description via TERM_CAL_TYPE and TERM_SEQUENCE_NUMBER.
- IGS_CA_TYPE (CT, CT1) — academic and term calendar type descriptions.
- IGS_AD_LOCATION_ALL (LOC) — location description.
- IGS_EN_ATD_MODE_ALL (AM) and IGS_EN_ATD_TYPE_ALL (ATT) — attendance mode and type descriptions.
- IGS_FI_FEE_CAT_ALL (FC) — fee category description (outer-joined).
- IGS_PR_CLASS_STD (PCS) — class standing (outer-joined).
The view is defined WITH READ ONLY, so it cannot be used for DML.
Key Columns
The view exposes over twenty columns. The most significant are:
- TERM_RECORD_ID — primary key of the underlying program-term record.
- PERSON_IDENTIFIER, PERSON_NUMBER, PERSON_NAME — student identity, sourced from HZ_PARTIES.
- PROGRAM_CODE, PROGRAM_VERSION, PROGRAM_TITLE — program context.
- ACADEMIC_CALENDAR_TYPE and TERM_CALENDAR_TYPE with their _DESC columns — calendar classification.
- TERM_CAL_SEQUENCE_NUMBER, TEM_CALENDAR_START_DATE, TERM_CALENDAR_END_DATE, TERM_CALENDAR_INSTANCE_DESC — the term's temporal boundaries.
- KEY_PROGRAM_FLAG and its descriptive companion column — a YES/NO lookup indicating the key program.
- LOCATION_CODE/LOCATION_CODE_DESC, ATTENDANCE_MODE/_DESC, ATTENDANCE/_DESC, FEE_CAT, CLASS_STANDING — attendance and categorization attributes.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns.
Common Use Cases and Queries
Typical usage is reporting on a student's program and term history, student term extract feeds, and cross-referencing key program flags. A representative query:
SELECT PERSON_NUMBER, PERSON_NAME, PROGRAM_CODE, PROGRAM_TITLE, TERM_CALENDAR_TYPE_DESC, TEM_CALENDAR_START_DATE, TERM_CALENDAR_END_DATE, KEY_PROGRAM_FLAG_DESC FROM IGSFV_STUDENT_PROGRAM_TERMS WHERE PERSON_IDENTIFIER = :person_id ORDER BY TEM_CALENDAR_START_DATE;
Consultants should verify the object's existence in the target instance before relying on it, given its obsolete status and "not implemented" flag in the ETRM metadata.
-
Lookup Type: FEE_CATEGORY 12.1.1
Fee Category
-
Lookup Type: FEE_CATEGORY 12.2.2
Fee Category
-
APPS.IGSFV_STUDENT_PROGRAM_TERMS·↳ HZ_PARTIES·↳ IGS_AD_LOCATION_ALL·↳ IGS_CA_INST_ALL·Explore IGS module →
-
Holds Information about Admission Application Program Details
APPS.IGSBV_AD_ADM_PS_APPL_INST·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_AD_PS_APPL_INST_ALL·Explore IGS module →
-
View: IGSFV_ADM_FEE_CAT 12.1.1
APPS.IGSFV_ADM_FEE_CAT·↳ IGS_AD_CAT_ALL·↳ IGS_FI_FEE_CAT_ALL·↳ IGS_FI_FEE_CAT_MAP·Explore IGS module →
-
View: IGS_FI_F_TYP_CA_INST_V 12.1.1
View used for Fee Calendar Instance tables. Used to bring together the following 3 tables : FEE_TYPE_CAL_INSTANCE FEE_CAT_CAL_INSTANCE FEE_CAT_FEE_LIABILITY Used to enable a common context block in form FINF2860.
APPS.IGS_FI_F_TYP_CA_INST_V·↳ IGS_FI_F_CAT_CA_INST·↳ IGS_FI_F_CAT_FEE_LBL·↳ IGS_FI_F_TYP_CA_INST·Explore IGS module →
-
View: IGSBV_ADM_FEE_CAT 12.1.1
APPS.IGSBV_ADM_FEE_CAT·↳ IGS_FI_FEE_CAT_MAP·Explore IGS module →
-
View: IGS_CA_TEACH_RET_CTX_V 12.1.1
View to query teaching calendars. The view structure will be same as view IGS_FI_F_TYP_CA_INST_V.
APPS.IGS_CA_TEACH_RET_CTX_V·↳ IGS_CA_INST·↳ IGS_CA_TYPE·Explore IGS module →
-
This entity describes a student's attempt at studying a particular course offered by the university.
APPS.IGSBV_STUDENT_PROGRAM_ATTEMPTS·↳ HZ_PARTIES·↳ IGS_EN_STDNT_PS_ATT_ALL·↳ IGS_PS_VER_ALL·Explore IGS module →
-
This view lists program attempt attributes based on Term Calendar.
APPS.IGSBV_STUDENT_PROGRAM_TERMS·↳ IGS_EN_SPA_TERMS·Explore IGS module →
-
Loan Fees Setup Table
-
Loan Fees Setup Table
-
Describes the request for program Entry for an Admission period
APPS.IGSFV_AD_ADM_PS_APPL_INST·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_AD_CNDNL_OFRSTAT·Explore IGS module →
-
Commercial Receivables Open Interface table.
-
View: IGSBV_PARTY_CHARGES 12.1.1
Contains details of charges for a person
APPS.IGSBV_PARTY_CHARGES·↳ IGS_FI_INVLN_INT_ALL·↳ IGS_FI_INV_INT_ALL·Explore IGS module →
-
This entity describes a student's attempt at studying a particular course offered by the university.
APPS.IGSFV_STUDENT_PROGRAM_ATTEMPTS·↳ HZ_PARTIES·↳ IGS_AD_LOCATION_ALL·↳ IGS_CA_INST_ALL·Explore IGS module →
-
View: IGSFV_PARTY_CHARGES 12.1.1
Contains details of charges for a person
APPS.IGSFV_PARTY_CHARGES·↳ GL_CODE_COMBINATIONS·↳ HZ_PARTIES·↳ IGS_FI_1098T_SETUP·Explore IGS module →
-
View: IGS_FI_F_TYP_CA_INST_V 12.2.2
View used for Fee Calendar Instance tables. Used to bring together the following 3 tables : FEE_TYPE_CAL_INSTANCE FEE_CAT_CAL_INSTANCE FEE_CAT_FEE_LIABILITY Used to enable a common context block in form FINF2860.
Not implemented in this database·Explore IGS module →
-
VIEW: LNS.LNS_FEES_ALL# 12.2.2
-
TABLE: LNS.LNS_FEES_ALL 12.1.1
-
VIEW: LNS.LNS_FEES_ALL# 12.2.2
-
VIEW: APPS.IGSBV_ADM_FEE_CAT 12.1.1
-
TABLE: LNS.LNS_FEES_ALL 12.2.2
-
View: IGSBV_ADM_FEE_CAT 12.2.2
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGSFV_ADM_FEE_CAT 12.1.1
-
View: IGSFV_ADM_FEE_CAT 12.2.2
Not implemented in this database·Explore IGS module →
-
This view lists program attempt attributes based on Term Calendar.
Not implemented in this database·Explore IGS module →
-
View: IGS_CA_TEACH_RET_CTX_V 12.2.2
View to query teaching calendars. The view structure will be same as view IGS_FI_F_TYP_CA_INST_V.
Not implemented in this database·Explore IGS module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
This entity describes a student's attempt at studying a particular course offered by the university.
Not implemented in this database·Explore IGS module →
-
View: IGSBV_PARTY_CHARGES 12.2.2
Contains details of charges for a person
Not implemented in this database·Explore IGS module →
-
Not implemented in this database·Explore IGS module →
-
Holds Information about Admission Application Program Details
Not implemented in this database·Explore IGS module →
-
View: IGSFV_PARTY_CHARGES 12.2.2
Contains details of charges for a person
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.LNS_FEE_ENGINE 12.1.1
-
This entity describes a student's attempt at studying a particular course offered by the university.
Not implemented in this database·Explore IGS module →