HRS_RESVNDR_VW

(SQL View)

SELECT A.HRS_VNDR_TRANS_ID , B.HRS_CANDIDATE_XSLT FROM PS_HRS_VNDR_TRANS A , PS_HRS_RESUME_VNDR B WHERE 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 HRS_VNDR_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Id specific to a Vendor and Transaction

2 HRS_CANDIDATE_XSLT Number(15,0) DECIMAL(15) NOT NULL Stores a reference to the xslt file used to transform the candidate section of an incoming message for Resume Processing Integrations.

#	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_CANDIDATE_XSLT	Number(15,0)	DECIMAL(15) NOT NULL	Stores a reference to the xslt file used to transform the candidate section of an incoming message for Resume Processing Integrations.