DARTS : UM_NAMES_PRF_VW

Key	Record.Fieldname	Format	Heading Text
→	EMPLID - Empl ID	Char11	ID
	FIRST_NAME - First Name	Char30	First Name
	LAST_NAME - Last Name	Char30	Last
	MIDDLE_NAME - Middle Name	Char30	Middle
	NAME - Name	Char50	Name
	NAME_PREFIX - Name Prefix	Char4	Prefix
	NAME_SUFFIX - Name Suffix	Char15	Suffix

SQL code for UM_NAMES_PRF_VW

SELECT a.emplid,
       a.name,
       a.last_name,
       a.first_name,
       a.middle_name,
       a.name_prefix,
       a.name_suffix
  FROM ps_names a
 WHERE a.name_type = 'PRF'
   AND a.effdt = (SELECT MAX(a1.effdt)
                    FROM ps_names a1
                   WHERE a1.emplid = a.emplid
                     AND a1.name_type = 'PRF'
                     AND a1.effdt <= SYSDATE);