Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
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