Results for “default_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_FI_HIER_ACCOUNTS is a reference table in the IGS (Student System) schema of Oracle E-Business Suite, validated in releases 12.1.1 and 12.2.2. It stores the header records for User Defined Account Hierarchies, which are used within the Oracle Student Financial Aid and Student System financials functionality to organize general ledger account ranges into reusable, named structures. Each row in this table represents a distinct account hierarchy that can subsequently be populated with detail rows describing individual account ranges.

From a Data Vault modeling perspective, the FK/PK relationships place this table in a hub-leaning position. The primary key ACCT_HIER_ID acts as a durable surrogate identifier that is referenced by dependent detail and instance tables, making the hierarchy header a natural business hub around which account-range satellites and link tables are organized. This classification is a heuristic suggestion derived from the mined foreign-key structure rather than an enforced EBS constraint, but it aligns well with how account hierarchy data is typically modeled.

Key Information Stored

The documented physical schema includes eleven columns, of which the following are the most significant:

• ACCT_HIER_ID — Surrogate primary key (IGS_FI_HIER_ACCOUNTS_PK) uniquely identifying each account hierarchy definition. Also carries unique index IGS_FI_HIER_ACCOUNTS_U1.
• NAME — The user-defined name of the hierarchy. This is a business-key candidate backed by unique index IGS_FI_HIER_ACCOUNTS_U2.
• DESCRIPTION — Free-text description clarifying the purpose or scope of the hierarchy.
• DEFAULT_FLAG — Indicates whether the hierarchy is the default used when no explicit hierarchy is supplied by downstream processes.
• ZERO_FILL_FLAG — Controls whether accounts without balances are included (zero-filled) when the hierarchy is expanded for reporting or ledger processing.
• CLOSED_IND — Marks the hierarchy as closed, preventing further assignment or use.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns providing audit and concurrency tracking.

Common Use Cases and Queries

Typical uses include listing available hierarchies for setup verification, resolving the default hierarchy for a given process, and joining header data to detail records to expand account ranges. A simple lookup example:

• SELECT acct_hier_id, name, description, default_flag FROM igs_fi_hier_accounts WHERE closed_ind = 'N';
• Identifying the active default: SELECT acct_hier_id, name FROM igs_fi_hier_accounts WHERE default_flag = 'Y' AND closed_ind = 'N';
• Joining headers to their accounts: SELECT h.name, t.* FROM igs_fi_hier_accounts h, igs_fi_hier_acct_tbl t WHERE h.acct_hier_id = t.acct_hier_id;
• Locating hierarchies assigned to fee types via IGS_FI_F_TYP_CA_INST_ALL.ACCT_HIER_ID.

Related Objects

• IGS_FI_HIER_ACCT_TBL — Holds the account-range detail lines; joined on ACCT_HIER_ID.
• IGS_FI_F_TYP_CA_INST_ALL — References ACCT_HIER_ID, associating hierarchies with fee-type calendar instances.
• IGS_FI_HIER_ACCOUNTS_PK / _U1 / _U2 — Primary and unique indexes enforcing identity and business uniqueness on ACCT_HIER_ID and NAME.