XML_SETPrompt Table: XML_SET_TBL
XML_TEMPLATE_IDPrompt Table: XML_TEMPLT_TBL
XMLFILE_IDXML_SRCH_VW(SQL View) |
Index Back |
|---|---|
XML Search ViewXML Search view for XML Files, searching by XML Set and XML Template |
| SELECT XML_SET , XML_TEMPLATE_ID , XMLFILE_ID , DESCR FROM PS_XML_DEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XML_SET |
Character(5) | VARCHAR2(5) NOT NULL |
XML Set
Prompt Table: XML_SET_TBL |
| 2 | XML_TEMPLATE_ID |
Character(3) | VARCHAR2(3) NOT NULL |
Template type
Prompt Table: XML_TEMPLT_TBL |
| 3 | XMLFILE_ID |
Character(50) | VARCHAR2(50) NOT NULL | XML File ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |