EOIU_KEYS_TMP

(SQL Table)
Index Back

Key Store

A meta data table that stores all the key name,value pairs

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EOIU_MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition.
3 EOIU_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name
4 EOIU_LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 EOIU_SEQ_NO Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 EOIU_KEYCOUNT Number(3,0) SMALLINT NOT NULL Key Count in the meta data record
7 EOIU_FLDNAME_1 Character(40) VARCHAR2(40) NOT NULL Field Name
8 EOIU_FLDNAME_2 Character(40) VARCHAR2(40) NOT NULL Field Name
9 EOIU_FLDNAME_3 Character(40) VARCHAR2(40) NOT NULL Field Name
10 EOIU_FLDNAME_4 Character(40) VARCHAR2(40) NOT NULL Field Name
11 EOIU_FLDNAME_5 Character(40) VARCHAR2(40) NOT NULL Field Name
12 EOIU_FLDNAME_6 Character(40) VARCHAR2(40) NOT NULL Field Name
13 EOIU_FLDNAME_7 Character(40) VARCHAR2(40) NOT NULL Field Name
14 EOIU_FLDNAME_8 Character(40) VARCHAR2(40) NOT NULL Field Name
15 EOIU_FLDNAME_9 Character(40) VARCHAR2(40) NOT NULL Field Name
16 EOIU_FLDNAME_10 Character(40) VARCHAR2(40) NOT NULL Field Name
17 EOIU_FLDVAL_1 Character(40) VARCHAR2(40) NOT NULL Field Value
18 EOIU_FLDVAL_2 Character(40) VARCHAR2(40) NOT NULL Field Value
19 EOIU_FLDVAL_3 Character(40) VARCHAR2(40) NOT NULL Field Value
20 EOIU_FLDVAL_4 Character(40) VARCHAR2(40) NOT NULL Field Value
21 EOIU_FLDVAL_5 Character(40) VARCHAR2(40) NOT NULL Field Value
22 EOIU_FLDVAL_6 Character(40) VARCHAR2(40) NOT NULL Field Value
23 EOIU_FLDVAL_7 Character(40) VARCHAR2(40) NOT NULL Field Value
24 EOIU_FLDVAL_8 Character(40) VARCHAR2(40) NOT NULL Field Value
25 EOIU_FLDVAL_9 Character(40) VARCHAR2(40) NOT NULL Field Value
26 EOIU_FLDVAL_10 Character(40) VARCHAR2(40) NOT NULL Field Value
27 EOIU_AUDIT_ACTION Character(1) VARCHAR2(1) NOT NULL Audit Action code
28 EOIU_INPROC_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
29 EOIU_MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Message node name