RB_AMPRULE_DTL(SQL Table) |
Index Back |
|---|---|
Automated Mail Processor RuleAutomated Mail Processor Rule Definition table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  AMP_RULE_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Mail Processor Rule ID |
| 2 | NLP_CATEGORY |
Character(100) | VARCHAR2(100) NOT NULL | Used as category field |
| 3 | PRIORITY |
Number(3,0) | SMALLINT NOT NULL | Priority |
| 4 | EOCF_ACTION_TYP_ID |
Number(31,0) | DECIMAL(31) NOT NULL |
the unique identifier pointing to a discreet action type configuration
Prompt Table: RB_ACTNTYPE_VW |
| 5 | EOCF_ACT_TYP_NAME | Character(30) | VARCHAR2(30) NOT NULL | user-defined name to identify the characteristics of a particular action |
| 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: %EDITTABLE40 |
| 10 | 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 Default Value: 1 |
| 11 | RB_WF_GRP_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Group Worklist Nameg
Prompt Table: RB_WF_WL_GRP |
| 12 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL |
Mail Box Id is an Id associated with Mail Boxes
Prompt Table: RB_MAILBOX_DEFN |
| 13 | DISP_TMPL_FAM_CD | Character(30) | VARCHAR2(30) NOT NULL |
Display Template Family Code
Prompt Table: RDT_TMPL_FAMILY |
| 14 | MAX_DOCS_NUM | Number(3,0) | SMALLINT NOT NULL | Maximum Number of Packages to be fetched |
| 15 | KB_THRESHOLD_DOC | Number(6,2) | DECIMAL(5,2) NOT NULL | Used to indicate the threshold |