HRS_PRE_CHK_VW (SQL View)	Index Back
PreEmployment Vendor Check Req PreEmployment Vendor Check Req

HRS_PRE_CHK_VW

(SQL View)

PreEmployment Vendor Check Req

SELECT A.HRS_VENDOR_ID , C.HRS_VNDR_TRANS_ID , D.HRS_CANDIDATE_EMBD , D.HRS_CANDIDATE_XSLT , E.HRS_XSLT_PATH FROM PS_HRS_VENDOR A , PS_HRS_VNDR_TRANS C , PS_HRS_PREMPL_VNDR D , PS_HRS_XSLT 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 A.HRS_VENDOR_ID=D.HRS_VENDOR_ID AND A.HRS_VERSION=D.HRS_VERSION AND C.HRS_TRANSACTION_ID='HC_UUID_88932272321052004' AND D.HRS_CANDIDATE_XSLT=E.HRS_XSLT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 HRS_CANDIDATE_EMBD Character(3) VARCHAR2(3) NOT NULL Candidate Embeded State
10=String
20=xml

4 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.

5 HRS_XSLT_PATH Long Character(2000) VARCHAR2(2000) Path to the XSLT file

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_VENDOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Integration Vendor ID
2	HRS_VNDR_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Id specific to a Vendor and Transaction
3	HRS_CANDIDATE_EMBD	Character(3)	VARCHAR2(3) NOT NULL	Candidate Embeded State 10=String 20=xml
4	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.
5	HRS_XSLT_PATH	Long Character(2000)	VARCHAR2(2000)	Path to the XSLT file