XMLGF_ITEM_ELMT(SQL Table) | 
Index Back | 
|---|---|
XML Framework Element KeysXML Framework Item Element Keys | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | Character(50) | VARCHAR2(50) NOT NULL | 
XML File ID
 Prompt Table: XML_DEFN  | 
|
| 4 | Character(50) | VARCHAR2(50) NOT NULL | Key 1 Field Value | |
| 5 | Character(50) | VARCHAR2(50) NOT NULL | Key 2 Field Value | |
| 6 | Character(50) | VARCHAR2(50) NOT NULL | Key 3 Field Value | |
| 7 | 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 |