VIEW: APPS.IGS_FI_STDNT_PS_ATT_CAT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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