EOIU_KEYS_TMP(SQL Table) |
Index Back |
---|---|
Key StoreA 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 |