NVS_SCOPENDBUVW

index back

XX


SELECT A.SETID ,A.TREE_NAME ,A.TREE_NODE ,A.EFFDT FROM PSTREENODE A ,PSTREEDEFN B WHERE B.SETID = A.SETID AND B.SETCNTRLVALUE = A.SETCNTRLVALUE AND B.TREE_NAME = A.TREE_NAME AND B.EFFDT = A.EFFDT AND ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PSTREENODE A_ED WHERE A.SETID = A_ED.SETID AND A.SETCNTRLVALUE = A_ED.SETCNTRLVALUE AND A.TREE_NAME = A_ED.TREE_NAME ) AND B.EFF_STATUS = 'A' )

PeopleSoft Field NameField TypeColumn TypeDescription
SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID
TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
TREE_NODECharacter(20)VARCHAR2(20) NOT NULLNode name
EFFDTDate(10)DATE NOT NULLEffective Date
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19