View: IGSFV_ST_HESA_DLHE_SURVEY_RECS

View Text

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

Columns