A new view to replace the existing cost center table at year of program level to allow users to record org unit details along with the cost center details for a year of program
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT YPCC.ROWID ROW_ID , YPCC.HESA_POOUS_CC_ID HESA_POOUS_CC_ID , YPCC.HESA_POOUS_OU_ID HESA_POOUS_OU_ID , YPCC.COST_CENTRE COST_CENTRE , (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_COSTCN' AND VALUE = YPCC.COST_CENTRE) COST_CENTRE_DESC , YPCC.SUBJECT SUBJECT , (SELECT DESCRIPTION FROM IGS_PS_FLD_OF_STUDY WHERE FIELD_OF_STUDY = YPCC.SUBJECT) SUBJECT_DESC , YPCC.PROPORTION PROPORTION , YPCC.CREATED_BY CREATED_BY , YPCC.CREATION_DATE CREATION_DATE , YPCC.LAST_UPDATED_BY LAST_UPDATED_BY , YPCC.LAST_UPDATE_DATE LAST_UPDATE_DATE , YPCC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_HE_POOUS_OU_CC YPCC