SAE_EVNT_STATUS(SQL Table) | 
Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(50) | VARCHAR2(50) NOT NULL | SAIP Target ID | |
| 2 | Character(60) | VARCHAR2(60) NOT NULL | Operation | |
| 3 | Character(250) | VARCHAR2(250) NOT NULL | Sourced Id | |
| 4 | DateTime(26) | TIMESTAMP | Event Driven Timestamp | |
| 5 | SAE_EXTOPR_NAME | Character(60) | VARCHAR2(60) NOT NULL | SAIP External Service Operation Name | 
| 6 | SAE_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name | 
| 7 | SAE_MODE | Character(1) | VARCHAR2(1) NOT NULL | 
Operation Mode
 A=Add C=Change D=Delete  | 
| 8 | SAE_LIS_SEVERITY | Character(4) | VARCHAR2(4) NOT NULL | 
Severity
 EROR=error STAT=status WARN=warning  | 
| 9 | SAE_LIS_CODE_MAJOR | Character(4) | VARCHAR2(4) NOT NULL | 
Code Major
 FAIL=failure PROC=processing SUCC=success UNSU=unsupported  | 
| 10 | SAE_LIS_CODE_MINOR | Character(4) | VARCHAR2(4) NOT NULL | Code Minor | 
| 11 | SAE_LIS_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Status Description | 
| 12 | SAE_ERR_DESC | Character(100) | VARCHAR2(100) NOT NULL | Error Description |