Search Results igsfv_ad_act_assessments

Overview

IGSFV_AD_ACT_ASSESSMENTS is a read-only Oracle EBS view owned by the APPS schema within the IGS (Student System) product family. It exposes ACT assessment records for persons known to the institution, combining externally received ACT test data with the person identification held in the EBS person layer. The view presents a single row per ACT assessment, carrying the reporting year, test date, test type, ACT identifier, and a broad set of demographic, high school, and scoring attributes. Its principal role is to support reporting and downstream processing of ACT admissions test data, including matching incoming ACT records to EBS persons and reviewing batch-level activity. Because it is defined WITH READ ONLY, it is intended purely for querying, not for transactional maintenance.

Underlying Base Objects

The view is defined over two base objects. The driving table is IGS_AD_ACT_ASSESSMENTS (aliased ACTAS), which stores the ACT assessment detail itself, including the ACT identifier, reporting year, batch identifier, test type, test date text, and the transmitted demographic and score fields. The second object is IGS_PE_ALT_PERS_ID (aliased PEA), the alternate person identifier table, which supplies the link between the ACT identifier and the EBS PERSON_ID. The join is an outer join (PEA.PERSON_ID_TYPE(+) = 'ACTID'), meaning assessments are returned even when no matching ACTID alternate identifier exists. The join predicate applies DECODE to strip a leading hyphen from the ACT identifier before comparison against PEA.API_PERSON_ID, so identifiers stored with a leading '-' still resolve correctly. Note that no base objects are documented for this view in the 12.2.2 ETRM metadata; the underlying objects above reflect the view's own SQL text.

Key Columns

• PERSON_IDENTIFIER — the EBS PERSON_ID resolved through the ACTID alternate identifier; null when no match exists.
• ACT_BATCH_ID — the batch identifier under which the ACT assessment was loaded; central to batch reconciliation and audit of inbound ACT transmissions.
• ACT_IDENTIFIER — the external ACT identifier for the person, used as the natural key for matching.
• REPORTING_YEAR and TEST_DATE_TXT — the reporting year and the test date as received (text format).
• TEST_TYPE — classification of the ACT test administered.
• INTERFACE_TRANSFER_DATE — timestamp of the interface transfer for the record.
• Demographic and contact columns — LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, GENDER, DATE_OF_BIRTH_TXT, address fields, and HOME_PHONE.
• Academic and scoring columns — GRADE_LEVEL, HIGH_SCHOOL_CODE, HIGH_SCHOOL_AVERAGE, HIGH_SCHOOL_GRADUATION, SUM_OF_SCALE_SCORES, COLLEGE_CHOICE, COLLEGE_CODE, LOCAL_IDENTIFIER, RELEASE, NORMS_TYPE, and CORRECTED_REPORT_INDICATOR.

Common Use Cases and Queries

Typical uses include reconciling ACT import batches, identifying unmatched ACT records, and reporting on ACT assessment populations. The ACT_BATCH_ID search is addressed directly by filtering, grouping, or counting on that column.

• List all assessments for a specific batch:
  SELECT act_identifier, last_name, first_name, test_type, test_date_txt FROM igsfv_ad_act_assessments WHERE act_batch_id = :batch_id;
• Summarize record counts per batch:
  SELECT act_batch_id, COUNT(*) rec_count FROM igsfv_ad_act_assessments GROUP BY act_batch_id ORDER BY act_batch_id;
• Find ACT records not yet matched to an EBS person:
  SELECT act_identifier, reporting_year, test_type FROM igsfv_ad_act_assessments WHERE person_identifier IS NULL;

As a read-only view with no documented base metadata in the ETRM 12.2.2 reference, its structure should be validated against the current instance before reliance in custom reporting, and queries should be restricted by reporting year or batch where possible to keep result sets manageable.