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: IGS_EN_SCA_STATUS_V

Product:	IGS - Student System (Obsolete)
Description:	This view describes student course attempt status along with displaying the course information and student information.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PDV.PERSON_ID
, PDV.PERSON_NUMBER
, PDV.TITLE
, PDV.SURNAME
, PDV.GIVEN_NAMES
, PDV.PREFERRED_GIVEN_NAME
, PDV.SEX
, PDV.BIRTH_DT
, PDV.EMAIL_ADDR
, PDV.ORACLE_USERNAME
, PDV.STAFF_MEMBER_IND
, PDV.DECEASED_IND
, PDV.CONTEXT_BLOCK_NAME
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.COURSE_CD||'.'|| TO_CHAR(SCA.VERSION_NUMBER)
, SCA.COURSE_ATTEMPT_STATUS
, SCA.LOCATION_CD
, SCA.ATTENDANCE_MODE
, SCA.ATTENDANCE_TYPE
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
, PDV.API_PERSON_ID
, PDV.PRE_NAME_ADJUNCT_MEANING
, PDV.SUFFIX
, PDV.MIDDLE_NAME
FROM IGS_PE_PERSON_V PDV
, IGS_EN_STDNT_PS_ATT SCA
WHERE PDV.PERSON_ID = SCA.PERSON_ID (+)

Columns

Name
PERSON_ID
PERSON_NUMBER
TITLE
SURNAME
GIVEN_NAMES
PREFERRED_GIVEN_NAME
SEX
BIRTH_DT
EMAIL_ADDR
ORACLE_USERNAME
STAFF_MEMBER_IND
DECEASED_IND
CONTEXT_BLOCK_NAME
COURSE_CD
VERSION_NUMBER
CRS_VERSION
COURSE_ATTEMPT_STATUS
LOCATION_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
API_PERSON_ID
PRE_NAME_ADJUNCT_MEANING
SUFFIX
MIDDLE_NAME