RE_CPYUDF (SQL View)	Index Back
User Defined Fields This record holds the 10 User Defined Fields to be used by Lease Administration.

RE_CPYUDF

(SQL View)

User Defined Fields

This record holds the 10 User Defined Fields to be used by Lease Administration.

SELECT SETID , USR_DEF_ID , UDF_FLDNM , UDF_DESCR FROM PS_RE_UDF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 USR_DEF_ID Number(10,0) DECIMAL(10) NOT NULL This field holds the Unique ID for each User Defined Field in a SetID.

3 UDF_FLDNM Character(15) VARCHAR2(15) NOT NULL This field holds the label for the User Defined Field.

4 UDF_DESCR Character(30) VARCHAR2(30) NOT NULL This field holds the description for the User Defined Field.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	USR_DEF_ID	Number(10,0)	DECIMAL(10) NOT NULL	This field holds the Unique ID for each User Defined Field in a SetID.
3	UDF_FLDNM	Character(15)	VARCHAR2(15) NOT NULL	This field holds the label for the User Defined Field.
4	UDF_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field holds the description for the User Defined Field.