XML_MBR_ESP_VW(SQL View) |
Index Back |
|---|---|
View for prompting CNO ESPView for prompting CNO Codes (Spanish local administrative Jobcodes for Delt@ Report) |
| SELECT A.XML_NODE_ID , B.XML_NODE_NM , A.XML_NODE_MBR , C.XML_NODE_NM , A.XML_SEQ_NBR FROM PS_XML_MEMBRS A , PS_XML_NODE_TBL B , PS_XML_NODE_TBL C WHERE A.XML_NODE_ID = B.XML_NODE_ID AND A.XML_NODE_MBR = C.XML_NODE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XML_NODE_ID | Character(6) | VARCHAR2(6) NOT NULL | Root node |
| 2 | XML_NODE_NM | Character(50) | VARCHAR2(50) NOT NULL | Tag node |
| 3 | XML_NODE_MBR | Character(6) | VARCHAR2(6) NOT NULL | Node identification |
| 4 | XML_NODE_TAG | Character(50) | VARCHAR2(50) NOT NULL | Root node |
| 5 | XML_SEQ_NBR | Number(7,0) | INTEGER NOT NULL | Sequence number |