RB_MB_RULES (SQL Table)	Index Back
Rules associted to the Mailbox Table to store the rules associted to the Mailbox

RB_MB_RULES

(SQL Table)

Rules associted to the Mailbox

Table to store the rules associted to the Mailbox

# 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

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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

5 AMP_RULE_NAME Character(50) VARCHAR2(50) NOT NULL Automated Mail Processor Rule Name aka Behavior

#	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
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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	AMP_RULE_NAME	Character(50)	VARCHAR2(50) NOT NULL	Automated Mail Processor Rule Name aka Behavior