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 | 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 |