Search Results penalty_applied_flag




Overview
Explore in AI Chat

Overview

IGS_AS_ASSITEM_ADI_V is a reporting and integration view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product. Its documented description is "Assessment Item WebADI View," indicating that it exists primarily to support the WebADI (Web Applications Desktop Integrator) mechanism for uploading and validating assessment item data into the student system. WebADI views in ETRM typically expose a flattened, human-readable projection of the underlying normalized tables so that spreadsheet-based data entry can be mapped to the correct columns without requiring users to navigate complex relational structures.

The view joins student assessment data with party (person) information, unit offering options, assessment definitions, and unit version details, producing one row per assessment outcome per student per unit attempt. Because it is a view rather than a table, it carries no storage of its own; it is a query layer over several base objects in the IGS and HZ schemas. Within Oracle EBS 12.1.1 and 12.2.2, views of this type are commonly used for both inbound WebADI uploads and outbound reporting extracts against assessment, marking, and penalty data.

The search term "penalty_applied_flag" corresponds directly to the PENALTY_APPLIED_FLAG column exposed by this view, which is sourced from the IGS_AS_SU_ATMPT_ITM table. Users searching this flag are typically investigating whether a late-submission or other penalty has been applied to a specific assessment outcome.

Underlying Base Objects

The view is defined over the following documented base objects:

The view also references IGS_AS_UNITASS_ITEM_ALL, IGS_PS_UNITASS_ITEM, and the package function IGS_AS_ANON_GRD_PKG.CHK_ANON_GRADED, plus the lookup function IGS_GE_GEN_004.GENP_GET_LOOKUP, to derive REFERENCE, DUE_DT, anonymised grading status, and comment text. The join is driven by PERSON_ID and UNIT_CD across the party, attempt, and unit version records.

Key Columns

The principal columns exposed by the view include:

  • PENALTY_APPLIED_FLAG — indicates whether a penalty has been applied to the assessment outcome.
  • PARTY_NAME, PARTY_NUMBER, PERSON_ID — identify the student.
  • MARK, GRADE, OUTCOME_DT, GRADING_SCHEMA_CD, GS_VERSION_NUMBER — describe the assessment result.
  • ASSESSMENT_ID, ASSESSMENT_TYPE, REFERENCE, DUE_DT, OVERRIDE_DUE_DT, SUBMITTED_DATE — describe the assessment item and submission timing.
  • WAIVED_FLAG — indicates whether the assessment requirement was waived.
  • COURSE_CD, UNIT_CD, TITLE, CAL_TYPE, CI_SEQUENCE_NUMBER, UNIT_CLASS, LOCATION_CD, UOO_ID — provide academic context.
  • CHK_ANON_GRADED, ANONYMOUS_ID — support anonymised grading workflows.
  • COMMENTS — decoded lookup text for the outcome comment code.

Common Use Cases and Queries

A frequent requirement is to list assessment outcomes where a penalty has been recorded, for example to reconcile marking or to audit late submissions.

SELECT PERSON_ID, UNIT_CD, ASSESSMENT_ID, MARK, GRADE, PENALTY_APPLIED_FLAG
FROM   APPS.IGS_AS_ASSITEM_ADI_V
WHERE  PENALTY_APPLIED_FLAG = 'Y';

Another common scenario is a WebADI extract for a specific unit and calendar type, filtering only submissions with recorded penalty or waiver activity.

SELECT PARTY_NUMBER, PARTY_NAME, UNIT_CD, ASSESSMENT_ID,
       SUBMITTED_DATE, DUE_DT, WAIVED_FLAG, PENALTY_APPLIED_FLAG
FROM   APPS.IGS_AS_ASSITEM_ADI_V
WHERE  UNIT_CD = :unit_cd
AND    CAL_TYPE = :cal_type;

The view can also be used to review outstanding or overridden due dates alongside penalty status, supporting student enquiry and results processing. Because the view performs functional lookups and nested subqueries, queries should be constrained by UNIT_CD, CAL_TYPE, or PERSON_ID where possible to avoid full scans during reporting.