[Home] [Help]
View: IGS_HE_POUS_OU_DTL_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | HESA Program Offering Option Organization Unit Details |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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 |