Results for “igs_pe_dynamic_persid”

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

Overview

IGS_PE_DYNAMIC_PERSID is a table residing in the IGS (Student System) schema within Oracle E-Business Suite Release 12.1.1 and 12.2.2. The ETRM repository lists the object with a status of VALID but explicitly annotates the description as Obsolete, indicating that the object is retained for backward compatibility and historical data retention rather than active functional use. The table forms part of the legacy dynamic personalization framework of the Oracle Student System, providing the persisted definition of dynamically generated person identifiers that were resolved from user-defined SQL statements.

The primary key of the table is IGS_PE_DYNAMIC_PERSID_PK, defined on the GROUP_ID column. A foreign key relationship is documented from IGS_PE_DYNAMIC_SQL.GROUP_ID to this table, establishing that the table holds the master grouping definition that individual dynamic SQL records reference. Under the heuristic Data Vault classification mined from the foreign key topology, the object exhibits hub-leaning characteristics: GROUP_ID functions as a durable, non-descriptive business key around which dependent records cluster. This classification is offered as a modeling suggestion only, since the physical implementation is a conventional relational table rather than a Data Vault construct.

Key Information Stored

The documented physical schema comprises 29 columns. The most significant are summarized below.

• GROUP_ID — Surrogate primary key and the sole column of IGS_PE_DYNAMIC_PERSID_PK; the anchor referenced by dependent dynamic SQL rows.
• GROUP_CD — Business-key candidate holding the user-assigned code that identifies the personalization group.
• WORKBOOK_NAME — Name of the workbook associated with the dynamic personal identifier definition.
• WORKSHEET_NAME — Name of the worksheet within the workbook from which the identifier set is derived.
• DESCRIPTION — Free-text description of the group's purpose.
• CREATOR_PERSON_ID — Identifier of the person credited with creating the definition.
• CLOSED_IND — Flag indicating whether the group has been closed to further use.
• COMMENTS — Supplementary notes maintained by the defining user.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — The standard Oracle EBS descriptive flexfield columns, providing extensible storage for customer-specific attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record provenance and last modification.

Only GROUP_ID is documented as a unique index member; GROUP_CD is the natural business-key candidate, though no unique constraint on it is recorded in the ETRM metadata.

Common Use Cases and Queries

Because the object is marked obsolete, reporting use is predominantly historical and diagnostic. Typical patterns include enumerating group definitions, tracing dependent SQL records, and auditing unused personalization artifacts prior to decommissioning.

A representative query joining the parent and child tables:

• SELECT p.GROUP_ID, p.GROUP_CD, p.WORKBOOK_NAME, p.WORKSHEET_NAME, s.* FROM IGS_PE_DYNAMIC_SQL s JOIN IGS_PE_DYNAMIC_PERSID p ON s.GROUP_ID = p.GROUP_ID;
• Filtering to active definitions: WHERE p.CLOSED_IND = 'N'
• Auditing stale rows: WHERE p.LAST_UPDATE_DATE < ADD_MONTHS(SYSDATE, -24)
• Listing flexfield usage: selecting ATTRIBUTE_CATEGORY with any populated ATTRIBUTE1–ATTRIBUTE15 columns.

Related Objects

• IGS_PE_DYNAMIC_SQL — Child table joined on GROUP_ID; holds the SQL statements executed to resolve dynamic person identifiers.
• IGS_PE_DYNAMIC_PERSID_PK — The primary key constraint/index enforcing uniqueness of GROUP_ID.
• PER_ALL_PEOPLE_F — Referenced indirectly through CREATOR_PERSON_ID to resolve the creating person.
• FND_DESCR_FLEX_COLUMN_USAGES — Documents the ATTRIBUTE_CATEGORY and descriptive flexfield segment usage on this table.
• FND_TABLES / FND_COLUMNS — Oracle Applications Object Library registration for the IGS_PE_DYNAMIC_PERSID object.
• IGS_PE_* personalization objects — Sibling IGS Student System entities sharing the workbook/worksheet naming convention.