RB_ERMS_E_CAC_V

(SQL View)
Index Back

Categorization Confidence

Used for ERMS reports. Displays the Knowledge Base scores for emails (calling this the Categorization Confidence)

SELECT B.MAILBOX_ID ,B.LAST_GROUP_WL ,0 ,0 ,C.KB_THRESHOLD ,0 ,0 ,0 ,B.SLA_EXT_BASE_DTTM FROM PS_RB_ERMS_SYSDEFN A , PS_RB_IN_EMAIL B , PS_RB_AMP_NLPOUTPT C WHERE A.TMPLT_CATEGRY_ID <> B.TMPLT_CATEGRY_ID AND B.MCF_EMAIL_ID = C.MCF_EMAIL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MAILBOX_ID Character(30) VARCHAR2(30) NOT NULL Mail Box Id is an Id associated with Mail Boxes
2 LAST_GROUP_WL Character(30) VARCHAR2(30) NOT NULL Last/Current Group-level Worklist
3 RB_TOTAL_EMAILS Number(8,0) INTEGER NOT NULL Detail item status
4 RB_CLOSED_AUTO Number(8,0) INTEGER NOT NULL Detail item status
5 KB_THRESHOLD Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the threshold
6 RC_CASE_COUNT Number(7,0) INTEGER NOT NULL Case Count
7 RB_CLOSED_REP Number(8,0) INTEGER NOT NULL Detail item status
8 RB_CLOSED_MULT_REP Number(8,0) INTEGER NOT NULL Detail item status
9 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.