[Home] [Help]
View: IGSBV_ST_UNIT_SET_ATT_COST_CNT
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Base business view to allow queries on Student Unit Set Attempt Cost Center HESA Details. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT UCC.HE_SUSA_CC_ID HE_SUSA_CC_ID
, UCC.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, UCC.COURSE_CD PROGRAM_CODE
, UCC.UNIT_SET_CD UNIT_SET_CODE
, UCC.SEQUENCE_NUMBER SEQUENCE_NUMBER
, UCC.COST_CENTRE SUSA_COST_CENTRE
, UCC.SUBJECT SUSA_SUBJ
, UCC.PROPORTION SUSA_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_EN_SUSA_CC UCC
, HZ_PARTIES PER
WHERE PER.PARTY_ID = UCC.PERSON_ID WITH READ ONLY
Columns
| Name |
| HE_SUSA_CC_ID |
| PERSON_ID |
| PERSON_NUMBER |
| PROGRAM_CODE |
| UNIT_SET_CODE |
| SEQUENCE_NUMBER |
| SUSA_COST_CENTRE |
| SUSA_SUBJ |
| SUSA_COST_CENTRE_SUBJ_PROP |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |