HRS_VT_CUR_VW (SQL View)	Index Back
Current Vendor-Transactions Shows the vendor transactions associated with the current version of the vendor

HRS_VT_CUR_VW

(SQL View)

Current Vendor-Transactions

Shows the vendor transactions associated with the current version of the vendor

SELECT A.HRS_VNDR_TRANS_ID , A.HRS_VENDOR_ID , A.HRS_VERSION , A.HRS_TRANSACTION_ID , A.MSGNODENAME FROM PS_HRS_VNDR_TRANS A , PS_HRS_VENDOR B WHERE A.HRS_VERSION IN ( SELECT MAX(C.HRS_VERSION) FROM PS_HRS_VENDOR C WHERE C.HRS_VENDOR_ID=A.HRS_VENDOR_ID) AND A.HRS_VENDOR_ID=B.HRS_VENDOR_ID AND A.HRS_VERSION=B.HRS_VERSION AND B.HRS_VENDOR_STATUS='10'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 HRS_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Integration Vendor ID

3 HRS_VERSION Number(15,0) DECIMAL(15) NOT NULL used as version for numerous integration objects

4 HRS_TRANSACTION_ID Character(30) VARCHAR2(30) NOT NULL Transaction ID

5 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_VNDR_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Id specific to a Vendor and Transaction
2	HRS_VENDOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Integration Vendor ID
3	HRS_VERSION	Number(15,0)	DECIMAL(15) NOT NULL	used as version for numerous integration objects
4	HRS_TRANSACTION_ID	Character(30)	VARCHAR2(30) NOT NULL	Transaction ID
5	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).