CTTANODE1_ESPVW (SQL View)	Index Back
Contrata Nodes Lvl 1 VW ESP This View retrieves Contrata Nodes al level 1

CTTANODE1_ESPVW

(SQL View)

Contrata Nodes Lvl 1 VW ESP

This View retrieves Contrata Nodes al level 1

SELECT XML_NODE_ID , DESCR50 , XML_NODE_NM , XML_NODE_TYPE FROM PS_XML_NODE_TBL WHERE XML_ROOT = 'N' AND XML_NODE_ID LIKE 'C1%' AND XML_SET = 'C01' AND XML_NODE_TYPE = 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 XML_NODE_ID Character(6) VARCHAR2(6) NOT NULL Root node

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 XML_NODE_NM Character(50) VARCHAR2(50) NOT NULL Tag node

4 XML_NODE_TYPE Character(1) VARCHAR2(1) NOT NULL Node type
C=Complex
S=Simple

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	XML_NODE_ID	Character(6)	VARCHAR2(6) NOT NULL	Root node
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	XML_NODE_NM	Character(50)	VARCHAR2(50) NOT NULL	Tag node
4	XML_NODE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Node type C=Complex S=Simple