Results for “igs_as_untas_pattern_pk”
5 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGS_AS_UNTAS_PATTERN table is an entity within the Oracle E-Business Suite Student System module (IGS), which is classified as Obsolete in the ETRM data model. It describes the assessment patterns that make up the assessment requirement for a unit. In practical terms, the table records the individual pattern components — for example, continuous assessment, examination, or practical weighting components — that collectively define how a student's performance in a given unit is evaluated during a specific calendar period.
The ETRM metadata is explicit that this object is not implemented in the current database, which is consistent with its obsolete status. Consequently, it should be treated as a legacy or reference artifact rather than an active transactional object in Oracle EBS 12.1.1 or 12.2.2. Organizations planning migrations or data conversions from older Student System releases may still encounter it, and the ETRM relationship data classifies it heuristically as a satellite-leaning entity — that is, a descriptive table whose rows carry attributes about a parent assessment requirement rather than serving as a pure hub or link.
Key Information Stored
The table's composite primary key, IGS_AS_UNTAS_PATTERN_PK, is formed from five columns, each of which represents a business-key candidate rather than a single surrogate identifier:
- UNIT_CD — the unit (course) code identifying the academic unit to which the assessment pattern belongs.
- VERSION_NUMBER — the version of the unit record, enabling multiple historical versions of the same unit to coexist.
- CAL_TYPE — the calendar type (for example, academic year or teaching period) under which the pattern applies.
- CI_SEQUENCE_NUMBER — a sequence number associated with the calendar instance, ordering patterns within a period.
- ASS_PATTERN_ID — the identifier of the assessment pattern itself, linking each row to the specific pattern definition.
In addition, the table carries a foreign key column, UNIT_MODE, which references the row's parent or related record via the table's own FK definition. Because the composite key collectively enforces uniqueness, any query or ETL process must treat all five columns as the identifying set rather than relying on a single column such as ASS_PATTERN_ID alone.
Common Use Cases and Queries
Although obsolete, the table is relevant for historical reporting, data migration, and reconciliation exercises. A typical query retrieves the assessment patterns for a particular unit and version:
- SELECT ASS_PATTERN_ID, UNIT_MODE FROM IGS_AS_UNTAS_PATTERN WHERE UNIT_CD = :unit_cd AND VERSION_NUMBER = :version AND CAL_TYPE = :cal_type ORDER BY CI_SEQUENCE_NUMBER;
- Reconciliation queries that compare the set of patterns returned here against the corresponding assessment requirement records to verify completeness of migrated data.
- Audit extracts listing all patterns by calendar period to support historical assessment-weighting analysis.
Because the table is documented as not implemented, the first practical step in any 12.1.1 or 12.2.2 engagement is to confirm its presence via a data dictionary query on ALL_TABLES before authoring SQL against it.
Related Objects
The principal documented relationship is the foreign key from IGS_AS_UNTAS_PATTERN.UNIT_MODE into its referenced table, as captured in the ETRM FK mapping. Surrounding objects in the Student System assessment area typically include the parent unit-of-study and assessment-requirement tables keyed on UNIT_CD and VERSION_NUMBER, the calendar/teaching-period definitions keyed on CAL_TYPE, the assessment pattern definition table keyed on ASS_PATTERN_ID, and the calendar instance structure implied by CI_SEQUENCE_NUMBER. Migration and reporting logic should therefore join primarily on UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, and ASS_PATTERN_ID to reconstruct the full assessment requirement context.
-
Table: IGS_AS_UNTAS_PATTERN 12.1.1
This entity describes the assessment patterns which make up the assessment requirement for a unit.
Not implemented in this database·Explore IGS module →
-
Table: IGS_AS_UNTAS_PATTERN 12.2.2
This entity describes the assessment patterns which make up the assessment requirement for a unit.
Not implemented in this database·Explore IGS module →
-
- Obsolete
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.