PMT_SEC_RULE_VW

(SQL View)
 Index Back

Returns security rule list

Returns the list of rules based on type of security.

SELECT RULE_ID , PMT_RULE_NAME , PMT_SECURITY_TYPE ,PMT_RULE_ACTION ,PMT_RULE_MSG ,EVENT_CODE ,MESSAGE_SET_NBR , MESSAGE_NBR FROM PS_PMT_RULE WHERE PMT_SECURITY_TYPE = 'S'

# 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.