SETIDACCTEFFDTSUMTREE_ACT_VW(SQL View) |
Index Back |
|---|---|
Summary Trees - Account |
| SELECT a.setid , a.tree_node , a.effdt , b.descr FROM PSTREENODE a , ps_tree_node_tbl b WHERE a.setid = 'SHARE' AND a.tree_name = 'ACCTROLLUP' AND a.setid = b.setid AND a.tree_node=b.tree_node AND a.tree_level_num BETWEEN 4 AND 5 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 | ACCT |
Character(20) | VARCHAR2(20) NOT NULL | Account Node |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |