HRS_PREMPL_VNDR

(SQL Table)

# 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_VERSION Number(15,0) DECIMAL(15) NOT NULL used as version for numerous integration objects

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

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

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

6 HRS_SHOW_ADUJ Character(1) VARCHAR2(1) NOT NULL Display Adjudication
Y/N Table Edit

7 HRS_VIEW_DETAILS Character(1) VARCHAR2(1) NOT NULL View Results on External Site
Y/N Table Edit

#	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_VERSION	Number(15,0)	DECIMAL(15) NOT NULL	used as version for numerous integration objects
3	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.
4	HRS_CANDIDATE_EMBD	Character(3)	VARCHAR2(3) NOT NULL	Candidate Embeded State 10=String 20=xml
5	HRS_BGCHECK_XSLT	Number(15,0)	DECIMAL(15) NOT NULL	Background Check XSLT
6	HRS_SHOW_ADUJ	Character(1)	VARCHAR2(1) NOT NULL	Display Adjudication Y/N Table Edit
7	HRS_VIEW_DETAILS	Character(1)	VARCHAR2(1) NOT NULL	View Results on External Site Y/N Table Edit