POS_NODE_SRC_VW (SQL View)	Index Back
Sources used by node View of sources used by a node. Used as an edit table on the position monitor.

POS_NODE_SRC_VW

(SQL View)

Sources used by node

View of sources used by a node. Used as an edit table on the position monitor.

SELECT SETID , TREE_NAME , SOURCE_SET , TREE_NODE , POS_SOURCE_ID FROM PS_POS_WHERE_HDR WHERE USE_SOURCE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

3 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.

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

5 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset
Prompt Table: POS_SOURCE_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
3	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
4	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
5	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset Prompt Table: POS_SOURCE_TBL