HRS_PREVNDR_VW (SQL View)	Index Back
PreEmployment Vendor View

HRS_PREVNDR_VW

(SQL View)

PreEmployment Vendor View

SELECT A.HRS_VNDR_TRANS_ID , B.HRS_CANDIDATE_XSLT , B.HRS_CANDIDATE_EMBD , B.HRS_BGCHECK_XSLT FROM PS_HRS_VNDR_TRANS A , PS_HRS_PREMPL_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.

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

4 HRS_BGCHECK_XSLT Number(15,0) DECIMAL(15) NOT NULL Background Check XSLT

#	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.
3	HRS_CANDIDATE_EMBD	Character(3)	VARCHAR2(3) NOT NULL	Candidate Embeded State 10=String 20=xml
4	HRS_BGCHECK_XSLT	Number(15,0)	DECIMAL(15) NOT NULL	Background Check XSLT