MCF_EMAIL_IDSEQ_NUMQG=Query Group
WL=Email Group Worklist
Prompt Table: RB_WF_WL_GRP
RB_EM_WLSCOR_VW(SQL View) |
Index Back |
|---|---|
Email Worklist Score ViewEmail Scores for Worklists generated by Classifier |
| SELECT MCF_EMAIL_ID , SEQ_NUM , OBJECT_TYP , OBJECT_ID , SCORE FROM %Table(RB_EMAIL_SCORES) WHERE OBJECT_TYP = 'WL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MCF_EMAIL_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | OBJECT_TYP | Character(3) | VARCHAR2(3) NOT NULL |
Object Type
QG=Query Group WL=Email Group Worklist |
| 4 | OBJECT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Name of recommended Group Worklist for inbound email.
Prompt Table: RB_WF_WL_GRP |
| 5 | SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Test Score |