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: IGSFV_AS_SU_ATMPT_OUTCOMES

Product:	IGS - Student System (Obsolete)
Description:	Describes a student unit attempt outcome
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, SUAO.COURSE_CD
, CRV.TITLE
, SUAO.UNIT_CD
, UV.TITLE
, SUAO.CAL_TYPE
, SUAO.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, SUAO.OUTCOME_DT
, SUAO.MARK
, SUAO.GRADE
, '_LA:SUAO.FINALISED_OUTCOME_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:SUAO.GRADING_PERIOD_CD:IGS_LOOKUP_VALUES:AS_GRADING_PERIOD:MEANING'
, SUAO.TRANSLATED_DT
, SUAO.TRANSLATED_GRADE
, SUAO.CI_START_DT
, SUAO.CI_END_DT
, SUAO.NUMBER_TIMES_KEYED
, SUAO.INCOMP_DEADLINE_DATE
, SUAO.INCOMP_DEFAULT_GRADE
, SUAO.INCOMP_DEFAULT_MARK
, SUAO.COMMENTS
, '_LA:SUAO.S_GRADE_CREATION_METHOD_TYPE:IGS_LOOKUP_VALUES:GRADE_CREATION_METHOD_TYPE:MEANING'
, GS1.DESCRIPTION
, GS2.DESCRIPTION
, SUAO.PERSON_ID
, SUAO.GRADING_SCHEMA_CD
, SUAO.VERSION_NUMBER
, SUA.VERSION_NUMBER
, SCA.VERSION_NUMBER
, SUAO.INCOMP_GRADING_SCHEMA_CD
, SUAO.INCOMP_VERSION_NUMBER
, SUAO.TRANSLATED_GRADING_SCHEMA_CD
, SUAO.TRANSLATED_VERSION_NUMBER
, SUAO.CREATED_BY
, SUAO.CREATION_DATE
, SUAO.LAST_UPDATED_BY
, SUAO.LAST_UPDATE_DATE
, SUAO.UOO_ID
, '_LA:SUAO.MARK_CAPPED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:SUAO.SHOW_ON_ACADEMIC_HISTRY_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SUAO.RELEASE_DATE
, '_LA:SUAO.MANUAL_OVERRIDE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, IGS_AS_DERIVE_GRADE.GET_ASSESSMENT_STATUS( SUAO.PERSON_ID
, SUAO.COURSE_CD
, SUAO.UOO_ID
, SUAO.UNIT_CD)
FROM IGS_AS_SU_STMPTOUT_ALL SUAO
, HZ_PARTIES HP
, IGS_EN_SU_ATTEMPT_ALL SUA
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_AS_GRD_SCHEMA GS1
, IGS_AS_GRD_SCHEMA GS2
, IGS_CA_INST_ALL CI
, IGS_PS_UNIT_VER_ALL UV
, IGS_PS_VER_ALL CRV
WHERE SUAO.PERSON_ID = HP.PARTY_ID
AND SUAO.PERSON_ID = SUA.PERSON_ID AND SUAO.COURSE_CD = SUA.COURSE_CD AND SUAO.UOO_ID = SUA.UOO_ID
AND SUAO.PERSON_ID = SCA.PERSON_ID
AND SUAO.COURSE_CD = SCA.COURSE_CD
AND SUA.UNIT_CD = UV.UNIT_CD
AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SUAO.CAL_TYPE = CI.CAL_TYPE AND SUAO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SUAO.GRADING_SCHEMA_CD = GS1.GRADING_SCHEMA_CD
AND SUAO.VERSION_NUMBER = GS1.VERSION_NUMBER
AND SUAO.TRANSLATED_GRADING_SCHEMA_CD = GS2.GRADING_SCHEMA_CD (+)
AND SUAO.TRANSLATED_VERSION_NUMBER = GS2.VERSION_NUMBER (+) WITH READ ONLY

Columns

Name
PERSON_NAME
PERSON_NUMBER
PROGRAM_CODE
PROGRAM_TITLE
UNIT_CODE
UNIT_TITLE
CALENDAR_TYPE
CALENDAR_SEQUENCE_NUMBER
CALENDAR_DESCRIPTION
OUTCOME_DATE
MARK
GRADE
"_LA:FINALISED_OUTCOME_IND"
"_LA:GRADING_PERIOD"
TRANSLATED_DATE
TRANSLATED_GRADE
TEACHING_CAL_START_DATE
TEACHING_CAL_END_DATE
NUMBER_TIMES_KEYED
INCOMP_DEADLINE_DATE
INCOMP_DEFAULT_GRADE
INCOMP_DEFAULT_MARK
COMMENTS
"_LA:GRADE_CREATION_METHOD"
GRADING_SCHEMA_DESC
TRANSLATED_GRADING_SCHEMA_DESC
PERSON_ID
GRADING_SCHEMA_CODE
GRADING_SCHEMA_VERSION_NUMBER
UNIT_VERSION_NUMBER
PROGRAM_VERSION_NUMBER
INCOMP_GRADING_SCHEMA_CODE
INCOMP_VERSION_NUMBER
TRANSLATED_GRADING_SCHEMA_CODE
TRANSLATED_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
UOO_ID
"_LA:MARK_CAPPED_FLAG"
"_LA:SHOW_ON_ACADCM_HIST_FLAG"
RELEASE_DATE
"_LA:MANUAL_OVERRIDE_FLAG"
ASSESSMENT_STATUS