XML_SETPrompt Table: XML_SET_TBL
XML_NODE_IDC=Complex
S=Simple
Y/N Table Edit
XML_NODE_S_VW(SQL View) |
Index Back |
|---|---|
XML Simples Node VW ESPThis view retrieves simple nodes |
| SELECT XML_SET , XML_NODE_ID , DESCR50 , XML_NODE_NM , XML_NODE_TYPE , XML_ROOT FROM PS_XML_NODE_TBL WHERE XML_ROOT = 'N' AND XML_NODE_TYPE = 'S' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XML_SET |
Character(5) | VARCHAR2(5) NOT NULL |
XML Set
Prompt Table: XML_SET_TBL |
| 2 | XML_NODE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Root node |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | XML_NODE_NM | Character(50) | VARCHAR2(50) NOT NULL | Tag node |
| 5 | XML_NODE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Node type
C=Complex S=Simple |
| 6 | XML_ROOT | Character(1) | VARCHAR2(1) NOT NULL |
Root node
Y/N Table Edit |