XMLGF_ITEM(SQL Table) |
Index Back |
---|---|
XML Framework ItemXML 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 |