TED_STRCT_VW (SQL View)	Index Back
Vw-Tree Structure Names

TED_STRCT_VW

(SQL View)

Vw-Tree Structure Names

SELECT A.TREE_STRCT_ID ,A.DESCR FROM PSTREESTRCT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_STRCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Name (see PSTREESTRCT).
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description