View: IGSFV_HESA_EXT_RUN_DAT_LINES

View Text

SELECT LN.RN_DAT_LN_ID HESA_RETURN_LINE_ID
, LN.EXTRACT_RUN_ID EXTRACT_RUN_ID
, EXRN.SUBMISSION_NAME SUBMISSION_NAME
, EXRN.USER_RETURN_SUBCLASS USER_RETURN_SUBCLASS
, (SELECT DESCRIPTION
FROM IGS_HE_USR_RTN_CLAS
WHERE USER_RETURN_SUBCLASS = EXRN.USER_RETURN_SUBCLASS ) USER_RETURN_SUB_CLASS_DESC
, EXRN.RETURN_NAME RETURN_NAME
, SHDR.ENROLMENT_START_DATE REPORTING_PERIOD_START_DATE
, SHDR.ENROLMENT_END_DATE REPORTING_PERIOD_END_DATE
, LN.RECORD_ID RECORD_ID
, (SELECT SYSTEM_RETURN_CLASS_TYPE
FROM IGS_HE_USR_RTN_CLAS
WHERE USER_RETURN_SUBCLASS = EXRN.USER_RETURN_SUBCLASS ) SYSTEM_RETURN_CLASS_TYPE
, LN.LINE_NUMBER LINE_NUMBER
, LN.PERSON_ID PERSON_ID
, PE.PERSON_NUMBER PERSON_NUMBER
, PE.LAST_NAME PERSON_SURNAME
, PE.FIRST_NAME PERSON_GIVEN_NAMES
, PE.FULL_NAME PERSON_FULL_NAME
, LN.STUDENT_INST_NUMBER STUDENT_INSTANCE_NUMBER
, LN.COURSE_CD PROGRAM_CODE
, LN.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, CS.TITLE PROGRAM_TITLE
, CS.SHORT_TITLE PROGRAM_SHORT_TITLE
, CS.ABBREVIATION PROGRAM_ABBREVIATION
, LN.UNIT_CD UNIT_CODE
, LN.UV_VERSION_NUMBER UNIT_VERSION_NUMBER
, UV.TITLE UNIT_TITLE
, UV.SHORT_TITLE UNIT_SHORT_TITLE
, UV.ABBREVIATION UNIT_ABBREVIATION
, LN.MANUALLY_INSERTED MANUALLY_INSERTED_FLAG
, LN.EXCLUDE_FROM_FILE EXCLUDE_FROM_FILE_FLAG
, LN.RECALCULATE_FLAG RECALCULATE_FLAG
, LN.CREATED_BY CREATED_BY
, LN.CREATION_DATE CREATION_DATE
, LN.LAST_UPDATED_BY LAST_UPDATED_BY
, LN.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_EX_RN_DAT_LN LN
, IGS_HE_EXT_RUN_DTLS EXRN
, IGS_HE_SUBMSN_HEADER SHDR
, IGS_PE_PERSON_BASE_V PE
, IGS_PS_UNIT_VER_ALL UV
, IGS_PS_VER_ALL CS
WHERE LN.EXTRACT_RUN_ID = EXRN.EXTRACT_RUN_ID
AND EXRN.SUBMISSION_NAME = SHDR.SUBMISSION_NAME
AND LN.PERSON_ID = PE.PERSON_ID(+)
AND LN.COURSE_CD = CS.COURSE_CD(+)
AND LN.CRV_VERSION_NUMBER = CS.VERSION_NUMBER(+)
AND LN.UNIT_CD = UV.UNIT_CD(+)
AND LN.UV_VERSION_NUMBER = UV.VERSION_NUMBER(+) WITH READ ONLY

Columns