VIEW: APPS.IGS_EN_STDNT_PS_ATT

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)