Search Results servicer_id




Overview
Explore in AI Chat

Overview

IGF.IGF_SL_SERVICER_BRC is a reference and cross-reference table within the Oracle E-Business Suite Financials (formerly ETRM/Leasing) schema owned by IGF. It stores non-ED (Electronic Data) branch codes and descriptions associated with loan servicers. When a servicer processes loans, it may operate through multiple branches that are not registered directly with Electronic Data (ED), and this table captures those branch identifiers together with their descriptive text. It therefore functions as an extension of the master servicer record, allowing the application to distinguish an individual servicer from its various operational branches while preserving a traceable link back to the Trading Community Architecture (TCA) party model.

The ETRM metadata describes this object's storage in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and it carries two unique indexes: IGF_SL_SERVICER_BRC_PK and IGF_SL_SERVICER_BRC_U1. Based on the foreign key relationship to IGF_SL_SERVICER and the presence of a PARTY_ID column for TCA integration, the heuristic Data Vault classification is satellite-leaning. In Data Vault modeling terms, this suggests the table should be treated as a satellite dependent on its parent servicer hub, rather than as an independent hub or a link entity.

Key Information Stored

The table is keyed by a composite primary key, IGF_SL_SERVICER_BRC_PK, comprising SERVICER_ID and SRVC_NON_ED_BRC_ID. SERVICER_ID (VARCHAR2(30)) is the unique six-character identification code assigned by Electronic Data to the servicer processing the loan, while SRVC_NON_ED_BRC_ID (VARCHAR2(30)) is the servicer's non-ED branch identifier. A second unique index, IGF_SL_SERVICER_BRC_U1, exists on PARTY_ID, a NUMBER(15) column that links the servicer's branch organization to TCA.

The DESCRIPTION column (VARCHAR2(80)) stores the human-readable description of the lender branch and is the primary descriptive attribute. The ENABLED column is a checkbox-style indicator that determines whether the servicer is active; setting it to inactive prevents the servicer from being selected in new or modified records. The remaining columns are standard WHO audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, all documented in the metadata and present for row-level auditing and concurrency tracking.

Common Use Cases and Queries

Typical usage includes resolving a servicer's branch to its descriptive label for reporting, validating that a branch is active before allowing it to be attached to a new loan record, and joining to TCA for party-level analytics. The standard query pattern supplied in the ETRM documentation is:

  • SELECT SERVICER_ID, SRVC_NON_ED_BRC_ID, DESCRIPTION, PARTY_ID, ENABLED FROM IGF.IGF_SL_SERVICER_BRC;
  • Filter active branches: add WHERE ENABLED = 'Y' to exclude inactive servicers from selection lists.
  • Retrieve branches for a given servicer: WHERE SERVICER_ID = :p_servicer_id ORDER BY SRVC_NON_ED_BRC_ID.
  • Join to the parent servicer master on SERVICER_ID to obtain the servicer's full attributes alongside each branch.
  • Reporting extracts often join PARTY_ID to TCA party tables to reconcile branch organizations with customer/vendor party records.

Related Objects

The ETRM dependency metadata indicates that IGF_SL_SERVICER_BRC does not reference any database object directly at the SQL level, but its FK relationship documents that SERVICER_ID references the parent table IGF.IGF_SL_SERVICER, which acts as the servicer master hub. The table is referenced by the APPS synonym IGF_SL_SERVICER_BRC. The most significant join paths are therefore:

  • IGF.IGF_SL_SERVICER on SERVICER_ID — retrieves the master servicer record for each branch.
  • TCA party tables via PARTY_ID — links the branch organization to the Trading Community Architecture party model.
  • APPS synonym IGF_SL_SERVICER_BRC — the public name by which application forms and concurrent programs access the table.

Together these relationships position IGF_SL_SERVICER_BRC as a dependent satellite providing branch-level granularity to the servicer master used throughout the leasing and loan servicing processes.