VIEW: APPS.IGS_AD_STDNT_PS_ATT_V

Source

View Text - Preformatted

SELECT STD.ROWID ROW_ID, STD.PERSON_ID, PE.PERSON_NUMBER, STD.COURSE_CD, STD.VERSION_NUMBER, STD.CAL_TYPE, STD.LOCATION_CD, STD.ATTENDANCE_MODE, STD.ATTENDANCE_TYPE, STD.COO_ID, STD.STUDENT_CONFIRMED_IND, STD.COMMENCEMENT_DT, STD.COURSE_ATTEMPT_STATUS, STD.PROGRESSION_STATUS, STD.DERIVED_ATT_TYPE, STD.DERIVED_ATT_MODE, STD.PROVISIONAL_IND, STD.DISCONTINUED_DT, STD.DISCONTINUATION_REASON_CD, STD.LAPSED_DT, STD.FUNDING_SOURCE, STD.EXAM_LOCATION_CD, STD.DERIVED_COMPLETION_YR, STD.DERIVED_COMPLETION_PERD, STD.NOMINATED_COMPLETION_YR, STD.NOMINATED_COMPLETION_PERD, STD.RULE_CHECK_IND, STD.WAIVE_OPTION_CHECK_IND, STD.LAST_RULE_CHECK_DT, STD.PUBLISH_OUTCOMES_IND, STD.COURSE_RQRMNT_COMPLETE_IND, STD.COURSE_RQRMNTS_COMPLETE_DT, STD.S_COMPLETED_SOURCE_TYPE, STD.OVERRIDE_TIME_LIMITATION, STD.ADVANCED_STANDING_IND, STD.FEE_CAT, STD.CORRESPONDENCE_CAT, STD.SELF_HELP_GROUP_IND, STD.LOGICAL_DELETE_DT, STD.ADM_ADMISSION_APPL_NUMBER, STD.ADM_NOMINATED_COURSE_CD, STD.ADM_SEQUENCE_NUMBER, STD.CREATED_BY, STD.CREATION_DATE, STD.LAST_UPDATED_BY, STD.LAST_UPDATE_DATE, STD.LAST_UPDATE_LOGIN, STD.REQUEST_ID, STD.PROGRAM_APPLICATION_ID, STD.PROGRAM_ID, STD.PROGRAM_UPDATE_DATE FROM IGS_EN_STDNT_PS_ATT STD, IGS_PE_PERSON_BASE_V PE WHERE STD.PERSON_ID=PE.PERSON_ID

View Text - HTML Formatted

SELECT STD.ROWID ROW_ID
, STD.PERSON_ID
, PE.PERSON_NUMBER
, STD.COURSE_CD
, STD.VERSION_NUMBER
, STD.CAL_TYPE
, STD.LOCATION_CD
, STD.ATTENDANCE_MODE
, STD.ATTENDANCE_TYPE
, STD.COO_ID
, STD.STUDENT_CONFIRMED_IND
, STD.COMMENCEMENT_DT
, STD.COURSE_ATTEMPT_STATUS
, STD.PROGRESSION_STATUS
, STD.DERIVED_ATT_TYPE
, STD.DERIVED_ATT_MODE
, STD.PROVISIONAL_IND
, STD.DISCONTINUED_DT
, STD.DISCONTINUATION_REASON_CD
, STD.LAPSED_DT
, STD.FUNDING_SOURCE
, STD.EXAM_LOCATION_CD
, STD.DERIVED_COMPLETION_YR
, STD.DERIVED_COMPLETION_PERD
, STD.NOMINATED_COMPLETION_YR
, STD.NOMINATED_COMPLETION_PERD
, STD.RULE_CHECK_IND
, STD.WAIVE_OPTION_CHECK_IND
, STD.LAST_RULE_CHECK_DT
, STD.PUBLISH_OUTCOMES_IND
, STD.COURSE_RQRMNT_COMPLETE_IND
, STD.COURSE_RQRMNTS_COMPLETE_DT
, STD.S_COMPLETED_SOURCE_TYPE
, STD.OVERRIDE_TIME_LIMITATION
, STD.ADVANCED_STANDING_IND
, STD.FEE_CAT
, STD.CORRESPONDENCE_CAT
, STD.SELF_HELP_GROUP_IND
, STD.LOGICAL_DELETE_DT
, STD.ADM_ADMISSION_APPL_NUMBER
, STD.ADM_NOMINATED_COURSE_CD
, STD.ADM_SEQUENCE_NUMBER
, STD.CREATED_BY
, STD.CREATION_DATE
, STD.LAST_UPDATED_BY
, STD.LAST_UPDATE_DATE
, STD.LAST_UPDATE_LOGIN
, STD.REQUEST_ID
, STD.PROGRAM_APPLICATION_ID
, STD.PROGRAM_ID
, STD.PROGRAM_UPDATE_DATE
FROM IGS_EN_STDNT_PS_ATT STD
, IGS_PE_PERSON_BASE_V PE
WHERE STD.PERSON_ID=PE.PERSON_ID