[Home] [Help]
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
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
|
|
|
|