RSF_ACC_FLAT_V1 (SQL View)	Index Back
Flattened Tree table CRM Sales - Flattened Tree table.

RSF_ACC_FLAT_V1

(SQL View)

Flattened Tree table

CRM Sales - Flattened Tree table.

SELECT TREE_NAME , EFFDT , TERRITORY_PARENT , TERRITORY_ID , PERSON_ID_MANAGER , PERSON_ID , NAME_PARENT , NAME , TREE_NODE_NUM , TREE_LEVEL_NUM , PARENT_FLAG , PROCESS_INSTANCE , SYNCID , SYNCDTTM FROM PS_RSF_ACC_FLAT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 TERRITORY_PARENT Character(20) VARCHAR2(20) NOT NULL Territory Parent

4 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID

5 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

6 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

7 NAME_PARENT Character(50) VARCHAR2(50) NOT NULL Name

8 NAME Character(50) VARCHAR2(50) NOT NULL Name

9 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number

10 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record

11 PARENT_FLAG Character(1) VARCHAR2(1) NOT NULL Parent Flag

12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

13 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.

14 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	TERRITORY_PARENT	Character(20)	VARCHAR2(20) NOT NULL	Territory Parent
4	TERRITORY_ID	Character(20)	VARCHAR2(20) NOT NULL	Territory ID
5	PERSON_ID_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
6	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
7	NAME_PARENT	Character(50)	VARCHAR2(50) NOT NULL	Name
8	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
9	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
10	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
11	PARENT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Parent Flag
12	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
13	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.
14	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time