OPRIDXMLFILE_IDKEY1_FLD_VALKEY2_FLD_VALKEY3_FLD_VAL0=XML Sent Confirmed
1=Data OK
2=Required Data
3=Data Not Validated
4=Data Not Loaded
Default Value: 4
XML_ITEMSRCH_VW(SQL View) |
Index Back |
|---|---|
Contract Printing Vw ESPContract Printing Vw ESP |
| SELECT DISTINCT C.OPRID , C.ROWSECCLASS , A.XMLFILE_ID , A.KEY1_FLD_VAL , A.KEY2_FLD_VAL , A.KEY3_FLD_VAL , A.XML_NODE_STATUS , A.XML_NODE_ID FROM PS_XML_ITEM A , PS_PERS_SRCH_GBL C WHERE A.KEY1_FLD_VAL = C.EMPLID |
| # | 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 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 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_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 |
| 8 | XML_NODE_ID | Character(6) | VARCHAR2(6) NOT NULL | Root node |