Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT SPAT.TERM_RECORD_ID
, SPAT.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SPAT.PROGRAM_CD
, SPAT.PROGRAM_VERSION
, PV.TITLE
, SPAT.ACAD_CAL_TYPE
, CT.DESCRIPTION
, SPAT.TERM_CAL_TYPE
, CT1.DESCRIPTION
, SPAT.TERM_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, SPAT.KEY_PROGRAM_FLAG
, '_LA:KEY_PROGRAM_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SPAT.LOCATION_CD
, LOC.DESCRIPTION
, SPAT.ATTENDANCE_MODE
, AM.DESCRIPTION
, SPAT.ATTENDANCE_TYPE
, ATT.DESCRIPTION
, SPAT.FEE_CAT
, FC.DESCRIPTION
, SPAT.COO_ID
, SPAT.CLASS_STANDING_ID
, PCS.CLASS_STANDING
, '_DF:IGS:IGS_EN_SPA_TERMS_FLEX:SPAT'
, SPAT.CREATED_BY
, SPAT.CREATION_DATE
, SPAT.LAST_UPDATED_BY
, SPAT.LAST_UPDATE_DATE
FROM IGS_EN_SPA_TERMS SPAT
, HZ_PARTIES HP
, IGS_PS_VER_ALL PV
, IGS_CA_INST_ALL CI
, IGS_CA_TYPE CT
, IGS_CA_TYPE CT1
, IGS_AD_LOCATION_ALL LOC
, IGS_EN_ATD_MODE_ALL AM
, IGS_EN_ATD_TYPE_ALL ATT
, IGS_FI_FEE_CAT_ALL FC
, IGS_PR_CLASS_STD PCS
WHERE SPAT.PERSON_ID = HP.PARTY_ID
AND SPAT.PROGRAM_CD = PV.COURSE_CD
AND SPAT.PROGRAM_VERSION = PV.VERSION_NUMBER
AND SPAT.ACAD_CAL_TYPE = CT.CAL_TYPE
AND SPAT.TERM_CAL_TYPE = CT1.CAL_TYPE
AND SPAT.TERM_CAL_TYPE = CI.CAL_TYPE
AND SPAT.TERM_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SPAT.LOCATION_CD = LOC.LOCATION_CD
AND SPAT.ATTENDANCE_MODE = AM.ATTENDANCE_MODE
AND SPAT.ATTENDANCE_TYPE = ATT.ATTENDANCE_TYPE
AND SPAT.FEE_CAT = FC.FEE_CAT(+)
AND SPAT.CLASS_STANDING_ID = PCS.IGS_PR_CLASS_STD_ID(+) WITH READ ONLY