[Home] [Help]
View: IGSBV_PRG_UK_STAT_COST_CENTRES
Product: | IGS - Student System (Obsolete) |
Description: | Base View for UK Statistics Program Cost Center Details |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PC.HE_PROG_CC_ID HESA_STATS_PROGRAM_CC_ID
, PC.COURSE_CD PROGRAM_CODE
, PC.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, PC.COST_CENTRE PROGRAM_COST_CENTRE
, PC.SUBJECT PROGRAM_SUBJECT
, PC.PROPORTION PROGRAM_COST_CENTRE_SUBJ_PROP
, PC.CREATED_BY CREATED_BY
, PC.CREATION_DATE CREATION_DATE
, PC.LAST_UPDATED_BY LAST_UPDATED_BY
, PC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_ST_PROG_CC PC WITH READ ONLY
Columns
Name |
HESA_STATS_PROGRAM_CC_ID |
PROGRAM_CODE |
PROGRAM_VERSION_NUMBER |
PROGRAM_COST_CENTRE |
PROGRAM_SUBJECT |
PROGRAM_COST_CENTRE_SUBJ_PROP |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |