GPES_FNQ_DEV_VW

(SQL View)
 Index Back

Termination earnings rate comp

Rate components for the earnings that are paid at termination

SELECT B.PIN_NUM , A.ACM_SIGN FROM PS_GP_ACM_MBR A , PS_GP_PIN B , PS_GP_PIN_CMPNT C WHERE A.PIN_NUM = ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_CODE = 'SS AC BSE D S ESP') AND B.PIN_PARENT_NUM = A.PIN_MBR_NUM AND C.PIN_NUM = A.PIN_MBR_NUM AND C.PIN_AA_RATE_NUM = B.PIN_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_RATE_NUM Number(8,0) INTEGER NOT NULL PinNumber Rate
2 ACM_SIGN Character(1) VARCHAR2(1) NOT NULL Accumulator Sign
A=Add
S=Subtract