HRS_MYPROF_VW1

(SQL View)
 Index Back

Applicant's JPM Person Profile

Used by Job Openings for Your Profiles Search called from Employee Self Service Career home page, this view gets all JPM Person Profiles for the Applicant

SELECT APP.HRS_PERSON_ID , 'P' , PROF.JPM_PROFILE_ID , APP.EMPLID , 'E' , 'J' FROM PS_HRS_APPLICANT APP , PS_JPM_PROFILE PROF , PS_JPM_JP_SEC_VW SEC WHERE APP.EMPLID <> ' ' AND APP.APP_PER_STATUS = 'E' AND PROF.EMPLID = APP.EMPLID AND PROF.JPM_PROFILE_USAGE = 'P' AND PROF.JPM_JP_PRFL_STATUS = 'A' AND SEC.JPM_JP_TYPE = PROF.JPM_JP_TYPE AND SEC.JPM_ROLE = 'EMP'

# 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_MY_PROF_TYP Character(1) VARCHAR2(1) NOT NULL Source Profile Type
I=Interest Profile
J=Job Profile
P=Person Profile
3 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 HRS_SRC_PROF_TYPE Character(1) VARCHAR2(1) NOT NULL Profile Match Source Profile Type: Applicant, Employee or Non-Person Profile
A=Applicant
E=Employee
J=Job Opening
N=Non Person
6 HRS_TGT_PROF_TYPE Character(1) VARCHAR2(1) NOT NULL Profile Match Target Profile Type: Applicant, Employee, Job Opening or Non-Person Profile
A=Applicants
E=Employees
J=Job Openings
N=Non Persons