HRS_MYPROF_VW2

(SQL View)
 Index Back

SELECT DISTINCT APP.HRS_PERSON_ID , 'I' , INTPROF.JPM_PROFILE_ID , APP.EMPLID , 'N' , 'J' FROM PS_HRS_APPLICANT APP , PS_JPM_PROFILE PROF , PS_JPM_JP_SEC_VW SEC , PS_JPM_PROF_INT_I INTPROF 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' AND INTPROF.EMPLID = APP.EMPLID

# 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