Results for “igs_or_unit_acct_cd_all”

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

Overview

IGS_OR_UNIT_ACCT_CD_ALL is a table in the IGS (Student System) product schema of Oracle E-Business Suite, documented as VALID in ETRM releases 12.1.1 and 12.2.2. It stores revenue account string information for an organization unit, acting as the bridge between an academic organization unit and the receivables account string used when revenue is posted. In practice, rows in this table determine which revenue account code (REV_ACCOUNT_CD) applies to a given organization unit over a defined effective period, enabling institutions to route student-related revenue to the correct general ledger or receivables accounting flexfield.

The table is keyed by the surrogate primary key IGS_OR_UNIT_ACCT_CD_PK on ORG_ACCOUNT_CD_ID. Two unique indexes expose business-key candidates: IGS_OR_UNIT_ACCT_CD_U1 on ORG_ACCOUNT_CD_ID and IGS_OR_UNIT_ACCT_CD_U2 on (ORG_UNIT_CD, START_DT, ORG_ID). The second unique index is significant because it enforces that only one revenue account assignment exists per organization unit, per start date, per operating unit. From a Data Vault modeling perspective, the mined FK structure classifies this object as satellite-leaning, suggesting it is best treated as a descriptive satellite keyed to an organization unit or account hub rather than as an independent hub or associative link.

Key Information Stored

The documented physical schema contains 10 columns. The most significant are:

• ORG_ACCOUNT_CD_ID — Surrogate primary key and the unique identifier for each row. Also a business-key candidate via IGS_OR_UNIT_ACCT_CD_U1.
• ORG_UNIT_CD — The organization unit code to which the revenue account assignment applies. Forms part of unique index U2 with START_DT and ORG_ID.
• START_DT — The effective start date of the account assignment. Combined with ORG_UNIT_CD and ORG_ID, it enforces date-effective uniqueness.
• REV_ACCOUNT_CD — The revenue account code string. This column carries the foreign key to IGS_FI_ACC_ALL, linking the assignment to the valid account definition.
• ORG_ID — The operating unit identifier, providing multi-org partitioning and completing the U2 business key.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified each row and when.

The surrogate key ORG_ACCOUNT_CD_ID is system-generated and should not be exposed as a business identifier; integrations and reports should instead resolve the assignment using ORG_UNIT_CD plus START_DT plus ORG_ID.

Common Use Cases and Queries

The most frequent query pattern resolves the currently effective revenue account for an organization unit, respecting the effective-dating implied by START_DT:

• Revenue account lookup for a given unit and operating unit, ordered by START_DT descending to obtain the latest assignment.
• Audit of all historical account assignments for a unit to trace accounting changes over time.
• Validation that every active organization unit has a revenue account defined, by outer-joining this table to the organization unit definition.
• Reporting seeded feeds into receivables, where the REV_ACCOUNT_CD string drives the accounting flexfield concatenation.

A representative statement is: SELECT rev_account_cd FROM igs_or_unit_acct_cd_all WHERE org_unit_cd = :unit AND org_id = :org AND start_dt <= SYSDATE ORDER BY start_dt DESC. Because U2 guarantees a single row per unit/date/org combination, this pattern returns a deterministic result without further deduplication.

Related Objects

• IGS_FI_ACC_ALL — Referenced through the foreign key IGS_OR_UNIT_ACCT_CD_ALL.REV_ACCOUNT_CD to IGS_FI_ACC_ALL; the primary validation and lookup object for revenue account codes.
• IGS_OR_UNIT_ACCT_CD_PK — The primary key constraint/index on ORG_ACCOUNT_CD_ID.
• IGS_OR_UNIT_ACCT_CD_U1 and IGS_OR_UNIT_ACCT_CD_U2 — Unique indexes defining the surrogate and composite business keys respectively.
• Organization unit definition tables in the IGS schema — Joined on ORG_UNIT_CD to describe the unit to which the account applies.
• IGS receivables and accounting setup objects — Consume the resolved REV_ACCOUNT_CD when posting student revenue and generating accounting entries.

Together these objects position IGS_OR_UNIT_ACCT_CD_ALL as the effective-dated mapping layer between academic organization units and revenue account strings in the Oracle Student System.