LM_NMSEQ_FUT_VW

(SQL View)
 Index Back

Person Name Sequence

Contains the various Names of a Person joined with the Name Type Table so it also contains the order by Sequence

SELECT A.LM_PERSON_ID , B.LM_ORDER_BY_SEQ , A.LM_NAME_TYPE , A.COUNTRY_NM_FORMAT , A.NAME , A.NAME_INITIALS , A.NAME_PREFIX , A.NAME_SUFFIX , A.NAME_ROYAL_PREFIX , A.NAME_ROYAL_SUFFIX , A.NAME_TITLE , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH , A.LAST_NAME , A.FIRST_NAME , A.MIDDLE_NAME , A.SECOND_LAST_NAME , A.SECOND_LAST_SRCH , A.NAME_AC , A.PREF_FIRST_NAME , A.PARTNER_LAST_NAME , A.PARTNER_ROY_PREFIX , A.LAST_NAME_PREF_NLD , A.LM_NAME_DISPLAY FROM PS_LM_PERSON_NAME A , PS_LM_NAME_TYPE B WHERE B.LM_NAME_TYPE = A.LM_NAME_TYPE AND %DateIn('9999-12-31') = A.LM_END_EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
2 LM_ORDER_BY_SEQ Number(2,0) SMALLINT NOT NULL Order By Sequence
3 LM_NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Name Type
4 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Format for Country

Prompt Table: COUNTRY_TBL

5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
7 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
8 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
9 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
10 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
11 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
12 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
13 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
14 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
15 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
16 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
17 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
18 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
19 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name
20 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
21 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.
22 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.
23 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.
24 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field