HRS_HIRE_REF

(SQL View)
Index Back

Hire - Referral Source

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

SELECT A.EMPLID , %CurrentDateIn , B.HRS_SOURCE_ID , B.HRS_SUBSOURCE_ID , A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , 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_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 %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 SPECIFIC_REFER_SRC Character(50) VARCHAR2(50) NOT NULL Specific Referral Source
8 HRS_HIRE_SEQ Number(10,0) DECIMAL(10) NOT NULL Hire Sequence ID