VIEW: APPS.IGS_PR_STDNT_PS_ATT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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