XML_FILE_LVL2VW

(SQL View)
Index Back

XML File View

XML 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