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_AS_SCAE_V

Product:	IGS - Student System (Obsolete)
Description:	This view is used to combine the student course attempt enrolment details with calendar details so the records can be order by start and end date.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SCAE.ROWID
, SCAE.PERSON_ID
, SCAE.COURSE_CD
, SCAE.CAL_TYPE
, SCAE.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, SCAE.ENROLMENT_CAT
, SCAE.ENROLLED_DT
, SCAE.ENR_FORM_DUE_DT
, SCAE.ENR_PCKG_PROD_DT
, SCAE.ENR_FORM_RECEIVED_DT
, SCAE.CREATED_BY
, SCAE.CREATION_DATE
, SCAE.LAST_UPDATED_BY
, SCAE.LAST_UPDATE_DATE
, SCAE.LAST_UPDATE_LOGIN
FROM IGS_AS_SC_ATMPT_ENR SCAE
, IGS_CA_INST CI
WHERE SCAE.CAL_TYPE = CI.CAL_TYPE
AND SCAE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

Columns

Name
ROW_ID
PERSON_ID
COURSE_CD
CAL_TYPE
CI_SEQUENCE_NUMBER
START_DT
END_DT
ALTERNATE_CODE
ENROLMENT_CAT
ENROLLED_DT
ENR_FORM_DUE_DT
ENR_PCKG_PROD_DT
ENR_FORM_RECEIVED_DT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN