Results for “selfrep_weighted_rank”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_AD_ACADHIS_INT_ALL is a Student System (IGS) interface table that holds information about a person's academic history. It is owned by the IGS schema and resides in the core Student System product family shipped with Oracle E-Business Suite 12.1.1 and 12.2.2. The table belongs to the academic-history interface family (the "_INT_ALL" suffix), which follows the standard Oracle interface-table convention: records are staged, validated, matched, and then either applied to, or rejected from, the corresponding production entities. Within that pipeline, IGS_AD_ACADHIS_INT_ALL is the staging area for external academic history data such as prior institutions attended, programmes attempted and earned, self-reported grade point averages, class rank, and credit totals, all of which are later reflected in the person's education record and student academic history.
The physical schema documented in ETRM for 12.1.1 contains 64 columns, with a primary key constraint IGS_AD_ACADHIS_INT_PK on INTERFACE_ACADHIS_ID and a unique index IGS_AD_ACADHIS_INT_ALL_U1 on INTERFACE_ACADHIS_ID. Based on the foreign-key structure that has been mined from the schema, a Data Vault modelling heuristic would classify this object as satellite-leaning: its grain is the individual interface academic-history record (keyed by INTERFACE_ACADHIS_ID), with descriptive attributes and a foreign key to HZ_EDUCATION carrying the reference relationship to the TCA education entity.
Key Information Stored
The most significant columns fall into four groups:
- Identity and run control: INTERFACE_ACADHIS_ID (surrogate primary key and unique business key of the interface row), INTERFACE_ID, INTERFACE_RUN_ID, REQUEST_ID, ORG_ID, and PERSON_ID, which tie the staged row back to a specific interface run, operating unit, and person.
- Institution and programme detail: INSTITUTION_CODE, TYPE_OF_SCHOOL, CURRENT_INST, PROGRAM_CODE, PROGRAM_TYPE_ATTEMPTED, PROGRAM_TYPE_EARNED, DEGREE_ATTEMPTED, DEGREE_EARNED, START_DATE, END_DATE, and PLANNED_COMPLETION_DATE.
- Self-reported academic performance: SELFREP_TOTAL_CP_ATTEMPTED, SELFREP_TOTAL_CP_EARNED, SELFREP_TOTAL_GP_UNITS_ATTEMP, SELFREP_INST_GPA, SELFREP_WEIGHTED_GPA, SELFREP_RANK_IN_CLASS, SELFREP_WEIGHTED_RANK, SELFREP_GRADING_SCALE_ID, and CLASS_SIZE.
- Processing and audit: STATUS, MATCH_IND, ERROR_CODE, ERROR_TEXT, DUP_ACAD_HISTORY_ID, EDUCATION_ID (foreign key to HZ_EDUCATION), UPDATE_EDUCATION_ID, TRANSCRIPT_REQUIRED, and the standard audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, plus the 20 generic ATTRIBUTE columns.
Per the documented schema, the sole business-key candidate is the unique index on INTERFACE_ACADHIS_ID; the foreign key to HZ_EDUCATION is carried on EDUCATION_ID.
Common Use Cases and Queries
Typical usage centres on loading external academic history, monitoring validation outcomes, and reconciling staged data before or after the import into the student record. Common patterns include:
- Monitoring interface errors and status:
SELECT INTERFACE_ACADHIS_ID, PERSON_ID, STATUS, ERROR_CODE, ERROR_TEXT FROM IGS.IGS_AD_ACADHIS_INT_ALL WHERE INTERFACE_RUN_ID = :run_id AND STATUS = 'E'; - Reporting self-reported performance for review: aggregating SELFREP_INST_GPA, SELFREP_WEIGHTED_GPA, and SELFREP_RANK_IN_CLASS grouped by INSTITUTION_CODE or PROGRAM_CODE.
- Checking duplicates before applying records, using DUP_ACAD_HISTORY_ID or MATCH_IND, and joining EDUCATION_ID to HZ_EDUCATION to confirm the matched education record.
- Auditing a specific load via REQUEST_ID or INTERFACE_RUN_ID to trace which batch introduced each academic history row.
Related Objects
The following objects are the most significant in the documented relationship data:
- HZ_EDUCATION — referenced through IGS_AD_ACADHIS_INT_ALL.EDUCATION_ID; the TCA education entity that the staged academic history is matched to or applied against.
- IGS_AD_TXCPT_INT — references this table through INTERFACE_ACADHIS_ID; holds transcript exception interface records tied to the same academic-history interface row.
- IGS_AD_ACADHIS_INT_PK and IGS_AD_ACADHIS_INT_ALL_U1 — the primary key constraint and unique index defining row identity and uniqueness.
- IGS_AD_ACADHIS_ALL (and its related academic-history production entities) — the destination structures populated when a staged row is successfully applied.
- HZ_PERSON / PERSON_ID-based person views — used to resolve PERSON_ID to the individual whose prior academic history is being imported.
Together these confirm the table's role as a staging satellite within the IGS academic-history interface, anchored on the person and education hub records and consumed by the transcript exception interface.
-
Holds information about person's academic history
-
View: IGS_AD_ACADHIS_INT 12.1.1
APPS.IGS_AD_ACADHIS_INT·↳ IGS_AD_ACADHIS_INT_ALL·Explore IGS module →
-
View: IGS_AD_ACADHIS_INT 12.2.2
Not implemented in this database·Explore IGS module →
-
Import Error Code
-
Import Error Code
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.