USER_WORK_VW

(SQL View)
 Index Back

Sample terms View

Additional view used by terms appropriate

SELECT A.OPRID , A.PERSON_ID , B.MANAGER_LEVEL , C.XLATLONGNAME , D.COMPETENCY , D.PROFICIENCY , E.RATING_MODEL , F.DESCR FROM PSOPRALIAS A JOIN PS_RD_WRKR_JOB B ON A.PERSON_ID = B.PERSON_ID JOIN PSXLATITEM C ON B.MANAGER_LEVEL = C.FIELDVALUE LEFT JOIN PS_RB_COMPETENCIES D ON A.PERSON_ID = D.PERSON_ID LEFT JOIN PS_COMPETENCY_TBL E ON D.COMPETENCY = E.COMPETENCY LEFT JOIN PS_REVW_RATING_TBL F ON E.RATING_MODEL = F.RATING_MODEL AND D.PROFICIENCY = F.REVIEW_RATING WHERE C.FIELDNAME = 'MANAGER_LEVEL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level.
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager
4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
5 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency - this field is brought over from HRMS
6 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency Field. This Field is imported into CRM DB from Human Resources Database.
7 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL RATING_MODEL field used in the HCM/ CRM sync Application Messages.
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description