Search Results org_unit




Overview
Explore in AI Chat

Overview

The IGS_EN_NSC_BRANCH_V view is a database object owned by the APPS schema within the Oracle E-Business Suite environment. It belongs to the IGS (Student System) product family and is classified as VALID. The view is designed specifically to support the National Student Clearinghouse (NSC) creation process, a regulatory reporting requirement for educational institutions that must submit enrollment and status data to the clearinghouse. The view supplies branch codes used by the NSC creation process, and it serves as the source for a concurrent process value set. In practical terms, this view presents a consolidated list of organization alternate identifiers drawn from the organization hierarchy, restricted to organization units, plus a synthetic "00 00" entry. Because it is wired into a value set, it functions as a controlled selection list for parameters entered when the NSC creation concurrent program is launched.

Underlying Base Objects

According to the documented view text, the primary base object is IGS_OR_ORG_ALT_IDS_V, itself a view over organization alternate identifier data in the Student System. The outer query filters this source on ORG_STRUCTURE_TYPE = 'ORG_UNIT' and on an active date range, using NVL(ALT.END_DATE, SYSDATE) >= SYSDATE so that only organizations whose alternate identifiers are currently effective (or open-ended) are returned. A second branch of the UNION appends a literal row constructed from DUAL containing the values '00' padded to twenty characters and the token '00', producing an ALTERNATE_ID of 00 00 and an ALTERNATE_ID_TYPE of 00 00. This sentinel row allows the value set to offer a default or "not applicable" branch selection alongside the real organization unit entries. No additional base tables are documented beyond this reference to the organization alternate IDs view.

Key Columns

  • ALTERNATE_ID — Constructed by concatenating the organization alternate identifier, right-padded to twenty characters, with a single space and the alternate identifier type. The result is a display-friendly composite string used as the value list entry for the NSC branch parameter.
  • ALTERNATE_ID_TYPE — Constructed as the organization alternate identifier concatenated with a space and the alternate identifier type (ORG_ALTERNATE_ID || ' ' || ORG_ALTERNATE_ID_TYPE). This column echoes the same pairing as the display value and is the value the scanned "alternate_id_type" search term relates to.
  • ORG_ALTERNATE_ID and ORG_ALTERNATE_ID_TYPE — The underlying components sourced from IGS_OR_ORG_ALT_IDS_V; the type label distinguishes among the various identifier schemes assigned to an organization unit.
  • ORG_STRUCTURE_TYPE — Filter predicate ensuring only organization units are included, excluding other hierarchy classifications.
  • END_DATE — Date-bounded attribute used to exclude expired alternate identifiers from the returned set.

Common Use Cases and Queries

The view is consumed primarily through the concurrent process value set, so users rarely query it directly; however, administrators and technical analysts inspect it when validating NSC submissions or diagnosing missing branch options. A typical validation query lists all selectable values:

  • SELECT alternate_id, alternate_id_type FROM apps.igs_en_nsc_branch_v ORDER BY alternate_id;
  • Filtering to real organizations only: SELECT alternate_id FROM apps.igs_en_nsc_branch_v WHERE alternate_id_type <> '00 00';
  • Joining to organization data to reconcile identifiers for a specific branch before running the NSC creation process.

Because the UNION branch contributes the fixed "00 00" row, any query intended to return actual organizations must exclude it explicitly. In EBS 12.1.1 and 12.2.2, the view behaves identically and inherits security through the APPS schema and any organization security applied to IGS_OR_ORG_ALT_IDS_V.