Results for “grading_schema”

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

Overview

The view IGS_SS_EN_ENROLL_CART_RSLT_V, owned by the APPS schema and valid in Oracle E-Business Suite 12.1.1 and 12.2.2, is a reporting object within the IGS (Student System / Student Information System) product family. Its ETRM description is "Enrollment Worksheet Result," and it functions as the canonical result set behind the enrollment worksheet (shopping cart) used by students and administrative staff to review the units or sections they intend to enroll in before committing an enrollment.

The view flattens and decorates the enrollment cart data with derived academic attributes: title and subtitle composition, credit points, grading schema, occurrence or location descriptions, waitlist capacity, and enrollment counts. Rather than requiring a report or form to call multiple PL/SQL APIs individually, the view exposes the results of those API calls as regular columns, making it directly consumable by Oracle Reports, OAF pages, BI Publisher data models, and ad hoc SQL. This role is significant for self-service enrollment and for administrative enrollment validation, where the grading schema and credit points of each proposed section must be visible to the user before submission.

Underlying Base Objects

The view text defines a three-way outer-join dependency chain, with the driving object being IGS_SS_USEC_V, aliased as B. This virtual object supplies the unit offering option (UOO) context: unit code, calendar type, sequence number, version, section status, class, location, and enrollment limits. It is joined to two reference tables and one address table:

• IGS_PS_USEC_REF (alias C) — the unit section reference table, joined on UOO_ID with an outer join, providing SUBTITLE and SUBTITLE_MODIFIABLE_FLAG.
• IGS_PS_USEC_GRD_SCHM (alias D) — the unit section grading scheme table, joined on UOO_ID with an outer join, which underpins the grading schema resolution for each section.
• IGS_AD_LOCATION (alias E) — the address/location table supplying DESCRIPTION for the section location.

The ETRM metadata lists no separately documented referenced base objects, so the object-level lineage is established from the view text. The view also invokes several functions in the IGS_SS_ENR_DETAILS package, which are effectively dependent objects even though they are not tables: ENRP_GET_ENR_MAX_ACT, GET_TITLE_SECTION, GET_CREDIT_POINTS, GET_GRADING_SCHEMA, GET_OCCUR_DESC_DETAILS, GET_OCCUR_CD_DETAILS, GET_OCCUR_DETAILS_NO_LOCATION, ENRP_CHK_USEC_GROUP, and GET_SUP_SUB_DETAILS.

Key Columns

• UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER — identity of the unit offering option; UNIT_CODE and version identify the unit, while calendar type and sequence identify the teaching period occurrence.
• GRADING_SCHEMA — derived from IGS_SS_ENR_DETAILS.GET_GRADING_SCHEMA(NULL, UOO_ID, UNIT_CD, VERSION_NUMBER, NULL); returns the grading schema applicable to the section, matching the user's search term.
• CREDIT_POINTS — populated by GET_CREDIT_POINTS for the section, used in enrollment load calculations.
• TITLE_SUBTITLE, TITLE, SHORT_TITLE, ABBREVIATION — presentation attributes for the section, with TITLE_SUBTITLE composed by GET_TITLE_SECTION.
• UNIT_STATUS, UNIT_SECTION_STATUS, SS_DISPLAY_IND, SS_ENROL_IND, AUDITABLE_IND — status and self-service availability flags controlling whether the section can be displayed or enrolled.
• START_DATE, END_DATE, UNIT_SECTION_START_DT, UNIT_SECTION_END_DT, SEMESTER — teaching dates; SEMESTER is a concatenation of calendar type and dates, and the section start/end columns resolve differently when NON_STD_USEC_FLAG is 'Y'.
• ENROLLMENT_ACTUAL, ENROLLMENT_MINIMUM, ENROLLMENT_MAXIMUM, ENROLL_MAX_ACT — capacity and actual enrollment counts, with ENROLL_MAX_ACT derived from ENRP_GET_ENR_MAX_ACT.
• WAITLIST_MAX_ACT — formatted as maximum students per waitlist followed by the actual waitlist count in parentheses.
• OCCUR_LOCATION_DESC, OCCUR_LOCATION_CODE, OCCUR_NO_LOCATION — occurrence and location descriptions resolved by the IGS_SS_ENR_DETAILS occurrence functions.
• SUP_UOO_ID, RELATION_TYPE, USEC_PART_OF_GROUP — parent/child section relationships and grouping indicators used for linked or grouped sections.

Common Use Cases and Queries

The predominant use case is displaying the enrollment worksheet for a student or a proxy, including grading schema, credit points, and waitlist position. A typical query filters by unit and version:

• SELECT unit_cd, version_number, title, grading_schema, credit_points, unit_section_status FROM igs_ss_en_enroll_cart_rslt_v WHERE unit_cd = :unit_code AND version_number = :version;
• Reporting on sections by grading schema: SELECT grading_schema, COUNT(*) FROM igs_ss_en_enroll_cart_rslt_v GROUP BY grading_schema;
• Capacity and waitlist monitoring: SELECT unit_cd, enrollment_actual, enrollment_maximum, waitlist_max_act FROM igs_ss_en_enroll_cart_rslt_v WHERE enrollment_actual >= enrollment_maximum;
• Extracting self-service eligible and auditable sections: SELECT unit_cd, ss_enrol_ind, auditable_ind FROM igs_ss_en_enroll_cart_rslt_v WHERE ss_display_ind = 'Y';

Because the view depends on IGS_SS_ENR_DETAILS functions, query performance is affected by row-by-row PL/SQL invocation; filtering on UNIT_CD, VERSION_NUMBER, or UOO_ID before retrieval is advisable. Access should be granted through the standard APPS synonyms and responsibility-based security rather than direct grants to base objects.