WHEREUSEDOBJVW2 (SQL View)	Index Back
Where Used Object Type Tbl Object types used in app designer projects.

WHEREUSEDOBJVW2

(SQL View)

Where Used Object Type Tbl

Object types used in app designer projects.

SELECT WHEREUSEDOBJTYPE ,DESCR ,ABBREV_3 FROM %Table(WHEREUSEDOBJTBL)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 WHEREUSEDOBJTYPE Signed Number(4,0) DECIMAL(3) NOT NULL Where Used Object Type. This includes non copyable objects which are represented by negative numbers.

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 ABBREV_3 Character(3) VARCHAR2(3) NOT NULL Three Letter Abbreviation

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WHEREUSEDOBJTYPE	Signed Number(4,0)	DECIMAL(3) NOT NULL	Where Used Object Type. This includes non copyable objects which are represented by negative numbers.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	ABBREV_3	Character(3)	VARCHAR2(3) NOT NULL	Three Letter Abbreviation