GPBR_PIN_AM_VW

(SQL View)
 Index Back

Brazil Mbr Accumulators View

Brazil Memebers Accumulators View

SELECT D.PIN_NUM , D.PIN_MBR_NUM , B.PIN_NM , B.DESCR FROM PS_GP_COUNTRY A , PS_GP_PIN B , PS_GP_ACM_MBR D WHERE B.PIN_TYPE = 'ER' AND A.COUNTRY = 'BRA' AND B.PIN_NUM < 50000000 AND D.PIN_MBR_NUM = B.PIN_NUM AND (B.USED_BY = 'C' AND B.COUNTRY = A.COUNTRY)

  • Related Language Record: GPBR_PIN_AM_L_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    2 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field
    3 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description