RE_CLSCPYUDF_VW (SQL View)	Index Back
Clause User Defined Fields This record is used for designing Clause User Defined Fields.

RE_CLSCPYUDF_VW

(SQL View)

Clause User Defined Fields

This record is used for designing Clause User Defined Fields.

SELECT SETID , USR_DEF_ID , UDF_FLDNM , UDF_DESCR FROM PS_RE_CLS_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.