RB_MBACTN_CFG(SQL Table) |
Index Back |
|---|---|
Automated Mail Processor RuleAutomated Mail Processor Rule Definition table |
| # | 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
Prompt Table: RB_MAILBOX_DEFN |
| 2 | NLP_CATEGORY |
Character(100) | VARCHAR2(100) NOT NULL | Used as category field |
| 3 | AMP_RULE_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Mail Processor Rule ID |
| 4 | PRIORITY |
Number(3,0) | SMALLINT NOT NULL | Priority |
| 5 | EOCF_ACTION_TYP_ID |
Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier pointing to a discreet action type configuration |
| 6 | KB_THRESHOLD | Number(6,2) | DECIMAL(5,2) NOT NULL | Used to indicate the threshold |
| 7 | MAX_SOLUTIONS | Number(3,0) | SMALLINT NOT NULL | Maximum Number of Solutions to be included in Auto-Response or Auto-Suggest |
| 8 | RB_PACKAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Package
Prompt Table: %EDITTABLE39 |
| 9 | RB_PACKAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Package Name
Prompt Table: RB_PACKAGEID_VW |
| 10 | DISP_TMPL_FAM_CD | Character(30) | VARCHAR2(30) NOT NULL |
Display Template Family Code
Prompt Table: RDT_TMPL_FAMILY |
| 11 | CONFIG_SPAM | Character(4) | VARCHAR2(4) NOT NULL |
Flag to configure SPAM type Actions
1=Delete SPAM from System 2=Mark as Spam and Route to WL 3=Route email to a Spam Mailbox |
| 12 | RB_WF_GRP_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Group Worklist Nameg
Prompt Table: RB_WF_WL_GRP |
| 13 | MAILBOX_ID1 | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 14 | KB_THRESHOLD_DOC | Number(6,2) | DECIMAL(5,2) NOT NULL | Used to indicate the threshold |
| 15 | MAX_DOCS_NUM | Number(3,0) | SMALLINT NOT NULL | Maximum Number of Packages to be fetched |
| 16 | MAX_SOLUTIONS_AREP | Number(3,0) | SMALLINT NOT NULL | Maximum Number of Solutions to be included in Auto-Response or Auto-Suggest |
| 17 | KB_THRESHOLD_ARESP | Number(6,2) | DECIMAL(5,2) NOT NULL | Used to indicate the threshold |
| 18 | FAILURE_PACKAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Package Id for Failurel return from Applications API |
| 19 | FAILURE_PKG_NAME | Character(30) | VARCHAR2(30) NOT NULL | Package Name |
| 20 | RB_PACKAGE_ID_AR | Number(10,0) | DECIMAL(10) NOT NULL | Package |
| 21 | RB_PACKAGE_NAME_AR | Character(30) | VARCHAR2(30) NOT NULL |
Package Name
Prompt Table: RB_PACKAGEID_VW |