PMT_SEC_FIELDS (SQL Table)	Index Back
Payment Security Fields Contains the fields that are available for security.

PMT_SEC_FIELDS

(SQL Table)

Payment Security Fields

Contains the fields that are available for security.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PMT_SECURITY Character(1) VARCHAR2(1) NOT NULL Level 0 field for payment security options.

2 PMT_RULE_FIELD_ID Character(18) VARCHAR2(18) NOT NULL Unique identifier for a field referenced in a rule.
Prompt Table: PMT_SEC_FLD_VW

3 PMT_SEC_FIELD_SW Character(1) VARCHAR2(1) NOT NULL Payment Security Field Switch
N=No
Y=Yes
Default Value: N

4 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PMT_SECURITY	Character(1)	VARCHAR2(1) NOT NULL	Level 0 field for payment security options.
2	PMT_RULE_FIELD_ID	Character(18)	VARCHAR2(18) NOT NULL	Unique identifier for a field referenced in a rule. Prompt Table: PMT_SEC_FLD_VW
3	PMT_SEC_FIELD_SW	Character(1)	VARCHAR2(1) NOT NULL	Payment Security Field Switch N=No Y=Yes Default Value: N
4	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition)