XML_ITEM_ELEMNT

(SQL Table)
Index Back

XML File Temporary Table

XML File Temporary 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 KEY1_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 1 Field Value
3 KEY2_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 2 Field Value
4 KEY3_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 3 Field Value
5 XML_SEQ_NBR 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