Search Results plan_line_id

Overview

The IGS_FI_PP_TMPL_LNS table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module. It functions as the detailed line-level repository for payment plan templates. A payment plan template is a predefined schedule of charges and due dates used to automate the creation of individual student payment plans. This table stores the specific line items—such as tuition installments, fee components, or other charges—that constitute the template's structure. Its role is critical for ensuring consistent, rule-based financial planning and billing for students across the institution.

Key Information Stored

The table's primary purpose is to define each line within a payment plan template. Key columns, as indicated by its primary and foreign keys, include:

• PLAN_LINE_ID: The system-generated unique identifier (primary key) for each template line record.
• PAYMENT_PLAN_NAME: A foreign key column linking the line to its parent template in the IGS_FI_PP_TEMPLATES table. This identifies which template the line belongs to.
• PLAN_LINE_NUM: Defines the sequence or order of the line within its parent payment plan template. This column, combined with PAYMENT_PLAN_NAME, forms a unique constraint (IGS_FI_PP_TMPL_LNS_U1).

While the provided metadata does not list all columns, typical data stored in such a table would include the charge type, amount (fixed or calculated), due date rule or offset from a baseline date, and descriptive information for the line item.

Common Use Cases and Queries

This table is central to operations involving the setup and application of standardized payment schedules. Common use cases include the administration of template creation and maintenance, system validation when generating a student-specific payment plan from a template, and auditing the composition of financial plans. A typical reporting query would join this table to its parent to list all lines for a given template:

SELECT tmpl.payment_plan_name,
ln.plan_line_num,
ln.charge_type,
ln.due_date_offset
FROM igs_fi_pp_tmpl_lns ln,
igs_fi_pp_templates tmpl
WHERE ln.payment_plan_name = tmpl.payment_plan_name
AND tmpl.payment_plan_name = '&TEMPLATE_NAME'
ORDER BY ln.plan_line_num;

Data from this table is also essential for troubleshooting discrepancies in automated student billing and for analyzing the standard financial structures offered by the institution.

Related Objects

The IGS_FI_PP_TMPL_LNS table has a direct and essential relationship with its parent table, IGS_FI_PP_TEMPLATES, via the foreign key on PAYMENT_PLAN_NAME. This enforces referential integrity, ensuring every template line is associated with a valid template. It is a foundational object for higher-level application logic; therefore, key APIs and forms within the Student System's financials submodule, particularly those governing payment plan setup (e.g., template definition forms), will query and maintain this table. While not listed in the metadata, it is also logically related to transactional tables like IGS_FI_P_PLANS and IGS_FI_P_PLAN_LNS, which store the actual student payment plans generated from these templates.