REGN_ZIP_ND_VW (SQL View)	Index Back
Region Zip Parent Node View This view returns the zipcode ranges for each lowest-level region (parent node) on the Region tree.

REGN_ZIP_ND_VW

(SQL View)

Region Zip Parent Node View

This view returns the zipcode ranges for each lowest-level region (parent node) on the Region tree.

SELECT A.SETID ,A.TREE_NODE ,A.TREE_NODE_NUM ,C.TREE_EFFDT ,E.RANGE_FROM ,E.RANGE_TO FROM PSTREENODE A ,PS_R_AD505 C ,PSTREELEAF E WHERE A.TREE_NAME = 'REGION' AND A.SETID = C.SETID AND E.SETID = A.SETID AND E.EFFDT = C.TREE_EFFDT AND E.TREE_NAME = A.TREE_NAME AND E.EFFDT = A.EFFDT AND E.TREE_NODE_NUM=A.TREE_NODE_NUM

# 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

5 RANGE_FROM Character(30) VARCHAR2(30) NOT NULL Lower boundary for detail value that contains a range of values

6 RANGE_TO Character(30) VARCHAR2(30) NOT NULL Upper boundary for detail value that contains a range of values

#	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
5	RANGE_FROM	Character(30)	VARCHAR2(30) NOT NULL	Lower boundary for detail value that contains a range of values
6	RANGE_TO	Character(30)	VARCHAR2(30) NOT NULL	Upper boundary for detail value that contains a range of values