SAE_EVNT_STATUS

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SAE_TARGET_ID Character(50) VARCHAR2(50) NOT NULL SAIP Target ID
2 SAE_INTERNAL_OP Character(60) VARCHAR2(60) NOT NULL Operation
3 SAE_SOURCED_ID Character(250) VARCHAR2(250) NOT NULL Sourced Id
4 SAE_EVENT_DT 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