EFFDTDefault Value: %date
RSF_ACC_FLAT_VW(SQL View) |
Index Back |
|---|---|
Flattened Territory Tree ViewA tree hierarchy is broken down to a sequence of flat records. |
| SELECT DISTINCT T.EFFDT , TEAM.PERSON_ID , T.TREE_NAME , T.TREE_NODE_NUM , T.TREE_LEVEL_NUM , T.TERRITORY_ID , T.PERSON_ID , T.NAME , T.PARENT_FLAG , T.SYNCID , T.SYNCDTTM FROM PS_RSF_ACC_FLAT T , PS_RSF_TR_TEAM TEAM WHERE T.TREE_NAME =TEAM.TREE_NAME AND EXISTS ( SELECT 'X' FROM PS_RSF_ACC_TRU_VW R WHERE R.TERRITORY_PARENT = TEAM.TERRITORY_ID AND R.TREE_NAME = TEAM.TREE_NAME AND T.TERRITORY_ID = R.TERRITORY_ID AND T.TREE_NAME = R.TREE_NAME) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 2 | PERSON_ID_MANAGER | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 3 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 4 | TREE_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 5 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 6 | TERRITORY_ID | Character(20) | VARCHAR2(20) NOT NULL | Territory ID |
| 7 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 8 | NAME_PARENT | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 9 | PARENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Parent Flag |
| 10 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 11 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |