Search Results igs_ad_act_statistics




Overview
Explore in AI Chat

Overview

The IGS_AD_ACT_STATISTICS table resides in the IGS schema and forms part of the Oracle E-Business Suite Student System (IGS) product family. It stores ACT statistical test components, capturing both the statistic type and the statistic category associated with each recorded test result. Within the broader IGS admissions and recruiting data model, this table serves as a reference-grade repository for externally supplied ACT assessment data, enabling institutions to evaluate applicant and student performance against national and local norms.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure suggests this object leans toward a satellite. This is a modeling suggestion rather than a prescriptive directive: the table records descriptive and measurable attributes tied to a composite business identifier, which is characteristic of satellite constructs. The table is documented as VALID in ETRM 12.1.1 with a physical column count of 22.

Key Information Stored

The primary key, IGS_AD_ACT_STATISTICS_PK, is defined across the columns REPORTING_YEAR, ACT_IDENTIFIER, TEST_TYPE, TEST_DATE_TXT, STATISTIC_TYPE, and STATISTIC_CATEGORY. This composite key also constitutes the sole documented unique index and therefore serves as the principal business-key candidate. Notably, the metadata documentation does not identify a single-column surrogate key; the uniqueness of a row is established entirely through this composite combination.

The most significant columns include:

  • REPORTING_YEAR — the academic or reporting cycle to which the statistical record belongs; part of the primary key.
  • ACT_IDENTIFIER — the identifier linking the record to a specific ACT test administration or candidate; part of the primary key.
  • TEST_TYPE and TEST_DATE_TXT — the nature and textual representation of the test date; both participate in the primary key.
  • STATISTIC_TYPE — the category of statistical measure represented (the column central to the user's search).
  • STATISTIC_CATEGORY — the grouping or classification applied to the statistic.
  • SCORE, NATIONAL_NORM, LOCAL_NORM — the raw score and the corresponding national and local norm values.
  • STANDARD_SCORE, PERCENTILE_RANK, NUMERIC_GRADE — derived standardized and comparative measures.
  • GRADE_EARNED, GRADE_POINT_AVERAGE, COURSE_STATUS — academic outcome attributes associated with the record.
  • PROBABILITY and DESCRIPTION — supplementary analytical and descriptive fields.
  • Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN track row-level change history.

Common Use Cases and Queries

Typical use cases center on admissions review, statistical reporting, and comparative performance analysis. A frequent pattern filters on statistic type and category for a given reporting year:

  • Retrieving all statistical components for a specific reporting year and ACT identifier to build an applicant performance profile.
  • Comparing national and local norms against earned scores to assess relative standing.
  • Aggregating percentile ranks or standard scores across cohorts of test takers.
  • Reconciling imported ACT data against student records by joining on ACT_IDENTIFIER.

A representative SQL pattern would select the primary key columns alongside SCORE, NATIONAL_NORM, LOCAL_NORM, STANDARD_SCORE, and PERCENTILE_RANK, filtered by REPORTING_YEAR and a specific STATISTIC_TYPE. Because STATISTIC_TYPE appears in the primary key and is indexed, it is an efficient predicate for most queries.

Related Objects

The documented foreign key relationships are limited, with the metadata indicating a reference from IGS_AD_ACT_STATISTICS.REPORTING_YEAR to a related reported table. In practice, this table operates within the IGS admissions and recruiting schema, where related objects include:

  • IGS_AD_ACT_STATISTICS_PK — the unique index enforcing composite uniqueness.
  • Applicant and admissions tables within the IGS schema joined via ACT_IDENTIFIER.
  • Reporting-year reference structures joined via REPORTING_YEAR.
  • Student term and grade entities joined via GRADE_EARNED or GRADE_POINT_AVERAGE.
  • Test component reference tables joined on TEST_TYPE and STATISTIC_TYPE.

Analysts should confirm actual constraint definitions in the target environment, as the ETRM excerpt presents a partial foreign-key listing. The table is Oracle proprietary and confidential, subject to the standard legal notices governing EBS metadata.