CM_JOBTASK_VW2

(SQL View)
 Index Back

All Job Task Roles

All Competency/Cluster profiled roles that are identified by a Job Task. This view is used within Person to Role match. It selects the Setid in SETID_JOBTASK to differentiate between the Job code Setid.

SELECT DISTINCT A.JPM_CAT_SETID , %Substring(JPM_RLAT_KEY1 ,1,6) , A.JPM_PROFILE_ID , B.JPM_JP_TYPE , B.DESCR FROM PS_JPM_JP_X_RLAT A , PS_JPM_PROFILE B WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JPM_JP_X_RLAT WHERE A.JPM_PROFILE_ID = JPM_PROFILE_ID AND A.JPM_RLAT_NAME = JPM_RLAT_NAME AND A.JPM_CAT_SETID = JPM_CAT_SETID AND A.JPM_RLAT_KEY1 = JPM_RLAT_KEY1 AND EFFDT <= %CurrentDateIn) AND A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_RLAT_NAME = 'JOB_TASK'

  • Related Language Record: CM_TSKALVW2_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_JOBTASK Character(5) VARCHAR2(5) NOT NULL Job Task Set ID
    2 JOB_TASK Character(6) VARCHAR2(6) NOT NULL Job Task

    Prompt Table: CM_JOBTASK_VW

    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 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description