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.

VIEW: APPS.IGSFV_ST_HESA_DLHE_SURVEY_RECS

Source

View Text - Preformatted


SELECT dlhe.PERSON_ID PERSON_ID, per.PARTY_NUMBER PERSON_NUMBER, dlhe.SUBMISSION_NAME SUBMISSION_NAME, dlhe.USER_RETURN_SUBCLASS USER_RETURN_SUBCLASS, dlhe.RETURN_NAME RETURN_NAME, dlhe.QUAL_PERIOD_CODE QUALIFYING_PERIOD_CODE, dlhe.DLHE_RECORD_STATUS DLHE_RECORD_STATUS, '_LA:dlhe.DLHE_RECORD_STATUS:IGS_LOOKUP_VALUES:IGS_HE_DLHE_RECORD_STATUS:MEANING' "_LA:DLHE_RECORD_STATUS_DESC", dlhe.PARTICIPANT_SOURCE PARTICIPANT_SOURCE, dlhe.DATE_STATUS_CHANGED DATE_STATUS_CHANGED, dlhe.VALIDATION_STATUS VALIDATION_STATUS, dlhe.ADMIN_CODING ADMIN_CODING, dlhe.SURVEY_METHOD SURVEY_METHOD, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_METHOD' AND VALUE = dlhe.SURVEY_METHOD) SURVEY_METHOD_DESC, dlhe.EMPLOYMENT EMPLOYMENT, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_EMPCIR' AND VALUE = dlhe.EMPLOYMENT) EMPLOYMENT_DESC, dlhe.FURTHER_STUDY FURTHER_STUDY, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_MODSTUDY' AND VALUE = dlhe.FURTHER_STUDY) FURTHER_STUDY_DESC, dlhe.QUALIFIED_TEACHER QUALIFIED_TEACHER, dlhe.PT_STUDY PT_STUDY, dlhe.EMPLOYER_BUSINESS EMPLOYER_BUSINESS, dlhe.EMPLOYER_NAME EMPLOYER_NAME, dlhe.EMPLOYER_CLASSIFICATION EMPLOYER_CLASSIFICATION, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_SIC' AND VALUE = dlhe.EMPLOYER_CLASSIFICATION) EMPLOYER_CLASSIFICATION_DESC, dlhe.EMPLOYER_LOCATION EMPLOYER_LOCATION, dlhe.EMPLOYER_POSTCODE EMPLOYER_POSTCODE, dlhe.EMPLOYER_COUNTRY EMPLOYER_COUNTRY, dlhe.JOB_TITLE JOB_TITLE, dlhe.JOB_DUTIES JOB_DUTIES, dlhe.JOB_CLASSIFICATION JOB_CLASSIFICATION, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_SOCDLHE' AND VALUE = dlhe.JOB_CLASSIFICATION) JOB_CLASSIFICATION_DESC, dlhe.EMPLOYER_SIZE EMPLOYER_SIZE, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_EMPSIZE' AND VALUE = dlhe.EMPLOYER_SIZE) EMPLOYER_SIZE_DESC, dlhe.JOB_DURATION JOB_DURATION, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_DURATION' AND VALUE = dlhe.JOB_DURATION) JOB_DURATION_DESC, dlhe.JOB_SALARY JOB_SALARY, dlhe.SALARY_REFUSED SALARY_REFUSED, dlhe.QUALIFICATION_REQUIREMENT QUAL_REQUIREMENT, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_QUALREQ' AND VALUE = dlhe.QUALIFICATION_REQUIREMENT) QUAL_REQUIREMENT_DESC, dlhe.QUALIFICATION_IMPORTANCE QUAL_IMPORTANCE, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_EMPIMP' AND VALUE = dlhe.QUALIFICATION_IMPORTANCE) QUAL_IMPORTANCE_DESC, dlhe.JOB_REASON1 JOB_REASON1, 'IT FITTED INTO MY CAREER PLAN / IT WAS EXACTLY THE TYPE OF WORK I WANTED' JOB_REASON1_DESC, dlhe.JOB_REASON2 JOB_REASON2, 'IT WAS THE BEST JOB OFFER I RECEIVED / ONLY JOB OFFER I RECEIVED' JOB_REASON2_DESC, dlhe.JOB_REASON3 JOB_REASON3, 'IT WAS AN OPPORTUNITY TO PROGRESS IN THE ORGANIZATION' JOB_REASON3_DESC, dlhe.JOB_REASON4 JOB_REASON4, 'TO GAIN EXPERIENCE IN ORDER GET THE TYPE OF JOB I REALLY WANT' JOB_REASON4_DESC, dlhe.JOB_REASON5 JOB_REASON5, 'TO SEE IF I WOULD LIKE THE TYPE OF WORK IT INVOLVED' JOB_REASON5_DESC, dlhe.JOB_REASON6 JOB_REASON6, 'TO BROADEN MY EXPERIENCE / TO DEVELOP GENERAL SKILLS' JOB_REASON6_DESC, dlhe.JOB_REASON7 JOB_REASON7, 'IN ORDER TO PAY OFF DEBTS' JOB_REASON7_DESC, dlhe.JOB_REASON8 JOB_REASON8, 'BECAUSE IT IS BETTER THAN BEING UNEMPLOYED' JOB_REASON8_DESC, dlhe.OTHER_JOB_REASON OTHER_JOB_REASON, dlhe.NO_OTHER_JOB_REASON NO_OTHER_JOB_REASON, dlhe.JOB_SOURCE JOB_SOURCE, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_JOBFND' AND VALUE = dlhe.JOB_SOURCE) JOB_SOURCE_DESC, dlhe.OTHER_JOB_SOURCE OTHER_JOB_SOURCE, dlhe.NO_OTHER_JOB_SOURCE NO_OTHER_JOB_SOURCE, dlhe.PREVIOUS_JOB PREVIOUS_JOB, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_PREVEMP' AND VALUE = dlhe.PREVIOUS_JOB) PREVIOUS_JOB_DESC, dlhe.PREVIOUS_JOBTYPE1 PREVIOUS_JOBTYPE1, 'ON A SANDWICH PLACEMENT' PREVIOUS_JOBTYPE1_DESC, dlhe.PREVIOUS_JOBTYPE2 PREVIOUS_JOBTYPE2, 'ON ANOTHER KIND OF PLACEMENT OR PROJECT WORK' PREVIOUS_JOBTYPE2_DESC, dlhe.PREVIOUS_JOBTYPE3 PREVIOUS_JOBTYPE3, 'AS A HOLIDAY JOB' PREVIOUS_JOBTYPE3_DESC, dlhe.PREVIOUS_JOBTYPE4 PREVIOUS_JOBTYPE4, 'FULL-TIME OR PART-TIME WORK ALL YEAR ROUND' PREVIOUS_JOBTYPE4_DESC, dlhe.PREVIOUS_JOBTYPE5 PREVIOUS_JOBTYPE5, 'FULL-TIME OR PART-TIME DURING TERM TIME' PREVIOUS_JOBTYPE5_DESC, dlhe.PREVIOUS_JOBTYPE6 PREVIOUS_JOBTYPE6, 'IN OTHER WAYS' PREVIOUS_JOBTYPE6_DESC, dlhe.FURTHER_STUDY_TYPE FURTHER_STUDY_TYPE, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_NATSTUDY' AND VALUE = dlhe.FURTHER_STUDY_TYPE) FURTHER_STUDY_TYPE_DESC, dlhe.COURSE_NAME COURSE_NAME, dlhe.COURSE_TRAINING_SUBJECT COURSE_TRAINING_SUBJECT, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_SOCDLHE' AND VALUE = dlhe.COURSE_TRAINING_SUBJECT) COURSE_TRAINING_SUBJECT_DESC, dlhe.RESEARCH_SUBJECT RESEARCH_SUBJECT, dlhe.RESEARCH_TRAINING_SUBJECT RESEARCH_TRAINING_SUBJECT, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_SOCDLHE' AND VALUE = dlhe.RESEARCH_TRAINING_SUBJECT) RESEARCH_TRAINING_SUBJECT_DESC, dlhe.FURTHER_STUDY_PROVIDER FURTHER_STUDY_PROVIDER, (SELECT HP.PARTY_NAME FROM HZ_PARTIES HP, IGS_PE_HZ_PARTIES IHP WHERE IHP.OSS_ORG_UNIT_CD = dlhe.FURTHER_STUDY_PROVIDER AND IHP.PARTY_ID = HP.PARTY_ID) FURTHER_STUDY_PROVIDER_NAME, dlhe.FURTHER_STUDY_QUALAIM FURTHER_STUDY_QUAL_AIM, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_TYPEQUAL' AND VALUE = dlhe.FURTHER_STUDY_QUALAIM) FURTHER_STUDY_QUAL_AIM_DESC, dlhe.PROFESSIONAL_QUALIFICATION PROFESSIONAL_QUAL, dlhe.STUDY_REASON1 STUDY_REASON1, 'IT IS A REQUIREMENT OF YOUR EMPLOYMENT THAT YOU UNDERTAKE FURTHER STUDY, TRAINING OR RESEARCH' STUDY_REASON1_DESC, dlhe.STUDY_REASON2 STUDY_REASON2, 'TO DEVELOP A BROADER OR MORE SPECIALIST RANGE OF SKILLS OR KNOWLEDGE' STUDY_REASON2_DESC, dlhe.STUDY_REASON3 STUDY_REASON3, 'TO CHANGE OR IMPROVE MY CAREER OPTIONS' STUDY_REASON3_DESC, dlhe.STUDY_REASON4 STUDY_REASON4, 'BECAUSE I WAS INTERESTED IN THE CONTENT OF THE COURSE' STUDY_REASON4_DESC, dlhe.STUDY_REASON5 STUDY_REASON5, 'BECAUSE I HAD ENJOYED MY FIRST COURSE AND WANTED TO CONTINUE STUDYING' STUDY_REASON5_DESC, dlhe.STUDY_REASON6 STUDY_REASON6, 'I WANTED TO GO ON BEING A STUDENT / I WANTED TO POSTPONE JOB HUNTING' STUDY_REASON6_DESC, dlhe.STUDY_REASON7 STUDY_REASON7, 'I HAD BEEN UNABLE TO FIND A SUITABLE JOB' STUDY_REASON7_DESC, dlhe.OTHER_STUDY_REASON OTHER_STUDY_REASON, dlhe.NO_OTHER_STUDY_REASON NO_OTHER_STUDY_REASON, dlhe.EMPLOYER_SPONSORED EMPLOYER_SPONSORED, dlhe.FUNDING_SOURCE FUNDING_SOURCE, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_FUNDSTUDY' AND VALUE = dlhe.FUNDING_SOURCE) FUNDING_SOURCE_DESC, dlhe.TEACHER_TEACHING TEACHER_TEACHING, dlhe.TEACHER_SEEKING TEACHER_SEEKING, dlhe.TEACHING_SECTOR TEACHING_SECTOR, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_TEACHSCT' AND VALUE = dlhe.TEACHING_SECTOR) TEACHING_SECTOR_DESC, dlhe.TEACHING_LEVEL TEACHING_LEVEL, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_TEACHPHS' AND VALUE = dlhe.TEACHING_LEVEL) TEACHING_LEVEL_DESC, dlhe.REASON_FOR_PTCOURSE REASON_FOR_PTCOURSE, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_INTENT' AND VALUE = dlhe.REASON_FOR_PTCOURSE) REASON_FOR_PTCOURSE_DESC, dlhe.JOB_WHILE_STUDYING JOB_WHILE_STUDYING, dlhe.EMPLOYER_SUPPORT1 EMPLOYER_SUPPORT1, 'YES: MY TUITION FEES WERE PAID' EMPLOYER_SUPPORT1_DESC, dlhe.EMPLOYER_SUPPORT2 EMPLOYER_SUPPORT2, 'YES: I WAS GIVEN A GRANT TO COVER MY TUITION FEES AND LIVING EXPENSES' EMPLOYER_SUPPORT2_DESC, dlhe.EMPLOYER_SUPPORT3 EMPLOYER_SUPPORT3, 'YES: I WAS GIVEN STUDY LEAVE' EMPLOYER_SUPPORT3_DESC, dlhe.EMPLOYER_SUPPORT4 EMPLOYER_SUPPORT4, 'YES: I WAS SUPPORTED IN OTHER WAYS' EMPLOYER_SUPPORT4_DESC, dlhe.EMPLOYER_SUPPORT5 EMPLOYER_SUPPORT5, 'NO: MY EMPLOYER DID NOT SUPPORT ME IN ANY WAY' EMPLOYER_SUPPORT5_DESC, dlhe.POPDLHE_FLAG POPDLHE_FLAG, dlhe.CREATED_BY CREATED_BY, dlhe.CREATION_DATE CREATION_DATE, dlhe.LAST_UPDATED_BY LAST_UPDATED_BY, dlhe.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_HE_STDNT_DLHE dlhe, HZ_PARTIES per WHERE per.PARTY_ID = dlhe.PERSON_ID WITH READ ONLY

