VIEW: APPS.IGSBV_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, 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

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
, 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