XMLFILE_IDPrompt Table: XML_SET_TBL
Prompt Table: XML_TEMPLT_TBL
XML_RESP_SRCH(SQL View) |
Index Back |
|---|---|
XML DefinitionXML Definition |
| SELECT A.XMLFILE_ID , B.DESCR , B.XML_SET , B.XML_TEMPLATE_ID FROM PS_XML_RESPONSE A , PS_XML_DEFN B WHERE A.XMLFILE_ID = B.XMLFILE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XMLFILE_ID |
Character(50) | VARCHAR2(50) NOT NULL | XML File ID |
| 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 |