HRS_HIRE_REF_1

(SQL View)
 Index Back

Hire - Referral Source

Hire - Referral Source Info carried to HR. All Employee Referrals

SELECT A.EMPLID ,%CurrentDateIn , B.HRS_SOURCE_ID , B.HRS_SUBSOURCE_ID , A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , C.EMPLID , C.PREV_EMPL_BY_COMPY , C.APP_IS_FAMILY , B.HRS_SUBSOURCE_DESC , A.HRS_HIRE_SEQ FROM PS_HRS_HIRE A , PS_HRS_APP_PROFILE D , PS_HRS_AL_SRCE_I B , PS_HRS_EE_REFERRAL C , PS_HRS_SOURCE E WHERE A.HRS_PERSON_ID = D.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = D.HRS_PROFILE_SEQ AND D.HRS_AL_LOG_ID = B.HRS_AL_LOG_ID AND B.HRS_SOURCE_ID = E.HRS_SOURCE_ID AND E.HRS_SOURCE_TYPE = '30' AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = C.HRS_PROFILE_SEQ AND C.HRS_AL_LOG_SRC_SEQ = B.HRS_AL_LOG_SRC_SEQ AND %CurrentDateIn BETWEEN E.EFFDT AND E.HRS_END_EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EFFDT Date(10) DATE NOT NULL Effective Date
3 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID

Prompt Table: HRS_SOURCE_I

4 HRS_SUBSOURCE_ID Number(15,0) DECIMAL(15) NOT NULL SubSource ID

Prompt Table: HRS_SUBSOURCE_I

5 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
6 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
7 EMPL_REFERRAL_ID Character(11) VARCHAR2(11) NOT NULL Employee Referral ID

Prompt Table: PERS_APPL_NAME

8 PREV_EMPL_BY_COMPY Character(1) VARCHAR2(1) NOT NULL Previously Employed by Company

Y/N Table Edit

9 APP_IS_FAMILY Character(1) VARCHAR2(1) NOT NULL Applicant is a family member

Y/N Table Edit

10 SPECIFIC_REFER_SRC Character(50) VARCHAR2(50) NOT NULL Specific Referral Source
11 HRS_HIRE_SEQ Number(10,0) DECIMAL(10) NOT NULL Hire Sequence ID