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_PS_USEC_OCCURS

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT USO.ROWID ROW_ID
, USO.UNIT_SECTION_OCCURRENCE_ID UNIT_SECTION_OCCURRENCE_ID
, USO.UOO_ID UOO_ID
, USO.MONDAY MONDAY
, USO.TUESDAY TUESDAY
, USO.WEDNESDAY WEDNESDAY
, USO.THURSDAY THURSDAY
, USO.FRIDAY FRIDAY
, USO.SATURDAY SATURDAY
, USO.SUNDAY SUNDAY
, USO.START_TIME START_TIME
, USO.END_TIME END_TIME
, USO.BUILDING_CODE BUILDING_CODE
, USO.ROOM_CODE ROOM_CODE
, USO.BUILDING_CODE SCHEDULED_BUILDING_CODE
, USO.ROOM_CODE SCHEDULED_ROOM_CODE
, USO.DEDICATED_BUILDING_CODE DEDICATED_BUILDING_CODE
, USO.DEDICATED_ROOM_CODE DEDICATED_ROOM_CODE
, USO.PREFERRED_BUILDING_CODE PREFERRED_BUILDING_CODE
, USO.PREFERRED_ROOM_CODE PREFERRED_ROOM_CODE
, USO.SCHEDULE_STATUS SCHEDULE_STATUS
, USO.STATUS_LAST_UPDATED STATUS_LAST_UPDATED
, USO.INSTRUCTOR_ID INSTRUCTOR_ID
, USO.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, USO.ATTRIBUTE1 ATTRIBUTE1
, USO.ATTRIBUTE2 ATTRIBUTE2
, USO.ATTRIBUTE3 ATTRIBUTE3
, USO.ATTRIBUTE4 ATTRIBUTE4
, USO.ATTRIBUTE5 ATTRIBUTE5
, USO.ATTRIBUTE6 ATTRIBUTE6
, USO.ATTRIBUTE7 ATTRIBUTE7
, USO.ATTRIBUTE8 ATTRIBUTE8
, USO.ATTRIBUTE9 ATTRIBUTE9
, USO.ATTRIBUTE10 ATTRIBUTE10
, USO.ATTRIBUTE11 ATTRIBUTE11
, USO.ATTRIBUTE12 ATTRIBUTE12
, USO.ATTRIBUTE13 ATTRIBUTE13
, USO.ATTRIBUTE14 ATTRIBUTE14
, USO.ATTRIBUTE15 ATTRIBUTE15
, USO.ATTRIBUTE16 ATTRIBUTE16
, USO.ATTRIBUTE17 ATTRIBUTE17
, USO.ATTRIBUTE18 ATTRIBUTE18
, USO.ATTRIBUTE19 ATTRIBUTE19
, USO.ATTRIBUTE20 ATTRIBUTE20
, USO.CREATED_BY CREATED_BY
, USO.CREATION_DATE CREATION_DATE
, USO.LAST_UPDATED_BY LAST_UPDATED_BY
, USO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, USO.ERROR_TEXT ERROR_TEXT
, USO.REQUEST_ID REQUEST_ID
, USO.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, USO.PROGRAM_ID PROGRAM_ID
, USO.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, USO.ORG_ID ORG_ID
, USO.START_DATE START_DATE
, USO.END_DATE END_DATE
, USO.TO_BE_ANNOUNCED TO_BE_ANNOUNCED
, USO.INST_NOTIFY_IND INST_NOTIFY_IND
, USO.NOTIFY_STATUS NOTIFY_STATUS
, USO.PREFERRED_REGION_CODE PREFERRED_REGION_CODE
, USO.NO_SET_DAY_IND NO_SET_DAY_IND
, USO.CANCEL_FLAG CANCEL_FLAG
, USO.OCCURRENCE_IDENTIFIER OCCURRENCE_IDENTIFIER
, USO.ABORT_FLAG ABORT_FLAG
FROM IGS_PS_USEC_OCCURS_ALL USO
WHERE NVL (USO.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
ROW_ID
UNIT_SECTION_OCCURRENCE_ID
UOO_ID
MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
SATURDAY
SUNDAY
START_TIME
END_TIME
BUILDING_CODE
ROOM_CODE
SCHEDULED_BUILDING_CODE
SCHEDULED_ROOM_CODE
DEDICATED_BUILDING_CODE
DEDICATED_ROOM_CODE
PREFERRED_BUILDING_CODE
PREFERRED_ROOM_CODE
SCHEDULE_STATUS
STATUS_LAST_UPDATED
INSTRUCTOR_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ERROR_TEXT
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ORG_ID
START_DATE
END_DATE
TO_BE_ANNOUNCED
INST_NOTIFY_IND
NOTIFY_STATUS
PREFERRED_REGION_CODE
NO_SET_DAY_IND
CANCEL_FLAG
OCCURRENCE_IDENTIFIER
ABORT_FLAG