XMLFILE_IDPrompt Table: XML_SRCH_VW
Prompt Table: XML_SET_TBL
Prompt Table: XML_TEMPLT_TBL
XML_SNT_SRCH(SQL View) |
Index Back |
|---|---|
Response XML File Search RcdResponse XML File Search Record. Shows sent XML files. |
| SELECT A.XMLFILE_ID , A.DESCR , A.XML_SET , A.XML_TEMPLATE_ID FROM PS_XML_DEFN A WHERE A.STATUS_ESP = 'S' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XMLFILE_ID |
Character(50) | VARCHAR2(50) NOT NULL |
XML File ID
Prompt Table: XML_SRCH_VW |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | XML_SET | Character(5) | VARCHAR2(5) NOT NULL |
XML Set
Prompt Table: XML_SET_TBL |
| 4 | XML_TEMPLATE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Template type
Prompt Table: XML_TEMPLT_TBL |