TREE_CHRTFD2_VW (SQL View)	Index Back
Tree for Combo Edit Chartfield SUMMER TREE VIEW GL 9: replace EFFDT with EFFDT_TREE remove DESCR

TREE_CHRTFD2_VW

(SQL View)

Tree for Combo Edit Chartfield

SUMMER TREE VIEW GL 9: replace EFFDT with EFFDT_TREE remove DESCR

SELECT C.SETCNTRLVALUE , B.DTL_FIELDNAME , A.TREE_NAME , A.EFFDT , A.EFF_STATUS FROM PSTREEDEFN A , PSTREESTRCT B , PS_SET_CNTRL_TBL C WHERE B.TREE_STRCT_ID = A.TREE_STRCT_ID AND (C.SETID = A.SETID OR (EXISTS ( SELECT 'X' FROM PS_SET_CNTRL_TREE D WHERE D.SETCNTRLVALUE = C.SETCNTRLVALUE AND D.SETID = A.SETID AND D.TREE_NAME = A.TREE_NAME))) AND B.NODE_FIELDNAME = 'TREE_NODE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value

2 COMBO_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Non-Anchor ChartField

3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

4 EFFDT_TREE Date(10) DATE Tree Effective Date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
2	COMBO_CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	Non-Anchor ChartField
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
4	EFFDT_TREE	Date(10)	DATE	Tree Effective Date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive