LM_PERS_NAME_I

(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 , A.LM_EXT_PERSON_FLG , A.LM_HR_EMPLID , C.LM_LE_ID , B.COUNTRY_NM_FORMAT , B.NAME_AC , B.LM_NAME_DISPLAY FROM PS_LM_PERSON A , PS_LM_PERSON_NAME B ,PS_LM_PERSON_ATTRB 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 C.LM_PERSON_ID = A.LM_PERSON_ID AND C.LM_EMPL_RCD = ( SELECT MIN(C1.LM_EMPL_RCD) FROM PS_LM_PERSON_ATTRB C1 WHERE C1.LM_PERSON_ID = C.LM_PERSON_ID AND C1.EFFDT = C.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_EXT_PERSON_FLG Character(1) VARCHAR2(1) NOT NULL External Person Flag
12 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
13 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
14 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Format for Country

Prompt Table: COUNTRY_TBL

15 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name
16 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field