XMLGF_ITEM

(SQL Table)
Index Back

XML Framework Item

XML Framework Item

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 XMLFILE_ID Character(50) VARCHAR2(50) NOT NULL XML File ID
4 KEY1_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 1 Field Value
5 KEY2_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 2 Field Value
6 KEY3_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 3 Field Value
7 XML_NODE_ID Character(6) VARCHAR2(6) NOT NULL Root node
8 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

Default Value: 4