PER_NAME_EXTRA (SQL View)	Index Back
CommGen ID Extract Name view CommGen ID Extract Name view is used to build the Communication Data Source with the person name data.

PER_NAME_EXTRA

(SQL View)

CommGen ID Extract Name view

CommGen ID Extract Name view is used to build the Communication Data Source with the person name data.

SELECT A.EMPLID ,A.NAME_TYPE ,A.EFFDT ,A.EFF_STATUS ,A.NAME_PREFIX ,B.DESCR ,B.DESCRSHORT ,A.NAME_SUFFIX ,C.DESCR ,C.DESCRSHORT ,A.NAME ,' ' ,A.FIRST_NAME ,A.MIDDLE_NAME ,A.LAST_NAME ,A.NAME_INITIALS ,A.NAME_ROYAL_PREFIX ,A.NAME_ROYAL_SUFFIX ,A.SECOND_LAST_NAME ,A.NAME_AC ,A.PREF_FIRST_NAME ,A.PARTNER_LAST_NAME ,A.PARTNER_ROY_PREFIX ,A.LAST_NAME_PREF_NLD ,A.NAME_DISPLAY ,A.NAME_FORMAL ,A.NAME_TITLE ,A.LASTUPDDTTM ,A.LASTUPDOPRID FROM PS_NAMES A LEFT OUTER JOIN PS_NAME_PREFIX_TBL B ON A.NAME_PREFIX = B.NAME_PREFIX LEFT OUTER JOIN PS_NAME_SUFFIX_TBL C ON A.NAME_SUFFIX = C.NAME_SUFFIX WHERE A.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_NAMES B1 WHERE A.EMPLID = B1.EMPLID AND A.NAME_TYPE = B1.NAME_TYPE AND B1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
Prompt Table: NAME_TYPE_TBL

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

6 PRFX_DESCR Character(30) VARCHAR2(30) NOT NULL Prefix Description

7 PRFX_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Prefix Short Description

8 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

9 SUFX_DESCR Character(30) VARCHAR2(30) NOT NULL Suffix Description

10 SUFX_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Suffix Short Description

11 NAME Character(50) VARCHAR2(50) NOT NULL Name

12 NAME_RESULT Character(120) VARCHAR2(120) NOT NULL Name Result

13 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

14 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME

15 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

16 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials

17 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix

18 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix

19 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name

20 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

21 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name

22 PARTNER_LAST_NAME Character(30) VARCHAR2(30) NOT NULL The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.

23 PARTNER_ROY_PREFIX Character(15) VARCHAR2(15) NOT NULL The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.

24 LAST_NAME_PREF_NLD Character(1) VARCHAR2(1) NOT NULL The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
1=Own Name
2=Name Partner
3=Name Partner + Own Name
4=Own Name + Name Partner

25 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

26 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.

27 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title

28 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

29 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Prompt Table: NAME_TYPE_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
6	PRFX_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Prefix Description
7	PRFX_DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Prefix Short Description
8	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
9	SUFX_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Suffix Description
10	SUFX_DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Suffix Short Description
11	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
12	NAME_RESULT	Character(120)	VARCHAR2(120) NOT NULL	Name Result
13	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
15	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
16	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
17	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
18	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Suffix
19	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
20	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
21	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
22	PARTNER_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
23	PARTNER_ROY_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.
24	LAST_NAME_PREF_NLD	Character(1)	VARCHAR2(1) NOT NULL	The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name. 1=Own Name 2=Name Partner 3=Name Partner + Own Name 4=Own Name + Name Partner
25	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
26	NAME_FORMAL	Character(60)	VARCHAR2(60) NOT NULL	Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
27	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title
28	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
29	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.