SSR_BR_NAME_VW

(SQL View)
 Index Back

SELECT NAMES1.EMPLID ,NAMES1.LAST_NAME ,NAMES1.NAME_ROYAL_PREFIX ,CASE WHEN( NAMES1.FIRST_NAME %Concat NAMES1.MIDDLE_NAME) = (' ') THEN ('.') ELSE (NAMES1.FIRST_NAME %Concat ' ' %Concat NAMES1.MIDDLE_NAME) END AS SSR_BR_FST_NMS_NLD FROM PS_NAMES NAMES1 WHERE NAMES1.NAME_TYPE = ( SELECT A.NAME_TYPE FROM PS_SSR_BR_BO_SETUP A ) AND NAMES1.EFFDT = ( SELECT MAX(NAMES2.EFFDT) FROM PS_NAMES NAMES2 WHERE NAMES2.EMPLID = NAMES1.EMPLID AND NAMES2.NAME_TYPE = NAMES1.NAME_TYPE AND NAMES2.EFFDT <= %CurrentDateIn AND NAMES2.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
3 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
4 SSR_BR_FST_NMS_NLD Character(200) VARCHAR2(200) NOT NULL Firstnames