Results for “igs_ad_test_segments”

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

Overview

IGS_AD_TEST_SEGMENTS is a core reference table within the Oracle EBS Student System (IGS) product family, specifically belonging to the Admissions (AD) sub-module. It holds the definition of test segments — the individual scored components that make up an admission test, such as the verbal, quantitative, or analytical sections of a standardized examination. Rather than storing a candidate's actual result, this table stores the master configuration for each segment: its name, applicable test type, scoring thresholds, and the statistical indicators that downstream processing must apply. Every captured test result and every admissions decision that depends on test performance ultimately resolves back to a row in this table via TEST_SEGMENT_ID.

The table is owned by the IGS schema and is marked VALID in the documented 12.1.1 environment, carrying 23 columns. The primary key is IGS_AD_TEST_SEGMENTS_PK, defined on the single column TEST_SEGMENT_ID. From a Data Vault modeling perspective, the mined FK structure suggests a hub-leaning classification: IGS_AD_TEST_SEGMENTS acts as a business entity whose surrogate key is widely referenced by dependent and transactional tables, without itself being a pure transactional satellite. This is consistent with its role as a controlled reference entity that anchors test scoring across the Student System.

Key Information Stored

• TEST_SEGMENT_ID — the surrogate primary key (IGS_AD_TEST_SEGMENTS_PK). It is the join column used by every dependent table and is the strongest single-column key candidate.
• ADMISSION_TEST_TYPE — associates the segment with the overarching admission test type, forming the natural business grouping of segments.
• TEST_SEGMENT_NAME and DESCRIPTION — the human-readable identity of the segment; TEST_SEGMENT_NAME is the most likely business-key candidate alongside ADMISSION_TEST_TYPE.
• SEGMENT_TYPE and SEGMENT_GROUP — classify and cluster segments for reporting and processing logic.
• MIN_SCORE and MAX_SCORE — the valid scoring range for the segment.
• INCLUDE_IN_COMP_SCORE — controls whether the segment contributes to a composite score.
• SCORE_IND, PERCENTILE_IND, NATIONAL_PERCENTILE_IND, STATE_PERCENTILE_IND, PERCENTILE_YEAR_RANK_IND — indicator flags governing which score and percentile representations are produced for the segment.
• SCORE_BAND_UPPER_IND, SCORE_BAND_LOWER_IND — flags for upper and lower score-band reporting.
• IRREGULARITY_CODE_IND — indicates whether irregularity codes apply to the segment.
• CLOSED_IND — marks the segment as inactive for new use.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns.

Common Use Cases and Queries

The table is queried whenever test results must be interpreted, validated against score ranges, or aggregated into composite scores. Typical patterns include resolving segment names for result reporting, filtering active segments for data entry LOVs, and validating captured scores against MIN_SCORE and MAX_SCORE.

• Retrieving active segments for a test type: SELECT test_segment_id, test_segment_name FROM igs_ad_test_segments WHERE admission_test_type = :type AND closed_ind = 'N';
• Joining results to definitions: SELECT s.test_segment_name, r.score FROM igs_ad_tst_rslt_dtls r, igs_ad_test_segments s WHERE r.test_segment_id = s.test_segment_id;
• Identifying composite-score contributors: filtering on include_in_comp_score = 'Y'.
• Reporting which percentile and score-band indicators are enabled per segment.
• Data extraction and integration feed validation using IGS_AD_TEST_SEGS_INT.

Related Objects

• IGS_AD_TST_RSLT_DTLS.TEST_SEGMENT_ID — admission test result details referencing the segment definition.
• IGS_SS_TST_RSLT_DTLS.TEST_SEGMENT_ID — Student System test result details.
• IGS_SS_INQ_TESTSEG.TEST_SEGMENT_ID — inquiry/test-segment association.
• IGS_AD_UP_HEADER.TEST_SEGMENT_ID and IGS_AD_TSTDTL_UH_INT.TEST_SEGMENT_ID — upload header and interface detail references for test data loads.
• IGS_AD_TEST_SEGS_INT.TEST_SEGMENT_ID — the interface table used for inbound segment data.
• IGS_AV_STND_UNIT_LVL_ALL.TEST_SEGMENT_ID and IGS_AV_STND_UNIT_ALL.TEST_SEGMENT_ID — standing unit associations.
• IGR_IS_TESTSEG.TEST_SEGMENT_ID — institutional research test-segment reference.