FO_AL_LOG_VW

(SQL View)
 Index Back

SELECT A.FO_AL_LOG_ID , ' ' , ' ' , ' ' , A.FO_SOURCE_ID , B.FO_CHANNEL , C.FO_RESOLUTION FROM PS_FO_AL_LOG A , PS_FO_AL_LOG_RES B , PS_FO_AL_LOG_RES C WHERE A.FO_AL_LOG_ID=B.FO_AL_LOG_ID AND B.FO_AL_LOG_ID=C.FO_AL_LOG_ID AND C.FO_ROW_UPD_DTTM IN ( SELECT MAX(D.FO_ROW_UPD_DTTM) FROM PS_FO_AL_LOG_RES D WHERE A.FO_AL_LOG_ID=D.FO_AL_LOG_ID) AND B.FO_ROW_UPD_DTTM IN ( SELECT MIN(E.FO_ROW_UPD_DTTM) FROM PS_FO_AL_LOG_RES E WHERE A.FO_AL_LOG_ID=E.FO_AL_LOG_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FO_AL_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Resume Extraction Queue ID
2 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
4 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
5 FO_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
6 FO_CHANNEL Character(3) VARCHAR2(3) NOT NULL Communication Channel
7 FO_RESOLUTION Character(3) VARCHAR2(3) NOT NULL Resolution State
10=Success
20=Rejected
30=Unresolved with Errors
40=Draft
50=Loaded