EMPLIDEMPL_RCDEFFDTDefault Value: %date
EFFSEQTREE_NAMEFT_PAR_DEPT_VW(SQL View) |
Index Back |
|---|
| SELECT J.EMPLID , EMPL_RCD , J.EFFDT , J.EFFSEQ , C.TREE_NAME , J.DEPTID , P.TREE_NODE FROM PSTREENODE C , PSTREENODE P , PS_JOB J WHERE C.SETID = P.SETID AND C.SETCNTRLVALUE = P.SETCNTRLVALUE AND C.TREE_NAME = P.TREE_NAME AND C.EFFDT = P.EFFDT AND C.PARENT_NODE_NUM = P.TREE_NODE_NUM AND J.SETID_DEPT = C.SETID AND C.SETCNTRLVALUE = ' ' AND J.DEPTID = C.TREE_NODE AND C.EFFDT = ( SELECT MAX(T.EFFDT) FROM PSTREENODE T WHERE C.SETID = T.SETID AND C.SETCNTRLVALUE = T.SETCNTRLVALUE AND C.TREE_NAME = T.TREE_NAME AND T.EFFDT <= J.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 Record |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 7 | FT_DEPTID_PARENT | Character(20) | VARCHAR2(20) NOT NULL | Parent Department |