HRS_EXTR_VT_VW

(SQL View)

SELECT A.HRS_VENDOR_ID , C.HRS_VNDR_TRANS_ID FROM PS_HRS_VENDOR A , PS_HRS_VNDR_TRANS C 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 C.HRS_TRANSACTION_ID='HC_UUID_50532281611032004'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_EXTRACTOR_ID Number(15,0) DECIMAL(15) NOT NULL Used to store the extractor in Source.

2 HRS_VNDR_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Id specific to a Vendor and Transaction

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_EXTRACTOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Used to store the extractor in Source.
2	HRS_VNDR_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Id specific to a Vendor and Transaction