Results for “segment_num”

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

Overview

IGS_PS_USEC_ACCTS_ALL is a transactional table within the Oracle E-Business Suite Student System (IGS) product family. It stores the revenue account segment values that are associated with a specific unit section offering. In EBS terminology, a "unit section" corresponds to a teachable course offering, and the account segments recorded here drive the financial accounting entries generated when students enroll and when revenue is recognized against that offering. The table is owned by the IGS schema and resides in the APPS data model that is exposed for Oracle Student System implementations on release 12.1.1 and 12.2.2.

From a dimensional modeling perspective, the documented foreign key relationship — IGS_PS_USEC_ACCTS_ALL.UOO_ID referencing IGS_PS_UNIT_OFR_OPT_ALL — suggests a satellite-leaning classification. Under a Data Vault heuristic, this table behaves as a descriptive satellite attached to the unit offering option, holding the accounting attribute payload rather than acting as an independent business hub or an associative link. This classification is a modeling suggestion only; the physical table remains an operational EBS table with standard WHO columns.

Key Information Stored

The documented physical schema for the 12.1.1 baseline contains eleven columns. The most significant are:

• USEC_ACCOUNT_ID — the surrogate primary key, enforced by the unique index IGS_PS_USEC_ACCTS_PK (and mirrored by business-key candidate IGS_PS_USEC_ACCTS_U1). It uniquely identifies each account segment row.
• UOO_ID — the foreign key to IGS_PS_UNIT_OFR_OPT_ALL, tying each accounting row to its parent unit offering option.
• SEGMENT — the identity of the accounting segment (for example, the natural account or cost center designation) being populated.
• SEGMENT_NUM — the ordinal position of the segment within the accounting flexfield structure.
• SEGMENT_VALUE — the actual value assigned to that segment for the unit section.
• ORG_ID — the operating unit context, which is essential for multi-org reporting and for correct subledger accounting.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle WHO audit columns that record row provenance and change history.

No descriptive or effective-date columns beyond the audit set are documented; the accounting detail is carried entirely through the SEGMENT / SEGMENT_VALUE pair.

Common Use Cases and Queries

The primary use case is mapping a unit offering option to the correct revenue accounting flexfield. Financial and student-system reports join this table to the parent offering to resolve which accounts receive enrollment revenue. A typical query resolves all segments for a given offering:

• SELECT uoo_id, segment, segment_num, segment_value FROM igs_ps_usec_accts_all WHERE uoo_id = :p_uoo_id ORDER BY segment_num;
• Multi-org reporting filtered by operating unit: ... WHERE org_id = :p_org_id;
• Validation queries that detect offerings lacking a complete segment set, used before period-close revenue posting.

Because each segment occupies its own row, reports frequently pivot SEGMENT into columns to reconstruct a full accounting flexfield per offering. Reconciliation between this table and the subledger accounting entries generated from student enrollment transactions is another standard investigative scenario.

Related Objects

The following objects are most significant in relation to this table:

• IGS_PS_UNIT_OFR_OPT_ALL — the parent table, joined on UOO_ID = IGS_PS_USEC_ACCTS_ALL.UOO_ID. This FK is the single documented relationship and defines the satellite-to-parent dependency.
• IGS_PS_UNIT_OFR_ALL and IGS_PS_UNIT_ALL — the broader unit offering and unit hierarchy used to report account assignments across a curriculum.
• IGS_PS_ENROL_ALL — enrollment records whose revenue recognition draws on the account segments defined here.
• IGS_PS_USEC_ACCTS_PK / IGS_PS_USEC_ACCTS_U1 — the primary and unique constraints that enforce uniqueness on USEC_ACCOUNT_ID.
• GL_CODE_COMBINATIONS — the general ledger flexfield table against which the SEGMENT_VALUE combinations are validated.

Together these objects govern how student revenue is attributed to the correct general ledger accounts within Oracle Student System.