IT_BU_TREESETID

(SQL View)
 Index Back

Tree setid for IT oprid setid

Tree setid for IT oprid setid and tree name

SELECT %Substring(C.SETCNTRLVALUE, 1, 5) , T.TREE_NAME , T.SETID FROM PSTREEDEFN T , PS_SET_CNTRL_TBL C WHERE (C.SETID = T.SETID OR EXISTS ( SELECT 'X' FROM PS_SET_CNTRL_TREE E WHERE E.SETCNTRLVALUE = C.SETCNTRLVALUE AND E.SETID = T.SETID AND E.TREE_NAME = T.TREE_NAME))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
3 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID