JPM_JP_QL_LNGVW

(SQL View)
 Index Back

Instance Qualifiers by Role

Related Language view for JPM_JP_QUAL_VW

SELECT %Substring(X.FIELDVALUE, 1, 3) , S.JPM_JP_TYPE , I.JPM_CAT_TYPE , I.JPM_CAT_ITEM_QUAL , I.LANGUAGE_CD , I.DESCR FROM PS_JPM_JP_QINS_LNG I , PS_JPM_JP_SECTION S , PSXLATITEM X WHERE X.FIELDNAME = 'JPM_ROLE' AND %EffdtCheck(PSXLATITEM X1, X, %Currentdatein) AND I.JPM_CAT_TYPE = S.JPM_CAT_TYPE AND I.JPM_JP_QUAL_SET = S.JPM_JP_QUAL_SET AND %EffdtCheck(JPM_JP_TYPES T, S, %CurrentdateIn)

  • Related Language Record for JPM_JP_QUAL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_ROLE Character(3) VARCHAR2(3) NOT NULL Role
    ADM=Administrator
    EMP=Employee
    MGR=Manager
    2 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    3 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
    4 JPM_CAT_ITEM_QUAL Character(12) VARCHAR2(12) NOT NULL Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description