Search Results igf_sl_dl_chg_fld_u2

Overview

IGF.IGF_SL_DL_CHG_FLD is a seed/reference table within the Oracle E-Business Suite 12.1.1 and 12.2.2 Financial Aid module (IGF schema). It maintains the catalogue of change field codes for the Direct Loan (DL) process. In the U.S. Department of Education Direct Loan Common Origination and Disbursement (COD) model, the school transmits both origination and subsequent change records to the loan origination center. Each change record carries a numeric change code and a value for a specific field. IGF_SL_DL_CHG_FLD defines which change codes are valid for a given Direct Loan specification version and loan category, maps each code to the corresponding database field, and records the maximum string length permitted for that field within the change file.

The table is a standalone, low-volume configuration object; the ETRM dependency report confirms that it references no other database object and is referenced only by its APPS synonym in the delivered environment. Under the heuristic Data Vault classification supplied with the metadata, the object is best modelled as a satellite-style reference (or a small reference hub with descriptive attributes), keyed on the surrogate identifier DCHG_ID, with the natural composite keys carried by the unique indexes. Storage is in the APPS_TS_SEED tablespace, consistent with seeded reference data delivered by the application.

Key Information Stored

• DCHG_ID (NUMBER, 15) — surrogate identifier for a Direct Loan change-data definition; defined as the primary key via IGF_SL_DL_CHG_FLD_PK and enforced by unique index IGF_SL_DL_CHG_FLD_U1.
• DL_VERSION (VARCHAR2, 30) — Direct Loan specification version, for example 2001-2002 or 2002-2003; drives the version-specific rules for each award year.
• CHG_CODE (VARCHAR2, 30) — pre-defined change field number sent to the loan origination center. Together with DL_VERSION and LOAN_CATG it forms the business key enforced by IGF_SL_DL_CHG_FLD_U2.
• LOAN_CATG (VARCHAR2, 30) — loan category, the key term matched by the user search "loan_catg". It partitions change codes by loan program type (for example subsidized, unsubsidized, or PLUS).
• FLD_NAME (VARCHAR2, 30) — the database field name whose value changes. With DL_VERSION and LOAN_CATG it forms the alternate business key enforced by IGF_SL_DL_CHG_FLD_U3.
• FLD_LENGTH (NUMBER, 15) — maximum string length permitted for the field within the change file; used for validation and for building fixed-width change records.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who columns, providing audit and concurrency information for the seeded rows.

The three unique indexes therefore represent three candidate business keys: DCHG_ID alone; DL_VERSION + LOAN_CATG + CHG_CODE; and DL_VERSION + LOAN_CATG + FLD_NAME. The last two guarantee that a given version and loan category cannot reuse a change code or map two codes to the same field.

Common Use Cases and Queries

Typical usage centers on decoding change codes during COD file generation, validating inbound change data, and reporting on field-level mappings by award year and loan category. The standard query text documented for the object is:

• SELECT DCHG_ID, DL_VERSION, CHG_CODE, LOAN_CATG, FLD_NAME, FLD_LENGTH, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGF.IGF_SL_DL_CHG_FLD;
• Lookup by business key: WHERE DL_VERSION = :version AND LOAN_CATG = :loan_catg AND CHG_CODE = :chg_code — resolves the target field name and maximum length before a change record is built.
• Reverse lookup by field: WHERE DL_VERSION = :version AND LOAN_CATG = :loan_catg AND FLD_NAME = :fld_name — determines which change code to emit when a tracked field is modified.
• Version coverage report: SELECT DL_VERSION, LOAN_CATG, COUNT(*) FROM IGF.IGF_SL_DL_CHG_FLD GROUP BY DL_VERSION, LOAN_CATG — verifies that all required codes are seeded for the active award year.
• Validation report: SELECT * FROM IGF.IGF_SL_DL_CHG_FLD WHERE FLD_LENGTH IS NULL — identifies incomplete seed rows that could cause truncation in outbound change files.

Related Objects

• APPS.IGF_SL_DL_CHG_FLD — the APPS synonym over the IGF table; the ETRM dependency report lists this as the sole referencing object, and it is the access path used by forms, concurrent programs, and reports running under the APPS schema.
• IGF.IGF_SL_DL_CHG_FLD_PK / _U1 / _U2 / _U3 — the primary key and unique index structures that define the surrogate and business keys used in every join predicate.
• Direct Loan change-data staging tables in the IGF schema — parent/child objects that hold the actual changed values keyed by CHG_CODE, DL_VERSION, and LOAN_CATG, resolving field names and lengths against this table at file-generation time.
• Direct Loan COD file-generation concurrent programs — the interface processes that read IGF_SL_DL_CHG_FLD to format change records for transmission to the loan origination center.
• Direct Loan validation APIs and packages — routines that consult this table to confirm that a requested change code is valid for the applicable DL_VERSION and LOAN_CATG before accepting a change.

Because the object is standalone, no foreign keys exist to or from it; integration is achieved logically rather than through referential constraints.