[Home] [Help]
View: IGSBV_USEC_X_LISTED_GROUPS
Product: | IGS - Student System (Obsolete) |
Description: | This is the base view which describes Unit Sections that are part of the Unit Section Cross-Listed Group. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT US.USEC_X_LISTED_GROUP_MEM_ID
, US.UOO_ID UNI_SECTION_ID
, US.PARENT PARENT_INDICATOR
, US.USEC_X_LISTED_GROUP_ID
, UN.UNIT_CD
, UN.VERSION_NUMBER
, UN.CAL_TYPE
, UN.CI_SEQUENCE_NUMBER
, UN.LOCATION_CD
, UN.UNIT_CLASS
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
FROM IGS_PS_USEC_X_GRPMEM US
, IGS_PS_UNIT_OFR_OPT_ALL UN
WHERE UN.UOO_ID = US.UOO_ID WITH READ ONLY
Columns
Name |
USEC_X_LISTED_GROUP_MEM_ID |
UNIT_SECTION_ID |
PARENT_INDICATOR |
USEC_X_LISTED_GROUP_ID |
UNIT_CODE |
VERSION_NUMBER |
CALENDAR_TYPE |
CAL_INST_SEQUENCE_NUMBER |
LOCATION_CODE |
UNIT_CLASS |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |