GPSC_XMLRF_UN_NBRXML_SEQ_NBRC=Complex
S=Simple
GPSC_XMLRF_STG(SQL Table) |
Index Back |
|---|---|
Reading XML - Staging dataThis table is used to store data in XML file in node-data format |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPSC_XMLRF_UN_NBR |
Number(20,0) | DECIMAL(20) NOT NULL | Field to store unique numbers that are needed in reading XML files |
| 2 | XML_SEQ_NBR |
Number(7,0) | INTEGER NOT NULL | Sequence number |
| 3 | LEVEL1 | Number(5,0) | INTEGER NOT NULL | Level 1 |
| 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_NODE_PATH | Character(250) | VARCHAR2(250) NOT NULL | Node value |
| 7 | XML_STRING | Long Character | CLOB | Preview XML |
| 8 | RECORDNAME | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 9 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 10 | KEY1 | Character(65) | VARCHAR2(65) NOT NULL | First Key |