eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSFV_POOUS_HESA_COST_CENTRES

Product:	IGS - Student System (Obsolete)
Description:	Full business view to allow queries on Program HESA Cost Center Details
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT YPCC.HESA_POOUS_CC_ID HESA_POOUS_CC_ID
, YPCC.HESA_POOUS_OU_ID HESA_POOUS_OU_ID
, YPOU.COURSE_CD PROGRAM_CODE
, PRG.TITLE PROGRAM_TITLE
, PRG.SHORT_TITLE PROGRAM_SHORT_TITLE
, PRG.ABBREVIATION PROGRAM_ABBREVIATION
, YPOU.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, YPOU.CAL_TYPE CALENDAR_TYPE
, (SELECT DESCRIPTION
FROM IGS_CA_TYPE
WHERE CAL_TYPE = YPOU.CAL_TYPE) CALENDAR_DESC
, (SELECT ABBREVIATION
FROM IGS_CA_TYPE
WHERE CAL_TYPE = YPOU.CAL_TYPE) CALENDAR_ABBREVIATION
, YPOU.LOCATION_CD LOCATION_CODE
, (SELECT DESCRIPTION
FROM IGS_AD_LOCATION_ALL
WHERE LOCATION_CD = YPOU.LOCATION_CD) LOCATION_DESC
, YPOU.ATTENDANCE_MODE ATTENDANCE_MODE
, (SELECT DESCRIPTION
FROM IGS_EN_ATD_MODE_ALL
WHERE ATTENDANCE_MODE = YPOU.ATTENDANCE_MODE) ATTENDANCE_MODE_DESC
, YPOU.ATTENDANCE_TYPE ATTENDANCE_TYPE
, (SELECT DESCRIPTION
FROM IGS_EN_ATD_TYPE_ALL
WHERE ATTENDANCE_TYPE = YPOU.ATTENDANCE_TYPE) ATTENDANCE_TYPE_DESC
, YPOU.UNIT_SET_CD UNIT_SET_CODE
, US.TITLE UNIT_SET_TITLE
, US.SHORT_TITLE UNIT_SET_SHORT_TITLE
, US.ABBREVIATION UNIT_SET_ABBREVIATION
, YPOU.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, YPOU.ORGANIZATION_UNIT ORG_UNIT_CODE
, (SELECT HP.PARTY_NAME
FROM HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
WHERE IHP.OSS_ORG_UNIT_CD = YPOU.ORGANIZATION_UNIT
AND IHP.PARTY_ID = HP.PARTY_ID) ORG_UNIT_DESC
, YPCC.COST_CENTRE POOUS_COST_CENTRE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = YPCC.COST_CENTRE) POOUS_COST_CENTRE_DESC
, YPCC.SUBJECT POOUS_SUBJ
, (SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY
WHERE FIELD_OF_STUDY = YPCC.SUBJECT) POOUS_SUBJ_DESC
, YPCC.PROPORTION POOUS_COST_CENTRE_SUBJ_PROP
, YPCC.CREATED_BY CREATED_BY
, YPCC.CREATION_DATE CREATION_DATE
, YPCC.LAST_UPDATED_BY LAST_UPDATED_BY
, YPCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_POOUS_OU_CC YPCC
, IGS_HE_POOUS_OU_ALL YPOU
, IGS_PS_VER_ALL PRG
, IGS_EN_UNIT_SET_ALL US
WHERE YPCC.HESA_POOUS_OU_ID = YPOU.HESA_POOUS_OU_ID
AND PRG.COURSE_CD (+) = YPOU.COURSE_CD
AND PRG.VERSION_NUMBER (+) = YPOU.CRV_VERSION_NUMBER
AND US.UNIT_SET_CD (+) = YPOU.UNIT_SET_CD
AND US.VERSION_NUMBER (+) = YPOU.US_VERSION_NUMBER WITH READ ONLY

Columns

Name
HESA_POOUS_CC_ID
HESA_POOUS_OU_ID
PROGRAM_CODE
PROGRAM_TITLE
PROGRAM_SHORT_TITLE
PROGRAM_ABBREVIATION
PROGRAM_VERSION_NUMBER
CALENDAR_TYPE
CALENDAR_DESC
CALENDAR_ABBREVIATION
LOCATION_CODE
LOCATION_DESC
ATTENDANCE_MODE
ATTENDANCE_MODE_DESC
ATTENDANCE_TYPE
ATTENDANCE_TYPE_DESC
UNIT_SET_CODE
UNIT_SET_TITLE
UNIT_SET_SHORT_TITLE
UNIT_SET_ABBREVIATION
UNIT_SET_VERSION_NUMBER
ORG_UNIT_CODE
ORG_UNIT_DESC
POOUS_COST_CENTRE
POOUS_COST_CENTRE_DESC
POOUS_SUBJ
POOUS_SUBJ_DESC
POOUS_COST_CENTRE_SUBJ_PROP
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE