RB_MAILRUL_STAT (SQL Table)	Index Back
Log the AMP Rule Outcome CRM ERMS table used for Log the AMP Rule Outcome

RB_MAILRUL_STAT

(SQL Table)

Log the AMP Rule Outcome

CRM ERMS table used for Log the AMP Rule Outcome

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MCF_EMAIL_ID Number(16,0) DECIMAL(16) NOT NULL Email Id

2 AMP_RULE_ID Number(18,0) DECIMAL(18) NOT NULL Mail Processor Rule ID

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

4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

5 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MCF_EMAIL_ID	Number(16,0)	DECIMAL(16) NOT NULL	Email Id
2	AMP_RULE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Mail Processor Rule ID
3	AMP_RULE_NAME	Character(50)	VARCHAR2(50) NOT NULL	Automated Mail Processor Rule Name aka Behavior
4	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
5	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.