XML_ITEM2_VW

(SQL View)
 Index Back

Template/Item view

This view link the XML Item record with the Template ID. It is used to check that the data have not been already processed.

SELECT A.XML_TEMPLATE_ID ,B.KEY1_FLD_VAL ,B.KEY2_FLD_VAL ,B.KEY3_FLD_VAL ,B.XML_NODE_STATUS FROM PS_XML_DEFN A , PS_XML_ITEM B WHERE A.XMLFILE_ID = B.XMLFILE_ID AND B.XML_NODE_STATUS < '1'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 XML_TEMPLATE_ID Character(3) VARCHAR2(3) NOT NULL Template type
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_NODE_STATUS Character(1) VARCHAR2(1) NOT NULL Node Status
0=XML Sent Confirmed
1=Data OK
2=Required Data
3=Data Not Validated
4=Data Not Loaded