[Home] [Help]
View: IGS_EN_UNIT_SET_ACTIVE_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | IGS_EN_UNIT_SET_ACTIVE_V describes the active unit sets that are available for a given specific period. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT US.UNIT_SET_CD
, US.SHORT_TITLE
, ' '
, US.UNIT_SET_CAT
, US.START_DT
, US.UNIT_SET_STATUS
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
, US.LAST_UPDATE_LOGIN FROM IGS_EN_UNIT_SET US
, IGS_EN_UNIT_SET_STAT USS
WHERE US.UNIT_SET_STATUS = USS.UNIT_SET_STATUS AND USS.S_UNIT_SET_STATUS = 'ACTIVE' AND US.EXPIRY_DT IS NULL
Columns
| Name |
| UNIT_SET_CD |
| SHORT_TITLE |
| LINKED_IND |
| UNIT_SET_CAT |
| START_DT |
| UNIT_SET_STATUS |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATE_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |