LM_PERS_DTL_VW

(SQL View)
 Index Back

Person Details View

Contains a Persons Detail fields for Use by Other Modules

SELECT A.LM_PERSON_ID , D.LM_ACTIVE , D.BUSINESS_UNIT , C.FIRST_NAME , C.LAST_NAME , C.NAME , D.LM_ORGANIZATION_ID , E.LM_ORG_DESCR , E.LM_ORG_SDESCR , E.LM_ORG_TYPE , 0 , ' ' , ' ' , D.LM_JOB_TITLE , D.LM_JOBCODE_ID , D.LM_HIRE_DT , A.LM_HR_EMPLID , C.LAST_NAME_SRCH , C.FIRST_NAME_SRCH , C.NAME_AC , A.LM_EXT_PERSON_FLG , C.LM_NAME_DISPLAY , D.LM_EMPL_RCD FROM PS_LM_PERSON A ,PS_LM_PERSON_NAME C ,PS_LM_CURR_JOB_VW D ,PS_LM_ORGANIZATION E WHERE D.LM_PERSON_ID = A.LM_PERSON_ID AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_LM_CURR_JOB_VW INR WHERE INR.LM_PERSON_ID = D.LM_PERSON_ID AND INR.LM_EMPL_RCD = D.LM_EMPL_RCD ) AND C.LM_PERSON_ID = A.LM_PERSON_ID AND C.LM_DISPLAY_FLAG = 'Y' AND E.LM_ORGANIZATION_ID = D.LM_ORGANIZATION_ID AND E.EFFDT = (SELECT MAX(ORG.EFFDT) FROM PS_LM_ORGANIZATION ORG WHERE ORG.LM_ORGANIZATION_ID = D.LM_ORGANIZATION_ID) AND E.EFF_STATUS = 'A' AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND ((C.LM_NAME_TYPE = 'PRF') OR (C.LM_NAME_TYPE = 'PRI' AND NOT EXISTS ( SELECT LM_NAME_TYPE FROM PS_LM_PERSON_NAME WHERE LM_PERSON_ID = c.LM_PERSON_ID AND LM_NAME_TYPE = 'PRF' AND %CurrentDateIn BETWEEN EFFDT AND LM_END_EFFDT)))

  • Related Language Record: LM_PERS_DTL_LVW

    • # 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_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
    N=Inactive
    Y=Active
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
    5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
    8 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
    9 LM_ORG_SDESCR Character(10) VARCHAR2(10) NOT NULL Organization Short Description
    10 LM_ORG_TYPE Character(15) VARCHAR2(15) NOT NULL Organization Type
    11 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
    12 LM_MGR_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Manager First Name
    13 LM_MGR_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Manager Last Name
    14 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    15 LM_JOBCODE_ID Number(15,0) DECIMAL(15) NOT NULL JobCode ID
    16 LM_HIRE_DT Date(10) DATE Hire Date
    17 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
    18 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    19 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    20 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name
    21 LM_EXT_PERSON_FLG Character(1) VARCHAR2(1) NOT NULL External Person Flag

    Y/N Table Edit

    22 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    23 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber