Results for “deactivate_recruit_status”

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

Overview

IGS_AD_RECRUITMENTS is a table within the IGS — Student System product family in Oracle E-Business Suite, holding recruitment details for prospective students. In the ETRM documentation this object is flagged as obsolete and, in the supplied 12.1.1 metadata, is recorded as "Not implemented in this database." The table serves as the recruitment tracking entity for an admissions-oriented workflow, capturing a prospect's institutional preferences, academic interests, and demographic indicators that institutions use to target and evaluate applicants.

The heuristic Data Vault classification mined from the foreign key structure is link. Treated as a modeling suggestion, this implies the table behaves primarily as an associative entity: it connects a person (via PERSON_ID to HZ_PARTIES) to a set of coded institutional and interest attributes, rather than acting as a standalone hub or a fully descriptive satellite. The primary key, IGS_AD_RECRUITMENTS_PK on RECRUITMENT_ID, provides the surrogate identity; a second unique index, IGS_AD_RECRUITMENTS_U1, is also defined on RECRUITMENT_ID, reinforcing its role as the single-column access path.

Key Information Stored

The documented physical schema for 12.1.1 contains 30 columns owned by the IGS schema. The most significant columns are:

• RECRUITMENT_ID — surrogate primary key; sole member of both IGS_AD_RECRUITMENTS_PK and the unique index IGS_AD_RECRUITMENTS_U1.
• PERSON_ID — foreign key to HZ_PARTIES, identifying the recruited party/individual. This is the primary business-key candidate linking recruitment records to the person model.
• PROGRAM_INTEREST_ID, DEGREE_GOAL_ID, UNIT_SET_ID — coded references to IGS_AD_CODE_CLASSES describing academic program, degree objective, and academic unit interest.
• INSTITUTION_SIZE_ID, INSTITUTION_CONTROL_ID, INSTITUTION_SETTING_ID, INSTITUTION_LOCATION_ID — coded preference attributes describing the type and location of institutions of interest.
• SPECIAL_INTEREST_ID, SPECIAL_SERVICES_ID — coded indicators of extracurricular or service-related interests.
• HOUSING_ID, EMPLOYMENT_ID, CERTAINTY_OF_CHOICE_ID — coded attributes describing housing preference, employment interest, and the prospect's certainty of enrollment choice.
• RELIGION_ID / RELIGION_CD — religious affiliation; the FK resolves to IGS_PE_CODE_CLASSES rather than IGS_AD_CODE_CLASSES.
• PRIORITY, PROBABILITY, VIP, DEACTIVATE_RECRUIT_STATUS — recruitment scoring and lifecycle flags.
• ADV_STUDIES_CLASSES, HONORS_CLASSES, CLASS_SIZE, PERCENT_PLAN_HIGHER_EDU, SEC_SCHOOL_LOCATION_ID — academic-preparation and secondary-school attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns managed by the EBS who-column conventions.

Common Use Cases and Queries

A recurring requirement is to retrieve recruitment records for a specific individual. Because RECRUITMENT_ID is the unique access path, lookups by person typically join through HZ_PARTIES or filter on PERSON_ID:

• Prospect profile retrieval: SELECT r.recruitment_id, r.person_id, r.priority, r.probability, r.program_interest_id FROM igs_ad_recruitments r WHERE r.person_id = :person_id;
• Recruitment pipeline by priority: aggregate records by PRIORITY and PROBABILITY to score prospect likelihood and drive outreach campaigns.
• Interest analysis: join the many IGS_AD_CODE_CLASSES foreign keys to decode program, housing, and institutional preferences for recruitment funnel reporting.
• VIP and active-status filtering: restrict on VIP and DEACTIVATE_RECRUIT_STATUS to segment active, high-value prospects.
• Audit and change tracking: use LAST_UPDATE_DATE and LAST_UPDATED_BY for incremental extract patterns.

Because the object is marked obsolete and not implemented in the supplied database, these patterns should be validated against the target environment before reuse; in later releases, recruitment data may reside in successor IGS admissions structures.

Related Objects

• HZ_PARTIES — joined on IGS_AD_RECRUITMENTS.PERSON_ID = HZ_PARTIES.PARTY_ID; anchors each recruitment record to the person entity.
• IGS_AD_CODE_CLASSES — the dominant foreign key target; referenced by CERTAINTY_OF_CHOICE_ID, DEGREE_GOAL_ID, HOUSING_ID, INSTITUTION_CONTROL_ID, INSTITUTION_SETTING_ID, PROGRAM_INTEREST_ID, EMPLOYMENT_ID, INSTITUTION_LOCATION_ID, INSTITUTION_SIZE_ID, SPECIAL_SERVICES_ID, SPECIAL_INTEREST_ID, UNIT_SET_ID, and SEC_SCHOOL_LOCATION_ID.
• IGS_PE_CODE_CLASSES — referenced by RELIGION_ID, providing the coded religion lookup distinct from the admissions code classes.
• IGS_AD_RECRUITMENTS_PK / IGS_AD_RECRUITMENTS_U1 — the primary key constraint and unique index governing RECRUITMENT_ID.