PMT_RULE (SQL Table)	Index Back
Payment Rule Stores validation/security rules for payments.

PMT_RULE

(SQL Table)

Payment Rule

Stores validation/security rules for payments.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RULE_ID Character(20) VARCHAR2(20) NOT NULL Rule ID

2 PMT_RULE_NAME Character(50) VARCHAR2(50) NOT NULL Payment criteria rule name.

3 PMT_SECURITY_TYPE Character(1) VARCHAR2(1) NOT NULL Xlat for security types.
S=Security
V=Validation

4 PMT_RULE_ACTION Character(3) VARCHAR2(3) NOT NULL Rule action (Error or Hold)
E=Error
H=Hold

5 PMT_RULE_MSG Character(254) VARCHAR2(254) NOT NULL Message to be used in the case that the rule fails.

6 EVENT_CODE Character(15) VARCHAR2(15) NOT NULL Event code that corresponds to a specific type of event. Can be used for finer filtering of events.

7 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

8 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

9 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	Rule ID
2	PMT_RULE_NAME	Character(50)	VARCHAR2(50) NOT NULL	Payment criteria rule name.
3	PMT_SECURITY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Xlat for security types. S=Security V=Validation
4	PMT_RULE_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Rule action (Error or Hold) E=Error H=Hold
5	PMT_RULE_MSG	Character(254)	VARCHAR2(254) NOT NULL	Message to be used in the case that the rule fails.
6	EVENT_CODE	Character(15)	VARCHAR2(15) NOT NULL	Event code that corresponds to a specific type of event. Can be used for finer filtering of events.
7	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
8	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
9	EVENT_TRACKING_ID	Number(10,0)	DECIMAL(10) NOT NULL	The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.