MCF_EMAIL_IDPrompt Table:
RB_WF_WL_GRP
Set Control Field: RB_WF_GRP_NAME
RB_AVG_WL_SCORE(SQL View) |
Index Back |
|---|---|
Worklist Score for EmailView of the Average Worklist Scores |
| SELECT C.MCF_EMAIL_ID , A.WORKLISTNAME , AVG(C.SCORE) FROM PS_RB_MB_WL_ASSOC A , PS_RB_WL_QG_ASSOC B , PS_RB_EMAIL_SCORES C , PS_RB_CLASSIFY_TBL D WHERE A.WORKLISTNAME = B.WORKLISTNAME AND C.OBJECT_ID = B.QUERY_GRP_ID AND C.OBJECT_TYP = 'QG' AND C.MCF_EMAIL_ID = D.MCF_EMAIL_ID AND D.MAILBOX_ID = A.MAILBOX_ID GROUP BY C.MCF_EMAIL_ID, A.WORKLISTNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MCF_EMAIL_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 2 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Worklist Name
Prompt Table:
RB_WF_WL_GRP
|
| 3 | SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Test Score |