Results for “s_assessment_type”

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

Overview

IGS_AS_SASSESS_TYPE is a system-owned reference table within the Oracle E-Business Suite Student System (IGS) product group. It describes system-defined assessment types — the seeded, delivered categories of assessment used across the institution's academic assessment processing. The table serves as a controlled vocabulary that downstream transactional tables reference, ensuring assessment records are classified consistently throughout the Student System.

In Oracle EBS 12.1.1 and 12.2.2, the table resides in the IGS schema and is validated. The ETRM documentation shows a small footprint of nine documented columns, with the primary key IGS_AS_SASSESS_TYPE_PK on S_ASSESSMENT_TYPE. A unique index, IGS_AS_SASSESS_TYPE_U1, exists on the same column, making S_ASSESSMENT_TYPE the business-key candidate as well as the primary key. Because the table carries descriptive attributes and depends on IGS_AD_LOCATION_ALL via NON_CNTRL_EXAM_LOC_CD, a heuristic Data Vault classification suggests a satellite-leaning profile: it holds descriptive context (such as the non-controlled exam location and closed flag) rather than acting as a pure hub or link. This classification is a modeling suggestion, not an enforced structure.

Key Information Stored

The documented columns define the essential content of each assessment type record:

• S_ASSESSMENT_TYPE — The primary key and unique business identifier for a system-defined assessment type. This is the value other tables join on.
• DESCRIPTION — The human-readable name or explanation of the assessment type.
• CLOSED_IND — Indicator of whether the assessment type is closed and therefore unavailable for new assessment records.
• NON_CNTRL_EXAM_LOC_CD — Foreign key to IGS_AD_LOCATION_ALL, specifying the location used for non-controlled examinations associated with this assessment type.
• CREATED_BY, CREATION_DATE — Standard audit columns capturing who created the record and when.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns tracking the most recent modification and the login session that performed it.

The surrogate primary key is not a generated numeric identifier here; instead, S_ASSESSMENT_TYPE is both the PK and the unique-indexed business key. The remaining columns provide descriptive and audit context around that identifier.

Common Use Cases and Queries

Reporting and validation queries typically resolve the assessment type code into its description, or filter active assessment types by the closed indicator:

• Listing available assessment types: SELECT s_assessment_type, description FROM igs_as_sassess_type WHERE NVL(closed_ind,'N') = 'N';
• Joining transactional assessment records to their type description using S_ASSESSMENT_TYPE as the join column.
• Resolving the non-controlled exam location by joining NON_CNTRL_EXAM_LOC_CD to IGS_AD_LOCATION_ALL.
• Auditing recently changed setup: SELECT s_assessment_type, last_updated_by, last_update_date FROM igs_as_sassess_type ORDER BY last_update_date DESC;

Because this is a seeded reference table, administrators generally query it rather than maintain it, and any configuration changes should be coordinated with the Student System implementation team.

Related Objects

The FK metadata identifies the following significant relationships:

• IGS_AD_LOCATION_ALL — Referenced via IGS_AS_SASSESS_TYPE.NON_CNTRL_EXAM_LOC_CD, providing the location used for non-controlled examinations.
• IGS_AS_ASSESSMNT_TYP — References this table through S_ASSESSMENT_TYPE, making it the primary dependent transactional object that consumes the assessment type definition.

These two relationships define the table's role: it is a parent reference for assessment-type usage and a child of the location reference data.