XML_ITEM_ELEMNT(SQL Table) |
Index Back |
|---|---|
XML File Temporary TableXML File Temporary Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(50) | VARCHAR2(50) NOT NULL |
XML File ID
Prompt Table: XML_DEFN |
|
| 2 | Character(50) | VARCHAR2(50) NOT NULL | Key 1 Field Value | |
| 3 | Character(50) | VARCHAR2(50) NOT NULL | Key 2 Field Value | |
| 4 | Character(50) | VARCHAR2(50) NOT NULL | Key 3 Field Value | |
| 5 | Number(7,0) | INTEGER NOT NULL | Sequence number | |
| 6 | XML_KEY1_FLD | Character(15) | VARCHAR2(15) NOT NULL | Key Field 1 |
| 7 | XML_KEY1_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key Value 1 |
| 8 | XML_KEY2_FLD | Character(15) | VARCHAR2(15) NOT NULL | Key Field 2 |
| 9 | XML_KEY2_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key Value 2 |
| 10 | XML_KEY3_FLD | Character(15) | VARCHAR2(15) NOT NULL | Key Field 3 |
| 11 | XML_KEY3_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key Value 3 |
| 12 | XML_KEY4_FLD | Character(15) | VARCHAR2(15) NOT NULL | Key Field 4 |
| 13 | XML_KEY4_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key Value 4 |
| 14 | XML_KEY5_FLD | Character(15) | VARCHAR2(15) NOT NULL | Key Field 5 |
| 15 | XML_KEY5_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key Value 5 |
| 16 | XML_KEY6_FLD | Character(15) | VARCHAR2(15) NOT NULL | Key Field 6 |
| 17 | XML_KEY6_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key Value 6 |
| 18 | XML_KEY7_FLD | Character(15) | VARCHAR2(15) NOT NULL | Key Field 7 |
| 19 | XML_KEY7_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key Value 7 |
| 20 | XML_KEY8_FLD | Character(15) | VARCHAR2(15) NOT NULL | Key Field 8 |
| 21 | XML_KEY8_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key Value 8 |
| 22 | XML_KEY9_FLD | Character(15) | VARCHAR2(15) NOT NULL | Key Field 9 |
| 23 | XML_KEY9_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key Value 9 |
| 24 | XML_TRACK_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Track Status |