PSTREEFLDDTLVW

(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

SELECT recname ,fieldname FROM PSRECFLDKEYSVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DTL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Detail Record name
2 DTL_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Detail Record name