Results for “change_code_description”

3 results




Overview
Explore in AI Chat

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

Overview

The IGF_SL_CL_CHG_REC_TYPES table is a pre-seeded reference table in the Oracle E-Business Suite Financial Aid (IGF) module, intended to store CommonLine Change Record Types. CommonLine is the industry-standard electronic data interchange specification used by the U.S. federal student loan community to exchange loan origination, disbursement, and change transactions between schools, lenders, guarantors, and servicers. The IGF product line was Oracle's Financial Aid processing solution, and this table formed part of its CommonLine interface infrastructure by defining the valid change record type codes that could appear on inbound or outbound CommonLine change transactions.

From a Data Vault modeling perspective, the ETRM relationship metadata classifies this object heuristically as standalone. This reflects the fact that the table has no documented foreign key dependencies to other tables in the extracted schema. Where a Data Vault model is being designed around this data, the recommended treatment is to model IGF_SL_CL_CHG_REC_TYPES as a reference hub (or, less formally, a standalone reference/code table), since it holds stable business codes rather than transaction events or descriptive change history.

A critical caveat from the ETRM documentation: this table is marked Not implemented in this database, and the IGF product is flagged as obsolete. Consequently, DBAs and integrators should not expect to find this object populated in a running 12.1.1 or 12.2.2 instance; it is inherited from older Financial Aid deliverables and retained in the ETRM catalog for historical and reference purposes.

Key Information Stored

The table comprises eleven documented columns. The most significant are the following:

  • CL_VERSION_CODE — Identifies the CommonLine specification version to which the change record type definition applies. Because the CommonLine standard evolved through multiple versions, this code scopes the remaining rows to a particular version's rules.
  • RECORD_TYPE_TXT — The text code for the CommonLine change record type itself, distinguishing the kinds of change records that can be transmitted.
  • CHANGE_CODE_TXT — The specific change code associated with the record type, indicating the nature of the modification (for example, a loan amount change or a status update).
  • RECORD_DESCRIPTION_TXT — Human-readable description of the record type, used in reporting and lookup displays.
  • CHANGE_CODE_DESCRIPTION — Human-readable description of the change code.
  • ENABLED_FLAG — Standard Oracle EBS enable/disable indicator controlling whether the code is active for use.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard EBS "WHO" audit columns capturing row creation and last modification metadata.

The primary key is the composite IGF_SL_CL_CHG_REC_TYPES_PK defined over (CL_VERSION_CODE, RECORD_TYPE_TXT, CHANGE_CODE_TXT). This same column set also serves as the unique business-key index, meaning the primary key is natural rather than surrogate — there is no single numeric ID column documented for this table. The three-column key enforces uniqueness across version, record type, and change code combinations.

Common Use Cases and Queries

In a functioning Financial Aid implementation, this table would be consulted during validation of CommonLine change transactions, to confirm that an incoming change record's type and change code are recognized for the given specification version. Reporting use cases include producing a catalog of supported change record types, and joining description fields into transaction-level extracts so that downstream reports display readable text rather than cryptic codes.

A typical lookup query filters on the version and enablement flag:

  • SELECT record_type_txt, change_code_txt, record_description_txt, change_code_description FROM igf_sl_cl_chg_rec_types WHERE cl_version_code = :version AND enabled_flag = 'Y';

Because the table is standalone and unpopulated in documented environments, any query against it should first confirm existence and row count. Migration and upgrade projects referencing this object should treat it as a static reference seed delivered with the Financial Aid product.

Related Objects

The ETRM metadata documents no foreign key relationships for this table; its Data Vault classification is standalone, meaning no other table in the extracted schema carries a documented FK to it and it references no parent table. The only strictly related object named in the documentation is its own primary/unique index, IGF_SL_CL_CHG_REC_TYPES_PK. Where relationships exist in a live implementation, they would be logical (validated in application code) rather than enforced by database constraints. Practitioners integrating with this area should trace the surrounding IGF_SL_CL_* CommonLine family of tables and the Financial Aid CommonLine processing APIs to determine how change record types are consumed, since those dependents are not captured in the provided relationship extract.