[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT R.ROWID ROW_ID
, R.PERSON_ID PERSON_ID
, R.RECRUITMENT_ID RECRUITMENT_ID
, R.SPECIAL_INTEREST_ID SPECIAL_INTEREST_ID
, CC1.NAME SPECIAL_INTEREST
, CC1.DESCRIPTION SPECIAL_INTEREST_DESC
, R.PRIORITY PRIORITY
, R.PROBABILITY PROBABILITY
, R.VIP VIP
, R.DEACTIVATE_RECRUIT_STATUS DEACTIVATE_RECRUIT_STATUS
, R.RELIGION_CD RELIGION
, CC2.MEANING RELIGION_DESC
, R.PROGRAM_INTEREST_ID PROGRAM_INTEREST_ID
, CC3.NAME PROGRAM_INTEREST
, CC3.DESCRIPTION PROGRAM_INTEREST_DESC
, R.INSTITUTION_SIZE_ID INSTITUTION_SIZE_ID
, CC4.NAME INSTITUTION_SIZE
, CC4.DESCRIPTION INSTITUTION_SIZE_DESC
, R.INSTITUTION_CONTROL_ID INSTITUTION_CONTROL_ID
, CC5.NAME INSTITUTION_CONTROL
, CC5. DESCRIPTION INSTITUTION_CONTROL_DESC
, R.INSTITUTION_SETTING_ID INSTITUTION_SETTING_ID
, CC6.NAME INSTITUTION_SETTING
, CC6. DESCRIPTION INSTITUTION_SETTING_DESC
, R.INSTITUTION_LOCATION_ID INSTITUTION_LOCATION_ID
, CC7.NAME INSTITUTION_LOCATION
, CC7.DESCRIPTION INSTITUTION_LOCATION_DESC
, R.SPECIAL_SERVICES_ID SPECIAL_SERVICES_ID
, CC8.NAME SPECIAL_SERVICES
, CC8.DESCRIPTION SPECIAL_SERVICES_DESC
, R.EMPLOYMENT_ID EMPLOYMENT_ID
, CC9.NAME EMPLOYMENT
, CC9.DESCRIPTION EMPLOYMENT_DESC
, R.HOUSING_ID HOUSING_ID
, CC10.NAME HOUSING
, CC10.DESCRIPTION HOUSING_DESC
, R.DEGREE_GOAL_ID DEGREE_GOAL_ID
, CC11.NAME DEGREE_GOAL
, CC11.DESCRIPTION DEGREE_GOAL_DESC
, R.UNIT_SET_ID UNIT_SET_ID
, CC12.NAME UNIT_SET
, CC12.DESCRIPTION UNIT_SET_DESC
, R.CERTAINTY_OF_CHOICE_ID CERTAINTY_OF_CHOICE_ID
, CC13.NAME CERTAINTY_OF_CHOICE
, CC13.DESCRIPTION CERTAINTY_OF_CHOICE_DESC
, R.ADV_STUDIES_CLASSES ADV_STUDIES_CLASSES
, R.HONORS_CLASSES HONORS_CLASSES
, R.CLASS_SIZE CLASS_SIZE
, R.SEC_SCHOOL_LOCATION_ID SEC_SCHOOL_LOCATION_ID
, CC14.NAME SEC_SCHOOL_LOCATION
, CC14.DESCRIPTION SEC_SCHOOL_LOCATION_DESC
, R.PERCENT_PLAN_HIGHER_EDU PERCENT_PLAN_HIGHER_EDU
, R.CREATED_BY CREATED_BY
, R.CREATION_DATE CREATION_DATE
, R.LAST_UPDATED_BY LAST_UPDATED_BY
, R.LAST_UPDATE_DATE LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_RECRUITMENTS R
, IGS_AD_CODE_CLASSES CC1
, IGS_LOOKUP_VALUES 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
, IGS_AD_CODE_CLASSES CC14
WHERE R.SPECIAL_INTEREST_ID = CC1.CODE_ID(+) AND R.RELIGION_CD = CC2.LOOKUP_CODE(+)
AND CC2.LOOKUP_TYPE(+) = 'PE_RELIGION' AND R.PROGRAM_INTEREST_ID = CC3.CODE_ID(+) AND R.INSTITUTION_SIZE_ID = CC4.CODE_ID(+) AND R.INSTITUTION_CONTROL_ID = CC5.CODE_ID(+)
AND R.INSTITUTION_SETTING_ID = CC6.CODE_ID(+) AND R.INSTITUTION_LOCATION_ID = CC7.CODE_ID(+) AND R.SPECIAL_SERVICES_ID = CC8.CODE_ID(+) AND R.EMPLOYMENT_ID = CC9.CODE_ID(+) AND R.HOUSING_ID = CC10.CODE_ID(+) AND R.DEGREE_GOAL_ID = CC11.CODE_ID(+) AND R.UNIT_SET_ID = CC12.CODE_ID(+) AND R.CERTAINTY_OF_CHOICE_ID = CC13.CODE_ID(+) AND R.SEC_SCHOOL_LOCATION_ID = CC14.CODE_ID(+)