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_PR_SDT_PR_RU_CK

Product:	IGS - Student System (Obsolete)
Description:	Describes Student Progression Rule Check
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, CRV.TITLE
, CI.DESCRIPTION
, PRGC.DESCRIPTION
, SPRC.COURSE_CD
, SPRC.PRG_CAL_TYPE
, SPRC.PRG_CI_SEQUENCE_NUMBER
, SPRC.RULE_CHECK_DT
, SPRC.PROGRESSION_RULE_CAT
, '_LA:SPRC.PASSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SPRC.RULE_MESSAGE_TEXT
, SPRC.PERSON_ID
, SPRC.PRA_SEQUENCE_NUMBER
, SPRC.CREATED_BY
, SPRC.CREATION_DATE
, SPRC.LAST_UPDATED_BY
, SPRC.LAST_UPDATE_DATE
FROM IGS_PR_SDT_PR_RU_CK_ALL SPRC
, IGS_EN_STDNT_PS_ATT_ALL SCA
, HZ_PARTIES HP
, IGS_PS_VER_ALL CRV
, IGS_CA_INST_ALL CI
, IGS_PR_RU_CAT PRGC
WHERE SPRC.PERSON_ID = HP.PARTY_ID
AND SPRC.PERSON_ID = SCA.PERSON_ID
AND SPRC.COURSE_CD = SCA.COURSE_CD
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SPRC.PRG_CAL_TYPE = CI.CAL_TYPE
AND SPRC.PRG_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SPRC.PROGRESSION_RULE_CAT = PRGC.PROGRESSION_RULE_CAT WITH READ ONLY

Columns

Name
PERSON_NAME
PERSON_NUMBER
PROGRAM_TITLE
PROGRESSION_CALENDAR
RULE_CATEGORY_DESCRIPTION
PROGRAM_CODE
PRG_CAL_TYPE
PRG_CI_SEQUENCE_NUMBER
RULE_CHECK_DT
PROGRESSION_RULE_CAT
"_LA:PASSED_IND"
RULE_MESSAGE_TEXT
PERSON_ID
PRA_SEQUENCE_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE