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'

# 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