Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT USAS.ROWID ROW_ID
, USAS.UNIT_SECTION_ASSESSMENT_ID UNIT_SECTION_ASSESSMENT_ID
, USAS.UOO_ID UOO_ID
, USAS.FINAL_EXAM_DATE FINAL_EXAM_DATE
, USAS.EXAM_START_TIME EXAM_START_TIME
, USAS.EXAM_END_TIME EXAM_END_TIME
, USAS.LOCATION_CD LOCATION_CD
, LOC.DESCRIPTION LOCATION_DESC
, USAS.BUILDING_CODE BUILDING_CODE
, BLD.DESCRIPTION BUILDING_DESC
, USAS.ROOM_CODE ROOM_CODE
, ROM.DESCRIPTION ROOM_DESC
, USAS.CREATED_BY CREATED_BY
, USAS.CREATION_DATE CREATION_DATE
, USAS.LAST_UPDATED_BY LAST_UPDATED_BY
, USAS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USAS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_AS USAS
, IGS_AD_LOCATION LOC
, IGS_AD_BUILDING BLD
, IGS_AD_ROOM ROM
WHERE USAS.LOCATION_CD = LOC.LOCATION_CD
AND USAS.BUILDING_CODE = BLD.BUILDING_ID (+)
AND USAS.ROOM_CODE = ROM.ROOM_ID (+)