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 |