Results for “title4_type_ind”

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

Overview

IGS_FI_CR_TYPES_ALL is a foundational configuration table in the Oracle EBS Student System (IGS) financials module, which is documented as obsolete in current releases but remains present in many 12.1.1 and 12.2.2 installations that were upgraded from earlier E-Business Suite versions. The table stores definitions of "credit types" — reusable classifications that determine how a credit transaction is accounted for. Each credit type record supplies the debit and credit account information, the credit class, refund and forfeiture rules, subaccount mapping, and posting hierarchy assignment used by the credit transaction engine.

In Data Vault modeling terms, the metadata's heuristic classification places IGS_FI_CR_TYPES_ALL as a hub. This reflects the fact that CREDIT_TYPE_ID is a stable business key referenced by numerous surrounding objects — credits, balance exceptions, lockbox defaults, waiver programs, and account hierarchies — rather than a transactional fact table itself. Treating it as a hub is a modeling suggestion; the surrounding descriptive attributes (accounts, priority, attributes, effective dates) would more naturally resolve into a satellite.

The table is operational, not temporal-transactional: rows define valid credit type configurations and are joined at run time by transaction processing routines. Because the module is obsolete, Oracle no longer ships patches specifically for this object, but the table remains queryable and is frequently encountered during migration and data-cleansing projects.

Key Information Stored

IGS_FI_CR_TYPES_ALL contains 45 documented columns. The most functionally significant are:

• CREDIT_TYPE_ID — surrogate primary key (IGS_FI_CR_TYPES_ALL_PK) that uniquely identifies each credit type and is the join key used by every dependent table.
• CREDIT_TYPE_NAME, EFFECTIVE_START_DATE, ORG_ID — the composite business-key candidate defined by unique index IGS_FI_CR_TYPES_ALL_U2, enforcing name uniqueness within an operating unit and effective period.
• CREDIT_CLASS — the category used to group credit types for reporting and rule evaluation.
• DR_ACCOUNT_CD and CR_ACCOUNT_CD — the debit and credit account codes referenced against IGS_FI_ACC_ALL.
• DR_GL_CCID and CR_GL_CCID — the corresponding General Ledger code combination identifiers used when journals are generated.
• SUBACCOUNT_ID — foreign key to IGS_FI_SUBACCTS_ALL for subaccount routing.
• APPL_HIERARCHY_ID — foreign key to IGS_FI_A_HIERARCHIES linking the credit type to an application (posting) hierarchy.
• PAYMENT_CREDIT_TYPE_ID — a recursive reference to another row in this table, defining the credit type applied to payments.
• FORFEITURE_ACCOUNT_CD and FORFEITURE_GL_CCID — the account used when credits are forfeited.
• REFUND_ALLOWED and PAYMENT_PRIORITY — control flags influencing refund eligibility and the ordering of payment application.
• EFFECTIVE_END_DATE — end-dates the configuration row, enabling versioned credit type definitions.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard EBS descriptive-flexfield columns for site-specific extension.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard audit columns.

Common Use Cases and Queries

Typical reporting needs include listing all active credit types for an operating unit, tracing which GL accounts a credit type posts to, and auditing configuration prior to a data migration. A basic active-configuration query:

• SELECT CREDIT_TYPE_ID, CREDIT_TYPE_NAME, CREDIT_CLASS, DR_ACCOUNT_CD, CR_ACCOUNT_CD FROM IGS_FI_CR_TYPES_ALL WHERE ORG_ID = :org AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE, SYSDATE+1);
• Joining to IGS_FI_CREDITS_ALL on CREDIT_TYPE_ID to summarise credit volume by type and class.
• Joining to IGS_FI_ACC_ALL on both DR_ACCOUNT_CD and CR_ACCOUNT_CD to verify that the debit and credit accounts are valid and enabled.
• Self-joining on PAYMENT_CREDIT_TYPE_ID to resolve the payment credit type name for a given credit type.
• Querying IGS_FI_WAIVER_PGMS and IGS_FI_LOCKBOXES for credit types used as waiver or default lockbox values.

Because many downstream objects share the CREDIT_TYPE_ID column, care must be taken when filtering by ORG_ID — the same credit type name may exist in multiple operating units with different account mappings.

Related Objects

The table is heavily referenced across the IGS financials schema and several ancillary modules. The most significant relationships include:

• IGS_FI_CREDITS_ALL — references CREDIT_TYPE_ID; the primary transactional consumer of credit type configuration.
• IGS_FI_ACC_ALL — parent of DR_ACCOUNT_CD, CR_ACCOUNT_CD, and FORFEITURE_ACCOUNT_CD.
• IGS_FI_A_HIERARCHIES — references CREDIT_TYPE_ID and is itself referenced via APPL_HIERARCHY_ID.
• IGS_FI_SUBACCTS_ALL — parent of SUBACCOUNT_ID.
• IGS_FI_BAL_EX_C_TYPS — references CREDIT_TYPE_ID for balance exception handling.
• IGS_FI_LB_CR_TYPES and IGS_FI_LOCKBOXES — link lockbox processing to credit types via CREDIT_TYPE_ID and DEFAULT_CREDIT_TYPE_ID.
• IGS_FI_WAIVER_PGMS — references CREDIT_TYPE_ID for waiver program definitions.
• IGS_FI_CR_TYPES_ALL (self-referencing) — via PAYMENT_CREDIT_TYPE_ID.
• IGS_FI_CRD_INT_ALL and IGS_FI_COM_RECS_INT — interface tables that stage credit and commission records keyed by CREDIT_TYPE_ID.

Although the IGS Student System is marked obsolete, these relationships persist in upgraded databases and must be accounted for in any archive, purge, or migration strategy.