EODI_LOG(SQL Table) | 
Index Back | 
|---|---|
Message Log | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | DateTime(26) | TIMESTAMP | Date/Time | |
| 2 | Number(5,0) | INTEGER NOT NULL | Sequence Number | |
| 3 | EODI_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL | 
System
 A=Address Book D=Dynamic Display M=Appointments T=Tasks X=File Transfer  | 
| 4 | EODI_PROCESS_ID | Character(15) | VARCHAR2(15) NOT NULL | Process ID | 
| 5 | EODI_TRANS_ID | Number(15,0) | DECIMAL(15) NOT NULL | Transaction ID | 
| 6 | EODI_LOG_LEVEL | Character(1) | VARCHAR2(1) NOT NULL | 
Log Level
 0=0 - No Logging 1=1 - Errors 2=2 - Warnings and above 3=3 - Information and above  | 
| 7 | EODI_ERROR_MSG | Character(250) | VARCHAR2(250) NOT NULL | Error Message | 
| 8 | EODI_ERROR_TXT | Character(250) | VARCHAR2(250) NOT NULL | Error Text |