XML_NODE_IDXML_SEQ_NBRXML_NODE_MBRPrompt Table: XML_NODE_VW
XML_SORT_SEQPrompt Table: XML_SORTFLD_VW
ASC=Ascending
DESC=Descending
XML_SORT(SQL Table) |
Index Back |
|---|---|
XML Node SortThis record allows to define sorting options for the XML iterative node. |
| # | 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_SORT_SEQ |
Number(7,0) | INTEGER NOT NULL | XML Sort Sequence number |
| 5 | XML_SORT_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
XML Sort Fieldname
Prompt Table: XML_SORTFLD_VW |
| 6 | XML_SORT_ORDER | Character(4) | VARCHAR2(4) NOT NULL |
XML Sort Order - Ascending (ASC) or Descending (DESC).
ASC=Ascending DESC=Descending |