Results for “ass_id”

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

Overview

IGS_AS_UNT_PATRN_ITM is a table in the IGS (Student System) product family of Oracle E-Business Suite. In the ETRM 12.1.1 and 12.2.2 documentation, the object is classified as Obsolete and is explicitly marked "Not implemented in this database." It therefore carries no runtime functionality in a standard EBS 12.1.1 or 12.2.2 installation and should be treated as a legacy or reserved schema object rather than an active transactional or setup table.

From a modeling perspective, the Data Vault classification supplied by the metadata is link. This heuristic classification is a modeling suggestion only: the table's composite primary key is composed entirely of foreign key components and an attribute (APPORTIONMENT_PERCENTAGE), which is characteristic of an associative or intersection/link structure resolving relationships between the unit assessment item and assessment pattern entities. Because the object is documented as obsolete, the classification serves primarily as a guide to the original design intent rather than to any operative data model.

Key Information Stored

The table's documented physical schema identifies 17 columns, with the primary key and unique index both defined on the same seven-column set. The most significant columns are:

• UNIT_CD — Unit (course/subject) code, part of the primary key and the business-key candidate, and the lead column of the composite foreign key to IGS_AS_UNITASS_ITEM_ALL.
• VERSION_NUMBER — Version of the unit, part of the primary key.
• CAL_TYPE — Calendar type (for example, academic or teaching calendar), part of the primary key.
• CI_SEQUENCE_NUMBER — Sequence number within the calendar instance, part of the primary key and the join to the unit assessment item.
• ASS_PATTERN_ID — Identifier of the assessment pattern, part of the primary key and the linking attribute in the FK relationships.
• ASS_ID — Assessment identifier, part of the primary key and the join to IGS_AS_UNITASS_ITEM_ALL.
• UAI_SEQUENCE_NUMBER — Sequence number of the unit assessment item, part of the primary key and the terminal column of the FK to IGS_AS_UNITASS_ITEM_ALL.
• APPORTIONMENT_PERCENTAGE — The weighting or percentage attributed to the item within the pattern; this is the principal non-key payload attribute.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard WHO audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program and program-update tracking columns.

The surrogate-style identity of the row is the seven-column combination enforced by IGS_AS_UNT_PATRN_ITM_PK; the unique index IGS_AS_UNT_PATRN_ITM_U1 uses the identical column list, so there is no separate surrogate key distinguished from the business key in the documented metadata. No single-column system-generated surrogate is documented.

Common Use Cases and Queries

Because the object is not implemented in the reference database, there are no supported application use cases. Any historical or migration-oriented reporting would be defensive in nature. A typical existence and structure check is:

• Verify presence: SELECT COUNT(*) FROM IGS.IGS_AS_UNT_PATRN_ITM; — expected to fail with ORA-00942 in a standard EBS 12.1.1/12.2.2 instance.
• Confirm columns from the dictionary: SELECT COLUMN_NAME, DATA_TYPE, NULLABLE FROM ALL_TAB_COLUMNS WHERE OWNER='IGS' AND TABLE_NAME='IGS_AS_UNT_PATRN_ITM' ORDER BY COLUMN_ID;
• Inspect constraints: SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE, COLUMN_NAME FROM ALL_CONS_COLUMNS WHERE OWNER='IGS' AND TABLE_NAME='IGS_AS_UNT_PATRN_ITM';

Were the table populated, the natural reporting pattern would join it to IGS_AS_UNITASS_ITEM_ALL on the six shared FK columns (UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, ASS_ID, UAI_SEQUENCE_NUMBER) to aggregate APPORTIONMENT_PERCENTAGE per unit assessment pattern, and to validate that apportionment percentages sum to 100 within an ASS_PATTERN_ID grouping. Such queries are illustrative only and are not valid against a standard installation.

Related Objects

The documented foreign key metadata connects this table to the unit assessment item entity, and the apportionment/pattern semantics imply further associations:

• IGS_AS_UNITASS_ITEM_ALL — Referenced via the composite FK on UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, ASS_ID, and UAI_SEQUENCE_NUMBER; the principal parent entity for this link.
• IGS_AS_UNT_PATRN_ITM (self-referencing relationship) — The metadata records a second FK association on UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, and ASS_PATTERN_ID, indicating a hierarchical or grouping relationship among pattern items.
• IGS_AS_UNITASS_ITEM — The base (non-_ALL) unit assessment item entity that commonly underlies the _ALL view/table in the IGS assessment schema.
• Assessment pattern entities — The ASS_PATTERN_ID column implies reference to an assessment pattern definition object within the IGS assessment (AS) module, which governs how items are grouped and weighted.
• IGS_AS_* assessment tables and associated IGS APIs/views — Broader IGS assessment module objects that would normally consume apportionment data for unit assessment calculations.

Overall, IGS_AS_UNT_PATRN_ITM is documented as an obsolete, non-implemented IGS assessment link table. Its schema remains useful as a reference for understanding the original unit-assessment-pattern data model, but it has no operational role in Oracle EBS 12.1.1 or 12.2.2.