View: IGS_PS_SCH_INT

View Text

SELECT TAB.ROWID ROW_ID
, TAB.CALENDAR_TYPE CALENDAR_TYPE
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, TAB.TRANSACTION_TYPE TRANSACTION_TYPE
, TAB.UNIT_SECTION_OCCURRENCE_ID UNIT_SECTION_OCCURRENCE_ID
, TAB.UNIT_CD UNIT_CD
, TAB.VERSION_NUMBER VERSION_NUMBER
, TAB.UNIT_TITLE UNIT_TITLE
, TAB.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CD
, TAB.UNIT_CLASS UNIT_CLASS
, TAB.MONDAY MONDAY
, TAB.TUESDAY TUESDAY
, TAB.WEDNESDAY WEDNESDAY
, TAB.THURSDAY THURSDAY
, TAB.FRIDAY FRIDAY
, TAB.SATURDAY SATURDAY
, TAB.SUNDAY SUNDAY
, TAB.UNIT_SECTION_START_DATE UNIT_SECTION_START_DATE
, TAB.UNIT_SECTION_END_DATE UNIT_SECTION_END_DATE
, TAB.START_TIME START_TIME
, TAB.END_TIME END_TIME
, TAB.ENROLLMENT_MAXIMUM ENROLLMENT_MAXIMUM
, TAB.ENROLLMENT_ACTUAL ENROLLMENT_ACTUAL
, TAB.INSTRUCTOR_ID INSTRUCTOR_ID
, TAB.SURNAME SURNAME
, TAB.BUILDING_CODE BUILDING_CODE
, TAB.ROOM_CODE ROOM_CODE
, TAB.LOCATION_CD LOCATION_CD
, TAB.UNIT_SEC_CROSS_UNIT_SEC_ID UNIT_SEC_CROSS_UNIT_SEC_ID
, TAB.UOO_ID UOO_ID
, TAB.SCHEDULE_STATUS SCHEDULE_STATUS
, TAB.ERROR_TEXT ERROR_TEXT
, TAB.TRANSACTION_ID TRANSACTION_ID
, TAB.ORG_ID ORG_ID
, TAB.INT_OCCURS_ID
, TAB.INT_USEC_ID
, TAB.GIVEN_NAMES
, TAB.MIDDLE_NAME
, TAB.DEDICATED_BUILDING_CODE
, TAB.DEDICATED_ROOM_CODE
, TAB.PREFERRED_BUILDING_CODE
, TAB.PREFERRED_ROOM_CODE
, TAB.TBA_STATUS
, TAB.USO_START_DATE
, TAB.USO_END_DATE
, TAB.BUILDING_ID BUILDING_ID
, TAB.ROOM_ID ROOM_ID
, TAB.DEDICATED_BUILDING_ID DEDICATED_BUILDING_ID
, TAB.DEDICATED_ROOM_ID DEDICATED_ROOM_ID
, TAB.PREFERRED_BUILDING_ID PREFERRED_BUILDING_ID
, TAB.PREFERRED_ROOM_ID PREFERRED_ROOM_ID
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ABORT_FLAG ABORT_FLAG
, TAB.IMPORT_DONE_FLAG IMPORT_DONE_FLAG
, TAB.OCCURRENCE_IDENTIFIER OCCURRENCE_IDENTIFIER
FROM IGS_PS_SCH_INT_ALL TAB

Columns