[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Interface View to capture the Scheduler Interface Unit Section Data |
| Implementation/DBA Data: | Not implemented in this database |
SELECT TAB.ROWID ROW_ID
, TAB.INT_USEC_ID INT_USEC_ID
, TAB.CALENDAR_TYPE CALENDAR_TYPE
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, 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.UNIT_SECTION_START_DATE UNIT_SECTION_START_DATE
, TAB.UNIT_SECTION_END_DATE UNIT_SECTION_END_DATE
, TAB.UNIT_SECTION_STATUS UNIT_SECTION_STATUS
, TAB.ENROLLMENT_MAXIMUM ENROLLMENT_MAXIMUM
, TAB.ENROLLMENT_ACTUAL ENROLLMENT_ACTUAL
, TAB.LOCATION_CD LOCATION_CD
, TAB.CAL_START_DT CAL_START_DT
, TAB.CAL_END_DT CAL_END_DT
, TAB.UOO_ID UOO_ID
, TAB.TRANSACTION_ID TRANSACTION_ID
, TAB.ORG_ID ORG_ID
, TAB.ENROLLMENT_EXPECTED
, TAB.OVERRIDE_ENROLLMENT_MAX
, 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.CALL_NUMBER CALL_NUMBER
, TAB.SUBTITLE SUBTITLE
, TAB.ORG_UNIT_DESCRIPTION ORG_UNIT_DESCRIPTION
, TAB.TEACHING_CAL_ALTERNATE_CODE TEACHING_CAL_ALTERNATE_CODE
, TAB.INT_PAT_ID INT_PAT_ID
FROM IGS_PS_SCH_USEC_INT_ALL TAB