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_EFFECTIVE_H_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 UNIQUE PERSON_ID
, COURSE_CD
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_EFF_ST( PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_EFF_END( PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_END_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'LOCATION_CD'
, LOCATION_CD
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'UNIT_CLASS'
, UNIT_CLASS
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'ENROLLED_DT'
, IGS_GE_DATE.IGSCHARDT(ENROLLED_DT)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'UNIT_ATTEMPT_STATUS'
, UNIT_ATTEMPT_STATUS
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'ADMINISTRATIVE_UNIT_STATUS'
, ADMINISTRATIVE_UNIT_STATUS
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'DISCONTINUED_DT'
, IGS_GE_DATE.IGSCHARDT(DISCONTINUED_DT)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'RULE_WAIVED_DT'
, IGS_GE_DATE.IGSCHARDT(RULE_WAIVED_DT)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, TO_NUMBER(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'RULE_WAIVED_PERSON_ID'
, TO_CHAR(RULE_WAIVED_PERSON_ID)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'NO_ASSESSMENT_IND'
, NO_ASSESSMENT_IND
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 1)
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'EXAM_LOCATION_CD'
, EXAM_LOCATION_CD
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'SUP_UNIT_CD'
, SUP_UNIT_CD
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, TO_NUMBER(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'SUP_VERSION_NUMBER'
, TO_CHAR(SUP_VERSION_NUMBER)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'ALTERNATIVE_TITLE'
, ALTERNATIVE_TITLE
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 90)
, TO_NUMBER(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'OVERRIDE_ENROLLED_CP'
, TO_CHAR(OVERRIDE_ENROLLED_CP)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, TO_NUMBER(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'OVERRIDE_EFTSU'
, TO_CHAR(OVERRIDE_EFTSU)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, TO_NUMBER(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'OVERRIDE_ACHIEVABLE_CP'
, TO_CHAR(OVERRIDE_ACHIEVABLE_CP)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'OVERRIDE_OUTCOME_DUE_DT'
, IGS_GE_DATE.IGSCHARDT(OVERRIDE_OUTCOME_DUE_DT)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'OVERRIDE_CREDIT_REASON'
, OVERRIDE_CREDIT_REASON
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, UOO_ID
FROM IGS_AS_SUA_H_V

Columns

Name
PERSON_ID
COURSE_CD
UNIT_CD
VERSION_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
EFFECTIVE_START_DT
EFFECTIVE_END_DT
LOCATION_CD
UNIT_CLASS
ENROLLED_DT
UNIT_ATTEMPT_STATUS
ADMINISTRATIVE_UNIT_STATUS
DISCONTINUED_DT
RULE_WAIVED_DT
RULE_WAIVED_PERSON_ID
NO_ASSESSMENT_IND
EXAM_LOCATION_CD
SUP_UNIT_CD
SUP_VERSION_NUMBER
ALTERNATIVE_TITLE
OVERRIDE_ENROLLED_CP
OVERRIDE_EFTSU
OVERRIDE_ACHIEVABLE_CP
OVERRIDE_OUTCOME_DUE_DT
OVERRIDE_CREDIT_REASON
UOO_ID