LM_PERS_NAME_VW

(SQL View)
 Index Back

Person Names

Contains a Person's name for the lowest sequence name type

SELECT A.LM_PERSON_ID , B.LM_NAME_TYPE , B.NAME , B.NAME_PREFIX , B.NAME_SUFFIX , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.LAST_NAME , B.FIRST_NAME , B.MIDDLE_NAME ,C.LM_ACTIVE , A.LM_EXT_PERSON_FLG , A.LM_HR_EMPLID , C.LM_LE_ID , B.COUNTRY_NM_FORMAT , B.NAME_AC , B.LM_NAME_DISPLAY , B.NAME_INITIALS , B.NAME_ROYAL_PREFIX , B.NAME_ROYAL_SUFFIX , B.NAME_TITLE , B.SECOND_LAST_NAME , B.SECOND_LAST_SRCH , B.PREF_FIRST_NAME , B.PARTNER_LAST_NAME , B.PARTNER_ROY_PREFIX , B.LAST_NAME_PREF_NLD , B.LM_DISPLAY_FLAG FROM PS_LM_PERSON A , PS_LM_PERSON_NAME B , PS_LM_CURR_JOB_VW C WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND B.LM_DISPLAY_FLAG ='Y' AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.LM_PERSON_ID = A.LM_PERSON_ID AND ((B.LM_NAME_TYPE = 'PRF') OR (B.LM_NAME_TYPE = 'PRI'AND NOT EXISTS ( SELECT P.LM_NAME_TYPE FROM PS_LM_PERSON_NAME P WHERE P.LM_PERSON_ID = B.LM_PERSON_ID AND P.LM_NAME_TYPE = 'PRF' AND %CurrentDateIn BETWEEN P.EFFDT AND P.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_NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Name Type
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
5 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
7 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
10 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
11 LM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
N=Inactive
Y=Active
12 LM_EXT_PERSON_FLG Character(1) VARCHAR2(1) NOT NULL External Person Flag
13 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
14 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
15 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Format for Country

Prompt Table: COUNTRY_TBL

16 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name
17 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
18 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
19 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
20 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
21 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
22 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
23 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
24 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
25 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.
26 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.
27 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.
28 LM_DISPLAY_FLAG Character(1) VARCHAR2(1) NOT NULL Display the information flag.