eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSBV_STDNT_RECRUITMENT

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ADR.RECRUITMENT_ID
, ADR.PERSON_ID
, ADR.SPECIAL_INTEREST_ID
, ADR.PRIORITY
, ADR.PROBABILITY
, '_LA:ADR.VIP:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:ADR.DEACTIVATE_RECRUIT_STATUS:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ADR.PROGRAM_INTEREST_ID
, ADR.INSTITUTION_SIZE_ID
, ADR.INSTITUTION_CONTROL_ID
, ADR.INSTITUTION_SETTING_ID
, ADR.INSTITUTION_LOCATION_ID
, ADR.SPECIAL_SERVICES_ID
, ADR.EMPLOYMENT_ID
, ADR.HOUSING_ID
, ADR.DEGREE_GOAL_ID
, ADR.UNIT_SET_ID
, ADR.CERTAINTY_OF_CHOICE_ID
, ADR.RELIGION_ID
, ADR.ADV_STUDIES_CLASSES
, ADR.HONORS_CLASSES
, ADR.CLASS_SIZE
, ADR.SEC_SCHOOL_LOCATION_ID
, ADR.PERCENT_PLAN_HIGHER_EDU
, ADR.RELIGION_CD
, ADR.CREATED_BY
, ADR.CREATION_DATE
, ADR.LAST_UPDATED_BY
, ADR.LAST_UPDATE_DATE
FROM IGS_AD_RECRUITMENTS ADR WITH READ ONLY

Columns

Name
RECRUITMENT_ID
PERSON_ID
SPECIAL_INTEREST_ID
PRIORITY
PROBABILITY
"_LA:VIP_IND"
"_LA:DEACTIVTE_RECRT_STAT_IND"
PROGRAM_INTEREST_ID
INSTITUTION_SIZE_ID
INSTITUTION_CONTROL_ID
INSTITUTION_SETTING_ID
INSTITUTION_LOCATION_ID
SPECIAL_SERVICES_ID
EMPLOYMENT_ID
HOUSING_ID
DEGREE_GOAL_ID
UNIT_SET_ID
CERTAINTY_OF_CHOICE_ID
RELIGION_ID
ADV_STUDIES_CLASSES
HONORS_CLASSES
CLASS_SIZE
SEC_SCHOOL_LOCATION_ID
PERCENT_PLAN_HIGHER_EDU
RELIGION_CD
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE