Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT ESPA.ROWID ROW_ID
, ESPA.PERSON_ID PERSON_ID
, PE.PARTY_NUMBER PERSON_NUMBER
, ESPA.COURSE_CD COURSE_CD
, ESPA.VERSION_NUMBER VERSION_NUMBER
, ESPA.CAL_TYPE CAL_TYPE
, ESPA.LOCATION_CD LOCATION_CD
, ESPA.ATTENDANCE_MODE ATTENDANCE_MODE
, ESPA.ATTENDANCE_TYPE ATTENDANCE_TYPE
, ESPA.COO_ID COO_ID
, ESPA.STUDENT_CONFIRMED_IND STUDENT_CONFIRMED_IND
, ESPA.COMMENCEMENT_DT COMMENCEMENT_DT
, ESPA.COURSE_ATTEMPT_STATUS COURSE_ATTEMPT_STATUS
, ESPA.PROGRESSION_STATUS PROGRESSION_STATUS
, ESPA.DERIVED_ATT_TYPE DERIVED_ATT_TYPE
, ESPA.DERIVED_ATT_MODE DERIVED_ATT_MODE
, ESPA.PROVISIONAL_IND PROVISIONAL_IND
, ESPA.DISCONTINUED_DT DISCONTINUED_DT
, ESPA.DISCONTINUATION_REASON_CD DISCONTINUATION_REASON_CD
, ESPA.LAPSED_DT LAPSED_DT
, ESPA.FUNDING_SOURCE FUNDING_SOURCE
, ESPA.EXAM_LOCATION_CD EXAM_LOCATION_CD
, ESPA.DERIVED_COMPLETION_YR DERIVED_COMPLETION_YR
, ESPA.DERIVED_COMPLETION_PERD DERIVED_COMPLETION_PERD
, ESPA.NOMINATED_COMPLETION_YR NOMINATED_COMPLETION_YR
, ESPA.NOMINATED_COMPLETION_PERD NOMINATED_COMPLETION_PERD
, ESPA.RULE_CHECK_IND RULE_CHECK_IND
, ESPA.WAIVE_OPTION_CHECK_IND WAIVE_OPTION_CHECK_IND
, ESPA.LAST_RULE_CHECK_DT LAST_RULE_CHECK_DT
, ESPA.PUBLISH_OUTCOMES_IND PUBLISH_OUTCOMES_IND
, ESPA.COURSE_RQRMNT_COMPLETE_IND COURSE_RQRMNT_COMPLETE_IND
, ESPA.COURSE_RQRMNTS_COMPLETE_DT COURSE_RQRMNTS_COMPLETE_DT
, ESPA.S_COMPLETED_SOURCE_TYPE S_COMPLETED_SOURCE_TYPE
, ESPA.OVERRIDE_TIME_LIMITATION OVERRIDE_TIME_LIMITATION
, ESPA.ADVANCED_STANDING_IND ADVANCED_STANDING_IND
, ESPA.FEE_CAT FEE_CAT
, ESPA.CORRESPONDENCE_CAT CORRESPONDENCE_CAT
, ESPA.SELF_HELP_GROUP_IND SELF_HELP_GROUP_IND
, ESPA.LOGICAL_DELETE_DT LOGICAL_DELETE_DT
, ESPA.ADM_ADMISSION_APPL_NUMBER ADM_ADMISSION_APPL_NUMBER
, ESPA.ADM_NOMINATED_COURSE_CD ADM_NOMINATED_COURSE_CD
, ESPA.ADM_SEQUENCE_NUMBER ADM_SEQUENCE_NUMBER
, ESPA.CREATED_BY CREATED_BY
, ESPA.CREATION_DATE CREATION_DATE
, ESPA.LAST_UPDATED_BY LAST_UPDATED_BY
, ESPA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ESPA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ESPA.REQUEST_ID REQUEST_ID
, ESPA.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ESPA.PROGRAM_ID PROGRAM_ID
, ESPA.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM IGS_EN_STDNT_PS_ATT_SV ESPA
, HZ_PARTIES PE
WHERE PE.PARTY_ID = ESPA.PERSON_ID