SETIDDEPTID_SUMEFFDTSUMTREE_DPT_VW(SQL View) |
Index Back |
|---|---|
Summary Trees - Department |
| select a.setid, a.tree_node, a.effdt, b.descr from PSTREENODE a, ps_tree_node_tbl b where a.setid = 'MFG' and a.tree_name = 'MFG_DEPARTMENTS' and a.setid = b.setid and a.tree_node=b.tree_node and a.tree_level_num = 3 and b.effdt = (select max(effdt) from ps_tree_node_tbl where setid=b.setid and tree_node=b.tree_node and effdt <= a.effdt) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DEPTID_SUM |
Character(20) | VARCHAR2(20) NOT NULL | Summary Department Node |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |