eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSBV_STUDENT_PROGRAM_ATTEMPTS

Product:	IGS - Student System (Obsolete)
Description:	This entity describes a student's attempt at studying a particular course offered by the university.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.CAL_TYPE
, SCA.LOCATION_CD
, SCA.ATTENDANCE_MODE
, SCA.ATTENDANCE_TYPE
, SCA.COO_ID
, SCA.STUDENT_CONFIRMED_IND
, SCA.COMMENCEMENT_DT
, SCA.COURSE_ATTEMPT_STATUS
, SCA.PROGRESSION_STATUS
, SCA.DERIVED_ATT_TYPE
, SCA.DERIVED_ATT_MODE
, SCA.PROVISIONAL_IND
, SCA.DISCONTINUED_DT
, SCA.DISCONTINUATION_REASON_CD
, SCA.LAPSED_DT
, SCA.FUNDING_SOURCE
, SCA.EXAM_LOCATION_CD
, SCA.DERIVED_COMPLETION_YR
, SCA.DERIVED_COMPLETION_PERD
, SCA.NOMINATED_COMPLETION_YR
, SCA.NOMINATED_COMPLETION_PERD
, SCA.RULE_CHECK_IND
, SCA.WAIVE_OPTION_CHECK_IND
, SCA.LAST_RULE_CHECK_DT
, SCA.PUBLISH_OUTCOMES_IND
, SCA.COURSE_RQRMNT_COMPLETE_IND
, SCA.COURSE_RQRMNTS_COMPLETE_DT
, SCA.S_COMPLETED_SOURCE_TYPE
, SCA.OVERRIDE_TIME_LIMITATION
, SCA.ADVANCED_STANDING_IND
, SCA.FEE_CAT
, SCA.CORRESPONDENCE_CAT
, SCA.SELF_HELP_GROUP_IND
, SCA.LOGICAL_DELETE_DT
, SCA.ADM_ADMISSION_APPL_NUMBER
, SCA.ADM_NOMINATED_COURSE_CD
, SCA.ADM_SEQUENCE_NUMBER
, SCA.LAST_DATE_OF_ATTENDANCE
, SCA.DROPPED_BY
, SCA.IGS_PR_CLASS_STD_ID
, SCA.PRIMARY_PROGRAM_TYPE
, SCA.PRIMARY_PROG_TYPE_SOURCE
, SCA.CATALOG_CAL_TYPE
, SCA.CATALOG_SEQ_NUM
, SCA.KEY_PROGRAM
, SCA.OVERRIDE_CMPL_DT
, SCA.MANUAL_OVR_CMPL_DT_IND
, HP.PARTY_NUMBER
, PSV.TITLE
, '_LA:COURSE_ATTEMPT_STATUS:IGS_LOOKUP_VALUES:CRS_ATTEMPT_STATUS:MEANING'
, '_LA:PROGRESSION_STATUS:IGS_LOOKUP_VALUES:PROGRESSION_STATUS:MEANING'
, '_LA:PRIMARY_PROG_TYPE_SOURCE:IGS_LOOKUP_VALUES:IGS_EN_PP_SOURCE:MEANING'
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.FUTURE_DATED_TRANS_FLAG
FROM IGS_EN_STDNT_PS_ATT_ALL SCA
, HZ_PARTIES HP
, IGS_PS_VER_ALL PSV
WHERE SCA.PERSON_ID = HP.PARTY_ID
AND SCA.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER WITH READ ONLY

Columns

Name
PERSON_ID
PROGRAM_CODE
VERSION_NUMBER
CALENDAR_TYPE
LOCATION_CODE
ATTENDANCE_MODE
ATTENDANCE_TYPE
COO_ID
STUDENT_CONFIRMED_INDICATOR
COMMENCEMENT_DATE
PROGRAM_ATTEMPT_STATUS
PROGRESSION_STATUS
DERIVED_ATTENDANCE_TYPE
DERIVED_ATTENDANCE_MODE
PROVISIONAL_INDICATOR
DISCONTINUED_DATE
DISCONTINUATION_REASON_CODE
LAPSED_DATE
FUNDING_SOURCE
EXAM_LOCATION_CODE
DERIVED_COMPLETION_YEAR
DERIVED_COMPLETION_PERIOD
NOMINATED_COMPLETION_YEAR
NOMINATED_COMPLETION_PERIOD
RULE_CHECK_INDICATOR
WAIVE_OPTION_CHECK_INDICATOR
LAST_RULE_CHECK_DATE
PUBLISH_OUTCOMES_INDICATOR
PROGRAM_RQRMNT_COMPLETE_IND
PROGRAM_RQRMNTS_COMPLETE_DATE
S_COMPLETED_SOURCE_TYPE
OVERRIDE_TIME_LIMITATION
ADVANCED_STANDING_INDICATOR
FEE_CATEGORY
CORRESPONDENCE_CATEGORY
SELF_HELP_GROUP_INDICATOR
LOGICAL_DELETE_DATE
ADM_ADMISSION_APPL_NUMBER
ADM_NOMINATED_PROGRAM_CODE
ADM_SEQUENCE_NUMBER
LAST_DATE_OF_ATTENDANCE
DROPPED_BY
IGS_PR_CLASS_STD_ID
PRIMARY_PROGRAM_TYPE
PRIMARY_PROG_TYPE_SOURCE
CATALOG_CALENDAR_TYPE
CATALOG_SEQUENCE_NUM
KEY_PROGRAM
OVERRIDE_COMPLETION_DATE
MANUAL_OVR_CMPL_DATE_INDICATOR
PERSON_NUMBER
PROGRAM_TITLE
"_LA:PROG_ATTEMPT_STAT_DESC"
"_LA:PROGRESSION_STATUS_DESC"
"_LA:PRIMARY_PROG_TY_SRC_DESC"
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
FUTURE_DATED_TRANS_FLAG