HRS_EE_REFRAL_I (SQL View)	Index Back
eRecruit Referral Record This record stores general data about employee referrals made through eRecruit.

HRS_EE_REFRAL_I

(SQL View)

eRecruit Referral Record

This record stores general data about employee referrals made through eRecruit.

SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.EMPLID , A.HRS_AL_LOG_SRC_SEQ , A.REFERRAL_DTTM , A.REFERRAL_ID , A.REFERRAL_PWD , A.APPL_EMPLID , A.APPL_EMPL_RCD , A.HIRE_DT , A.HRS_JO_ID_HIRED , A.PREV_TERM_DT , A.REFERRER_NAME , A.EMAIL_ADDR , A.PREV_EMPL_BY_COMPY , A.APP_IS_FAMILY ,%subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_EE_REFERRAL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON_NAME

4 HRS_AL_LOG_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Unique Identifier - For Log Source

5 REFERRAL_DTTM DateTime(26) TIMESTAMP Referral Time Stamp
Default Value: %DateTime

6 REFERRAL_ID Character(20) VARCHAR2(20) NOT NULL Referral Track ID

7 REFERRAL_PWD Character(6) VARCHAR2(6) NOT NULL Referral Password

8 APPL_EMPLID Character(11) VARCHAR2(11) NOT NULL Applicant Employee ID

9 APPL_EMPL_RCD Number(3,0) SMALLINT NOT NULL Applicant Empl Rcd#

10 HIRE_DT Date(10) DATE First Start Date

11 HRS_JO_ID_HIRED Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
Prompt Table: HRS_JOB_OPENING

12 PREV_TERM_DT Date(10) DATE Previous Termination Date

13 REFERRER_NAME Character(50) VARCHAR2(50) NOT NULL Referral Name

14 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address

15 PREV_EMPL_BY_COMPY Character(1) VARCHAR2(1) NOT NULL Previously Employed by Company
Y/N Table Edit
Default Value: N

16 APP_IS_FAMILY Character(1) VARCHAR2(1) NOT NULL Applicant is a family member
Y/N Table Edit
Default Value: N

17 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime

18 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id

19 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime

20 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	HRS_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
4	HRS_AL_LOG_SRC_SEQ	Number(15,0)	DECIMAL(15) NOT NULL	Unique Identifier - For Log Source
5	REFERRAL_DTTM	DateTime(26)	TIMESTAMP	Referral Time Stamp Default Value: %DateTime
6	REFERRAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Referral Track ID
7	REFERRAL_PWD	Character(6)	VARCHAR2(6) NOT NULL	Referral Password
8	APPL_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Applicant Employee ID
9	APPL_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Applicant Empl Rcd#
10	HIRE_DT	Date(10)	DATE	First Start Date
11	HRS_JO_ID_HIRED	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone Prompt Table: HRS_JOB_OPENING
12	PREV_TERM_DT	Date(10)	DATE	Previous Termination Date
13	REFERRER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Referral Name
14	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
15	PREV_EMPL_BY_COMPY	Character(1)	VARCHAR2(1) NOT NULL	Previously Employed by Company Y/N Table Edit Default Value: N
16	APP_IS_FAMILY	Character(1)	VARCHAR2(1) NOT NULL	Applicant is a family member Y/N Table Edit Default Value: N
17	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
18	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
19	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
20	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id