Search Results igf_sl_cl_file_type_pk

Overview

IGF_SL_CL_FILE_TYPE is a seed-data configuration table in the IGF (Financial Aid) product schema of Oracle E-Business Suite. It maintains the mapping between flat-file release versions and file types, providing the file identification code and file name used by the Student Loan (SL) processing components when reading, writing, and validating CommonLine and related flat files exchanged with lenders, guarantors, and servicers. The table is delivered populated with Oracle-supplied rows and is generally not maintained by end users; it acts as a reference or lookup source that drives file recognition logic across releases.

Within a Data Vault modeling context, the metadata classifies this object heuristically as standalone, with no inbound or outbound foreign key dependencies mined from the schema. In practical modeling terms this suggests a hub-style reference table: it holds a stable, uniquely identified business key (the combination of release version and file type) with no link relationships to other hubs, and the descriptive attributes (production flag, file identification name and code) can be viewed as satellite-style context attached to that key.

Key Information Stored

The primary key is IGF_SL_CL_FILE_TYPE_PK, defined on the composite of CL_VERSION and CL_FILE_TYPE. A unique index, IGF_SL_CL_FILE_TYPE_U1, enforces the same two-column combination, confirming that CL_VERSION and CL_FILE_TYPE together form the business key of the table rather than a surrogate identifier. The documented schema contains ten columns.

• CL_VERSION — the CommonLine specification or processing release version for which the file definition applies; part of the composite primary key and the discriminator between otherwise identical file types across releases.
• CL_FILE_TYPE — the file type identifier for the flat file (for example, loan application, disbursement roster, or acknowledgement file); also part of the composite primary key.
• FILE_IDENT_NAME — the human-readable or programmatic file identification name associated with the version and file type combination.
• FILE_IDENT_CODE — the file identification code used by the interface to recognize and route the flat file during import and export processing.
• PRODUCTION — a flag indicating the production status or applicability of the seed row, used to distinguish production-ready definitions from test or non-production entries.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns recording row creation and last modification metadata.

Common Use Cases and Queries

The table is primarily consumed by the Financial Aid file-processing programs to resolve a file identification code or name from a given release version and file type before parsing or generating a flat file. Reporting and reconciliation queries typically join or filter on CL_VERSION to isolate the correct release, and on PRODUCTION to exclude non-production seed rows.

A representative lookup query retrieves the identification code and name for a specific version and type:

• SELECT cl_version, cl_file_type, file_ident_code, file_ident_name, production FROM igf.igf_sl_cl_file_type WHERE cl_version = :version AND cl_file_type = :file_type;

An administrative or diagnostic query lists all file types defined for a release:

• SELECT cl_file_type, file_ident_name, file_ident_code FROM igf.igf_sl_cl_file_type WHERE cl_version = :version AND production = 'Y' ORDER BY cl_file_type;

Audit reporting can use the standard audit columns to identify recently seeded or patched rows, for example filtering on LAST_UPDATE_DATE to detect rows refreshed by a patch or upgrade.

Related Objects

The metadata records this table as standalone, with no documented foreign key relationships to or from other objects. Consequently, related objects are identified functionally rather than through referential constraints. The following are the most significant dependencies in practice:

• IGF_SL_CL_FILE_TYPE_PK — the composite primary key constraint on (CL_VERSION, CL_FILE_TYPE) that governs uniqueness of every row.
• IGF_SL_CL_FILE_TYPE_U1 — the unique index on the same two columns, reinforcing the business-key definition.
• Financial Aid CommonLine file import and export concurrent programs — the processing routines that resolve file identification codes and names from this table at runtime.
• IGF_SL_CL_* interface tables — sibling CommonLine staging objects whose validation depends on the file type definitions maintained here.
• Release and version reference data — the source of valid CL_VERSION values used throughout the Financial Aid module.

Because the table is seed data, changes should be applied only through Oracle-provided patches or controlled DBA scripts rather than ad hoc maintenance.