Search Results corrected_report_ind

Overview

IGS.IGS_AD_ACT_ASSESSMENTS is a transactional table within the Oracle E-Business Suite IGS (Intelligent Grants / Student Systems) schema that stores ACT assessment details for persons, keyed by Reporting Year, Test Date, and Test Type. Its stated purpose in the ETRM dictionary is the storage of "ACT assessment details of persons with Reporting Year, Test Date and Test Type." The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes are housed in APPS_TS_TX_IDX. In Oracle EBS 12.1.1 and 12.2.2 the object is delivered as FND Design Data (IGS.IGS_AD_ACT_ASSESSMENTS) and is registered as VALID in the applications file system.

From the perspective of the heuristic Data Vault classification mined from the foreign-key structure, the table is classified as hub-leaning. This is a modeling suggestion rather than a physical constraint: the composite unique index on reporting year, ACT identifier, test type, and test date behaves like a business key for an assessment hub, while the descriptive student attributes (name, address, demographics, scores) act as satellite-style context.

Key Information Stored

The table contains 33 documented columns. The most significant are:

• REPORTING_YEAR — the cycle or academic year the assessment belongs to; part of the composite primary key.
• ACT_IDENTIFIER — the ACT record/person identifier; part of the composite primary key.
• TEST_TYPE — the type of ACT test taken; part of the composite primary key.
• TEST_DATE_TXT — the test date stored as text; part of the composite primary key.
• ACT_BATCH_ID — the assessment batch identifier and the sole column of non-unique index IGS_AD_ACT_ASSESSMENTS_N1.
• INTERFACE_TRANSFER_DATE — the date the row was transferred through the interface.
• LAST_NAME, FIRST_NAME, MIDDLE_INITIAL — student name components.
• GENDER, DATE_OF_BIRTH_TXT — demographic attributes.
• STREET_ADDRESS, CITY, STATE_CODE, STATE_ABBREVIATION, ZIP_CODE, HOME_PHONE — contact and address information.
• HIGH_SCHOOL_CODE, HIGH_SCHOOL_AVERAGE, HIGH_SCHOOL_GRADUATION, GRADE_LEVEL — high-school academic context.
• CORRECTED_REPORT_IND — the corrected report indicator, the column most frequently retrieved in searches of this object.
• SUM_OF_SCALE_SCORES — the aggregate of ACT scale scores.
• COLLEGE_CHOICE, COLLEGE_CODE, LOCAL_IDENTIFIER, RELEASE, NORMS_TYPE — college preference, institutional local ID, and test release/norms metadata.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who columns.

The surrogate-level uniqueness is enforced through IGS_AD_ACT_ASSESSMENTS_PK, which is the business-key candidate (REPORTING_YEAR, ACT_IDENTIFIER, TEST_TYPE, TEST_DATE_TXT). All four key columns are VARCHAR2, so joins on these columns must respect case and formatting conventions used by the inbound ACT interface.

Common Use Cases and Queries

Typical scenarios include identifying corrected ACT submissions, reconciling assessment batches, and producing prospect/admissions reports by test cycle. A query returning corrected rows for a given reporting year:

• SELECT ACT_IDENTIFIER, TEST_TYPE, TEST_DATE_TXT, SUM_OF_SCALE_SCORES FROM IGS.IGS_AD_ACT_ASSESSMENTS WHERE CORRECTED_REPORT_IND = 'Y' AND REPORTING_YEAR = :year;
• SELECT * FROM IGS.IGS_AD_ACT_ASSESSMENTS WHERE ACT_BATCH_ID = :batch_id; — retrieves every record loaded by a single interface batch, using IGS_AD_ACT_ASSESSMENTS_N1.
• SELECT a.ACT_IDENTIFIER, p.* FROM IGS.IGS_AD_ACT_ASSESSMENTS a JOIN IGS.IGS_AD_ACT_PROFILES p ON p.REPORTING_YEAR = a.REPORTING_YEAR; — correlates assessment rows with the profile record.

Related Objects

The referenced relationship data identifies the following dependency:

• IGS.IGS_AD_ACT_PROFILES — references this table through its REPORTING_YEAR column, joining to IGS_AD_ACT_ASSESSMENTS.REPORTING_YEAR. This is the primary downstream consumer of the assessment rows and is the principal join path for profile-based reporting.

Additional related objects include the ACT inbound interface and staging objects within the IGS schema that populate ACT_BATCH_ID and INTERFACE_TRANSFER_DATE, together with the standard concurrent programs and reports that read the table for admissions and recruitment analytics. Because the documented FK evidence is limited to the profile relationship above, integrators should confirm any further dependencies against the delivered IGS data model before building custom extracts.