Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This is the full view which describes the sponsorship information for a unit section. |
Implementation/DBA Data: | Not implemented in this database |
SELECT US.UNIT_SECTION_SPONSORSHIP_ID
, US.UOO_ID UNIT_SECTION_ID
, US.ORGANIZATION_CODE
, US.SPONSORSHIP_PERCENTAGE
, UN.UNIT_CD UNIT_CODE
, UN.VERSION_NUMBER
, UN.CAL_TYPE CALENDAR_TYPE
, UN.CI_SEQUENCE_NUMBER CAL_INST_SEQUENCE_NUMBER
, UN.LOCATION_CD LOCATION_CODE
, UN.UNIT_CLASS
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
FROM IGS_PS_USEC_SPNSRSHP US
, IGS_PS_UNIT_OFR_OPT_ALL UN
WHERE US.UOO_ID = UN.UOO_ID WITH READ ONLY