[Home] [Help]
View: IGSBV_UNIT_STAT_COST_CENTRES
View Text
SELECT UCC.HESA_ST_UV_CC_ID HESA_STATS_UNIT_CC_ID
, UCC.UNIT_CD UNIT_CODE
, UCC.VERSION_NUMBER UNIT_VERSION_NUMBER
, UCC.COST_CENTRE UNIT_COST_CENTRE
, UCC.SUBJECT UNIT_SUBJECT
, UCC.PROPORTION UNIT_COST_CENTRE_SUBJ_PROP
, UCC.CREATED_BY CREATED_BY
, UCC.CREATION_DATE CREATION_DATE
, UCC.LAST_UPDATED_BY LAST_UPDATED_BY
, UCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_ST_UV_CC_ALL UCC WITH READ ONLY
Columns
Name |
HESA_STATS_UNIT_CC_ID |
UNIT_CODE |
UNIT_VERSION_NUMBER |
UNIT_COST_CENTRE |
UNIT_SUBJECT |
UNIT_COST_CENTRE_SUBJ_PROP |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |