GPES_ERN_RATECD

(SQL View)
Index Back

Earnings rate code

View to retrive the rate component from all Spanish basic earnings. This component will be retrived only if its type is Rate Code.

SELECT C.EFFDT , A.PIN_NUM , C.EFF_STATUS , C.ENTRY_TYPE_RATE , C.PIN_RATE_NUM FROM PS_GP_PIN A , PS_GP_ERN_DED C WHERE A.PIN_NUM = C.PIN_NUM AND PIN_TYPE = 'ER' AND C.ENTRY_TYPE_RATE LIKE 'RC%' AND A.PIN_CATEGORY = 'BAS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EFFDT Date(10) DATE Effective Date

Default Value: %date

2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 ENTRY_TYPE_RATE Character(3) VARCHAR2(3) NOT NULL entry type rate
5 PIN_RATE_NUM Number(8,0) INTEGER NOT NULL PinNumber Rate