XMLGF_ITEM_ELMT

(SQL Table)
Index Back

XML Framework Element Keys

XML Framework Item Element Keys

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 XMLFILE_ID Character(50) VARCHAR2(50) NOT NULL XML File ID

Prompt Table: XML_DEFN

4 KEY1_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 1 Field Value
5 KEY2_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 2 Field Value
6 KEY3_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 3 Field Value
7 XML_SEQ_NBR Number(7,0) INTEGER NOT NULL Sequence number
8 XML_KEY1_FLD Character(15) VARCHAR2(15) NOT NULL Key Field 1
9 XML_KEY1_VAL Character(50) VARCHAR2(50) NOT NULL Key Value 1
10 XML_KEY2_FLD Character(15) VARCHAR2(15) NOT NULL Key Field 2
11 XML_KEY2_VAL Character(50) VARCHAR2(50) NOT NULL Key Value 2
12 XML_KEY3_FLD Character(15) VARCHAR2(15) NOT NULL Key Field 3
13 XML_KEY3_VAL Character(50) VARCHAR2(50) NOT NULL Key Value 3
14 XML_KEY4_FLD Character(15) VARCHAR2(15) NOT NULL Key Field 4
15 XML_KEY4_VAL Character(50) VARCHAR2(50) NOT NULL Key Value 4
16 XML_KEY5_FLD Character(15) VARCHAR2(15) NOT NULL Key Field 5
17 XML_KEY5_VAL Character(50) VARCHAR2(50) NOT NULL Key Value 5
18 XML_KEY6_FLD Character(15) VARCHAR2(15) NOT NULL Key Field 6
19 XML_KEY6_VAL Character(50) VARCHAR2(50) NOT NULL Key Value 6
20 XML_KEY7_FLD Character(15) VARCHAR2(15) NOT NULL Key Field 7
21 XML_KEY7_VAL Character(50) VARCHAR2(50) NOT NULL Key Value 7
22 XML_KEY8_FLD Character(15) VARCHAR2(15) NOT NULL Key Field 8
23 XML_KEY8_VAL Character(50) VARCHAR2(50) NOT NULL Key Value 8
24 XML_KEY9_FLD Character(15) VARCHAR2(15) NOT NULL Key Field 9
25 XML_KEY9_VAL Character(50) VARCHAR2(50) NOT NULL Key Value 9
26 XML_TRACK_STATUS Character(1) VARCHAR2(1) NOT NULL Track Status