XML_NODE_IDXML_SEQ_NBRPrompt Table: XML_NODE_VW
Prompt Table: XML_SET_TBL
C=Complex
S=Simple
XML_MEMBRS2_VW(SQL View) |
Index Back |
|---|---|
XML Node vw for HR SpainXML Node vw for HR Spain |
| SELECT B.XML_NODE_ID , B.XML_SEQ_NBR , B.XML_NODE_MBR , B.XML_SET , A.DESCR50 , A.XML_NODE_TYPE FROM PS_XML_NODE_TBL A , PS_XML_MEMBRS B WHERE A.XML_NODE_ID = B.XML_NODE_MBR AND A.XML_SET = B.XML_SET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XML_NODE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Root node |
| 2 | XML_SEQ_NBR |
Number(7,0) | INTEGER NOT NULL | Sequence number |
| 3 | XML_NODE_MBR | Character(6) | VARCHAR2(6) NOT NULL |
Node identification
Prompt Table: XML_NODE_VW |
| 4 | XML_SET | Character(5) | VARCHAR2(5) NOT NULL |
XML Set
Prompt Table: XML_SET_TBL |
| 5 | XML_NODE_TAG | Character(50) | VARCHAR2(50) NOT NULL | Root node |
| 6 | XML_NODE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Node type
C=Complex S=Simple |