XML_FILE_LVL1VW

(SQL View)
Index Back

XML File View

XML File View

SELECT DISTINCT XMLFILE_ID , KEY1_FLD_VAL , XML_SEQ_NBR , 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 XML_SEQ_NBR Number(7,0) INTEGER NOT NULL Sequence number
4 XML_LEVEL Number(3,0) SMALLINT NOT NULL Level
5 XML_NODE_ID Character(6) VARCHAR2(6) NOT NULL Root node
6 XML_NODE_VALUE Character(50) VARCHAR2(50) NOT NULL Node value