HRS_SRCT_LKP_I

(SQL View)
 Index Back

Source Transaction Lookup Int

Source Transaction Lookup Interface

SELECT D.HRS_SOURCE_ID , C.HRS_TRANSACTION_ID , C.HRS_VENDOR_ID , C.HRS_VNDR_TRANS_ID FROM PS_HRS_VENDOR A , PS_HRS_VNDR_TRANS C , PS_HRS_SOURCE D , PS_HRS_SOURCE_VNDR E WHERE A.HRS_VERSION = ( SELECT MAX (B.HRS_VERSION) FROM PS_HRS_VENDOR B WHERE B.HRS_VENDOR_ID=A.HRS_VENDOR_ID) AND A.HRS_VENDOR_STATUS='10' AND A.HRS_VENDOR_ID=C.HRS_VENDOR_ID AND A.HRS_VERSION=C.HRS_VERSION AND D.HRS_SOURCE_ID=E.HRS_SOURCE_ID AND D.EFFDT=E.EFFDT AND E.HRS_VENDOR_ID=A.HRS_VENDOR_ID AND %CurrentDateIn BETWEEN D.EFFDT AND D.HRS_END_EFFDT AND D.HRS_SOURCE_STATUS='10'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
2 HRS_TRANSACTION_ID Character(30) VARCHAR2(30) NOT NULL Transaction ID
3 HRS_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Integration Vendor ID
4 HRS_VNDR_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Id specific to a Vendor and Transaction