JPM_JP_QUAL_VW

(SQL View)
 Index Back

Instance Qualifiers by Role

View of Instance Qualifiers for a Profile Type/Catalog Type that are available to each Role. Used as a prompt table for JPM Profile Items Instance Qualifier 1 field to show the values available for the applicable role.

SELECT %Substring(X.FIELDVALUE, 1, 3) , S.JPM_JP_TYPE , I.JPM_CAT_TYPE , I.JPM_CAT_ITEM_QUAL , I.DESCR FROM PS_JPM_JP_QUAL_INS I , PS_JPM_JP_SECTION S , PSXLATITEM X WHERE X.FIELDNAME = 'JPM_ROLE' AND %EffdtCheck(PSXLATITEM X1, X, %Currentdatein) AND X.EFF_STATUS = 'A' AND (X.FIELDVALUE = 'ADM' OR (X.FIELDVALUE = 'EMP' AND I.JPM_JP_EMP_VW_IND = 'Y') OR (X.FIELDVALUE = 'MGR' AND I.JPM_JP_MGR_VW_IND = 'Y')) 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: JPM_JP_QL_LNGVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description