OPRIDRUN_CNTL_IDXMLFILE_IDPrompt Table: XML_DEFN
KEY1_FLD_VALKEY2_FLD_VALKEY3_FLD_VALXML_SEQ_NBRXMLGF_NODES(SQL Table) |
Index Back |
|---|---|
XML Nodes for PrintingThis record stores the XML Node values for each XML File. |
| # | 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
Prompt Table: XML_DEFN |
| 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_SEQ_NBR |
Number(7,0) | INTEGER NOT NULL | Sequence number |
| 8 | XML_LEVEL | Number(3,0) | SMALLINT NOT NULL | Level |
| 9 | XML_NODE_ID | Character(6) | VARCHAR2(6) NOT NULL | Root node |
| 10 | XML_NODE_VALUE | Character(50) | VARCHAR2(50) NOT NULL | Node value |
| 11 | XML_LONG_VALUE | Long Character | CLOB | XML Long value |
| 12 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 13 | XML_EDITNODE | Character(10) | VARCHAR2(10) NOT NULL | This field have some node special properties: Position 1: Iterative (Y/N) Position 2: Required (Y/N) Position 3: PrintIfBlank (Y/N) Position 4: Manual Value (Y/N) |
| 14 | XML_ATTRIBUTES | Character(250) | VARCHAR2(250) NOT NULL | Node identification |