Search Results igf_sl_servicer_brc




Overview
Explore in AI Chat

Overview

The IGF.IGF_SL_SERVICER_BRC table is a transactional configuration object within the Oracle E-Business Suite Financial Aid (IGF) module, which supports the administration of Title IV and non-Title IV student loan programs. The table stores non-ED (non-Department of Education) branch codes and their associated descriptions for student loan servicers. These servicer branch codes are used to identify specific servicing locations or operational branches of a loan servicer that are not directly affiliated with the U.S. Department of Education, allowing institutions and financial aid offices to route, track, and report on loan servicing activity at a granular branch level.

The object is classified in ETRM as VALID and exists in the IGF schema on both Oracle EBS 12.1.1 and 12.2.2. Based on the foreign key topology—a single inbound reference to IGF_SL_SERVICER combined with descriptive attributes and auditable columns—the heuristic Data Vault classification is satellite-leaning. In a Data Vault model, this table would most naturally be represented as a satellite attached to the IGF_SL_SERVICER hub, since it carries descriptive context about a parent servicer entity keyed by the servicer identifier.

Key Information Stored

The table contains ten documented columns. The most significant are:

  • SERVICER_ID — Identifies the parent loan servicer. This column is part of the composite primary key and is a foreign key to IGF_SL_SERVICER.
  • SRVC_NON_ED_BRC_ID — The non-ED branch code identifier. Together with SERVICER_ID, it forms the composite primary key IGF_SL_SERVICER_BRC_PK.
  • DESCRIPTION — The human-readable description of the servicer branch code.
  • PARTY_ID — The trading community / party identifier associated with the servicer branch. This column is the basis of the unique index IGF_SL_SERVICER_BRC_U1, making it a business-key candidate.
  • ENABLED — A flag indicating whether the branch code is active and selectable.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each record.

The surrogate-style composite primary key (SERVICER_ID, SRVC_NON_ED_BRC_ID) can be distinguished from the business-key candidate PARTY_ID, which is enforced through the unique index IGF_SL_SERVICER_BRC_U1.

Common Use Cases and Queries

Typical reporting and validation scenarios include listing all non-ED branches for an active servicer, validating branch codes prior to loan assignment, and joining branch descriptions to disbursement or reconciliation reports.

Sample query listing active branches for a servicer:

  • SELECT brc.SERVICER_ID, brc.SRVC_NON_ED_BRC_ID, brc.DESCRIPTION, brc.ENABLED
  • FROM IGF.IGF_SL_SERVICER_BRC brc
  • WHERE brc.SERVICER_ID = :servicer_id AND brc.ENABLED = 'Y';

A join to the parent servicer for descriptive reporting:

  • SELECT s.SERVICER_ID, s.SERVICER_NAME, b.SRVC_NON_ED_BRC_ID, b.DESCRIPTION
  • FROM IGF.IGF_SL_SERVICER s, IGF.IGF_SL_SERVICER_BRC b
  • WHERE s.SERVICER_ID = b.SERVICER_ID;

Related Objects

  • IGF_SL_SERVICER — Parent table; referenced via IGF_SL_SERVICER_BRC.SERVICER_ID → IGF_SL_SERVICER.SERVICER_ID.
  • IGF_SL_SERVICER_BRC_PK — Composite primary key index on (SERVICER_ID, SRVC_NON_ED_BRC_ID).
  • IGF_SL_SERVICER_BRC_U1 — Unique index on PARTY_ID.

The table is a supporting configuration satellite within the IGF servicer management sub-model and should be queried alongside its parent servicer record for complete context.