AMP_RULE_IDNLP_CATEGORYPrompt Table: RB_AMPRUL_TM_VW
RB_AMPRULE_SR_V(SQL View) |
Index Back |
|---|---|
AMP Rule search ViewERMS View used for seaching AMP rules |
| SELECT A.AMP_RULE_ID , %Sql(RB_TOCHAR,B.TMPLT_CATEGRY_ID) , B.TMPLT_CATEGRY_ID , B.TMPLT_CATEGRY_NAME , A.AMP_RULE_NAME FROM PS_RB_AMPRULE_DFN A , PS_RBC_TEMPLT_CAT B WHERE A.NLP_CATEGORY = %Sql(RB_TOCHAR,B.TMPLT_CATEGRY_ID) |
| # | 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 | TMPLT_CATEGRY_ID | Number(6,0) | INTEGER NOT NULL |
Category Name
Prompt Table: RB_AMPRUL_TM_VW |
| 4 | TMPLT_CATEGRY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Holds the names of the categories. 01/16/03: Set the Format Type to "Mixedcase", from Uppercase. |
| 5 | AMP_RULE_NAME | Character(50) | VARCHAR2(50) NOT NULL | Automated Mail Processor Rule Name aka Behavior |