RB_BEST_WL (SQL View)	Index Back
Worklist Score for Email View of the Best Worklist Score

RB_BEST_WL

(SQL View)

Worklist Score for Email

View of the Best Worklist Score

SELECT A.MCF_EMAIL_ID , B.WORKLISTNAME , B.WLPRIORITY , A.SCORE FROM PS_RB_EMAIL_SCORES A , PS_RB_MB_WL_ASSOC B WHERE A.OBJECT_TYP = 'WL' AND A.OBJECT_ID = B.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
Set Control Field: RB_WF_GRP_NAME

3 WLPRIORITY Number(3,0) SMALLINT NOT NULL Worklist Priority tie breaker.

4 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score

#	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 Set Control Field: RB_WF_GRP_NAME
3	WLPRIORITY	Number(3,0)	SMALLINT NOT NULL	Worklist Priority tie breaker.
4	SCORE	Number(7,2)	DECIMAL(6,2) NOT NULL	Test Score