[Home] [Help]
View: IGS_AS_SUSA_V
Product: | IGS - Student System (Obsolete) |
Description: | View for Student unit bset attempt |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PERSON_ID
, COURSE_CD
, UNIT_SET_CD
, SEQUENCE_NUMBER
, US_VERSION_NUMBER
, SUBSTR(LPAD(' '
, 2*(LEVEL-1)) || UNIT_SET_CD
, 1
, 40)
, END_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_AS_SU_SETATMPT START WITH PARENT_UNIT_SET_CD IS NULL CONNECT BY PRIOR PERSON_ID = PERSON_ID AND PRIOR COURSE_CD = COURSE_CD AND PRIOR UNIT_SET_CD = PARENT_UNIT_SET_CD AND PRIOR SEQUENCE_NUMBER = PARENT_SEQUENCE_NUMBER
Columns
Name |
PERSON_ID |
COURSE_CD |
UNIT_SET_CD |
SEQUENCE_NUMBER |
US_VERSION_NUMBER |
UNIT_SET_CD_DISPLAY_LVL |
END_DT |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |