GPSC_ELM_UBY_VW

(SQL View)
 Index Back

GP Used By Element List

Element Browser Used By Element List

SELECT DISTINCT A.PIN_NUM , B.DESCR , B.PIN_NM , B.PIN_CODE , B.PIN_TYPE , A.PIN_MBR_NUM , A.EFFDT , B.COUNTRY , '' FROM PS_GP_PINMAP_EFFDT A , PS_GP_PIN B WHERE A.PIN_NUM= B.PIN_NUM AND A.PIN_MBR_NUM <> 0 AND A.PIN_MBR_NUM <> A.PIN_NUM AND A.EFFDT=( SELECT MAX(MAX_ED.EFFDT) FROM PS_GP_PINMAP_EFFDT MAX_ED WHERE A.PIN_NUM = MAX_ED.PIN_NUM AND A.PIN_MBR_NUM = MAX_ED.PIN_MBR_NUM AND MAX_ED.EFFDT <= %CurrentDateIn)

  • Related Language Record: GP_PIN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    4 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
    5 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
    6 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field
    7 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    9 COMMENTS Long Character CLOB Comment