Results for “igs_ps_usec_as_u1”

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

Overview

IGS.IGS_PS_USEC_AS is a transactional table in the Oracle E-Business Suite Student System (IGS) schema. Its name derives from "PS Unit Section Assessment," and its documented purpose is to capture the relationship between unit sections and the assessments conducted within them. In practical terms, the table stores examination scheduling and venue data for assessments tied to specific unit offerings, making it a supporting data object for the academic scheduling and assessment management functions of Oracle Student Systems.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, placing it among the transactional data objects rather than reference or setup data. The documented Data Vault classification, derived heuristically from its foreign key structure, suggests this object behaves as a link table. This modeling suggestion is consistent with its position between unit section offerings and assessment records, where the table resolves the relationship between two entities while carrying descriptive attributes (dates, times, and location details) that describe the assessment event itself.

Key Information Stored

The table contains thirteen documented columns. The central identifiers and attributes are:

• UNIT_SECTION_ASSESSMENT_ID — A NUMBER column serving as the surrogate primary key (IGS_PS_USEC_AS_PK) and the unique identifier for the relation between unit sections and assessments.
• UOO_ID — The unit section identifier, which is the foreign key linking to IGS_PS_UNIT_OFR_OPT_ALL.
• FINAL_EXAM_DATE — The date on which the final examination is scheduled.
• EXAM_START_TIME and EXAM_END_TIME — The start and end times of the examination.
• LOCATION_CD — A VARCHAR2(10) unique identifier for the location at which the assessment is held.
• BUILDING_CODE and ROOM_CODE — Numeric codes identifying the building and room for the examination venue.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Who columns that record audit and concurrency information.

Two unique indexes serve as business-key candidates. IGS_PS_USEC_AS_U1 enforces uniqueness on UNIT_SECTION_ASSESSMENT_ID, confirming the primary key. IGS_PS_USEC_AS_U2 enforces uniqueness across the composite of UOO_ID, FINAL_EXAM_DATE, LOCATION_CD, BUILDING_CODE, and ROOM_CODE, which together identify a scheduled examination event and prevent duplicate venue bookings for the same unit section, date, and location.

Common Use Cases and Queries

Typical reporting scenarios include generating examination timetables, auditing venue utilization, and reconciling assessment schedules against unit section offerings. A basic extraction follows the documented query text:

• SELECT UNIT_SECTION_ASSESSMENT_ID, UOO_ID, FINAL_EXAM_DATE, EXAM_START_TIME, EXAM_END_TIME, LOCATION_CD, BUILDING_CODE, ROOM_CODE FROM IGS.IGS_PS_USEC_AS;
• To retrieve assessments for a particular unit section: WHERE UOO_ID = :p_uooid.
• To build an exam-day schedule: WHERE FINAL_EXAM_DATE = :p_date ORDER BY EXAM_START_TIME.
• To report room demand: group by BUILDING_CODE and ROOM_CODE with COUNT on assessments per date.
• To detect schedule conflicts, join on UOO_ID and compare overlapping EXAM_START_TIME and EXAM_END_TIME windows.

The composite unique index U2 should be consulted when validating that no two assessments for the same unit offering, date, and venue are recorded.

Related Objects

The documented dependencies identify the principal relationships for this object:

• IGS.IGS_PS_UNIT_OFR_OPT_ALL — Referenced through the UOO_ID foreign key, providing the unit section offering context for each assessment.
• IGS_PS_USEC_AS (APPS synonym) — The APPS-layer synonym or view through which application code and reports access the table.
• IGS_PS_USEC_AS_U1 — The unique index on UNIT_SECTION_ASSESSMENT_ID supporting primary key lookups.
• IGS_PS_USEC_AS_U2 — The composite unique index supporting business-key validation and venue conflict checks.

No other database objects are documented as referencing this table, and the table itself references only IGS_PS_UNIT_OFR_OPT_ALL. These relationships confirm that IGS_PS_USEC_AS functions as a dependent link between unit section offerings and scheduled assessments.