HRS_DUP_REF_VW (SQL View)	Index Back
Duplicate Referral View This view is used to display Employee and Applicant information for each referral in the ER_DUP_REFERRAL page.

HRS_DUP_REF_VW

(SQL View)

Duplicate Referral View

This view is used to display Employee and Applicant information for each referral in the ER_DUP_REFERRAL page.

SELECT A.HRS_PERSON_ID , A.EMPLID , A.REFERRAL_DTTM ,B.PROCESSED FROM PS_HRS_EE_REFERRAL A , PS_HRS_EE_REF_ELIG B WHERE A.EMPLID <> ' ' AND B.HRS_PERSON_ID = A.HRS_PERSON_ID AND B. EMPLID = A.EMPLID AND B.ELIGIBILITY_STATUS = 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 REFERRAL_DTTM DateTime(26) TIMESTAMP Referral Time Stamp

4 PROCESSED Character(1) VARCHAR2(1) NOT NULL Processed?
I=In Process
N=Not Processed
Y=Processed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	REFERRAL_DTTM	DateTime(26)	TIMESTAMP	Referral Time Stamp
4	PROCESSED	Character(1)	VARCHAR2(1) NOT NULL	Processed? I=In Process N=Not Processed Y=Processed