PA_ERNCD_SPC_VW

(SQL View)
 Index Back

Erncd + spcl erncd union


SELECT a.erncd_spcl , a.descr FROM PS_SPCL_EARNS_TBL a WHERE a.eff_status = 'A' AND a.effdt = ( SELECT MAX(b.effdt) FROM PS_SPCL_EARNS_TBL b WHERE a.erncd_spcl = b.erncd_spcl)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ERNCD_SPCL Character(3) VARCHAR2(3) NOT NULL Special Accumulator Code
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description