[Home] [Help]
View: IGSBV_ST_PROG_ATT_COST_CENTRES
Product: | IGS - Student System (Obsolete) |
Description: | Base business view to allow queries on Student Program Attempt Cost Center HESA details. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT HCC.HE_SPA_CC_ID HESA_SPA_CC_ID
, HCC.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, HCC.COURSE_CD PROGRAM_CODE
, HCC.COST_CENTRE SPA_COST_CENTRE
, HCC.SUBJECT SPA_SUBJ
, HCC.PROPORTION SPA_COST_CENTRE_SUBJ_PROP
, HCC.CREATED_BY CREATED_BY
, HCC.CREATION_DATE CREATION_DATE
, HCC.LAST_UPDATED_BY LAST_UPDATED_BY
, HCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_ST_SPA_CC HCC
, HZ_PARTIES PER
WHERE HCC.PERSON_ID = PER.PARTY_ID WITH READ ONLY
Columns
Name |
HESA_SPA_CC_ID |
PERSON_ID |
PERSON_NUMBER |
PROGRAM_CODE |
SPA_COST_CENTRE |
SPA_SUBJ |
SPA_COST_CENTRE_SUBJ_PROP |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |