Results for “igs_as_assessmnt_typ”

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

Overview

IGS_AS_ASSESSMNT_TYP is a core reference table within the Oracle E-Business Suite IGS - Student System (Oracle Student System / OSS) product. As its documentation states, the object "describes possible types of assessment items." In practical terms, it functions as the master catalogue of assessment type codes that the institution uses to categorize the instruments by which student performance is evaluated — for example written examinations, continuous assessments, assignments, practicals, or project work. Because it is referenced by numerous downstream transactional tables, it acts as a controlled vocabulary that ensures assessment data across the student system is consistently and uniquely typed.

In Oracle EBS 12.1.1 and 12.2.2 the table is owned by the IGS schema and carries a VALID status in the data dictionary. The documented ETRM metadata records eleven columns and a physical primary key constraint named IGS_AS_ASSESSMNT_TYP_PK, defined on the ASSESSMENT_TYPE column. A heuristic Data Vault classification derived from the foreign-key structure tags this table as hub-leaning. In Data Vault modeling terms, this suggests treating IGS_AS_ASSESSMNT_TYP as a hub entity — a stable, business-key-driven list of assessment types — with its descriptive and flag attributes suitable for modelling as an adjacent satellite. This classification is a modelling suggestion rather than a documented Oracle construct.

Key Information Stored

The most significant columns documented for this table are:

• ASSESSMENT_TYPE — The business key and the single column comprising the primary key constraint IGS_AS_ASSESSMNT_TYP_PK and the unique index IGS_AS_ASSESSMNT_TYP_U1. It is the code that uniquely identifies each assessment type.
• S_ASSESSMENT_TYPE — A secondary type classification that forms a foreign key to IGS_AS_SASSESS_TYPE, allowing assessment types to be grouped under a broader system-level assessment category.
• DESCRIPTION — The human-readable name or explanation of the assessment type, used for display and reporting.
• EXAMINABLE_IND — An indicator flag denoting whether the assessment type is treated as examinable within grading and scheduling processes.
• CLOSED_IND — A status flag indicating whether the assessment type is closed and therefore unavailable for new assessment records.
• ANON_GRADING_IND — An indicator that flags whether the assessment type supports anonymous grading, linking conceptually to the anonymous marking tables that reference this object.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Oracle EBS WHO-column audit set that records creation and last-modification user, date, and login context for every row.

The surrogate-versus-business distinction is straightforward: the constraint IGS_AS_ASSESSMNT_TYP_PK is defined directly on the natural business key ASSESSMENT_TYPE, and the unique index IGS_AS_ASSESSMNT_TYP_U1 reinforces that same column as the business-key candidate. There is no separate meaningless surrogate column documented; the assessment type code serves both roles.

Common Use Cases and Queries

Typical usage centres on decoding and validating assessment type codes in reports and integration extracts. A foundational lookup query joining the table to its own system-level grouping is common:

• List active assessment types for a validation list or LOV:
  SELECT assessment_type, description FROM igs_as_assessmnt_typ WHERE closed_ind = 'N';
• Decode assessment types with their system category:
  SELECT a.assessment_type, a.description, s.description system_category FROM igs_as_assessmnt_typ a, igs_as_sassess_type s WHERE a.s_assessment_type = s.s_assessment_type;
• Identify anonymous-grading assessment types:
  SELECT assessment_type FROM igs_as_assessmnt_typ WHERE anon_grading_ind = 'Y';

Reporting scenarios include assessment mix analysis (what proportion of items are examinable), audit of which types are closed versus open, and integration feeds that map local assessment types to external grading or LMS systems. The table is also consulted indirectly whenever assessment records are created, to enforce valid type codes.

Related Objects

Because it is a hub-leaning reference table, IGS_AS_ASSESSMNT_TYP anchors several dependent child tables through the shared ASSESSMENT_TYPE column:

• IGS_AS_SASSESS_TYPE — Referenced by IGS_AS_ASSESSMNT_TYP via the S_ASSESSMENT_TYPE foreign key; the parent grouping of assessment types.
• IGS_AS_APPR_GRD_SCH — Approved grading scheme records, referencing IGS_AS_ASSESSMNT_TYP through ASSESSMENT_TYPE.
• IGS_AS_ANON_ID_ASS — Anonymous identification assessment records, joined on ASSESSMENT_TYPE.
• IGS_AS_ANON_METHOD — Anonymous grading method definitions, joined on ASSESSMENT_TYPE.

The consistent ASSESSMENT_TYPE join column across these objects confirms the table's role as the central reference point for assessment typing throughout the Oracle Student System.