POSN_TREE_VW

(SQL View)
 Index Back

Position Tree View


SELECT J.EMPLID , J.EMPL_RCD , J.REPORTS_TO , T.TREE_NODE , T.PARENT_NODE_NAME FROM PSTREENODE T , PS_JOB J WHERE T.TREE_NAME = 'POSITION' AND T.EFFDT =( SELECT MAX(T2.EFFDT) FROM PSTREENODE T2 WHERE T.SETID = T2.SETID AND T.SETCNTRLVALUE = T2.SETCNTRLVALUE AND T.TREE_NAME = T2.TREE_NAME AND T2.EFFDT <=%CurrentDateIn ) AND J.POSITION_NBR = T.TREE_NODE AND J.EFFDT= ( SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J.EMPLID=J2.EMPLID AND J.EMPL_RCD=J2.EMPL_RCD AND J2.EFFDT<=%CurrentDateIn ) AND J.EFFSEQ= ( SELECT MAX(J3.EFFSEQ) FROM PS_JOB J3 WHERE J.EMPLID=J3.EMPLID AND J.EMPL_RCD=J3.EMPL_RCD AND J.EFFDT=J3.EFFDT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
4 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
5 PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node