Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This table holds person's extracirricular activities or interests that are not present in TCA tables HZ_INTEREST |
Implementation/DBA Data: | Not implemented in this database |
SELECT HPI.PERSON_INTEREST_ID
, HEA.HZ_EXTRACURR_ACT_ID
, HPI.PARTY_ID
, HPI.LEVEL_OF_INTEREST
, '_LA:HPI.LEVEL_OF_PARTICIPATION:IGS_LOOKUP_VALUES:PARTICIPATION_LEVEL:MEANING'
, '_LA:HPI.INTEREST_TYPE_CODE:IGS_LOOKUP_VALUES:INTEREST_TYPE:MEANING'
, HPI.COMMENTS
, '_LA:HPI.SPORT_INDICATOR:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, HPI.INTEREST_NAME
, HPI.TEAM
, HPI.SINCE
, HEA.END_DATE
, HEA.HOURS_PER_WEEK
, HEA.WEEKS_PER_YEAR
, '_LA:HEA.ACTIVITY_SOURCE_CD:IGS_LOOKUP_VALUES:ACTIVITY_SOURCE:MEANING'
, HEA.CREATED_BY
, HEA.CREATION_DATE
, HEA.LAST_UPDATED_BY
, HEA.LAST_UPDATE_DATE
, HEA.LAST_UPDATE_LOGIN
FROM HZ_PERSON_INTEREST HPI
, IGS_AD_HZ_EXTRACURR_ACT HEA
WHERE HPI.PERSON_INTEREST_ID = HEA.PERSON_INTEREST_ID WITH READ ONLY