Search Results igs_fi_cr_types_all




Overview
Explore in AI Chat

Overview

The IGS_FI_CR_TYPES_ALL table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically for financial management. It serves as a master definition table for credit types, which are fundamental to the processing of financial credit transactions. A credit type defines the accounting rules for a transaction by providing the default debit and credit General Ledger account combinations. It also holds critical control information, such as the credit class and applicable accounting hierarchy, ensuring that financial postings adhere to institutional and regulatory accounting standards. As a multi-org enabled table (indicated by the _ALL suffix and the ORG_ID column), it supports the definition of unique credit types for different operating units within a single installation.

Key Information Stored

The table's primary key is CREDIT_TYPE_ID, with a unique key constraint on the combination of CREDIT_TYPE_NAME, EFFECTIVE_START_DATE, and ORG_ID, enforcing unique, date-effective definitions per operating unit. Essential columns include CREDIT_TYPE_NAME for identification and DESCRIPTION. The core accounting logic is driven by DR_ACCOUNT_CD and CR_ACCOUNT_CD, which are foreign keys to IGS_FI_ACC_ALL, storing the default debit and credit account codes. The SUBACCOUNT_ID links to a specific sub-account definition, and APPL_HIERARCHY_ID references IGS_FI_A_HIERARCHIES to determine the applicable accounting hierarchy for transaction validation. Other significant columns include CREDIT_CLASS, PAYMENT_CREDIT_TYPE_ID (for linking to a related payment credit type), and FORFEITURE_ACCOUNT_CD for handling forfeiture scenarios.

Common Use Cases and Queries

This table is central to configuring the financial posting rules for various student transactions, such as tuition credits, fee waivers, or payment applications. A common reporting use case involves querying all active credit types for a specific operating unit to review their accounting setups. For technical support, one might trace the accounting impact of a specific transaction by joining from a credit record to this table.

  • Sample Query: List credit types with their account codes for an ORG_ID.
    SELECT credit_type_name, description, dr_account_cd, cr_account_cd
    FROM igs_fi_cr_types_all
    WHERE org_id = :p_org_id
    AND SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, SYSDATE)
    ORDER BY credit_type_name;
  • Sample Query: Find the hierarchy and sub-account for a specific credit type.
    SELECT ct.credit_type_name, ah.hierarchy_name, sa.subaccount_name
    FROM igs_fi_cr_types_all ct,
    igs_fi_a_hierarchies ah,
    igs_fi_subaccts_all sa
    WHERE ct.appl_hierarchy_id = ah.hierarchy_id(+)
    AND ct.subaccount_id = sa.subaccount_id(+)
    AND ct.credit_type_id = :p_credit_type_id;

Related Objects

The IGS_FI_CR_TYPES_ALL table has extensive relationships, acting as a parent for numerous transactional and control tables. Key documented foreign key relationships include: