SAE_EVNTSTAT_VW

(SQL View)
 Index Back

SELECT SAE_TARGET_ID , A.SAE_INTERNAL_OP , A.SAE_SOURCED_ID , A.SAE_EVENT_DT AS SAE_PREF_EVENT_DT , A.SAE_EXTOPR_NAME , A.SAE_RECNAME , A.SAE_MODE , A.SAE_LIS_SEVERITY , A.SAE_LIS_CODE_MAJOR , A.SAE_LIS_CODE_MINOR , A.SAE_LIS_DESCR , A.SAE_ERR_DESC FROM PS_SAE_EVNT_STATUS A WHERE A.SAE_EVENT_DT IN ( SELECT MAX(SAE_EVENT_DT) FROM PS_SAE_EVNT_STATUS B WHERE B.SAE_TARGET_ID =A.SAE_TARGET_ID AND B.SAE_INTERNAL_OP =A.SAE_INTERNAL_OP AND B.SAE_SOURCED_ID=A.SAE_SOURCED_ID GROUP BY B.SAE_TARGET_ID , B.SAE_INTERNAL_OP, B.SAE_SOURCED_ID)

# 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_LAST_EVENT_DT DateTime(26) TIMESTAMP Last Event 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