Results for “educ_major”

3 results




Overview
Explore in AI Chat

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

Overview

The view APPS.IGSFV_AD_ACT_PROFILES_SPS is a reporting and integration object within the Oracle E-Business Suite IGS – Student System product. It presents ACT profile components and category details filtered to a single profile type, SPSQ (SPS Questionnaire). The view is registered in the ETRM repository with a VALID status under the APPS schema, which indicates that it is a supported, deployable object for the 12.1.1 and 12.2.2 releases.

Functionally, the view consolidates admissions test profile data captured for applicants and students whose records fall into the SPS Questionnaire category. It joins the profile component table to an alternate person identifier table so that the ACT identifier can be resolved to an internal person identifier. This makes the view suitable for downstream reporting, extracts, and integration interfaces that require person-centric admissions test data without needing to re-implement the profile type filtering or the identifier resolution logic. The WITH READ ONLY clause guarantees that the view cannot be used for DML, reinforcing its role as a query-only reporting surface.

Underlying Base Objects

The view is defined over two base tables in the APPS schema:

  • IGS_AD_ACT_PROFILES (alias ACTPR) – the driving table holding ACT profile component records, including reporting year, ACT identifier, test type, test date, profile category, code columns, educational major, and vocational choices.
  • IGS_PE_ALT_PERS_ID (alias PEA) – the alternate person identifier table, outer-joined to resolve the ACT identifier to a person identifier.

The join is expressed as an outer join ((+) syntax) in the WHERE clause, with the condition DECODE(SUBSTR(ACTPR.ACT_IDENTIFIER,1,1),'-',SUBSTR(ACTPR.ACT_IDENTIFIER,2),ACTPR.ACT_IDENTIFIER) = PEA.API_PERSON_ID (+) and PEA.PERSON_ID_TYPE(+) = 'ACTID'. This DECODE logic strips a leading hyphen from the ACT identifier before matching, accommodating identifier formats that include a leading dash. The filter ACTPR.PROFILE_TYPE = 'SPSQ' restricts the result set to the SPS Questionnaire profile type only, which is the defining characteristic of this view relative to other ACT profile views.

Key Columns

  • PERSON_IDENTIFIER – the resolved internal person identifier derived from IGS_PE_ALT_PERS_ID; may be null where no ACTID mapping exists.
  • REPORTING_YEAR – the academic/reporting year associated with the profile record.
  • ACT_IDENTIFIER – the external ACT identifier for the profile record.
  • TEST_TYPE and TEST_DATE_TXT – the type of test and its textual date representation.
  • PROFILE_CATEGORY_CODE – the stored category code, accompanied by two hidden _LA: columns that resolve to lookup meanings and descriptions from IGS_LOOKUP_VALUES using the ACT_PROFILE_CATEGORY lookup type.
  • CODE1 – CODE21 – component-specific code values captured on the ACT profile record.
  • EDUC_MAJOR, VOC_CHOICE1, VOC_CHOICE2 – educational major and vocational choice fields; VOC_CHOICE2 is the column associated with the user search term and stores the second vocational preference.
  • CHOICE1 – CHOICE5 – the sequence of choice selections recorded on the profile.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE – standard Oracle EBS audit columns.

Common Use Cases and Queries

The view is typically queried to extract SPS Questionnaire ACT profile data for a cohort of persons, often filtered by reporting year or person identifier. A representative query follows:

  • SELECT person_identifier, act_identifier, reporting_year, test_type, voc_choice2, educ_major FROM igsfv_ad_act_profiles_sps WHERE reporting_year = '2014';
  • SELECT * FROM igsfv_ad_act_profiles_sps WHERE person_identifier = :person_id;
  • Joining to a person table (IGS_PE_PERSONS or PER_ALL_PEOPLE_F) on PERSON_IDENTIFIER to enrich the extract with demographic attributes.

Because the view is READ ONLY and already encapsulates the profile type filter and identifier resolution, it is the preferred access path for reporting on SPS Questionnaire profiles rather than querying IGS_AD_ACT_PROFILES directly. Note that the _LA: columns are localization/translation helper columns generated by the IGS framework and should generally be ignored or handled explicitly in custom extracts.