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_AS_CHNG_GRD_REQUESTS

Product:	IGS - Student System (Obsolete)
Description:	Request details for grade changes
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT HP1.PARTY_NAME
, HP1.PARTY_NUMBER
, CGR.COURSE_CD
, CGR.UNIT_CD
, UV.TITLE
, CGR.UNIT_CLASS
, UC.DESCRIPTION
, CGR.LOCATION_CD
, LOC.DESCRIPTION
, CGR.TEACH_CAL_TYPE
, CGR.TEACH_CI_SEQUENCE_NUMBER
, CI1.DESCRIPTION
, CGR.REQUEST_DATE
, CGR.LOAD_CAL_TYPE
, CGR.LOAD_CI_SEQUENCE_NUMBER
, CI2.DESCRIPTION
, CGR.CURRENT_MARK
, CGR.CURRENT_GRADING_SCHEMA_CD
, CGR.CURRENT_GS_VERSION_NUMBER
, CGR.CURRENT_GRADE
, GSG1.FULL_GRADE_NAME
, CGR.CHANGE_MARK
, CGR.CHANGE_GRADING_SCHEMA_CD
, CGR.CHANGE_GS_VERSION_NUMBER
, CGR.CHANGE_GRADE
, GSG2.FULL_GRADE_NAME
, CGR.REQUESTER_COMMENTS
, CGR.APPROVER_DATE
, CGR.APPROVER_COMMENTS
, CGR.CURRENT_STATUS
, HP2.PARTY_NAME
, HP2.PARTY_NUMBER
, HP3.PARTY_NAME
, HP3.PARTY_NUMBER
, '_LA:CGR.MARK_CAPPED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:CGR.SHOW_ON_ACADEMIC_HISTRY_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, CGR.UOO_ID
, CGR.PERSON_ID
, CGR.REQUESTER_ID
, CGR.APPROVER_ID
, CGR.CREATED_BY
, CGR.CREATION_DATE
, CGR.LAST_UPDATED_BY
, CGR.LAST_UPDATE_DATE
FROM IGS_AS_CHN_GRD_REQ CGR
, HZ_PARTIES HP1
, IGS_PS_UNIT_VER_ALL UV
, IGS_AS_UNIT_CLASS_ALL UC
, IGS_AD_LOCATION LOC
, IGS_CA_INST_ALL CI1
, IGS_PS_UNIT_OFR_OPT_ALL UOO
, HZ_PARTIES HP2
, HZ_PARTIES HP3
, IGS_AS_GRD_SCH_GRADE GSG1
, IGS_AS_GRD_SCH_GRADE GSG2
, IGS_CA_INST_ALL CI2
WHERE CGR.PERSON_ID = HP1.PARTY_ID
AND CGR.APPROVER_ID = HP2.PARTY_ID (+)
AND CGR.REQUESTER_ID = HP3.PARTY_ID
AND CGR.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND CGR.UNIT_CLASS = UC.UNIT_CLASS
AND CGR.LOCATION_CD = LOC.LOCATION_CD
AND CGR.TEACH_CAL_TYPE = CI1.CAL_TYPE
AND CGR.TEACH_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND CGR.LOAD_CAL_TYPE = CI2.CAL_TYPE
AND CGR.LOAD_CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER
AND CGR.CURRENT_GRADING_SCHEMA_CD = GSG1.GRADING_SCHEMA_CD
AND CGR.CURRENT_GS_VERSION_NUMBER = GSG1.VERSION_NUMBER
AND CGR.CURRENT_GRADE = GSG1.GRADE
AND CGR.CHANGE_GRADING_SCHEMA_CD = GSG2.GRADING_SCHEMA_CD
AND CGR.CHANGE_GS_VERSION_NUMBER = GSG2.VERSION_NUMBER
AND CGR.CHANGE_GRADE = GSG2.GRADE WITH READ ONLY

Columns

Name
PERSON_NAME
PERSON_NUMBER
PROGRAM_CODE
UNIT_CODE
UNIT_TITLE
UNIT_CLASS
UNIT_CLASS_DESCRIPTION
LOCATION_CODE
LOCATION_DESCRIPTION
TEACH_CALENDAR_TYPE
TEACH_CI_SEQUENCE_NUMBER
TEACH_CALENDAR_DESCRIPTION
REQUEST_DATE
LOAD_CALENDAR_TYPE
LOAD_CI_SEQUENCE_NUMBER
LOAD_CALENDAR_DESCRIPTION
CURRENT_MARK
CURRENT_GRADING_SCHEMA_CODE
CURRENT_GS_VERSION_NUMBER
CURRENT_GRADE
CURRENT_FULL_GRADE_NAME
CHANGE_MARK
CHANGE_GRADING_SCHEMA_CODE
CHANGE_GS_VERSION_NUMBER
CHANGE_GRADE
CHANGE_FULL_GRADE_NAME
REQUESTER_COMMENTS
APPROVER_DATE
APPROVER_COMMENTS
CURRENT_STATUS
REQUESTOR_NAME
REQUESTOR_NUMBER
APPROVER_NAME
APPROVER_NUMBER
"_LA:MARK_CAPPED_FLAG"
"_LA:SHOW_ON_ACAD_HIST_FLAG"
UNIT_SECTION_ID
PERSON_ID
REQUESTER_ID
APPROVER_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE