HRS_JO_HIR_TEAM

(SQL View)
 Index Back

Job Opening Hiring Team

This view returns unique hiring team members

SELECT DISTINCT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , B.EMPLID , B.HRS_JO_TM_TYPE FROM PS_HRS_RCMNT A , PS_HRS_JO_TEAM B WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND B.HRS_JO_TM_TYPE IN ('G','I','M','O','A','R')

# 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: HRS_ACT_PERS_I

4 HRS_JO_TM_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Team Type
A=Approver/Reviewer
G=Originator
I=Interviewer
M=Manager
O=Interested Party
R=Recruiter
S=Screening Team