Search Results statistic_category

Overview

IGS.IGS_AD_ACT_STATISTICS is a transactional table in the Oracle E-Business Suite 12.1.1 / 12.2.2 IGS (Student Systems / Advanced Data) schema that stores ACT statistical test components alongside their statistic type and category details. It is the persistence point for standardized test scores reported against ACT assessments, capturing both the raw outcome values and the normative reference data used to interpret them, such as national and local norms, standard scores, and percentile ranks. The table resides in the APPS_TS_TX_DATA tablespace, which is consistent with its role as a transactional data store rather than a reference or setup object.

Per the heuristic Data Vault classification mined from the foreign key structure, this object is satellite-leaning. This suggests it may best be modeled as a satellite table attached to a hub or link representing the ACT test event, with its descriptive score and norm columns serving as the satellite's payload. This is a modeling suggestion, not a documented constraint, and should be validated against the actual integration design in use.

Key Information Stored

The table carries a six-column composite primary key, IGS_AD_ACT_STATISTICS_PK, defined across REPORTING_YEAR, ACT_IDENTIFIER, TEST_TYPE, TEST_DATE_TXT, STATISTIC_TYPE, and STATISTIC_CATEGORY. This unique index functions as the business-key candidate — there is no separate surrogate primary key column documented in the metadata, so the composite acts as both the unique identifier and the grain definition. The most important columns are:

• REPORTING_YEAR — the reporting year for the statistic record; part of the primary key.
• ACT_IDENTIFIER — the ACT identifier linking the record to the relevant assessment or student activity; part of the primary key.
• TEST_TYPE — the type of ACT test administered; part of the primary key.
• TEST_DATE_TXT — the test date, stored as text; part of the primary key.
• STATISTIC_TYPE — the type of statistic (length 30); part of the primary key. This is the column most closely related to the user term that would typically be filtered alongside STATISTIC_CATEGORY.
• STATISTIC_CATEGORY — the statistic category (length 30); part of the primary key and the direct match for the search term "statistic_category." This column segments statistics into reporting groupings.
• SCORE — the reported score value.
• NATIONAL_NORM — the national normative reference value.
• LOCAL_NORM — the local normative reference value.
• NUMERIC_GRADE — the numeric grade awarded.
• STANDARD_SCORE — the standardized score derived from the raw result.
• PERCENTILE_RANK — the percentile ranking of the result.
• GRADE_EARNED and GRADE_POINT_AVERAGE — the grade and GPA values associated with the test outcome.
• DESCRIPTION — free-text description of the statistic.

The table also includes the standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit traceability. All business data columns are stored as VARCHAR2, which is significant for query writing: numeric comparisons require explicit conversion.

Common Use Cases and Queries

Typical reporting scenarios include producing ACT score distributions by statistic category, comparing local norms to national norms, and extracting percentile ranks and standard scores for a given reporting year. A frequent pattern is filtering specifically on STATISTIC_CATEGORY and STATISTIC_TYPE to isolate a class of measures.

• Category-based reporting: SELECT REPORTING_YEAR, ACT_IDENTIFIER, STATISTIC_TYPE, STATISTIC_CATEGORY, SCORE, PERCENTILE_RANK FROM IGS.IGS_AD_ACT_STATISTICS WHERE STATISTIC_CATEGORY = :category;
• Year and test isolation: filtering on REPORTING_YEAR and TEST_TYPE to compare score outcomes across assessment cycles.
• Norm comparison: selecting NATIONAL_NORM, LOCAL_NORM, and STANDARD_SCORE side by side to evaluate cohort performance.
• Key lookup: querying the full composite key to retrieve a single statistic record.

Because SCORE, STANDARD_SCORE, and PERCENTILE_RANK are VARCHAR2, sort and range predicates should use TO_NUMBER where arithmetic or ordering is required. The primary key index on the composite columns supports efficient filtering when leading columns such as REPORTING_YEAR and ACT_IDENTIFIER are supplied.

Related Objects

The documented dependency information shows no inbound or outbound foreign key relationships defined at the database level, aside from the reported reference from REPORTING_YEAR to a related object. In practice, the table joins to its parent ACT assessment and student activity structures through ACT_IDENTIFIER, and to year or test setup data through REPORTING_YEAR and TEST_TYPE.

• IGS.IGS_AD_ACT_STATISTICS_PK — the unique index enforcing the composite business key.
• ACT assessment header objects in the IGS_AD_* family, joined on ACT_IDENTIFIER and TEST_TYPE.
• Student activity tables keyed by ACT_IDENTIFIER, providing the person or activity context.
• Reporting year and test type reference objects, joined on REPORTING_YEAR and TEST_TYPE.
• IGS_AD_ACT_STATISTICS dependent views and concurrent programs that consume the statistic rows for ACT reporting.

Consumers should confirm the ACT_IDENTIFIER lineage against the specific IGS release, as the ETRM metadata for this object does not enumerate all dependent foreign key targets.