SCC_GE_WKLST_VW(SQL View) |
Index Back |
|---|---|
EMS Worklist Item ViewEvaluation Management System WorkList Item View Returns the EMS Worklist Items assigned to an Evaluator (EMPLID). |
| SELECT H.SCC_NTF_CON_ID ,D.EMPLID ,A.SCC_NTFREQ_ID ,A.SCC_NTFREQ_DTL_SEQ ,A.SCC_NTFREQ_ITM_SEQ ,A.SCC_NTF_DATE_FROM ,A.SCC_NTF_DATE_TO ,A.SCC_NTFREQ_SUB_STS ,A.SCC_NTFREQ_ITM_TAG ,E.SCC_GE_INSTANCE_ID ,E.SCC_GE_EVAL_CATGRY ,E.SCC_GE_EVALUATN_CD ,E.SCC_GE_EVAL_NBR ,E.SCC_GE_RTNG_SCHEME ,E.SCC_GE_SETUP_DT ,S.EMPLID ,S.INSTITUTION ,E2.SCC_GE_EVLTR_TYPE ,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 PS_SCC_NTF_ITM_VW A , PS_SCC_GE_NTFDA_VW B , PS_SCC_NTF_HDR_VW H , PS_SCC_NTF_DTL_VW D , PS_SCC_GE_EVALUATN E , PS_SCC_GE_STU_EVAL S , PS_SCC_GE_WKEVL_VW E2 WHERE A.SCC_NTFREQ_TYPE = 'WKL' AND H.SCC_NTF_CON_ID = 'SCC_NTF_CON_20130215180342' AND A.SCC_NTFREQ_ID = B.SCC_NTFREQ_ID AND D.SCC_NTFREQ_ID = H.SCC_NTFREQ_ID AND A.SCC_NTFREQ_ID = H.SCC_NTFREQ_ID AND A.SCC_NTFREQ_DTL_SEQ = D.SCC_NTFREQ_DTL_SEQ AND B.SCC_GE_DESCR = %NumToChar(E.SCC_GE_INSTANCE_ID) AND S.SCC_GE_INSTANCE_ID = E.SCC_GE_INSTANCE_ID AND E2.SCC_GE_INSTANCE_ID = E.SCC_GE_INSTANCE_ID AND E2.SCC_NTFREQ_ID = A.SCC_NTFREQ_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SCC_NTF_CON_ID |
Character(40) | VARCHAR2(40) NOT NULL | Consumer ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | SCC_NTFREQ_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Notification ID |
| 4 | SCC_NTFREQ_DTL_SEQ |
Number(5,0) | INTEGER NOT NULL | Notification Detail Sequence |
| 5 | SCC_NTFREQ_ITM_SEQ |
Number(5,0) | INTEGER NOT NULL | Notification Item Sequence |
| 6 | SCC_NTF_DATE_FROM | Date(10) | DATE NOT NULL | Date From |
| 7 | SCC_NTF_DATE_TO | Date(10) | DATE | Date To |
| 8 | SCC_NTFREQ_SUB_STS | Character(1) | VARCHAR2(1) NOT NULL |
Notification Item SubStatus
A=Acknowledged D=Deleted E=Error R=Ready S=Selected T=Timeout U=Unknown W=Worked |
| 9 | SCC_NTFREQ_ITM_TAG | Character(20) | VARCHAR2(20) NOT NULL | Notification Item Tag |
| 10 | SCC_GE_INSTANCE_ID | Number(16,0) | DECIMAL(16) NOT NULL | Evaluation Instance |
| 11 | SCC_GE_EVAL_CATGRY | Character(10) | VARCHAR2(10) NOT NULL |
Evaluation Category
Prompt Table: SCC_GE_CATEGORY |
| 12 | SCC_GE_EVALUATN_CD | Character(10) | VARCHAR2(10) NOT NULL |
Evaluation Code
Prompt Table: SCC_GE_EC_DEFN |
| 13 | SCC_GE_EVAL_NBR | Number(3,0) | SMALLINT NOT NULL | Evaluation Code Sequence |
| 14 | SCC_GE_RTNG_SCHEME | Character(10) | VARCHAR2(10) NOT NULL |
Rating Scheme
Prompt Table: SCC_GE_RTNG_VW1 |
| 15 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 16 | SCC_GE_EVALUEE_ID | Character(11) | VARCHAR2(11) NOT NULL | Evaluee ID |
| 17 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 18 | 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 |
| 19 | SCC_GE_EVAL_STATUS | Character(6) | VARCHAR2(6) NOT NULL | Evaluation Status |
| 20 | SCC_GE_EVAL_DT | Date(10) | DATE | Status Date |
| 21 | SCC_GE_RECOMMENDTN | Character(10) | VARCHAR2(10) NOT NULL | Recommendation Value |
| 22 | OVERALL_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Overall Rating |
| 23 | SCC_GE_OVERALL_RTG | Number(12,3) | DECIMAL(11,3) NOT NULL | Overall Rating |
| 24 | SCC_GE_CMPLTD_DTTM | DateTime(26) | TIMESTAMP | Completed Date |