Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This is a full view, which describes the organizational units which own a program and the percentage of ownership division. |
Implementation/DBA Data: | Not implemented in this database |
SELECT OW.COURSE_CD PROGRAM_CODE
, OW.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, OW.ORG_UNIT_CD ORGANIZATION_UNIT_CODE
, OW.OU_START_DT ORGANIZATION_UNIT_START_DATE
, OW.PERCENTAGE PERCENTAGE_ALLOCATION
, VE.TITLE PROGRAM_TITLE
, PA.PARTY_NAME ORGANIZATION_UNIT_DESCRIPTION
, OW.CREATED_BY
, OW.CREATION_DATE
, OW.LAST_UPDATED_BY
, OW.LAST_UPDATE_DATE
FROM IGS_PS_OWN OW
, IGS_PS_VER_ALL VE
, IGS_OR_INST_ORG_BASE_V PA
WHERE OW.COURSE_CD = VE.COURSE_CD
AND OW.VERSION_NUMBER = VE.VERSION_NUMBER
AND OW.ORG_UNIT_CD = PA.PARTY_NUMBER WITH READ ONLY