HR_SP_NP_TYP_VW

(SQL View)
 Index Back

SP Non-pers Prof Type view

Succession Planning Non-person Profile Type view

SELECT A.jpm_jp_type , a.descr FROM PS_JPM_JP_TYPES_I A WHERE %EffdtCheck(jpm_jp_types_i B, A, %CurrentDateIn) AND a.jpm_jp_type_status = 'A' AND a.jpm_profile_usage = 'J'

  • Related Language Record: SP_NPTYP_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SP_PRI_NP_TYP Character(12) VARCHAR2(12) NOT NULL Primary NonPerson Profile Type
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description