GP_PINTREE_SRCH

(SQL View)
 Index Back

Element Mapping Search

This search record selects from the GP Pin Map table.

SELECT C.OPRID , A.PIN_TYPE , B.DESCR , A.PIN_NM , A.DESCR , A.USED_BY , A.COUNTRY , A.PIN_NUM FROM PS_GP_PIN A , PS_GP_PIN_TYPE B , PS_GP_OPR_RULE_PRF C WHERE A.PIN_TYPE=B.PIN_TYPE AND EXISTS ( SELECT D.PIN_NUM FROM PS_GP_PINMAP_EFFDT D WHERE (A.PIN_NUM = D.PIN_NUM OR A.PIN_NUM = D.PIN_MBR_NUM)) AND (A.USED_BY = 'A' OR (A.USED_BY = 'C' AND C.USED_BY= 'A') OR (A.USED_BY = 'C' AND A.COUNTRY = C.COUNTRY))

  • Related Language Record: GP_PIN_SRCH_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

    Prompt Table: GP_PIN_TYPE

    3 PIN_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL PIN Type
    4 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
    A=All Countries
    C=Specific Country
    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    8 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number