TREE_NAMETREE_NODESETIDTIME_SETSEQ_NUMPOS_IMPCT_HDG_V(SQL View) |
Index Back |
|---|---|
Position Impact Heading ViewView of the position impact reporting periods. Used in the position monitor. |
| SELECT DISTINCT P.TREE_NAME ,P.TREE_NODE ,T.SETID ,T.TIME_SET ,T.SEQ_NUM ,T.PERIOD_START_DT ,T.PERIOD_END_DT 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 |
| # | 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 | PERIOD_START_DT | Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 7 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |