WCS_UNQ_NODE_VW (SQL View)	Index Back
Unique Access Node View Determines the distinct list of node from the Access Roles table wthin WCS that have at least one Role associated with it.

WCS_UNQ_NODE_VW

(SQL View)

Unique Access Node View

Determines the distinct list of node from the Access Roles table wthin WCS that have at least one Role associated with it.

SELECT TREE_NODE_NUM , BUDGET_ID , BUDGET_START_DT , TREE_NODE_NUM_END , TREE_LEVEL_NUM FROM PS_WCS_ECM_ACCESS

Parent record: WCS_ECM_NOD_STS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID

3 BUDGET_START_DT Date(10) DATE NOT NULL Budget Start Date

4 TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
2	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
3	BUDGET_START_DT	Date(10)	DATE NOT NULL	Budget Start Date
4	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending 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