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_SCH_X_USEC_INT

Product:	IGS - Student System (Obsolete)
Description:	Interface View to capture the Scheduler Interface Unit Section Cross Listings Data
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TAB.ROWID ROW_ID
, TAB.INT_USEC_X_USEC_ID INT_USEC_X_USEC_ID
, TAB.INT_USEC_ID INT_USEC_ID
, TAB.UNIT_SEC_CROSS_UNIT_SEC_ID UNIT_SEC_CROSS_UNIT_SEC_ID
, TAB.PARENT_UOO_ID PARENT_UOO_ID
, TAB.CHILD_UOO_ID CHILD_UOO_ID
, TAB.CHILD_UNIT_CD CHILD_UNIT_CD
, TAB.CHILD_VERSION_NUMBER CHILD_VERSION_NUMBER
, TAB.CHILD_TITLE CHILD_TITLE
, TAB.CHILD_CAL_TYPE CHILD_CAL_TYPE
, TAB.CHILD_ALTERNATE_CODE CHILD_ALTERNATE_CODE
, TAB.START_DT START_DT
, TAB.END_DT END_DT
, TAB.CHILD_CI_SEQUENCE_NUMBER CHILD_CI_SEQUENCE_NUMBER
, TAB.CHILD_UNIT_CLASS CHILD_UNIT_CLASS
, TAB.CHILD_UNIT_MODE CHILD_UNIT_MODE
, TAB.CHILD_LOCATION_CD CHILD_LOCATION_CD
, TAB.CHILD_LOCATION_DESCRIPTION CHILD_LOCATION_DESCRIPTION
, TAB.ORG_ID ORG_ID
, TAB.CROSS_LIST_GROUP_NAME
, TAB.CLASS_MAX_ENROLLMENT_NUMBER
, 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
FROM IGS_PS_SCH_X_USEC_INT_ALL TAB

Columns

Name
ROW_ID
INT_USEC_X_USEC_ID
INT_USEC_ID
UNIT_SEC_CROSS_UNIT_SEC_ID
PARENT_UOO_ID
CHILD_UOO_ID
CHILD_UNIT_CD
CHILD_VERSION_NUMBER
CHILD_TITLE
CHILD_CAL_TYPE
CHILD_ALTERNATE_CODE
START_DT
END_DT
CHILD_CI_SEQUENCE_NUMBER
CHILD_UNIT_CLASS
CHILD_UNIT_MODE
CHILD_LOCATION_CD
CHILD_LOCATION_DESCRIPTION
ORG_ID
CROSS_LIST_GROUP_NAME
CLASS_MAX_ENROLLMENT_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN