XMLFILE_IDPrompt Table: XML_DEFN
KEY1_FLD_VALKEY2_FLD_VALXML_FILE_LVL2VW(SQL View) |
Index Back |
|---|---|
XML File ViewXML File View |
| SELECT DISTINCT XMLFILE_ID , KEY1_FLD_VAL , KEY2_FLD_VAL , KEY3_FLD_VAL , XML_LEVEL , XML_NODE_ID , XML_NODE_VALUE FROM PS_XML_FILE_TBL WHERE KEY2_FLD_VAL <> ' ' AND KEY3_FLD_VAL = ' ' |
| # | 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_LEVEL | Number(3,0) | SMALLINT NOT NULL | Level |
| 6 | XML_NODE_ID | Character(6) | VARCHAR2(6) NOT NULL | Root node |
| 7 | XML_NODE_VALUE | Character(50) | VARCHAR2(50) NOT NULL | Node value |