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 |