GVT_NOA_ALL_VW

(SQL View)
 Index Back

All NOA codes

View to fetch all NOA codes

SELECT DISTINCT N.GVT_NOA_CODE ,N.DESCR25 FROM PS_GVT_NOAC_TBL N WHERE N.EFFDT = ( SELECT MAX(N1.EFFDT) FROM PS_GVT_NOAC_TBL N1 WHERE N1.ACTION = N.ACTION AND N1.GVT_NOA_CODE = N.GVT_NOA_CODE AND N1.EFFDT <=%CurrentDateIn ) AND N.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
2 DESCR25 Character(25) VARCHAR2(25) NOT NULL Short description