PSTREEFLDNODVW (SQL View)	Index Back
Tree Struct Rec Field Prompt Prompt view used by Tree Structure maintenance to prompt for all fields for a given record name

PSTREEFLDNODVW

(SQL View)

Tree Struct Rec Field Prompt

Prompt view used by Tree Structure maintenance to prompt for all fields for a given record name

SELECT recname ,fieldname FROM PSRECFLDKEYSVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 NODE_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Node Record name

2 NODE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Node Field name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	NODE_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Tree Structure Node Record name
2	NODE_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Node Field name