Search Results igs_fi_bill_pln_crd




Overview
Explore in AI Chat

Overview

The IGS_FI_BILL_PLN_CRD table is a data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the IGS (Student System) product family, which is documented as obsolete. Its core function is to store planned credit records associated with a specific bill extract. This table acts as a junction, linking billing information with the planned disbursements of financial aid awards. It is a critical component for tracking the anticipated application of funds (like grants or loans) against a student's charges during the billing cycle. The provided metadata explicitly states this table is "Not implemented in this database," indicating it may be a legacy or reference object in the documented versions, potentially superseded by other tables or processes in active implementations.

Key Information Stored

The table's primary purpose is to associate a bill with specific, planned financial aid disbursements. Its composite primary key, IGS_FI_BILL_PLN_CRD_PK, consists of BILL_ID, AWARD_ID, and DISB_NUM. This structure enforces a unique record for each combination of a bill, an award, and a disbursement number. Key columns include BILL_ID, which links to the main bill header (IGS_FI_BILL_ALL), and AWARD_ID and DISB_NUM, which together link to the specific award disbursement detail (IGF_AW_AWD_DISB_ALL). Additional foreign key columns, such as FUND_ID (linking to IGF_AW_FUND_MAST_ALL) and FEE_CAL_TYPE/FEE_CI_SEQUENCE_NUMBER (linking to IGS_CA_INST_ALL), provide connections to the fund master data and the academic calendar instance, respectively, offering context for the credit's source and applicable period.

Common Use Cases and Queries

The primary use case involves generating or analyzing a student's bill to reflect anticipated financial aid credits. A typical query would join this table to the bill and award disbursement tables to produce a summary of planned credits for a billing run. For example, to list all planned credits for a specific bill, one might use a SQL pattern such as: SELECT bpc.*, awd.disb_amount FROM IGS_FI_BILL_PLN_CRD bpc JOIN IGF_AW_AWD_DISB_ALL awd ON bpc.award_id = awd.award_id AND bpc.disb_num = awd.disb_num WHERE bpc.bill_id = :p_bill_id;. Reporting use cases include reconciliation reports between billed charges and anticipated aid, audit trails for financial aid applied to billing, and forecasting cash flow based on planned disbursements against outstanding student accounts.

Related Objects

The IGS_FI_BILL_PLN_CRD table has defined foreign key relationships with several core EBS tables, as documented in the metadata. These relationships are fundamental for data integrity and joins in queries:

  • IGS_FI_BILL_ALL: Linked via the BILL_ID column. This is the parent bill header table.
  • IGF_AW_AWD_DISB_ALL: Linked via the composite foreign key (AWARD_ID, DISB_NUM). This table holds the actual award disbursement details.
  • IGF_AW_FUND_MAST_ALL: Linked via the FUND_ID column. This table stores the master definition of the financial aid fund.
  • IGS_CA_INST_ALL: Linked via the composite foreign key (FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER). This table defines the calendar instance, likely indicating the period for which the fee or credit applies.
These relationships position IGS_FI_BILL_PLN_CRD as a central link between the billing, financial aid, and academic calendar modules.

  • Table: IGS_FI_BILL_PLN_CRD 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_PLN_CRD,  object_name:IGS_FI_BILL_PLN_CRD,  status:VALID,  product: IGS - Student System ,  description: Stores the planned credit records for the particular bill extract. ,  implementation_dba_data: IGS.IGS_FI_BILL_PLN_CRD , 

  • View: IGS_FI_BILL_PLN_CRD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_BILL_PLN_CRD_V,  object_name:IGS_FI_BILL_PLN_CRD_V,  status:VALID,  product: IGS - Student System ,  description: This view is used in Billing History form to display the planned credits that got extracted for a particular bill. ,  implementation_dba_data: APPS.IGS_FI_BILL_PLN_CRD_V , 

  • Table: IGS_FI_BILL_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_ALL,  object_name:IGS_FI_BILL_ALL,  status:VALID,  product: IGS - Student System ,  description: IGS_FI_BILL_ALL is the relation where the Billing Header information is recorded. Here the Bill Numbers are generated and Bill header details such as Bill Date, Due Date, Billed Person, Sub Account and Balances are recorded. ,  implementation_dba_data: IGS.IGS_FI_BILL_ALL , 

  • Table: IGS_CA_INST_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CA_INST_ALL,  object_name:IGS_CA_INST_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes an instance of a calendar type ,  implementation_dba_data: IGS.IGS_CA_INST_ALL ,