Product: | IGS - Student System (Obsolete) |
---|---|
Description: | No longer used |
Implementation/DBA Data: | Not implemented in this database |
SELECT SPA.ROWID ROW_ID
, SPA.ORG_ID
, SPA.PERSON_ID
, SPA.COURSE_CD
, SPA.VERSION_NUMBER
, SPA.CAL_TYPE
, SPA.LOCATION_CD
, SPA.ATTENDANCE_MODE
, SPA.ATTENDANCE_TYPE
, SPA.COO_ID
, SPA.STUDENT_CONFIRMED_IND
, SPA.COMMENCEMENT_DT
, SPA.COURSE_ATTEMPT_STATUS
, SPA.PROGRESSION_STATUS
, SPA.DERIVED_ATT_TYPE
, SPA.DERIVED_ATT_MODE
, SPA.PROVISIONAL_IND
, SPA.DISCONTINUED_DT
, SPA.DISCONTINUATION_REASON_CD
, SPA.LAPSED_DT
, SPA.FUNDING_SOURCE
, SPA.EXAM_LOCATION_CD
, SPA.DERIVED_COMPLETION_YR
, SPA.DERIVED_COMPLETION_PERD
, SPA.NOMINATED_COMPLETION_YR
, SPA.NOMINATED_COMPLETION_PERD
, SPA.RULE_CHECK_IND
, SPA.WAIVE_OPTION_CHECK_IND
, SPA.LAST_RULE_CHECK_DT
, SPA.PUBLISH_OUTCOMES_IND
, SPA.COURSE_RQRMNT_COMPLETE_IND
, SPA.COURSE_RQRMNTS_COMPLETE_DT
, SPA.S_COMPLETED_SOURCE_TYPE
, SPA.OVERRIDE_TIME_LIMITATION
, SPA.ADVANCED_STANDING_IND
, FCCR.FEE_CAT
, SPA.CORRESPONDENCE_CAT
, SPA.SELF_HELP_GROUP_IND
, SPA.LOGICAL_DELETE_DT
, SPA.ADM_ADMISSION_APPL_NUMBER
, SPA.ADM_NOMINATED_COURSE_CD
, SPA.ADM_SEQUENCE_NUMBER
, SPA.LAST_DATE_OF_ATTENDANCE
, SPA.DROPPED_BY
, SPA. IGS_PR_CLASS_STD_ID
, SPA.CREATED_BY
, SPA.CREATION_DATE
, SPA.LAST_UPDATED_BY
, SPA.LAST_UPDATE_DATE
, SPA.LAST_UPDATE_LOGIN
, SPA.REQUEST_ID
, SPA.PROGRAM_APPLICATION_ID
, SPA.PROGRAM_ID
, SPA.PROGRAM_UPDATE_DATE
, SPA.PRIMARY_PROGRAM_TYPE
, SPA.PRIMARY_PROG_TYPE_SOURCE
, SPA.CATALOG_CAL_TYPE
, SPA.CATALOG_SEQ_NUM
, SPA.KEY_PROGRAM
, FCCR.FEE_CAL_TYPE
, FCCR.FEE_CI_SEQUENCE_NUMBER
FROM IGS_EN_STDNT_PS_ATT SPA
, IGS_FI_F_CAT_CAL_REL FCCR
WHERE FCCR.PERSON_ID = SPA.PERSON_ID
AND FCCR.COURSE_CD = SPA.COURSE_CD
AND FCCR.VERSION_NUMBER = SPA.VERSION_NUMBER