XML_ESP_AET

(SQL Table)
Index Back

Contract Printing StateRec ESP

Contract Printing StateRec ESP

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 XMLFILE_ID Character(50) VARCHAR2(50) NOT NULL XML File ID

Prompt Table: XML_DEFN

6 XML_PRNT_FLTR_ESP Character(1) VARCHAR2(1) NOT NULL XML Printing Filter ESP
7 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
8 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
9 XML_LONG_VALUE Long Character CLOB XML Long value
10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
11 KEY3_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 3 Field Value
12 KEY2_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 2 Field Value
13 KEY1_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 1 Field Value
14 XML_RESPONSE_FLG Character(1) VARCHAR2(1) NOT NULL Iterative node
15 XML_SEQ_NBR Number(7,0) INTEGER NOT NULL Sequence number
16 XMLFILE_RESPONS_ID Character(20) VARCHAR2(20) NOT NULL Communication identification
17 XML_SET Character(5) VARCHAR2(5) NOT NULL XML Set

Prompt Table: XML_SET_TBL

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

Prompt Table: XML_TEMPLT_TBL