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_CAT_PRC_DTL_V

Product:	IGS - Student System (Obsolete)
Description:	Describes the Enrollment Category Eligibility Validation Details
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ECP.ROWID ROW_ID
, ECP.ENROLMENT_CAT
, EC.DESCRIPTION
, ECP.ENR_METHOD_TYPE
, EMT.DESCRIPTION
, ECP.S_STUDENT_COMM_TYPE
, LKUP.MEANING
, TO_CHAR(NULL)
, /**ECP.PRODUCE_PACKAGE_IND
, **/ ECP.PERSON_ADD_ALLOW_IND
, ECP.COURSE_ADD_ALLOW_IND
, ECP.CREATED_BY
, ECP.CREATION_DATE
, ECP.LAST_UPDATED_BY
, ECP.LAST_UPDATE_DATE
, ECP.LAST_UPDATE_LOGIN
, ECP.CONFIG_MIN_CP_VALDN
, ECP.ENFORCE_DATE_ALIAS
, CA.DESCRIPTION
FROM IGS_EN_CAT_PRC_DTL ECP
, IGS_EN_ENROLMENT_CAT EC
, IGS_EN_METHOD_TYPE EMT
, IGS_LOOKUPS_VIEW LKUP
, IGS_CA_DA CA
WHERE ECP.ENROLMENT_CAT = EC.ENROLMENT_CAT
AND ECP.ENR_METHOD_TYPE = EMT.ENR_METHOD_TYPE
AND ECP.S_STUDENT_COMM_TYPE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'VS_EN_COMMENCE'
AND ECP.ENFORCE_DATE_ALIAS = CA.DT_ALIAS(+)

Columns

Name
ROW_ID
ENROLMENT_CAT
ENR_CAT_DESC
ENR_METHOD_TYPE
ENR_MTYPE_DESC
S_STUDENT_COMM_TYPE
STD_COMM_TYPE_DESC
PRODUCE_PACKAGE_IND
PERSON_ADD_ALLOW_IND
COURSE_ADD_ALLOW_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CONFIG_MIN_CP_VALDN
ENFORCE_DATE_ALIAS
DESCRIPTION