GPNL_SPC_AC1_VW

(SQL View)
 Index Back

Prompt View- For Special Pays

This view selects Accumulators with Special Pays category. This view does not use the standard SBR because it uses an additional record in the select statement This view is called from PeopleCode using %GP_EDIT_FLD3.

SELECT B.COUNTRY , B.PIN_NUM , B.PIN_NM , B.DESCR , B.COUNTRY FROM PS_GP_PIN B , PS_GP_ACCUMULATOR A WHERE A.PIN_NUM = B.PIN_NUM AND B.PIN_NUM < 50000000 AND B.PIN_TYPE = 'AC' AND B.COUNTRY = 'NLD' AND B.PIN_CATEGORY = 'SPEC' AND A.ACM_PRD_OPTN IN ('5')

  • 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