Search Results igs_ad_act_prfl_pk

Overview

The IGS_AD_ACT_PROFILES table resides in the IGS schema and forms part of the Oracle EBS Student System (IGS) product family. It stores ACT profile components, associating each component with a profile type and its corresponding category details. ACT (American College Testing) assessment data is central to admissions processing within the Student System, and this table captures the finer-grained profile breakdowns that accompany an ACT test record — for example, subscores, interest inventory categories, and other derived profile dimensions returned by ACT score reporting.

Under the heuristic Data Vault classification mined from the foreign-key structure, this table is satellite-leaning. In Data Vault modeling terms, a satellite captures descriptive attributes that change over time and hang off a hub or link. Here, the profile components are descriptive qualifiers attached to the parent ACT assessment record, which behaves as the hub/link anchor. Modelers designing a warehouse layer should therefore treat IGS_AD_ACT_PROFILES as a dependent satellite keyed to the ACT assessment identity, not as an independent business entity.

Key Information Stored

The table contains 40 documented columns at the ETRM 12.1.1 level. The most significant are the following:

• REPORTING_YEAR — the reporting cycle for the ACT test administration; part of the primary key and the foreign key to IGS_AD_ACT_ASSESSMENTS.
• ACT_IDENTIFIER — the unique ACT record identifier for the student/test event; part of the primary key and foreign key.
• TEST_TYPE — the type of ACT test administered; part of the primary key and foreign key.
• TEST_DATE_TXT — the test date expressed as text; part of the primary key and foreign key.
• PROFILE_TYPE — classifies the nature of the profile component (e.g., interest inventory, educational profile).
• PROFILE_CATEGORY — the category within that profile type.
• CODE1 through CODE21 — a repeating set of generic code columns holding profile component values.
• EDUC_MAJOR — the intended or reported educational major associated with the profile.
• VOC_CHOICE1, VOC_CHOICE2 — vocational choice responses captured in the profile.
• CHOICE1 through CHOICE5 — ranked or listed choice responses forming part of the profile record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

The surrogate primary key is the unique index IGS_AD_ACT_PRFL_PK, which spans REPORTING_YEAR, ACT_IDENTIFIER, TEST_TYPE, TEST_DATE_TXT, PROFILE_TYPE, PROFILE_CATEGORY. Because this index is the sole documented unique index, it also serves as the business-key candidate: those six columns together uniquely identify a profile component row.

Common Use Cases and Queries

Admissions and student-records reporting frequently need to retrieve ACT profile components alongside their parent assessment. A typical join pattern is:

• Joining to the parent assessment on the full composite key (REPORTING_YEAR, ACT_IDENTIFIER, TEST_TYPE, TEST_DATE_TXT) to obtain complete ACT score context for a student.
• Filtering by PROFILE_TYPE and PROFILE_CATEGORY to isolate particular profile dimensions, such as interest inventory categories, for placement or advising reports.
• Aggregating EDUC_MAJOR, VOC_CHOICE1/2, and the CHOICE1–5 columns to analyze declared majors and preferences across a reporting year.
• Extracting CODE1–CODE21 values for downstream analytics, since these generic slots hold the profile component particulars returned by the ACT feed.
• Auditing record lineage using CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE to reconcile inbound ACT data loads.

Related Objects

The documented foreign-key relationship ties this table to IGS_AD_ACT_ASSESSMENTS on the composite columns REPORTING_YEAR, ACT_IDENTIFIER, TEST_TYPE, TEST_DATE_TXT. The parent assessment table is the primary anchor, holding the overall ACT test record. Because the table is satellite-leaning, the principal related object is this parent assessment; other Student System objects that consume ACT data — such as admissions application and prospect records keyed by student or ACT identifier — may reference the same parent assessment rather than this table directly. Analysts should always join through IGS_AD_ACT_ASSESSMENTS to reach student-level context, as no direct student foreign key is documented on IGS_AD_ACT_PROFILES itself.