XML_ITEM_LVL2VW(SQL View) |
Index Back |
---|---|
XML File ViewXML File View |
SELECT DISTINCT XMLFILE_ID , KEY1_FLD_VAL , KEY2_FLD_VAL , KEY3_FLD_VAL , XML_NODE_STATUS , XML_NODE_ID FROM PS_XML_ITEM WHERE KEY1_FLD_VAL <> ' ' AND KEY2_FLD_VAL <> ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(50) | VARCHAR2(50) NOT NULL |
XML File ID
Prompt Table: XML_DEFN |
|
2 | Character(50) | VARCHAR2(50) NOT NULL | Key 1 Field Value | |
3 | Character(50) | VARCHAR2(50) NOT NULL | Key 2 Field Value | |
4 | 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 |
6 | XML_NODE_ID | Character(6) | VARCHAR2(6) NOT NULL | Root node |