PMT_SEC_FLD_VW (SQL View)	Index Back
Returns list of security field Returns a list of security fields based on passed criteria.

PMT_SEC_FLD_VW

(SQL View)

Returns list of security field

Returns a list of security fields based on passed criteria.

SELECT F.PMT_RULE_FIELD_ID FROM PS_PMT_RULE_FIELD F , PS_PMT_SEC_FIELDS S WHERE S.PMT_RULE_FIELD_ID = F.PMT_RULE_FIELD_ID AND S.PMT_SEC_FIELD_SW = 'Y' AND F.PMT_SECURITY_TYPE = 'S'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PMT_RULE_FIELD_ID Character(18) VARCHAR2(18) NOT NULL Unique identifier for a field referenced in a rule.