View: IGSBV_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
, 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
, DLHE.EMPLOYMENT EMPLOYMENT
, DLHE.FURTHER_STUDY FURTHER_STUDY
, 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
, 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
, DLHE.EMPLOYER_SIZE EMPLOYER_SIZE
, DLHE.JOB_DURATION JOB_DURATION
, DLHE.JOB_SALARY JOB_SALARY
, DLHE.SALARY_REFUSED SALARY_REFUSED
, DLHE.QUALIFICATION_REQUIREMENT QUAL_REQUIREMENT
, DLHE.QUALIFICATION_IMPORTANCE QUAL_IMPORTANCE
, DLHE.JOB_REASON1 JOB_REASON1
, DLHE.JOB_REASON2 JOB_REASON2
, DLHE.JOB_REASON3 JOB_REASON3
, DLHE.JOB_REASON4 JOB_REASON4
, DLHE.JOB_REASON5 JOB_REASON5
, DLHE.JOB_REASON6 JOB_REASON6
, DLHE.JOB_REASON7 JOB_REASON7
, DLHE.JOB_REASON8 JOB_REASON8
, DLHE.OTHER_JOB_REASON OTHER_JOB_REASON
, DLHE.NO_OTHER_JOB_REASON NO_OTHER_JOB_REASON
, DLHE.JOB_SOURCE JOB_SOURCE
, DLHE.OTHER_JOB_SOURCE OTHER_JOB_SOURCE
, DLHE.NO_OTHER_JOB_SOURCE NO_OTHER_JOB_SOURCE
, DLHE.PREVIOUS_JOB PREVIOUS_JOB
, DLHE.PREVIOUS_JOBTYPE1 PREVIOUS_JOBTYPE1
, DLHE.PREVIOUS_JOBTYPE2 PREVIOUS_JOBTYPE2
, DLHE.PREVIOUS_JOBTYPE3 PREVIOUS_JOBTYPE3
, DLHE.PREVIOUS_JOBTYPE4 PREVIOUS_JOBTYPE4
, DLHE.PREVIOUS_JOBTYPE5 PREVIOUS_JOBTYPE5
, DLHE.PREVIOUS_JOBTYPE6 PREVIOUS_JOBTYPE6
, DLHE.FURTHER_STUDY_TYPE FURTHER_STUDY_TYPE
, DLHE.COURSE_NAME COURSE_NAME
, DLHE.COURSE_TRAINING_SUBJECT COURSE_TRAINING_SUBJECT
, DLHE.RESEARCH_SUBJECT RESEARCH_SUBJECT
, DLHE.RESEARCH_TRAINING_SUBJECT RESEARCH_TRAINING_SUBJECT
, DLHE.FURTHER_STUDY_PROVIDER FURTHER_STUDY_PROVIDER
, DLHE.FURTHER_STUDY_QUALAIM FURTHER_STUDY_QUAL_AIM
, DLHE.PROFESSIONAL_QUALIFICATION PROFESSIONAL_QUAL
, DLHE.STUDY_REASON1 STUDY_REASON1
, DLHE.STUDY_REASON2 STUDY_REASON2
, DLHE.STUDY_REASON3 STUDY_REASON3
, DLHE.STUDY_REASON4 STUDY_REASON4
, DLHE.STUDY_REASON5 STUDY_REASON5
, DLHE.STUDY_REASON6 STUDY_REASON6
, DLHE.STUDY_REASON7 STUDY_REASON7
, 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
, DLHE.TEACHER_TEACHING TEACHER_TEACHING
, DLHE.TEACHER_SEEKING TEACHER_SEEKING
, DLHE.TEACHING_SECTOR TEACHING_SECTOR
, DLHE.TEACHING_LEVEL TEACHING_LEVEL
, DLHE.REASON_FOR_PTCOURSE REASON_FOR_PTCOURSE
, DLHE.JOB_WHILE_STUDYING JOB_WHILE_STUDYING
, DLHE.EMPLOYER_SUPPORT1 EMPLOYER_SUPPORT1
, DLHE.EMPLOYER_SUPPORT2 EMPLOYER_SUPPORT2
, DLHE.EMPLOYER_SUPPORT3 EMPLOYER_SUPPORT3
, DLHE.EMPLOYER_SUPPORT4 EMPLOYER_SUPPORT4
, DLHE.EMPLOYER_SUPPORT5 EMPLOYER_SUPPORT5
, 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