Results for “code_id”

35 results




Overview
Explore in AI Chat

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

Overview

IGS_AD_RECRUITMENT_V is a reporting view belonging to the IGS (Student System) product family within Oracle E-Business Suite. In the ETRM documentation provided, the object is classified under the IGS - Student System (Obsolete) module, indicating that it is a legacy construct that may no longer be shipped or supported in current 12.1.1 / 12.2.2 installations. The view presents recruitment prospect data, exposing an admissions recruitment record alongside a large set of decoded descriptive attributes. Its primary role is to denormalize the recruitment table so that reporting tools, concurrent programs, and integration interfaces can retrieve a recruitment row together with human-readable descriptions of the various lookup codes without having to perform the joins themselves.

The documentation excerpt explicitly notes "Not implemented in this database" for the referenced implementation. This means that on the instance from which ETRM was harvested, the view either does not exist or is invalid. The view text nevertheless documents the intended projection, which is useful for understanding the historical Student System data model even where the object is unavailable.

Underlying Base Objects

The documented "Referenced base objects" list is empty, but the embedded view text reveals the actual definition. The primary driver table is the recruitment table, aliased R, which supplies ROWID, PERSON_ID, RECRUITMENT_ID, and the full set of recruitment attribute columns. Each descriptive column is resolved through joins to lookup or code tables. Based on the aliases CC1 through CC14 and the presence of both NAME/DESCRIPTION pairs (for code categories) and MEANING (for a flexfield lookup), the following base objects are implied:

The presence of the INSTITUTION_SETTING_ID column, which the user searched for, confirms that institution setting is one of the decoded recruitment attributes.

Key Columns

Identity columns anchor the record: ROW_ID (the recruitment row's ROWID), PERSON_ID, and RECRUITMENT_ID. Demographic and preference columns include SPECIAL_INTEREST/SPECIAL_INTEREST_DESC, RELIGION/RELIGION_DESC, PROGRAM_INTEREST/PROGRAM_INTEREST_DESC, PRIORITY, PROBABILITY, and VIP. Institutional fit columns cover INSTITUTION_SIZE, INSTITUTION_CONTROL, INSTITUTION_SETTING, and INSTITUTION_LOCATION, each paired with a code, name, and description. Service and life-situation columns include SPECIAL_SERVICES, EMPLOYMENT, and HOUSING. Academic-interest columns include DEGREE_GOAL, UNIT_SET, CERTAINTY_OF_CHOICE, ADV_STUDIES_CLASSES, HONORS_CLASSES, CLASS_SIZE, SEC_SCHOOL_LOCATION, and PERCENT_PLAN_HIGHER_EDU. Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and the corresponding update attributes complete the projection.

Common Use Cases and Queries

Typical usage involves prospect analytics, funnel reporting, and feed extraction to downstream CRM or marketing systems. A recruitment pipeline report groups by priority and probability; an institutional preference report profiles prospects by sector attributes such as institution setting and control. A representative query is:

  • SELECT RECRUITMENT_ID, PERSON_ID, INSTITUTION_SETTING, INSTITUTION_SETTING_DESC, PROBABILITY FROM IGS_AD_RECRUITMENT_V WHERE VIP = 'Y';
  • SELECT INSTITUTION_SIZE, INSTITUTION_SETTING, COUNT(*) FROM IGS_AD_RECRUITMENT_V GROUP BY INSTITUTION_SIZE, INSTITUTION_SETTING;

Because the object is documented as obsolete and not implemented, verify its existence in ALL_VIEWS before use, and consider the current Student System replacement objects for new development.