IDO_EDT2_JPN_VW (SQL View)	Index Back
Prompt view for EFFDT2_JPN Used as a prompt view for the field EFFDT2_JPN.

IDO_EDT2_JPN_VW

(SQL View)

Prompt view for EFFDT2_JPN

Used as a prompt view for the field EFFDT2_JPN.

SELECT SETID , TREE_NAME , EFFDT FROM PSTREEDEFN WHERE TREE_STRCT_ID IN ('DEPARTMENT')

# 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.

#	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.