FLD_REQ_TUF_VW (SQL View)	Index Back
Field Request User Fields View Field Request Template User Defined Fields View

FLD_REQ_TUF_VW

(SQL View)

Field Request User Fields View

Field Request Template User Defined Fields View

SELECT FIELDNAME , LENGTH , DECIMALPOS FROM PSDBFIELD WHERE FIELDNAME LIKE 'FLD_REQ_U%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

2 LENGTH Number(5,0) INTEGER NOT NULL Length

3 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
3	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions