[Home] [Help]
View: IGS_HE_POUS_OU_DTL_V
Product: | IGS - Student System |
Description: | HESA Program Offering Option Organization Unit Details |
Implementation/DBA Data: |
APPS.IGS_HE_POUS_OU_DTL_V
|
View Text
SELECT A.ROWID ROW_ID
, A.HESA_POOUS_OU_ID
, A.COURSE_CD
, A.CRV_VERSION_NUMBER
, A.CAL_TYPE
, A.LOCATION_CD
, A.ATTENDANCE_MODE
, A.ATTENDANCE_TYPE
, A.UNIT_SET_CD
, A.US_VERSION_NUMBER
, A.ORGANIZATION_UNIT
, B.START_DT
, B.DESCRIPTION
, A.PROPORTION
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN FROM IGS_HE_POOUS_OU A
, IGS_OR_UNIT B
WHERE A.ORGANIZATION_UNIT = B.ORG_UNIT_CD
Columns
Name |
ROW_ID |
HESA_POOUS_OU_ID |
COURSE_CD |
CRV_VERSION_NUMBER |
CAL_TYPE |
LOCATION_CD |
ATTENDANCE_MODE |
ATTENDANCE_TYPE |
UNIT_SET_CD |
US_VERSION_NUMBER |
ORGANIZATION_UNIT |
START_DATE |
ORGANIZATION_UNIT_DESC |
PROPORTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |