COMBO_TRCF2_VW

(SQL View)
 Index Back

WINTER/SPRING TREES

FOR COMBO EDIT TREE PROMPT

SELECT C.SETCNTRLVALUE ,B.NODE_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 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL 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