Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Holds the details of the evaluators assigned to various applications |
Implementation/DBA Data: | Not implemented in this database |
SELECT AE.ROWID ROW_ID
, AE.APPL_EVAL_ID APPL_EVAL_ID
, AE.PERSON_ID PERSON_ID
, P.PERSON_NUMBER PERSON_NUMBER
, AE.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, AE.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, AE.SEQUENCE_NUMBER SEQUENCE_NUMBER
, AE.EVALUATOR_ID EVALUATOR_ID
, P.FULL_NAME FULL_NAME
, AE.ASSIGN_TYPE ASSIGN_TYPE
, AE.ASSIGN_DATE ASSIGN_DATE
, AE.EVALUATION_DATE EVALUATION_DATE
, AE.RATING_VALUES_ID RATING_VALUES_ID
, RV.RATING_VALUE RATING
, AE.RATING_TYPE_ID RATING_TYPE_ID
, CC.NAME RATING_TYPE
, AE.RATING_NOTES RATING_NOTES
, AE.CREATED_BY CREATED_BY
, AE.CREATION_DATE CREATION_DATE
, AE.LAST_UPDATED_BY LAST_UPDATED_BY
, AE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AE.REQUEST_ID REQUEST_ID
, AE.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AE.PROGRAM_ID PROGRAM_ID
, AE.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AE.EVALUATION_SEQUENCE EVALUATION_SEQUENCE
, RS.RATING_SCALE_ID RATING_SCALE_ID
, RATING_SCALE_NAME RATING_SCALE_NAME
, AE.CLOSED_IND CLOSED_IND FROM IGS_AD_APPL_EVAL AE
, IGS_AD_RS_VALUES RV
, IGS_AD_CODE_CLASSES CC
, IGS_PE_PERSON_BASE_V P
, IGS_AD_RATING_SCALES_V RS
WHERE AE.RATING_VALUES_ID = RV.RATING_VALUES_ID (+)
AND AE.RATING_TYPE_ID = CC.CODE_ID (+)
AND AE.RATING_SCALE_ID = RS.RATING_SCALE_ID(+)
AND AE.EVALUATOR_ID = P.PERSON_ID