Search Results institution_location_id




Overview
Explore in AI Chat

Overview

IGS.IGS_AD_RECRUITMENTS is a transactional table in the Oracle EBS Student Systems (IGS) product family that stores recruitment detail records for prospective students tracked through the admissions recruiting process. Each row captures a single recruitment record for a person of interest, expressed through a rich set of attribute codes describing the prospect's academic intent, institution preferences, background characteristics, and enrollment probability. In Oracle EBS 12.1.1 and 12.2.2, the table is owned by the IGS schema, is registered in FND Design Data as IGS.IGS_AD_RECRUITMENTS, and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. All supporting indexes are held in APPS_TS_TX_IDX.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as a link. This is a suggested classification: the table connects a party (person) to a large set of coded reference attributes—institution setting, control, location, size, degree goal, program interest, housing, employment, and religion—each modeled as a foreign-key relationship rather than a self-contained descriptive entity. In 12.1.1 the documented physical schema consists of 30 columns.

Key Information Stored

The surrogate primary key is RECRUITMENT_ID (NUMBER(15)), enforced by the unique index IGS_AD_RECRUITMENTS_PK (documented as NONUNIQUE in the ETRM index extract, though it functions as the primary key constraint). It is the unique identifier of the recruitment detail record and the principal join key to dependent objects.

The most significant columns are:

The remaining coded columns (CERTAINTY_OF_CHOICE_ID, UNIT_SET_ID, SEC_SCHOOL_LOCATION_ID, ADV_STUDIES_CLASSES, HONORS_CLASSES, CLASS_SIZE, PERCENT_PLAN_HIGHER_EDU) are also foreign keys or descriptive flags, but are secondary to the attributes above.

Common Use Cases and Queries

Recruitment reporting is the dominant use case. A frequent pattern joins recruits to person data and decodes institution-setting codes:

  • Prospect roster by institution setting: SELECT r.RECRUITMENT_ID, r.PERSON_ID, r.PROBABILITY, r.PRIORITY FROM IGS.IGS_AD_RECRUITMENTS r WHERE r.INSTITUTION_SETTING_ID = :setting_id.
  • VIP/high-probability pipeline: filter on VIP and PROBABILITY to prioritize outreach.
  • Active recruiting counts: exclude records where DEACTIVATE_RECRUIT_STATUS indicates a closed recruit.
  • Code resolution: join INSTITUTION_SETTING_ID, DEGREE_GOAL_ID, and PROGRAM_INTEREST_ID to IGS.IGS_AD_CODE_CLASSES to translate identifiers into display meaning.
  • Trend and funnel analysis: aggregate by PRIORITY or DEGREE_GOAL_ID across terms.

Related Objects

  • HZ_PARTIES — joined via PERSON_ID to obtain prospect identity and contact details.
  • IGS_AD_CODE_CLASSES — the shared lookup table behind CERTAINTY_OF_CHOICE_ID, DEGREE_GOAL_ID, HOUSING_ID, INSTITUTION_CONTROL_ID, INSTITUTION_SETTING_ID, INSTITUTION_LOCATION_ID, INSTITUTION_SIZE_ID, PROGRAM_INTEREST_ID, SPECIAL_INTEREST_ID, SPECIAL_SERVICES_ID, EMPLOYMENT_ID, UNIT_SET_ID, and SEC_SCHOOL_LOCATION_ID.
  • IGS_PE_CODE_CLASSES — provides religious-affiliation decoding for RELIGION_ID.
  • IGS_AD_RECRUITMENTS_PK — the primary key index on RECRUITMENT_ID that anchors dependent child tables.
  • IGS_AD_RECRUITMENTS_N13 — the PERSON_ID index supporting person-centric lookups across admissions objects.

Together these relationships position IGS_AD_RECRUITMENTS as the central recruiting link between prospective persons and the coded attribute universe of the IGS admissions domain.