Results for “igs_fi_fee_pay_schd”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_FI_FEE_PAY_SCHD is a transactional configuration table in the Oracle E-Business Suite Student System (IGS) module. It stores the schedule-level definition of special contract-based fee assessment rates, allowing institutions to associate contracted fee arrangements with specific fee types, fee categories, and academic calendar instances. The table sits within the fee assessment and payment scheduling framework of Student Financials, and it acts as the bridge between a fee assessment rule defined against a calendar instance and the deferred or installment payment schedule applied to that fee. It is important to note that the ETRM metadata explicitly records this object as Not implemented in this database, meaning no physical columns are materialized in the reference release; the logical definition below reflects the documented schema contract.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is link. This is a reasonable modeling suggestion because IGS_FI_FEE_PAY_SCHD resolves relationships among an academic calendar instance, a fee type, a fee category, and a contract schedule, rather than acting as a standalone hub or a descriptive satellite.

Key Information Stored

The primary key is documented in two forms. The first, named FPS_UK, is a business-key candidate composed of FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, FEE_CAT, and SCHEDULE_NUMBER — the natural grain that uniquely identifies a contract-based fee payment schedule line. The second, IGS_FI_FEE_PAY_SCHD_PK, spans FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, S_RELATION_TYPE, and SEQUENCE_NUMBER. Both are documented as primary keys, so the surrogate-versus-business distinction is not cleanly separated in this release; treat FPS_UK as the primary business-key candidate.

• FEE_CAL_TYPE — the fee calendar type; part of both primary keys and the join key to fee calendar instances.
• FEE_CI_SEQUENCE_NUMBER — sequence identifying the specific fee calendar instance within the calendar type.
• FEE_TYPE — the assessed fee type; joins to IGS_FI_F_TYP_CA_INST_ALL.
• FEE_CAT — the fee category; joins to IGS_FI_F_CAT_CA_INST.
• SCHEDULE_NUMBER — identifies the payment schedule applied to the contract-based fee.
• S_RELATION_TYPE — the student relationship type qualifying the schedule.
• SEQUENCE_NUMBER — ordering/line sequence within the PK combination.
• DT_ALIAS and DAI_SEQUENCE_NUMBER — the data alias and instance sequence that resolve to the academic data alias instance (IGS_CA_DA_INST).

Together these columns define which contract-driven fee, for which category and type, is paid according to which schedule, under which calendar instance and relationship type.

Common Use Cases and Queries

Typical reporting scenarios include extracting the payment schedule applied to each contract-based fee, reconciling contracted rates against assessed fees, and auditing schedules by calendar term.

• List all contract fee schedules for a given calendar instance:
  SELECT fee_cal_type, fee_ci_sequence_number, fee_type, fee_cat, schedule_number FROM igs_fi_fee_pay_schd WHERE fee_cal_type = :cal AND fee_ci_sequence_number = :ci;
• Join to the fee type instance to describe the assessed fee:
  SELECT p.*, t.* FROM igs_fi_fee_pay_schd p, igs_fi_f_typ_ca_inst_all t WHERE p.fee_type = t.fee_type AND p.fee_cal_type = t.fee_cal_type AND p.fee_ci_sequence_number = t.fee_ci_sequence_number;
• Join to the fee category calendar instance for classification reporting on FEE_CAT and FEE_CAL_TYPE / FEE_CI_SEQUENCE_NUMBER.
• Resolve the academic data alias via DT_ALIAS and DAI_SEQUENCE_NUMBER against IGS_CA_DA_INST.
• Aggregate schedule counts by S_RELATION_TYPE to analyze contract coverage across student populations.

Related Objects

The table participates in three documented foreign-key relationships, each resolving to a calendar-instance parent:

• IGS_CA_DA_INST — joined on DT_ALIAS and DAI_SEQUENCE_NUMBER (plus FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER); provides the underlying data alias instance.
• IGS_FI_F_CAT_CA_INST — joined on FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER; supplies fee category definitions per calendar instance.
• IGS_FI_F_TYP_CA_INST_ALL — joined on FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER; supplies fee type definitions across all calendar instances.
• Fee calendar instance and schedule definition tables in the IGS_FI family that share FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER keys.

Because the object is not implemented in the reference database, implementers should confirm column availability in their target release (12.1.1 or 12.2.2) before relying on it in concurrent programs, reports, or integrations.