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_EN_SUA_V

Product:	IGS - Student System (Obsolete)
Description:	This view incorporates the student unit attempt record and its details such as the enrolled date, the administrative status unit associated with it and any discontinuation in the units and the corresponding reasons.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SUA.ROW_ID
, SUA.PERSON_ID
, PE1.PARTY_NUMBER
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, SUA.LOCATION_CD
, SUA.UNIT_CLASS
, SUA.CI_START_DT
, SUA.CI_END_DT
, SUA.UOO_ID
, SUA.ENROLLED_DT
, SUA.UNIT_ATTEMPT_STATUS
, SUA.ADMINISTRATIVE_UNIT_STATUS
, SUA.DISCONTINUED_DT
, SUA.RULE_WAIVED_DT
, SUA.RULE_WAIVED_PERSON_ID
, NULL
, SUA.NO_ASSESSMENT_IND
, SUA.SUP_UNIT_CD
, SUA.SUP_VERSION_NUMBER
, SUA.EXAM_LOCATION_CD
, SUA.ALTERNATIVE_TITLE
, SUA.OVERRIDE_ENROLLED_CP
, SUA.OVERRIDE_EFTSU
, SUA.OVERRIDE_ACHIEVABLE_CP
, SUA.OVERRIDE_OUTCOME_DUE_DT
, SUA.OVERRIDE_CREDIT_REASON
, SUA.CREATED_BY
, SUA.CREATION_DATE
, SUA.LAST_UPDATED_BY
, SUA.LAST_UPDATE_DATE
, SUA.LAST_UPDATE_LOGIN
, SUA.ADMINISTRATIVE_PRIORITY
, SUA.WAITLIST_DT
, SUA.WAITLIST_MANUAL_IND
, SUA.DCNT_REASON_CD
, SUA. GS_VERSION_NUMBER
, SUA.ENR_METHOD_TYPE
, SUA.FAILED_UNIT_RULE
, SUA.CART
, SUA.RSV_SEAT_EXT_ID
, SUA.ORG_UNIT_CD
, SUA.SESSION_ID
, SUA.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, SUA.DEG_AUD_DETAIL_ID DEG_AUD_DETAIL_ID
, SUA.STUDENT_CAREER_TRANSCRIPT
, SUA.STUDENT_CAREER_STATISTICS
, SUA.SUBTITLE
, SUA.ATTRIBUTE_CATEGORY
, SUA.ATTRIBUTE1
, SUA.ATTRIBUTE2
, SUA.ATTRIBUTE3
, SUA.ATTRIBUTE4
, SUA.ATTRIBUTE5
, SUA.ATTRIBUTE6
, SUA.ATTRIBUTE7
, SUA.ATTRIBUTE8
, SUA.ATTRIBUTE9
, SUA.ATTRIBUTE10
, SUA.ATTRIBUTE11
, SUA.ATTRIBUTE12
, SUA.ATTRIBUTE13
, SUA.ATTRIBUTE14
, SUA.ATTRIBUTE15
, SUA.ATTRIBUTE16
, SUA.ATTRIBUTE17
, SUA.ATTRIBUTE18
, SUA.ATTRIBUTE19
, SUA.ATTRIBUTE20
, SUA.WLST_PRIORITY_WEIGHT_NUM
, SUA.WLST_PREFERENCE_WEIGHT_NUM
, SUA.CORE_INDICATOR_CODE
, SUA.UPD_AUDIT_FLAG
, SUA.SS_SOURCE_IND
FROM IGS_EN_SU_ATTEMPT SUA
, HZ_PARTIES PE1
WHERE SUA.RULE_WAIVED_PERSON_ID IS NULL
AND PE1.PARTY_ID = SUA.PERSON_ID UNION SELECT SUA2.ROWID
, SUA2.PERSON_ID
, PE3.PARTY_NUMBER
, SUA2.COURSE_CD
, SUA2.UNIT_CD
, SUA2.VERSION_NUMBER
, SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER
, IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER)
, IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER)
, SUA2.LOCATION_CD
, SUA2.UNIT_CLASS
, SUA2.CI_START_DT
, SUA2.CI_END_DT
, SUA2.UOO_ID
, SUA2.ENROLLED_DT
, SUA2.UNIT_ATTEMPT_STATUS
, SUA2.ADMINISTRATIVE_UNIT_STATUS
, SUA2.DISCONTINUED_DT
, SUA2.RULE_WAIVED_DT
, SUA2.RULE_WAIVED_PERSON_ID
, PE2.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.CREATED_BY
, SUA2.CREATION_DATE
, SUA2.LAST_UPDATED_BY
, SUA2.LAST_UPDATE_DATE
, SUA2.LAST_UPDATE_LOGIN
, SUA2.ADMINISTRATIVE_PRIORITY
, SUA2.WAITLIST_DT
, SUA2.WAITLIST_MANUAL_IND
, SUA2.DCNT_REASON_CD
, SUA2. GS_VERSION_NUMBER
, SUA2.ENR_METHOD_TYPE
, SUA2.FAILED_UNIT_RULE
, SUA2.CART
, SUA2.RSV_SEAT_EXT_ID
, SUA2.ORG_UNIT_CD
, SUA2.SESSION_ID
, SUA2.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, SUA2.DEG_AUD_DETAIL_ID DEG_AUD_DETAIL_ID
, SUA2.STUDENT_CAREER_TRANSCRIPT
, SUA2.STUDENT_CAREER_STATISTICS
, SUA2.SUBTITLE
, SUA2.ATTRIBUTE_CATEGORY
, SUA2.ATTRIBUTE1
, SUA2.ATTRIBUTE2
, SUA2.ATTRIBUTE3
, SUA2.ATTRIBUTE4
, SUA2.ATTRIBUTE5
, SUA2.ATTRIBUTE6
, SUA2.ATTRIBUTE7
, SUA2.ATTRIBUTE8
, SUA2.ATTRIBUTE9
, SUA2.ATTRIBUTE10
, SUA2.ATTRIBUTE11
, SUA2.ATTRIBUTE12
, SUA2.ATTRIBUTE13
, SUA2.ATTRIBUTE14
, SUA2.ATTRIBUTE15
, SUA2.ATTRIBUTE16
, SUA2.ATTRIBUTE17
, SUA2.ATTRIBUTE18
, SUA2.ATTRIBUTE19
, SUA2.ATTRIBUTE20
, SUA2.WLST_PRIORITY_WEIGHT_NUM
, SUA2.WLST_PREFERENCE_WEIGHT_NUM
, SUA2.CORE_INDICATOR_CODE
, SUA2.UPD_AUDIT_FLAG
, SUA2.SS_SOURCE_IND
FROM IGS_EN_SU_ATTEMPT SUA2
, HZ_PARTIES PE2
, HZ_PARTIES PE3
WHERE SUA2.RULE_WAIVED_PERSON_ID IS NOT NULL
AND SUA2.RULE_WAIVED_PERSON_ID = PE2.PARTY_ID
AND SUA2.PERSON_ID = PE3.PARTY_ID

Columns

Name
ROW_ID
PERSON_ID
PERSON_NUMBER
COURSE_CD
UNIT_CD
VERSION_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
ACAD_ALTERNATE_CODE
TEACH_ALTERNATE_CODE
LOCATION_CD
UNIT_CLASS
CI_START_DT
CI_END_DT
UOO_ID
ENROLLED_DT
UNIT_ATTEMPT_STATUS
ADMINISTRATIVE_UNIT_STATUS
DISCONTINUED_DT
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
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ADMINISTRATIVE_PRIORITY
WAITLIST_DT
WAITLIST_MANUAL_IND
DCNT_REASON_CD
GS_VERSION_NUMBER
ENR_METHOD_TYPE
FAILED_UNIT_RULE
CART
RSV_SEAT_EXT_ID
ORG_UNIT_CD
SESSION_ID
GRADING_SCHEMA_CODE
DEG_AUD_DETAIL_ID
STUDENT_CAREER_TRANSCRIPT
STUDENT_CAREER_STATISTICS
SUBTITLE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
WLST_PRIORITY_WEIGHT_NUM
WLST_PREFERENCE_WEIGHT_NUM
CORE_INDICATOR_CODE
UPD_AUDIT_FLAG
SS_SOURCE_IND