RC_PRSN_SEL_VW

(SQL View)
 Index Back

Person Selector View

View used for populating the person details

SELECT C.EMPLID ,A.BO_ID ,C.PERSON_ID , D.DESCR , L.DESCR , J.DESCR FROM ((PS_RD_WRKR_ASGN A INNER JOIN PS_RD_WRKR_JOB B ON A.BO_ID=B.BO_ID) INNER JOIN PS_RD_PERSON C ON B.BO_ID=C.BO_ID) LEFT OUTER JOIN PS_LOCATION_WRK_VW L ON (B.SETID_LOCATION = L.SETID_LOCATION AND B.LOCATION=L.LOCATION) LEFT OUTER JOIN PS_DEPT_TBL_WRK_VW D ON (B.SETID_DEPT = D.SETID_DEPT AND B.DEPTID=D.DEPTID) LEFT OUTER JOIN PS_JOBCD_WRK_VW J ON (B.SETID_JOBCODE = J.SETID_JOBCODE AND B.JOBCODE=J.JOBCODE) WHERE A.ASGN_END_DT >= %CurrentDateIn AND A.ASGN_START_DT <= %CurrentDateIn AND A.PRIMARY_IND='Y' AND B.PERSON_ID=A.PERSON_ID AND B.WRKR_ASGN_SEQ = A.WRKR_ASGN_SEQ AND B.EFFDT=( SELECT MAX(E.EFFDT) FROM PS_RD_WRKR_JOB E WHERE E.EFFDT<=%CurrentDateIn AND E.PERSON_ID=B.PERSON_ID AND E.WRKR_ASGN_SEQ = B.WRKR_ASGN_SEQ) AND B.EFFSEQ=( SELECT MAX(F.EFFSEQ) FROM PS_RD_WRKR_JOB F WHERE F.EFFDT=B.EFFDT AND F.PERSON_ID=B.PERSON_ID AND F.WRKR_ASGN_SEQ = B.WRKR_ASGN_SEQ)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
4 RC_DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description to be displayed on HelpDesk page.
5 RC_LOC_DESCR Character(30) VARCHAR2(30) NOT NULL Descripton of the Location to be displayed in helpdesk page.
6 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description field used in HD_360_RESPONSE_SYNC message.