PMT_SEC_USR_FIE (SQL Table)	Index Back
Payment Security User Fields Security Fields tied to a user.

PMT_SEC_USR_FIE

(SQL Table)

Payment Security User Fields

Security Fields tied to a user.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

3 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	PMT_RULE_FIELD_ID	Character(18)	VARCHAR2(18) NOT NULL	Unique identifier for a field referenced in a rule.
3	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)