[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SE.ROWID ROW_ID
, P.PARTY_NUMBER PERSON_NUMBER
, SE.ASS_ID ASS_ID
, SE.EXAM_CAL_TYPE EXAM_CAL_TYPE
, SE.EXAM_CI_SEQUENCE_NUMBER EXAM_CI_SEQUENCE_NUMBER
, SE.DT_ALIAS DT_ALIAS
, SE.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER
, SE.START_TIME START_TIME
, SE.END_TIME END_TIME
, SE.ESE_ID ESE_ID
, SE.VENUE_CD VENUE_CD
, SE.PERSON_ID PERSON_ID
, SE.COURSE_CD COURSE_CD
, SE.UNIT_CD UNIT_CD
, SE.CAL_TYPE CAL_TYPE
, SE.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, SE.CREATION_DT CREATION_DT
, SE.ATTENDANCE_IND ATTENDANCE_IND
, SE.TIMESLOT TIMESLOT
, SE.TIMESLOT_DURATION TIMESLOT_DURATION
, SE.SEAT_NUMBER SEAT_NUMBER
, SE.CREATED_BY CREATED_BY
, SE.CREATION_DATE CREATION_DATE
, SE.LAST_UPDATED_BY LAST_UPDATED_BY
, SE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SE.UOO_ID
FROM IGS_AS_STD_EXM_INSTN SE
, HZ_PARTIES P
WHERE SE.PERSON_ID = P.PARTY_ID