HRS_VT_NODE (SQL View)	Index Back
Node to VT Reverse Lkup Node to Vendor-Transaction ID Reverse Lookup

HRS_VT_NODE

(SQL View)

Node to VT Reverse Lkup

Node to Vendor-Transaction ID Reverse Lookup

SELECT A.MSGNODENAME , A.HRS_VNDR_TRANS_ID , B.HRS_VENDOR_STATUS 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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 HRS_VENDOR_STATUS Character(3) VARCHAR2(3) NOT NULL Integration Vendor Status (Active/Inactive)
10=Active
20=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
2	HRS_VNDR_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Id specific to a Vendor and Transaction
3	HRS_VENDOR_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Integration Vendor Status (Active/Inactive) 10=Active 20=Inactive