NM_ROYPREF_VW

(SQL View)
 Index Back

Royal Name Prefix VW

This view will list the country specific naming standard for the Netherlands.

SELECT %Substring(A.FIELDVALUE,1,3) FROM PSXLATITEM A WHERE A.FIELDNAME = 'CERTIFIED_BY'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CERTIFIED_BY Character(3) VARCHAR2(3) NOT NULL Certified By
DUE=DUEVO
NEN=NEN