Search Results completed_flag_source_type

Overview

The view IGSBV_ST_PR_CONCENTRATION_ATTS is a reporting and integration object belonging to the IGS — Student System product family within Oracle E-Business Suite. The ETRM metadata describes it as a view that "describes a student's attempt at a program unit set." In the terminology of the Oracle Student System (successor to the legacy Student Records model), a "concentration" is a structured grouping of unit sets — a program major, minor, or specialisation — and this view exposes the status of an individual student's attempt to satisfy the requirements of that concentration.

The product designation marks IGS as Obsolete in the 12.1.1 and 12.2.2 releases, and the ETRM implementation record explicitly states "Not implemented in this database." This is significant: although the underlying table and column definitions remain documented, the view is not created in a standard EBS installation. It survives as reference metadata only, relevant to customers who either retained custom implementations or are migrating historical student data off the former Oracle Student System. The view is read-only (the view text terminates with WITH READ ONLY), making it purely a query and extract surface.

Underlying Base Objects

The ETRM record for this view documents no referenced base objects. However, the view text itself reveals a six-table join that the metadata excerpt preserves:

• IGS_AS_SU_SETATMPT (SUSA) — the primary table, holding the student's attempt at a program unit set. All source columns except the descriptive lookups originate here.
• HZ_PARTIES (HP) — supplies the party number and party name for the student identified by PERSON_ID.
• IGS_EN_STDNT_PS_ATT_ALL (SCA) — the student program attempt, joined on person and course to anchor the attempt to a program enrolment.
• IGS_PS_VER_ALL (PSV) — the program version, providing the program title and version context.
• IGS_EN_UNIT_SET_ALL (US) — the unit set definition, joined on unit set code and version to yield the unit set title.

The joins are keyed on PERSON_ID, COURSE_CD, VERSION_NUMBER, UNIT_SET_CD, and US_VERSION_NUMBER. The reliance on the _ALL synonymed tables indicates the view was designed for installation-wide (not date-tracked) access.

Key Columns

The view exposes a wide column set of which the following are most consequential:

• PERSON_NUMBER / PERSON_NAME — party identifiers for the student.
• PROGRAM_CODE / PROGRAM_TITLE — the program against which the concentration attempt is made.
• UNIT_SET_CODE / UNIT_SET_VERSION_NUMBER / UNIT_SET_TITLE — identifies the concentration itself.
• SELECTION_DATE / END_DATE — lifecycle dates for the attempt.
• STUDENT_CONFIRMED_FLAG, PRIMARY_SET_FLAG, VOLUNTARY_END_FLAG — Yes/No indicators, each accompanied by a translated descriptor column populated via the IGS_LOOKUP_VALUES flexfield mechanism (_LA: prefixed columns).
• RQRMNTS_COMPLETE_FLAG — indicates whether the concentration requirements have been satisfied.
• RQRMNTS_COMPLETE_DATE — the date on which those requirements were completed. This is the column the user searched for; it is the authoritative completion timestamp for the concentration attempt.
• COMPLETED_FLAG_SOURCE_TYPE — records the mechanism or source by which completion was determined.
• PARENT_UNIT_SET_CODE / PARENT_SEQUENCE_NUMBER — supports hierarchical concentration structures.
• AUTHORISED_PERSON_IDENTIFIER / AUTHORISED_ON / OVERRIDE_TITLE — capture manual authorisation or override activity.

Common Use Cases and Queries

Because the view is not implemented by default, it is most often encountered in migration extracts or custom reporting schemas. A typical completion audit query follows:

SELECT PERSON_NUMBER, PERSON_NAME, PROGRAM_CODE, UNIT_SET_CODE, UNIT_SET_TITLE, RQRMNTS_COMPLETE_FLAG, RQRMNTS_COMPLETE_DATE FROM IGSBV_ST_PR_CONCENTRATION_ATTS WHERE RQRMNTS_COMPLETE_FLAG = 'Y' AND RQRMNTS_COMPLETE_DATE IS NOT NULL;

A second common scenario isolates incomplete concentrations for advising and progression review:

SELECT PERSON_NUMBER, PROGRAM_TITLE, UNIT_SET_TITLE, SELECTION_DATE FROM IGSBV_ST_PR_CONCENTRATION_ATTS WHERE RQRMNTS_COMPLETE_FLAG = 'N' AND END_DATE IS NULL;

Where custom code still references the view, queries should be validated against the underlying IGS_AS_SU_SETATMPT table directly, since the ETRM confirms the view object may not exist in the target 12.1.1 or 12.2.2 instance.