GPBR_PIN_NM_VW

(SQL View)
 Index Back

Additional elemento for PI

Additiional element for complements BRA

SELECT A.PIN_NM , A.PIN_NUM ,A.DESCR ,B.CALC_RULE FROM ps_gp_pin A ,PS_GP_ERN_DED B WHERE A.country='BRA' AND A.PIN_TYPE='ER' AND A.PIN_NUM=B.PIN_NUM AND B.EFFDT =( SELECT MAX(J.EFFDT) FROM PS_GP_ERN_DED J WHERE J.PIN_NUM=B.PIN_NUM) AND A.OVRD_IND_PI='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
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