Product: | IGS - Student System |
---|---|
Description: | This view contains the data of student attempts for a given specific program structure. |
Implementation/DBA Data: | APPS.IGS_EN_STDNT_PS_ATT |
SELECT ROWID ROW_ID
, ORG_ID
, PERSON_ID
, COURSE_CD
, VERSION_NUMBER
, CAL_TYPE
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, COO_ID
, STUDENT_CONFIRMED_IND
, COMMENCEMENT_DT
, COURSE_ATTEMPT_STATUS
, PROGRESSION_STATUS
, DERIVED_ATT_TYPE
, DERIVED_ATT_MODE
, PROVISIONAL_IND
, DISCONTINUED_DT
, DISCONTINUATION_REASON_CD
, LAPSED_DT
, FUNDING_SOURCE
, EXAM_LOCATION_CD
, DERIVED_COMPLETION_YR
, DERIVED_COMPLETION_PERD
, NOMINATED_COMPLETION_YR
, NOMINATED_COMPLETION_PERD
, RULE_CHECK_IND
, WAIVE_OPTION_CHECK_IND
, LAST_RULE_CHECK_DT
, PUBLISH_OUTCOMES_IND
, COURSE_RQRMNT_COMPLETE_IND
, COURSE_RQRMNTS_COMPLETE_DT
, S_COMPLETED_SOURCE_TYPE
, OVERRIDE_TIME_LIMITATION
, ADVANCED_STANDING_IND
, FEE_CAT
, CORRESPONDENCE_CAT
, SELF_HELP_GROUP_IND
, LOGICAL_DELETE_DT
, ADM_ADMISSION_APPL_NUMBER
, ADM_NOMINATED_COURSE_CD
, ADM_SEQUENCE_NUMBER
, LAST_DATE_OF_ATTENDANCE
, DROPPED_BY
, IGS_PR_CLASS_STD_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PRIMARY_PROGRAM_TYPE
, PRIMARY_PROG_TYPE_SOURCE
, CATALOG_CAL_TYPE
, CATALOG_SEQ_NUM
, KEY_PROGRAM
, OVERRIDE_CMPL_DT
, MANUAL_OVR_CMPL_DT_IND
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, FUTURE_DATED_TRANS_FLAG
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) =NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)