View Text - HTML Formatted

SELECT DLHE.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, DLHE.SUBMISSION_NAME SUBMISSION_NAME
, DLHE.USER_RETURN_SUBCLASS USER_RETURN_SUBCLASS
, DLHE.RETURN_NAME RETURN_NAME
, DLHE.QUAL_PERIOD_CODE QUALIFYING_PERIOD_CODE
, DLHE.DLHE_RECORD_STATUS DLHE_RECORD_STATUS
, '_LA:DLHE.DLHE_RECORD_STATUS:IGS_LOOKUP_VALUES:IGS_HE_DLHE_RECORD_STATUS:MEANING' "_LA:DLHE_RECORD_STATUS_DESC"
, DLHE.PARTICIPANT_SOURCE PARTICIPANT_SOURCE
, DLHE.DATE_STATUS_CHANGED DATE_STATUS_CHANGED
, DLHE.VALIDATION_STATUS VALIDATION_STATUS
, DLHE.ADMIN_CODING ADMIN_CODING
, DLHE.SURVEY_METHOD SURVEY_METHOD
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_METHOD'
AND VALUE = DLHE.SURVEY_METHOD) SURVEY_METHOD_DESC
, DLHE.EMPLOYMENT EMPLOYMENT
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_EMPCIR'
AND VALUE = DLHE.EMPLOYMENT) EMPLOYMENT_DESC
, DLHE.FURTHER_STUDY FURTHER_STUDY
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_MODSTUDY'
AND VALUE = DLHE.FURTHER_STUDY) FURTHER_STUDY_DESC
, DLHE.QUALIFIED_TEACHER QUALIFIED_TEACHER
, DLHE.PT_STUDY PT_STUDY
, DLHE.EMPLOYER_BUSINESS EMPLOYER_BUSINESS
, DLHE.EMPLOYER_NAME EMPLOYER_NAME
, DLHE.EMPLOYER_CLASSIFICATION EMPLOYER_CLASSIFICATION
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_SIC'
AND VALUE = DLHE.EMPLOYER_CLASSIFICATION) EMPLOYER_CLASSIFICATION_DESC
, DLHE.EMPLOYER_LOCATION EMPLOYER_LOCATION
, DLHE.EMPLOYER_POSTCODE EMPLOYER_POSTCODE
, DLHE.EMPLOYER_COUNTRY EMPLOYER_COUNTRY
, DLHE.JOB_TITLE JOB_TITLE
, DLHE.JOB_DUTIES JOB_DUTIES
, DLHE.JOB_CLASSIFICATION JOB_CLASSIFICATION
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_SOCDLHE'
AND VALUE = DLHE.JOB_CLASSIFICATION) JOB_CLASSIFICATION_DESC
, DLHE.EMPLOYER_SIZE EMPLOYER_SIZE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_EMPSIZE'
AND VALUE = DLHE.EMPLOYER_SIZE) EMPLOYER_SIZE_DESC
, DLHE.JOB_DURATION JOB_DURATION
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_DURATION'
AND VALUE = DLHE.JOB_DURATION) JOB_DURATION_DESC
, DLHE.JOB_SALARY JOB_SALARY
, DLHE.SALARY_REFUSED SALARY_REFUSED
, DLHE.QUALIFICATION_REQUIREMENT QUAL_REQUIREMENT
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_QUALREQ'
AND VALUE = DLHE.QUALIFICATION_REQUIREMENT) QUAL_REQUIREMENT_DESC
, DLHE.QUALIFICATION_IMPORTANCE QUAL_IMPORTANCE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_EMPIMP'
AND VALUE = DLHE.QUALIFICATION_IMPORTANCE) QUAL_IMPORTANCE_DESC
, DLHE.JOB_REASON1 JOB_REASON1
, 'IT FITTED INTO MY CAREER PLAN / IT WAS EXACTLY THE TYPE OF WORK I WANTED' JOB_REASON1_DESC
, DLHE.JOB_REASON2 JOB_REASON2
, 'IT WAS THE BEST JOB OFFER I RECEIVED / ONLY JOB OFFER I RECEIVED' JOB_REASON2_DESC
, DLHE.JOB_REASON3 JOB_REASON3
, 'IT WAS AN OPPORTUNITY TO PROGRESS IN THE ORGANIZATION' JOB_REASON3_DESC
, DLHE.JOB_REASON4 JOB_REASON4
, 'TO GAIN EXPERIENCE IN ORDER GET THE TYPE OF JOB I REALLY WANT' JOB_REASON4_DESC
, DLHE.JOB_REASON5 JOB_REASON5
, 'TO SEE IF I WOULD LIKE THE TYPE OF WORK IT INVOLVED' JOB_REASON5_DESC
, DLHE.JOB_REASON6 JOB_REASON6
, 'TO BROADEN MY EXPERIENCE / TO DEVELOP GENERAL SKILLS' JOB_REASON6_DESC
, DLHE.JOB_REASON7 JOB_REASON7
, 'IN ORDER TO PAY OFF DEBTS' JOB_REASON7_DESC
, DLHE.JOB_REASON8 JOB_REASON8
, 'BECAUSE IT IS BETTER THAN BEING UNEMPLOYED' JOB_REASON8_DESC
, DLHE.OTHER_JOB_REASON OTHER_JOB_REASON
, DLHE.NO_OTHER_JOB_REASON NO_OTHER_JOB_REASON
, DLHE.JOB_SOURCE JOB_SOURCE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_JOBFND'
AND VALUE = DLHE.JOB_SOURCE) JOB_SOURCE_DESC
, DLHE.OTHER_JOB_SOURCE OTHER_JOB_SOURCE
, DLHE.NO_OTHER_JOB_SOURCE NO_OTHER_JOB_SOURCE
, DLHE.PREVIOUS_JOB PREVIOUS_JOB
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_PREVEMP'
AND VALUE = DLHE.PREVIOUS_JOB) PREVIOUS_JOB_DESC
, DLHE.PREVIOUS_JOBTYPE1 PREVIOUS_JOBTYPE1
, 'ON A SANDWICH PLACEMENT' PREVIOUS_JOBTYPE1_DESC
, DLHE.PREVIOUS_JOBTYPE2 PREVIOUS_JOBTYPE2
, 'ON ANOTHER KIND OF PLACEMENT OR PROJECT WORK' PREVIOUS_JOBTYPE2_DESC
, DLHE.PREVIOUS_JOBTYPE3 PREVIOUS_JOBTYPE3
, 'AS A HOLIDAY JOB' PREVIOUS_JOBTYPE3_DESC
, DLHE.PREVIOUS_JOBTYPE4 PREVIOUS_JOBTYPE4
, 'FULL-TIME OR PART-TIME WORK ALL YEAR ROUND' PREVIOUS_JOBTYPE4_DESC
, DLHE.PREVIOUS_JOBTYPE5 PREVIOUS_JOBTYPE5
, 'FULL-TIME OR PART-TIME DURING TERM TIME' PREVIOUS_JOBTYPE5_DESC
, DLHE.PREVIOUS_JOBTYPE6 PREVIOUS_JOBTYPE6
, 'IN OTHER WAYS' PREVIOUS_JOBTYPE6_DESC
, DLHE.FURTHER_STUDY_TYPE FURTHER_STUDY_TYPE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_NATSTUDY'
AND VALUE = DLHE.FURTHER_STUDY_TYPE) FURTHER_STUDY_TYPE_DESC
, DLHE.COURSE_NAME COURSE_NAME
, DLHE.COURSE_TRAINING_SUBJECT COURSE_TRAINING_SUBJECT
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_SOCDLHE'
AND VALUE = DLHE.COURSE_TRAINING_SUBJECT) COURSE_TRAINING_SUBJECT_DESC
, DLHE.RESEARCH_SUBJECT RESEARCH_SUBJECT
, DLHE.RESEARCH_TRAINING_SUBJECT RESEARCH_TRAINING_SUBJECT
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_SOCDLHE'
AND VALUE = DLHE.RESEARCH_TRAINING_SUBJECT) RESEARCH_TRAINING_SUBJECT_DESC
, DLHE.FURTHER_STUDY_PROVIDER FURTHER_STUDY_PROVIDER
, (SELECT HP.PARTY_NAME
FROM HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
WHERE IHP.OSS_ORG_UNIT_CD = DLHE.FURTHER_STUDY_PROVIDER
AND IHP.PARTY_ID = HP.PARTY_ID) FURTHER_STUDY_PROVIDER_NAME
, DLHE.FURTHER_STUDY_QUALAIM FURTHER_STUDY_QUAL_AIM
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_TYPEQUAL'
AND VALUE = DLHE.FURTHER_STUDY_QUALAIM) FURTHER_STUDY_QUAL_AIM_DESC
, DLHE.PROFESSIONAL_QUALIFICATION PROFESSIONAL_QUAL
, DLHE.STUDY_REASON1 STUDY_REASON1
, 'IT IS A REQUIREMENT OF YOUR EMPLOYMENT THAT YOU UNDERTAKE FURTHER STUDY
, TRAINING OR RESEARCH' STUDY_REASON1_DESC
, DLHE.STUDY_REASON2 STUDY_REASON2
, 'TO DEVELOP A BROADER OR MORE SPECIALIST RANGE OF SKILLS OR KNOWLEDGE' STUDY_REASON2_DESC
, DLHE.STUDY_REASON3 STUDY_REASON3
, 'TO CHANGE OR IMPROVE MY CAREER OPTIONS' STUDY_REASON3_DESC
, DLHE.STUDY_REASON4 STUDY_REASON4
, 'BECAUSE I WAS INTERESTED IN THE CONTENT OF THE COURSE' STUDY_REASON4_DESC
, DLHE.STUDY_REASON5 STUDY_REASON5
, 'BECAUSE I HAD ENJOYED MY FIRST COURSE
AND WANTED TO CONTINUE STUDYING' STUDY_REASON5_DESC
, DLHE.STUDY_REASON6 STUDY_REASON6
, 'I WANTED TO GO ON BEING A STUDENT / I WANTED TO POSTPONE JOB HUNTING' STUDY_REASON6_DESC
, DLHE.STUDY_REASON7 STUDY_REASON7
, 'I HAD BEEN UNABLE TO FIND A SUITABLE JOB' STUDY_REASON7_DESC
, DLHE.OTHER_STUDY_REASON OTHER_STUDY_REASON
, DLHE.NO_OTHER_STUDY_REASON NO_OTHER_STUDY_REASON
, DLHE.EMPLOYER_SPONSORED EMPLOYER_SPONSORED
, DLHE.FUNDING_SOURCE FUNDING_SOURCE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_FUNDSTUDY'
AND VALUE = DLHE.FUNDING_SOURCE) FUNDING_SOURCE_DESC
, DLHE.TEACHER_TEACHING TEACHER_TEACHING
, DLHE.TEACHER_SEEKING TEACHER_SEEKING
, DLHE.TEACHING_SECTOR TEACHING_SECTOR
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_TEACHSCT'
AND VALUE = DLHE.TEACHING_SECTOR) TEACHING_SECTOR_DESC
, DLHE.TEACHING_LEVEL TEACHING_LEVEL
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_TEACHPHS'
AND VALUE = DLHE.TEACHING_LEVEL) TEACHING_LEVEL_DESC
, DLHE.REASON_FOR_PTCOURSE REASON_FOR_PTCOURSE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_INTENT'
AND VALUE = DLHE.REASON_FOR_PTCOURSE) REASON_FOR_PTCOURSE_DESC
, DLHE.JOB_WHILE_STUDYING JOB_WHILE_STUDYING
, DLHE.EMPLOYER_SUPPORT1 EMPLOYER_SUPPORT1
, 'YES: MY TUITION FEES WERE PAID' EMPLOYER_SUPPORT1_DESC
, DLHE.EMPLOYER_SUPPORT2 EMPLOYER_SUPPORT2
, 'YES: I WAS GIVEN A GRANT TO COVER MY TUITION FEES
AND LIVING EXPENSES' EMPLOYER_SUPPORT2_DESC
, DLHE.EMPLOYER_SUPPORT3 EMPLOYER_SUPPORT3
, 'YES: I WAS GIVEN STUDY LEAVE' EMPLOYER_SUPPORT3_DESC
, DLHE.EMPLOYER_SUPPORT4 EMPLOYER_SUPPORT4
, 'YES: I WAS SUPPORTED IN OTHER WAYS' EMPLOYER_SUPPORT4_DESC
, DLHE.EMPLOYER_SUPPORT5 EMPLOYER_SUPPORT5
, 'NO: MY EMPLOYER DID NOT SUPPORT ME IN ANY WAY' EMPLOYER_SUPPORT5_DESC
, DLHE.POPDLHE_FLAG POPDLHE_FLAG
, DLHE.CREATED_BY CREATED_BY
, DLHE.CREATION_DATE CREATION_DATE
, DLHE.LAST_UPDATED_BY LAST_UPDATED_BY
, DLHE.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_STDNT_DLHE DLHE
, HZ_PARTIES PER
WHERE PER.PARTY_ID = DLHE.PERSON_ID WITH READ ONLY