SCC_GE_INSTANCE_IDSCC_NTFREQ_IDSCC_GE_EVLTR_TYPE1=Evaluation Administrator
2=Committee Scheme Administrator
3=Individual Scheme Admin
4=Committee Administrator
5=Individual Evaluator
6=Committee Evaluator
SCC_GE_WKEVL_VW(SQL View) |
Index Back |
|---|---|
EMS Worklist Evaluator ViewEvaluation Management System WorkList Evaluator View Used to return the Status, Recommendation, etc. from the EMS table related to a worklist Item Joins all the different Evaluator Tables together, but only 1 row should exist for an Instance ID/NTF ID combination. |
| SELECT E1.SCC_GE_INSTANCE_ID ,E1.SCC_NTFREQ_ID ,'1' ,E1.SCC_GE_EVAL_STATUS ,E1.SCC_GE_EVAL_DT ,E1.SCC_GE_RECOMMENDTN ,E1.OVERALL_RATING ,E1.SCC_GE_OVERALL_RTG ,E1.SCC_GE_CMPLTD_DTTM FROM %Table(SCC_GE_EVALUATN) E1 UNION ALL SELECT E2.SCC_GE_INSTANCE_ID ,E2.SCC_NTFREQ_ID ,'2' ,E2.SCC_GE_EVAL_STATUS ,E2.SCC_GE_EVAL_DT ,E2.SCC_GE_RECOMMENDTN ,E2.OVERALL_RATING ,E2.SCC_GE_OVERALL_RTG ,E2.SCC_GE_CMPLTD_DTTM FROM %Table(SCC_GE_CM_SCHEM) E2 UNION ALL SELECT E3.SCC_GE_INSTANCE_ID ,E3.SCC_NTFREQ_ID ,'3' ,E3.SCC_GE_EVAL_STATUS ,E3.SCC_GE_EVAL_DT ,E3.SCC_GE_RECOMMENDTN ,E3.OVERALL_RATING ,E3.SCC_GE_OVERALL_RTG ,E3.SCC_GE_CMPLTD_DTTM FROM %Table(SCC_GE_IE_SCHEM) E3 UNION ALL SELECT E4.SCC_GE_INSTANCE_ID ,E4.SCC_NTFREQ_ID ,'4' ,E4.SCC_GE_EVAL_STATUS ,E4.SCC_GE_EVAL_DT ,E4.SCC_GE_RECOMMENDTN ,E4.OVERALL_RATING ,E4.SCC_GE_OVERALL_RTG ,E4.SCC_GE_CMPLTD_DTTM FROM %Table(SCC_GE_CM_INFO) E4 UNION ALL SELECT E5.SCC_GE_INSTANCE_ID ,E5.SCC_NTFREQ_ID ,'5' ,E5.SCC_GE_EVAL_STATUS ,E5.SCC_GE_EVAL_DT ,E5.SCC_GE_RECOMMENDTN ,E5.OVERALL_RATING ,E5.SCC_GE_OVERALL_RTG ,E5.SCC_GE_CMPLTD_DTTM FROM %Table(SCC_GE_IE_EVLTR) E5 UNION ALL SELECT E6.SCC_GE_INSTANCE_ID ,E6.SCC_NTFREQ_ID ,'6' ,E6.SCC_GE_EVAL_STATUS ,E6.SCC_GE_EVAL_DT ,E6.SCC_GE_RECOMMENDTN ,E6.OVERALL_RATING ,E6.SCC_GE_OVERALL_RTG ,E6.SCC_GE_CMPLTD_DTTM FROM %Table(SCC_GE_CM_EVLTR) E6 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_GE_INSTANCE_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Evaluation Instance |
| 2 | SCC_NTFREQ_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Notification ID |
| 3 | SCC_GE_EVLTR_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Evaluator Type
1=Evaluation Administrator 2=Committee Scheme Administrator 3=Individual Scheme Admin 4=Committee Administrator 5=Individual Evaluator 6=Committee Evaluator |
| 4 | SCC_GE_EVAL_STATUS | Character(6) | VARCHAR2(6) NOT NULL | Evaluation Status |
| 5 | SCC_GE_EVAL_DT | Date(10) | DATE | Status Date |
| 6 | SCC_GE_RECOMMENDTN | Character(10) | VARCHAR2(10) NOT NULL | Recommendation Value |
| 7 | OVERALL_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Overall Rating |
| 8 | SCC_GE_OVERALL_RTG | Number(12,3) | DECIMAL(11,3) NOT NULL | Overall Rating |
| 9 | SCC_GE_CMPLTD_DTTM | DateTime(26) | TIMESTAMP | Completed Date |