GPAR_PIN_NME_VW

(SQL View)
 Index Back

Additional elemento for PI

Additiional element for complements ARG

SELECT A.PIN_NUM , A.PIN_NM , A.DESCR , B.CALC_RULE FROM PS_GP_PIN A ,PS_GP_ERN_DED B WHERE A.COUNTRY = 'ARG' AND A.PIN_TYPE = 'ER' AND A.PIN_NUM = B.PIN_NUM AND B.EFFDT =( SELECT MAX(B_ED.EFFDT) FROM PS_GP_ERN_DED B_ED WHERE B_ED.PIN_NUM = B.PIN_NUM) AND A.OVRD_IND_PI = 'Y'

  • Related Language Record: GPAR_PIN_NME_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    2 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CALC_RULE Character(2) VARCHAR2(2) NOT NULL Function Library field
    AM=Amount
    PB=Base * Percent
    RP=Unit * Rate * Percent
    RU=Unit * Rate