eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_AS_SUA_H_V

Product:	IGS - Student System (Obsolete)
Description:	This view is used to merge student unit attempt history with the current student unit attempt details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.UNIT_CD
, TO_NUMBER(NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('VERSION_NUMBER'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID)
, SUA1.VERSION_NUMBER))
, SUAH1.CAL_TYPE
, SUAH1.CI_SEQUENCE_NUMBER
, SUAH1.HIST_START_DT
, SUAH1.HIST_END_DT
, SUAH1.HIST_WHO
, SUBSTR(NVL(SUAH1.LOCATION_CD
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('LOCATION_CD'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.LOCATION_CD))
, 1
, 10)
, SUBSTR(NVL(SUAH1.UNIT_CLASS
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('UNIT_CLASS'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.UNIT_CLASS))
, 1
, 10)
, NVL(SUAH1.ENROLLED_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ENROLLED_DT'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID ))
, SUA1.ENROLLED_DT))
, SUBSTR(NVL(SUAH1.UNIT_ATTEMPT_STATUS
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('UNIT_ATTEMPT_STATUS'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.UNIT_ATTEMPT_STATUS))
, 1
, 10)
, SUBSTR(NVL(SUAH1.ADMINISTRATIVE_UNIT_STATUS
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ADMINISTRATIVE_UNIT_STATUS'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.ADMINISTRATIVE_UNIT_STATUS))
, 1
, 10)
, NVL(SUAH1.DISCONTINUED_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('DISCONTINUED_DT'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID ))
, SUA1.DISCONTINUED_DT))
, SUAH1.DCNT_REASON_CD
, NVL(SUAH1.RULE_WAIVED_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('RULE_WAIVED_DT'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID ))
, SUA1.RULE_WAIVED_DT))
, NVL(SUAH1.RULE_WAIVED_PERSON_ID
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('RULE_WAIVED_PERSON_ID'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.RULE_WAIVED_PERSON_ID))
, HZ.PARTY_NUMBER
, SUBSTR(NVL(SUAH1.NO_ASSESSMENT_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('NO_ASSESSMENT_IND'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.NO_ASSESSMENT_IND))
, 1
, 1)
, SUBSTR(NVL(SUAH1.SUP_UNIT_CD
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('SUP_UNIT_CD'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.SUP_UNIT_CD))
, 1
, 10)
, NVL(SUAH1.SUP_VERSION_NUMBER
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('SUP_VERSION_NUMBER'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.SUP_VERSION_NUMBER))
, SUBSTR(NVL(SUAH1.EXAM_LOCATION_CD
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('EXAM_LOCATION_CD'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.EXAM_LOCATION_CD))
, 1
, 10)
, SUBSTR(NVL(SUAH1.ALTERNATIVE_TITLE
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ALTERNATIVE_TITLE'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.ALTERNATIVE_TITLE))
, 1
, 90)
, NVL(SUAH1.OVERRIDE_ENROLLED_CP
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_ENROLLED_CP'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.OVERRIDE_ENROLLED_CP))
, NVL(SUAH1.OVERRIDE_EFTSU
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_EFTSU'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.OVERRIDE_EFTSU))
, NVL(SUAH1.OVERRIDE_ACHIEVABLE_CP
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_ACHIEVABLE_CP'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.OVERRIDE_ACHIEVABLE_CP))
, NVL(SUAH1.OVERRIDE_OUTCOME_DUE_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_OUTCOME_DUE_DT'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID ))
, SUA1.OVERRIDE_OUTCOME_DUE_DT))
, NVL(SUAH1.OVERRIDE_CREDIT_REASON
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_CREDIT_REASON'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.OVERRIDE_CREDIT_REASON))
, SUBSTR( NVL(SUAH1.ENR_METHOD_TYPE
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ENR_METHOD_TYPE'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.ENR_METHOD_TYPE))
, 1
, 10)
, SUBSTR( NVL(SUAH1.GRADING_SCHEMA_CODE
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('GRADING_SCHEMA_CODE'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.GRADING_SCHEMA_CODE))
, 1
, 10)
, SUAH1.CREATED_BY
, SUAH1.CREATION_DATE
, SUAH1.LAST_UPDATED_BY
, SUAH1.LAST_UPDATE_DATE
, SUAH1.LAST_UPDATE_LOGIN
, SUA1.DEG_AUD_DETAIL_ID
, SUAH1.UOO_ID
, NVL(SUAH1.CORE_INDICATOR_CODE
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL ('CORE_INDICATOR_CODE'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID)
, SUA1.CORE_INDICATOR_CODE))
FROM IGS_EN_SU_ATTEMPT_H SUAH1
, IGS_EN_SU_ATTEMPT SUA1
, HZ_PARTIES HZ
WHERE SUA1.PERSON_ID = SUAH1.PERSON_ID
AND SUA1.COURSE_CD = SUAH1.COURSE_CD
AND SUA1.UOO_ID = SUAH1.UOO_ID
AND IGS_AU_GEN_003.ENRP_RET_WAIVE_PERSON_ID(SUAH1.RULE_WAIVED_PERSON_ID
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID)= HZ.PARTY_ID(+) UNION ALL SELECT SUA2.PERSON_ID
, SUA2.COURSE_CD
, SUA2.UNIT_CD
, SUA2.VERSION_NUMBER
, SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER
, NVL(MAX(SUAH2.HIST_END_DT)
, SUA2.LAST_UPDATE_DATE)
, TO_DATE(NULL)
, SUA2.LAST_UPDATED_BY
, SUA2.LOCATION_CD
, SUA2.UNIT_CLASS
, SUA2.ENROLLED_DT
, SUA2.UNIT_ATTEMPT_STATUS
, SUA2.ADMINISTRATIVE_UNIT_STATUS
, SUA2.DISCONTINUED_DT
, SUA2.DCNT_REASON_CD
, SUA2.RULE_WAIVED_DT
, SUA2.RULE_WAIVED_PERSON_ID
, HZ.PARTY_NUMBER
, SUA2.NO_ASSESSMENT_IND
, SUA2.SUP_UNIT_CD
, SUA2.SUP_VERSION_NUMBER
, SUA2.EXAM_LOCATION_CD
, SUA2.ALTERNATIVE_TITLE
, SUA2.OVERRIDE_ENROLLED_CP
, SUA2.OVERRIDE_EFTSU
, SUA2.OVERRIDE_ACHIEVABLE_CP
, SUA2.OVERRIDE_OUTCOME_DUE_DT
, SUA2.OVERRIDE_CREDIT_REASON
, SUA2.ENR_METHOD_TYPE
, SUA2.GRADING_SCHEMA_CODE
, SUA2.CREATED_BY
, SUA2.CREATION_DATE
, SUA2.LAST_UPDATED_BY
, SUA2.LAST_UPDATE_DATE
, SUA2.LAST_UPDATE_LOGIN
, SUA2.DEG_AUD_DETAIL_ID
, SUA2.UOO_ID
, SUA2.CORE_INDICATOR_CODE
FROM IGS_EN_SU_ATTEMPT SUA2
, IGS_EN_SU_ATTEMPT_H SUAH2
, HZ_PARTIES HZ
WHERE SUA2.PERSON_ID = SUAH2.PERSON_ID(+)
AND SUA2.COURSE_CD = SUAH2.COURSE_CD(+)
AND SUA2.UOO_ID = SUAH2.UOO_ID(+)
AND SUA2.RULE_WAIVED_PERSON_ID = HZ.PARTY_ID(+) GROUP BY SUA2.PERSON_ID
, SUA2.COURSE_CD
, SUA2.UNIT_CD
, SUA2.VERSION_NUMBER
, SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER
, SUA2.LOCATION_CD
, SUA2.UNIT_CLASS
, SUA2.ENROLLED_DT
, SUA2.UNIT_ATTEMPT_STATUS
, SUA2.ADMINISTRATIVE_UNIT_STATUS
, SUA2.DISCONTINUED_DT
, SUA2.DCNT_REASON_CD
, SUA2.RULE_WAIVED_DT
, SUA2.RULE_WAIVED_PERSON_ID
, HZ.PARTY_NUMBER
, SUA2.NO_ASSESSMENT_IND
, SUA2.SUP_UNIT_CD
, SUA2.SUP_VERSION_NUMBER
, SUA2.EXAM_LOCATION_CD
, SUA2.ALTERNATIVE_TITLE
, SUA2.OVERRIDE_ENROLLED_CP
, SUA2.OVERRIDE_EFTSU
, SUA2.OVERRIDE_ACHIEVABLE_CP
, SUA2.OVERRIDE_OUTCOME_DUE_DT
, SUA2.OVERRIDE_CREDIT_REASON
, SUA2.ENR_METHOD_TYPE
, SUA2.GRADING_SCHEMA_CODE
, SUA2.CREATED_BY
, SUA2.CREATION_DATE
, SUA2.LAST_UPDATED_BY
, SUA2.LAST_UPDATE_DATE
, SUA2.LAST_UPDATE_LOGIN
, SUA2.DEG_AUD_DETAIL_ID
, SUA2.UOO_ID
, SUA2.CORE_INDICATOR_CODE

Columns

Name
PERSON_ID
COURSE_CD
UNIT_CD
VERSION_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
HIST_START_DT
HIST_END_DT
HIST_WHO
LOCATION_CD
UNIT_CLASS
ENROLLED_DT
UNIT_ATTEMPT_STATUS
ADMINISTRATIVE_UNIT_STATUS
DISCONTINUED_DT
DCNT_REASON_CD
RULE_WAIVED_DT
RULE_WAIVED_PERSON_ID
RULE_WAIVED_PERSON_NUMBER
NO_ASSESSMENT_IND
SUP_UNIT_CD
SUP_VERSION_NUMBER
EXAM_LOCATION_CD
ALTERNATIVE_TITLE
OVERRIDE_ENROLLED_CP
OVERRIDE_EFTSU
OVERRIDE_ACHIEVABLE_CP
OVERRIDE_OUTCOME_DUE_DT
OVERRIDE_CREDIT_REASON
ENR_METHOD_TYPE
GRADING_SCHEMA_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
DEG_AUD_DETAIL_ID
UOO_ID
CORE_INDICATOR_CODE