REGN_BASE_ND_VW (SQL View)	Index Back
Region Base Node View This view returns the lowest-level regions on the Region tree.

REGN_BASE_ND_VW

(SQL View)

Region Base Node View

This view returns the lowest-level regions on the Region tree.

SELECT A.SETID ,A.TREE_NODE ,A.TREE_NODE_NUM ,C.TREE_EFFDT FROM PSTREENODE A ,PS_R_AD505 C WHERE A.TREE_NAME = 'REGION' AND A.EFFDT = C.TREE_EFFDT AND A.SETID = C.SETID AND EXISTS (SELECT 'X' FROM PSTREELEAF E WHERE E.TREE_NODE_NUM=A.TREE_NODE_NUM AND E.SETID = A.SETID AND E.TREE_NAME = A.TREE_NAME AND E.EFFDT = A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

2 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

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

4 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
2	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
3	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
4	TREE_EFFDT	Date(10)	DATE NOT NULL	Effective date of the Tree