AMP_RULE_IDPrompt Table: RB_AMPCTGRYST_V
RB_AMPRULE_DFN(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 | TMPLT_CATEGRY_ID | Number(6,0) | INTEGER NOT NULL | Template Category ID |
| 3 | NLP_CATEGORY | Character(100) | VARCHAR2(100) NOT NULL |
Used as category field
Prompt Table: RB_AMPCTGRYST_V |
| 4 | AMP_RULE_NAME | Character(50) | VARCHAR2(50) NOT NULL | Automated Mail Processor Rule Name aka Behavior |
| 5 | KB_THRESHOLD | Number(6,2) | DECIMAL(5,2) NOT NULL | Used to indicate the threshold |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |