TREE_NAMETREE_NODESETIDTIME_SETSEQ_NUMPOS_SOURCE_IDPOS_IMPCT_SUM_V(SQL View) |
Index Back |
|---|---|
Pos. Impact Summation View |
| SELECT P.TREE_NAME ,P.TREE_NODE ,T.SETID ,T.TIME_SET ,T.SEQ_NUM ,P.POS_SOURCE_ID ,SUM(P.POS_IMPCT_ORIG) FROM PS_POS_PERIOD_TBL T, PS_POS_IMPCT_HDR P WHERE P.VALUE_DT <= T.PERIOD_END_DT AND P.VALUE_DT >= T.PERIOD_START_DT GROUP BY P.TREE_NAME ,P.TREE_NODE ,T.SETID ,T.TIME_SET ,T.SEQ_NUM ,P.POS_SOURCE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 2 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | TIME_SET |
Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier that represents a time horizon definition dataset. |
| 5 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 6 | POS_SOURCE_ID |
Character(18) | VARCHAR2(18) NOT NULL | "A unique key identifier that represents a position source dataset |
| 7 | POS_IMPCT_ORIG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the calculated monetary value for a specific position tree node; the result |