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

Product:	IGS - Student System (Obsolete)
Description:	This entity describes enrollment which will occur or has occurred for student program attempt
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SCAE.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SCAE.COURSE_CD
, PSV.TITLE
, SCAE.CAL_TYPE
, SCAE.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, SCAE.ENROLMENT_CAT
, EC.DESCRIPTION
, 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
FROM IGS_AS_SC_ATMPT_ENR SCAE
, HZ_PARTIES HP
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_VER_ALL PSV
, IGS_CA_INST_ALL CI
, IGS_EN_ENROLMENT_CAT EC
WHERE SCAE.PERSON_ID = HP.PARTY_ID
AND SCAE.PERSON_ID = SCA.PERSON_ID
AND SCAE.COURSE_CD = SCA.COURSE_CD
AND SCAE.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER
AND SCAE.CAL_TYPE = CI.CAL_TYPE
AND SCAE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SCAE.ENROLMENT_CAT = EC.ENROLMENT_CAT WITH READ ONLY

Columns

Name
PERSON_IDENTIFIER
PERSON_NUMBER
PERSON_NAME
PROGRAM_CODE
PROGRAM_TITLE
CALENDAR_TYPE
CAL_INST_SEQUENCE_NUMBER
CALENDAR_START_DATE
CALENDAR_END_DATE
CALENDAR_INSTANCE_DESC
ENROLMENT_CATEGORY
ENROLMENT_CATEGORY_DESC
ENROLLED_DATE
ENR_FORM_DUE_DATE
ENR_PACKAGE_PROD_DATE
ENR_FORM_RECEIVED_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE