[Home] [Help]
View: IGSBV_ORG_HESA_COST_CENTRES
Product: | IGS - Student System (Obsolete) |
Description: | Base business view to allow queries on Org Unit HESA Cost Center Details |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT OUCC.HESA_OU_CC_ID HESA_OU_CC_ID
, OUCC.ORG_UNIT_CD ORG_UNIT_CODE
, OUCC.COST_CENTRE ORG_UNIT_COST_CENTRE
, OUCC.SUBJECT ORG_UNIT_SUBJ
, OUCC.PROPORTION ORG_UNIT_COST_CENTRE_SUBJ_PROP
, OUCC.CREATED_BY CREATED_BY
, OUCC.CREATION_DATE CREATION_DATE
, OUCC.LAST_UPDATED_BY LAST_UPDATED_BY
, OUCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_OU_CC OUCC WITH READ ONLY
Columns
Name |
HESA_OU_CC_ID |
ORG_UNIT_CODE |
ORG_UNIT_COST_CENTRE |
ORG_UNIT_SUBJ |
ORG_UNIT_COST_CENTRE_SUBJ_PROP |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |