[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Full View for Program Offering Option Unit Set HESA Details - Organizations |
| Implementation/DBA Data: | Not implemented in this database |
SELECT POU.HESA_POOUS_OU_ID HESA_POOUS_OU_ID
, POU.COURSE_CD PROGRAM_CODE
, PS.TITLE PROGRAM_TITLE
, PS.SHORT_TITLE PROGRAM_SHORT_TITLE
, PS.ABBREVIATION PROGRAM_ABBREVIATION
, POU.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, POU.CAL_TYPE CALENDAR_TYPE
, CA.DESCRIPTION CALENDAR_DESC
, CA.ABBREVIATION CALENDAR_ABBREVIATION
, POU.LOCATION_CD LOCATION_CODE
, ( SELECT DESCRIPTION
FROM IGS_AD_LOCATION_ALL
WHERE LOCATION_CD = POU.LOCATION_CD) LOCATION_DESC
, POU.ATTENDANCE_MODE ATTENDANCE_MODE
, ( SELECT DESCRIPTION
FROM IGS_EN_ATD_MODE_ALL
WHERE ATTENDANCE_MODE = POU.ATTENDANCE_MODE ) ATTENDANCE_MODE_DESC
, POU.ATTENDANCE_TYPE ATTENDANCE_TYPE
, ( SELECT DESCRIPTION
FROM IGS_EN_ATD_TYPE_ALL
WHERE ATTENDANCE_TYPE = POU.ATTENDANCE_TYPE ) ATTENDANCE_TYPE_DESC
, POU.UNIT_SET_CD UNIT_SET_CODE
, EN.TITLE UNIT_SET_TITLE
, EN.SHORT_TITLE UNIT_SET_SHORT_TITLE
, EN.ABBREVIATION UNIT_SET_ABBREVIATION
, POU.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, POU.ORGANIZATION_UNIT ORGANIZATION_UNIT_CODE
, ( SELECT HP.PARTY_NAME
FROM HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
WHERE IHP.OSS_ORG_UNIT_CD = POU.ORGANIZATION_UNIT
AND IHP.PARTY_ID = HP.PARTY_ID) ORGANIZATION_UNIT_NAME
, POU.PROPORTION ORGANIZATION_UNIT_PROP
, POU.CREATED_BY CREATED_BY
, POU.CREATION_DATE CREATION_DATE
, POU.LAST_UPDATED_BY LAST_UPDATED_BY
, POU.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_POOUS_OU_ALL POU
, IGS_PS_VER_ALL PS
, IGS_EN_UNIT_SET_ALL EN
, IGS_CA_TYPE CA
WHERE POU.COURSE_CD = PS.COURSE_CD
AND POU.CRV_VERSION_NUMBER = PS.VERSION_NUMBER
AND POU.UNIT_SET_CD = EN.UNIT_SET_CD
AND POU.US_VERSION_NUMBER = EN.VERSION_NUMBER
AND POU.CAL_TYPE = CA.CAL_TYPE WITH READ ONLY