GPNL_PIN_ACM_VW

(SQL View)
 Index Back

GPNL Prompt View Accums

This view selects GPNL Accumulators. This view does not use the standard SBR because it uses an additional record in the select statement

SELECT B.COUNTRY , B.PIN_NUM , B.PIN_NM , B.DESCR , B.COUNTRY FROM PS_GP_PIN B , PS_GP_ACCUMULATOR D WHERE B.PIN_NUM=D.PIN_NUM AND B.PIN_NUM < 50000000 AND B.USED_BY = 'C' AND B.COUNTRY = 'NLD'

  • Related Language Record: GP_PIN_AC0_VL

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