AMP_RULE_IDNLP_CATEGORYLANGUAGE_CDRB_AMPRULSR_VLN(SQL View) |
Index Back |
|---|---|
Related Lang view for AMP RuleRelated Language view for AMP Rule Search |
| SELECT DFN.AMP_RULE_ID , DFN.NLP_CATEGORY , CATLNG.LANGUAGE_CD , CATLNG.TMPLT_CATEGRY_NAME , AMPLNG.AMP_RULE_NAME FROM PS_RB_AMPRULE_DFN DFN , PS_RBC_CAT_LNG CATLNG , PS_RB_AMPRULE_LNG AMPLNG WHERE DFN.AMP_RULE_ID=AMPLNG.AMP_RULE_ID AND CATLNG.LANGUAGE_CD=AMPLNG.LANGUAGE_CD AND DFN.NLP_CATEGORY = %Sql(RB_TOCHAR,CATLNG.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 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 |