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_SUAH_LOAD_V

Product:	IGS - Student System (Obsolete)
Description:	Used to create effective student unit attempt history records in recognition of back dating enrollment and discontinuation dates.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SUAEHV.PERSON_ID
, SUAEHV.COURSE_CD
, SUAEHV.UNIT_CD
, SUAEHV.VERSION_NUMBER
, SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.EFFECTIVE_START_DT
, SUAEHV.EFFECTIVE_END_DT
, SUAEHV.UNIT_ATTEMPT_STATUS
, SUAS.FEE_ASS_IND
, SUAEHV.ADMINISTRATIVE_UNIT_STATUS
, SUAEHV.ENROLLED_DT
, SUAEHV.DISCONTINUED_DT
, CI.LOAD_CAL_TYPE
, CI.LOAD_CI_SEQUENCE_NUMBER
, SUAEHV.CREATED_BY
, SUAEHV.CREATION_DATE
, SUAEHV.LAST_UPDATED_BY
, SUAEHV.LAST_UPDATE_DATE
, SUAEHV.LAST_UPDATE_LOGIN
, SUBSTR(IGS_EN_PRC_LOAD.ENRP_GET_LOAD_APPLY( SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.DISCONTINUED_DT
, SUAEHV.ADMINISTRATIVE_UNIT_STATUS
, SUAEHV.UNIT_ATTEMPT_STATUS
, SUAEHV.NO_ASSESSMENT_IND
, CI.LOAD_CAL_TYPE
, CI.LOAD_CI_SEQUENCE_NUMBER)
, 1
, 1)
, DECODE(IGS_EN_PRC_LOAD.ENRP_GET_LOAD_APPLY( SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.DISCONTINUED_DT
, SUAEHV.ADMINISTRATIVE_UNIT_STATUS
, SUAEHV.UNIT_ATTEMPT_STATUS
, SUAEHV.NO_ASSESSMENT_IND
, CI.LOAD_CAL_TYPE
, CI.LOAD_CI_SEQUENCE_NUMBER)
, 'Y'
, IGS_EN_GEN_014.ENRS_CLC_SUA_EFTSUT( SUAEHV.PERSON_ID
, SUAEHV.COURSE_CD
, SCA.VERSION_NUMBER
, SUAEHV.UNIT_CD
, SUAEHV.VERSION_NUMBER
, SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, IGS_PS_GEN_006.CRSP_GET_UOO_ID(SUAEHV.UNIT_CD
, SUAEHV.VERSION_NUMBER
, SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.LOCATION_CD
, SUAEHV.UNIT_CLASS)
, SUAEHV.OVERRIDE_ENROLLED_CP
, SUAEHV.OVERRIDE_EFTSU
, NULL)
, 'N'
, 0)
, DECODE(IGS_EN_PRC_LOAD.ENRP_GET_LOAD_APPLY( SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.DISCONTINUED_DT
, SUAEHV.ADMINISTRATIVE_UNIT_STATUS
, SUAEHV.UNIT_ATTEMPT_STATUS
, SUAEHV.NO_ASSESSMENT_IND
, CI.LOAD_CAL_TYPE
, CI.LOAD_CI_SEQUENCE_NUMBER)
, 'Y'
, IGS_EN_GEN_014.ENRS_CLC_SUA_CP( SUAEHV.PERSON_ID
, SUAEHV.COURSE_CD
, SCA.VERSION_NUMBER
, SUAEHV.UNIT_CD
, SUAEHV.VERSION_NUMBER
, SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, IGS_PS_GEN_006.CRSP_GET_UOO_ID(SUAEHV.UNIT_CD
, SUAEHV.VERSION_NUMBER
, SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.LOCATION_CD
, SUAEHV.UNIT_CLASS)
, CI.LOAD_CAL_TYPE
, CI.LOAD_CI_SEQUENCE_NUMBER
, SUAEHV.OVERRIDE_ENROLLED_CP
, SUAEHV.OVERRIDE_EFTSU
, 'Y'
, NULL)
, 'N'
, 0)
, SUA.DEG_AUD_DETAIL_ID
, SUAEHV.UOO_ID
FROM IGS_AS_SUAH_EFFECTIVE_H_V SUAEHV
, IGS_EN_SU_ATTEMPT SUA
, IGS_EN_STDNT_PS_ATT SCA
, IGS_LOOKUPS_VIEW SUAS
, IGS_CA_TEACH_TO_LOAD_V CI
WHERE SUA.PERSON_ID = SUAEHV.PERSON_ID
AND /*JOIN TO SUA IS USED TO */ SUA.COURSE_CD = SUAEHV.COURSE_CD AND /* PREVENT HISTORY BEING FOUND */ SUA.UOO_ID = SUAEHV.UOO_ID AND /* WHEN THE UNIT ATTEMPT HAS BEEN DELETED */ SCA.PERSON_ID = SUAEHV.PERSON_ID
AND SCA.COURSE_CD = SUAEHV.COURSE_CD
AND SUAS.LOOKUP_CODE = SUAEHV.UNIT_ATTEMPT_STATUS
AND SUAS.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'
AND SUA.CAL_TYPE = CI.TEACH_CAL_TYPE
AND SUA.CI_SEQUENCE_NUMBER = CI.TEACH_CI_SEQUENCE_NUMBER

Columns

Name
PERSON_ID
COURSE_CD
UNIT_CD
VERSION_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
EFFECTIVE_START_DT
EFFECTIVE_END_DT
UNIT_ATTEMPT_STATUS
FEE_ASS_IND
ADMINISTRATIVE_UNIT_STATUS
ENROLLED_DT
DISCONTINUED_DT
LOAD_CAL_TYPE
LOAD_CI_SEQUENCE_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LOAD_INCURRED_IND
EFTSU
CREDIT_POINTS
DEG_AUD_DETAIL_ID
UOO_ID