XMLFILE_IDPrompt Table: XML_DEFN
XML_SEQ_NBRPrompt Table: XML_NAMES_DVW
Prompt Table: XML_NODES_DVW
Prompt Table: XML_VALUES_DVW
Prompt Table: XML_VALUES2_DVW
Prompt Table: XML_VALUES3_DVW
XML_RESPONSE(SQL Table) |
Index Back |
|---|---|
XML File TableXML File Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XMLFILE_ID |
Character(50) | VARCHAR2(50) NOT NULL |
XML File ID
Prompt Table: XML_DEFN |
| 2 | XML_SEQ_NBR |
Number(7,0) | INTEGER NOT NULL | Sequence number |
| 3 | XML_LEVEL | Number(3,0) | SMALLINT NOT NULL | Level |
| 4 | XML_NODE_VALUE | Character(50) | VARCHAR2(50) NOT NULL | Node value |
| 5 | XML_NODE_PATH | Character(250) | VARCHAR2(250) NOT NULL | Node value |
| 6 | XML_NODE_NM | Character(50) | VARCHAR2(50) NOT NULL |
Tag node
Prompt Table: XML_NAMES_DVW |
| 7 | XML_NODE_ID | Character(6) | VARCHAR2(6) NOT NULL |
Root node
Prompt Table: XML_NODES_DVW |
| 8 | KEY1_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL |
Key 1 Field Value
Prompt Table: XML_VALUES_DVW |
| 9 | KEY2_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL |
Key 2 Field Value
Prompt Table: XML_VALUES2_DVW |
| 10 | KEY3_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL |
Key 3 Field Value
Prompt Table: XML_VALUES3_DVW |