IDO_TN2_JPN_VW

(SQL View)
Index Back

Prompt view for TREE_NODE_JPN

Prompt view for TREE_NODE_JPN

SELECT SETID , TREE_NAME , EFFDT , TREE_NODE FROM PSTREENODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID_2 Character(5) VARCHAR2(5) NOT NULL Setid used to build the Template for entering Bulk Positive Input
2 TREE_NAME_JPN Character(18) VARCHAR2(18) NOT NULL This field is used as a second Tree Name field on a page
3 EFFDT2_JPN Date(10) DATE This field is used as an Effective Date field on a page. This field prompts for acceptable values, and the Core field EFFDT does not permit such prompting.
4 TREE_NODE_JPN Character(20) VARCHAR2(20) NOT NULL This field is used as a second Tree Node field on a page.