Search Results igs_fi_lb_rec_types




Overview
Explore in AI Chat

Overview

The IGS_FI_LB_REC_TYPES table is a configuration table within the Oracle E-Business Suite Student System (IGS) module. Its primary role is to define and manage the mapping between bank-supplied record identifiers found in lockbox transmission files and the internal record type codes used by the application. This mapping is critical for the automated processing of electronic payments, as it enables the system to correctly interpret and route different data rows (e.g., header, detail, trailer records) from a bank's standardized file format. The table ensures that payment data from various banking institutions, each potentially using different identifier codes, can be accurately parsed and posted to the correct student financial accounts.

Key Information Stored

The table's structure is defined by a composite primary key and a unique key, emphasizing the criticality of its configuration data. The most important columns include LOCKBOX_NAME, which identifies the specific lockbox configuration from the IGS_FI_LOCKBOXES table. The RECORD_IDENTIFIER_CD stores the actual character or code as it appears in the bank's transmission file. The RECORD_TYPE_CODE is the internal application code that the system uses to classify that row of data (e.g., signifying a payment detail line versus a batch header). The relationship between these columns allows the system to translate external bank codes into a consistent internal processing logic.

Common Use Cases and Queries

The primary use case is during the execution of the Lockbox Processing concurrent program. When a bank file is ingested, the program queries this table to build a translation map. For instance, to validate or review the configuration for a specific lockbox, a query such as SELECT record_identifier_cd, record_type_code FROM igs_fi_lb_rec_types WHERE lockbox_name = 'US_EAST_BANK'; would be typical. Administrators may also query this table to troubleshoot parsing errors by verifying that the identifiers in an incoming file match a configured record type. Reporting on lockbox setups often involves joining this table to IGS_FI_LOCKBOXES to present a complete view of the bank interface configuration.

Related Objects

This table has a direct and essential relationship with the IGS_FI_LOCKBOXES table, which defines the master lockbox parameters. The documented foreign key constraint ensures referential integrity: the LOCKBOX_NAME in IGS_FI_LB_REC_TYPES must exist in IGS_FI_LOCKBOXES. This table is a child of IGS_FI_LOCKBOXES. The processing logic for lockbox files, likely housed within packages or concurrent programs in the IGS Financials domain, will heavily reference this mapping table. It serves as a key configuration point between the external bank data (via IGS_FI_LOCKBOXES) and the internal payment application engine.