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: IGSFV_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
, P.PARTY_NUMBER
, PP.PERSON_NAME
, ADR.SPECIAL_INTEREST_ID
, CC1.NAME
, CC1.DESCRIPTION
, 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
, CC2.NAME
, CC2.DESCRIPTION
, ADR.INSTITUTION_SIZE_ID
, CC3.NAME
, CC3.DESCRIPTION
, ADR.INSTITUTION_CONTROL_ID
, CC4.NAME
, CC4.DESCRIPTION
, ADR.INSTITUTION_SETTING_ID
, CC5.NAME
, CC5.DESCRIPTION
, ADR.INSTITUTION_LOCATION_ID
, CC6.NAME
, CC6.DESCRIPTION
, ADR.SPECIAL_SERVICES_ID
, CC7.NAME
, CC7.DESCRIPTION
, ADR.EMPLOYMENT_ID
, CC8.NAME
, CC8.DESCRIPTION
, ADR.HOUSING_ID
, CC9.NAME
, CC9.DESCRIPTION
, ADR.DEGREE_GOAL_ID
, CC10.NAME
, CC10.DESCRIPTION
, ADR.UNIT_SET_ID
, CC11.NAME
, CC11.DESCRIPTION
, ADR.CERTAINTY_OF_CHOICE_ID
, CC12.NAME
, CC12.DESCRIPTION
, ADR.RELIGION_ID
, CC13.NAME
, CC13.DESCRIPTION
, 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
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, IGS_AD_CODE_CLASSES CC3
, IGS_AD_CODE_CLASSES CC4
, IGS_AD_CODE_CLASSES CC5
, IGS_AD_CODE_CLASSES CC6
, IGS_AD_CODE_CLASSES CC7
, IGS_AD_CODE_CLASSES CC8
, IGS_AD_CODE_CLASSES CC9
, IGS_AD_CODE_CLASSES CC10
, IGS_AD_CODE_CLASSES CC11
, IGS_AD_CODE_CLASSES CC12
, IGS_AD_CODE_CLASSES CC13
WHERE CC1.CODE_ID(+) = ADR.SPECIAL_INTEREST_ID
AND CC2.CODE_ID(+) = ADR.PROGRAM_INTEREST_ID
AND CC3.CODE_ID(+) = ADR.INSTITUTION_SIZE_ID
AND CC4.CODE_ID(+) = ADR.INSTITUTION_CONTROL_ID
AND CC5.CODE_ID(+) = ADR.INSTITUTION_SETTING_ID
AND CC6.CODE_ID(+) = ADR.INSTITUTION_LOCATION_ID
AND CC7.CODE_ID(+) = ADR.SPECIAL_SERVICES_ID
AND CC8.CODE_ID(+) = ADR.EMPLOYMENT_ID
AND CC9.CODE_ID(+) = ADR.HOUSING_ID
AND CC10.CODE_ID(+) = ADR.DEGREE_GOAL_ID
AND CC11.CODE_ID(+) = ADR.UNIT_SET_ID
AND CC12.CODE_ID(+) = ADR.CERTAINTY_OF_CHOICE_ID
AND CC13.CODE_ID(+) = ADR.RELIGION_ID
AND ADR.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE) WITH READ ONLY

Columns

Name
RECRUITMENT_ID
PERSON_ID
PERSON_NUMBER
PERSON_NAME
SPECIAL_INTEREST_ID
SPECIAL_INTEREST_NAME
SPECIAL_INTEREST_DESC
PRIORITY
PROBABILITY
"_LA:VIP_IND"
"_LA:DEACTIVTE_RECRT_STAT_IND"
PROGRAM_INTEREST_ID
PROGRAM_INTEREST_NAME
PROGRAM_INTEREST_DESC
INSTITUTION_SIZE_ID
INSTITUTION_SIZE_NAME
INSTITUTION_SIZE_DESC
INSTITUTION_CONTROL_ID
INSTITUTION_CONTROL_NAME
INSTITUTION_CONTROL_DESC
INSTITUTION_SETTING_ID
INSTITUTION_SETTING_NAME
INSTITUTION_SETTING_DESC
INSTITUTION_LOCATION_ID
INSTITUTION_LOCATION_NAME
INSTITUTION_LOCATION_DESC
SPECIAL_SERVICES_ID
SPECIAL_SERVICES_NAME
SPECIAL_SERVICES_DESC
EMPLOYMENT_ID
EMPLOYMENT_NAME
EMPLOYMENT_DESC
HOUSING_ID
HOUSING_NAME
HOUSING_DESC
DEGREE_GOAL_ID
DEGREE_GOAL_NAME
DEGREE_GOAL_DESC
UNIT_SET_ID
UNIT_SET_NAME
UNIT_SET_DESC
CERTAINTY_OF_CHOICE_ID
CERTAINTY_OF_CHOICE_NAME
CERTAINTY_OF_CHOICE_DESC
RELIGION_ID
RELIGION_NAME
RELIGION_DESC
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