Search Results igs_or_org_note_type_u1

Overview

IGS.IGS_OR_ORG_NOTE_TYPE is a seed-data reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 IGS product schema. It stores user-defined structures or classifications for descriptive information note types that are available to organizational structure entities, specifically institutions, organizational units, and locations. In practical terms, the table acts as a controlled vocabulary that governs which kinds of free-text notes may be attached to records in the organizational hierarchy, and for which entity category each note type is valid.

The object resides in the APPS_TS_SEED tablespace, which is consistent with setup and reference data rather than transactional volume. It carries a VALID status and an FND Design Data registration of IGS.IGS_OR_ORG_NOTE_TYPE, indicating it is a registered, maintainable EBS object. The documented physical schema exposes ten columns, with ORG_NOTES_TYPE as the primary key (IGS_OR_ORG_NOTE_TYPES_PK). Based on the foreign key topology — where IGS_OR_ORG_NOTES references this table twice via ORG_NOTE_TYPE — the heuristic Data Vault classification is hub-leaning. In Data Vault modeling terms, this table can be treated as a hub for note type business keys, with dependent descriptive attributes (including the INST, UNIT, and LOCATION applicability flags) modeled as satellite attributes around that hub.

Key Information Stored

The table holds a compact set of ten documented columns. The most important are:

• ORG_NOTES_TYPE (VARCHAR2, 10, mandatory) — A note type identifier for an organization, institution, or location. This is the business-key candidate and primary key, uniquely enforced by the IGS_OR_ORG_NOTE_TYPE_U1 unique index in APPS_TS_SEED.
• NOTE_TYPE_DESCRIPTION (VARCHAR2, 60) — The human-readable description of the note type; this is the label presented to users.
• INST_FLAG (VARCHAR2) — Indicates whether the note type applies to institutions.
• UNIT_FLAG (VARCHAR2) — Indicates whether the note type applies to organizational units.
• LOCATION_FLAG (VARCHAR2) — Indicates whether the note type applies to locations.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS Who columns recording audit and concurrency information for each row.

Because the uniqueness constraint is defined solely on ORG_NOTES_TYPE, that column is the definitive surrogate/business key. The three flag columns, rather than serving as keys, function as applicability discriminators that determine where each note type may legitimately be used across the organization model.

Common Use Cases and Queries

The principal use case is validating or populating the note type that appears on organizational notes. Because IGS_OR_ORG_NOTES.ORG_NOTE_TYPE is a foreign key to this table, any reporting or data load touching organizational, institutional, or location notes should join back here for the descriptive label and applicability. Typical retrieval patterns include:

• Listing all defined note types with their descriptions for a setup review.
• Filtering note types available for a given entity category, for example locations only:

SELECT ORG_NOTES_TYPE, NOTE_TYPE_DESCRIPTION FROM IGS.IGS_OR_ORG_NOTE_TYPE WHERE LOCATION_FLAG IS NOT NULL;

• Resolving note descriptions for a note report by joining on the business key:

SELECT n.ORG_NOTE_TYPE, t.NOTE_TYPE_DESCRIPTION FROM IGS.IGS_OR_ORG_NOTES n JOIN IGS.IGS_OR_ORG_NOTE_TYPE t ON t.ORG_NOTES_TYPE = n.ORG_NOTE_TYPE;

• Auditing seed data currency by inspecting LAST_UPDATE_DATE and LAST_UPDATED_BY to identify recently maintained note types.

Related Objects

The documented dependency data shows a single primary reference relationship, though it appears twice in the metadata:

• IGS.IGS_OR_ORG_NOTES — The principal dependent table. Its ORG_NOTE_TYPE column references ORG_NOTES_TYPE in this table, making it the transactional counterpart where actual note content is stored against institution, organizational unit, and location records.
• IGS_OR_ORG_NOTE_TYPES_PK — The primary key constraint enforcing uniqueness of ORG_NOTES_TYPE.
• IGS_OR_ORG_NOTE_TYPE_U1 — The unique normal index on ORG_NOTES_TYPE in APPS_TS_SEED, and the object matching the user's search term.

The metadata records no outgoing dependencies from IGS_OR_ORG_NOTE_TYPE; it references no other database objects, positioning it as a leaf-level seed table that is consumed by the organizational notes entity rather than by the broader hierarchy itself.