XMLGF_AET

(SQL Table)
Index Back

XML Framework StateRec

XML Generation Framework StateRec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 XML_SET Character(5) VARCHAR2(5) NOT NULL XML Set

Prompt Table: XML_SET_TBL

5 XML_TEMPLATE_ID Character(3) VARCHAR2(3) NOT NULL Template type

Prompt Table: XML_TEMPLT_TBL

6 XMLFILE_ID Character(50) VARCHAR2(50) NOT NULL XML File ID

Prompt Table: XML_DEFN

7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
8 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
9 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
10 XML_LONG_VALUE Long Character CLOB XML Long value
11 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
12 KEY3_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 3 Field Value
13 KEY2_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 2 Field Value
14 KEY1_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 1 Field Value
15 XML_SEQ_NBR Number(7,0) INTEGER NOT NULL Sequence number
16 XML_OUTPUT_TYPE Character(1) VARCHAR2(1) NOT NULL Preview XML
F=File
S=String
17 XML_LOG_ENABLED Character(1) VARCHAR2(1) NOT NULL Preview XML

Y/N Table Edit

Default Value: Y

18 XML_STORE_FLG Character(1) VARCHAR2(1) NOT NULL XML Data Store Flag. All the node data will be stored in internal tables. This means a low performance.