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_PR_COHORT_INST_RANK_V

Product:	IGS - Student System (Obsolete)
Description:	Stores Cohort Instance Rank with denormalised references
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT COHIR.ROWID
, COHI.COHORT_NAME
, COHI.LOAD_CAL_TYPE
, COHI.LOAD_CI_SEQUENCE_NUMBER
, COHIR.PERSON_ID
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, COHIR.COURSE_CD
, PS.TITLE
, COHIR.AS_OF_RANK_GPA
, COHIR.COHORT_RANK
, COHIR.COHORT_OVERRIDE_RANK
, COHIR.COMMENTS
, COHIR.CREATED_BY
, COHIR.CREATION_DATE
, COHIR.LAST_UPDATED_BY
, COHIR.LAST_UPDATE_DATE
, COHIR.LAST_UPDATE_LOGIN
, COHIR.REQUEST_ID
, COHIR.PROGRAM_APPLICATION_ID
, COHIR.PROGRAM_ID
, COHIR.PROGRAM_UPDATE_DATE
FROM IGS_PR_COHINST_RANK COHIR
, IGS_PR_COHORT_INST COHI
, HZ_PARTIES HZ
, IGS_PS_VER PS
, IGS_EN_STDNT_PS_ATT SPA
, IGS_PS_OFR_OPT POO
WHERE COHIR.PERSON_ID = HZ.PARTY_ID
AND COHIR.COURSE_CD = PS.COURSE_CD
AND PS.VERSION_NUMBER = POO.VERSION_NUMBER
AND PS.COURSE_CD = POO.COURSE_CD
AND SPA.COO_ID = POO.COO_ID
AND SPA.COURSE_CD = COHIR.COURSE_CD
AND SPA.PERSON_ID = COHIR.PERSON_ID
AND COHI.COHORT_NAME = COHIR. COHORT_NAME
AND COHI.LOAD_CAL_TYPE = COHIR.LOAD_CAL_TYPE
AND COHI.LOAD_CI_SEQUENCE_NUMBER = COHIR. LOAD_CI_SEQUENCE_NUMBER

Columns

Name
ROW_ID
COHORT_NAME
LOAD_CAL_TYPE
LOAD_CI_SEQUENCE_NUMBER
PERSON_ID
PERSON_NUMBER
PERSON_NAME
COURSE_CD
COURSE_TITLE
AS_OF_RANK_GPA
COHORT_RANK
COHORT_OVERRIDE_RANK
COMMENTS
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE