CM_POSALVW_LNG

(SQL View)
 Index Back

All Position Roles

All Competency/Cluster profiled roles that are identified by a Position Number.

SELECT DISTINCT A.POSITION_NBR , B.LANGUAGE_CD , B.DESCR FROM PS_CM_ROLE_COMPS A , PS_POSN_DATA_LANG B WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CM_ROLE_COMPS WHERE A.POSITION_NBR = POSITION_NBR AND A.JOBCODE = JOBCODE AND A.JOB_FAMILY = JOB_FAMILY AND A.JOB_TASK = JOB_TASK AND EFFDT <= %CurrentDateIn) AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_POSITION_DATA WHERE B.POSITION_NBR = POSITION_NBR AND EFFDT <= %CurrentDateIn) AND A.POSITION_NBR = B.POSITION_NBR

  • Related Language Record for CM_POSN_ALL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description