LM_PERS_DTL_LVW

(SQL View)
 Index Back

Rel Lang Vw for LM_PERS_DTL_VW

Related Language View for LM_PERS_DTL_VW

SELECT A.LM_PERSON_ID , L.LANGUAGE_CD , L.LM_ORG_DESCR , L.LM_ORG_SDESCR , %Substring(N.LM_JOBCD_DESCR, 1, 30) FROM PS_LM_PERSON A , PS_LM_CURR_JOB_VW B , PS_LM_ORGANIZATION E , PS_LM_ORG_LANG L , PS_LM_JOBCODE_TBL M , PS_LM_JOBCODE_LANG N WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND E.LM_ORGANIZATION_ID = B.LM_ORGANIZATION_ID AND %CurrentDateIn BETWEEN E.EFFDT AND E.LM_END_EFFDT AND E.EFF_STATUS = 'A' AND L.LM_ORGANIZATION_ID = E.LM_ORGANIZATION_ID AND L.EFFDT = E.EFFDT AND B.LM_JOBCODE_ID = M.LM_JOBCODE_ID AND M.LM_JOBCODE_ID = N.LM_JOBCODE_ID AND %CurrentDateIn BETWEEN M.EFFDT AND M.LM_END_EFFDT AND M.EFFDT = N.EFFDT AND N.LANGUAGE_CD = L.LANGUAGE_CD AND M.EFF_STATUS = 'A' UNION SELECT A.LM_PERSON_ID , E.LANGUAGE_CD , C.LM_ORG_DESCR , C.LM_ORG_SDESCR , %Substring(E.LM_JOBCD_DESCR, 1, 30) FROM PS_LM_PERSON A , PS_LM_CURR_JOB_VW B , PS_LM_ORGANIZATION C , PS_LM_JOBCODE_TBL D , PS_LM_JOBCODE_LANG E WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND C.LM_ORGANIZATION_ID = B.LM_ORGANIZATION_ID AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.EFF_STATUS = 'A' AND B.LM_JOBCODE_ID = D.LM_JOBCODE_ID AND D.LM_JOBCODE_ID = E.LM_JOBCODE_ID AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT AND D.EFFDT = E.EFFDT AND D.EFF_STATUS = 'A' AND NOT EXISTS ( SELECT 'X' FROM PS_LM_ORG_LANG F WHERE F.LM_ORGANIZATION_ID = C.LM_ORGANIZATION_ID AND F.EFFDT = C.EFFDT AND F.LANGUAGE_CD = E.LANGUAGE_CD) UNION SELECT A.LM_PERSON_ID , D.LANGUAGE_CD , D.LM_ORG_DESCR , D.LM_ORG_SDESCR , %Substring(E.LM_JOBCD_DESCR, 1, 30) FROM PS_LM_PERSON A , PS_LM_CURR_JOB_VW B , PS_LM_ORGANIZATION C , PS_LM_ORG_LANG D , PS_LM_JOBCODE_TBL E WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND C.LM_ORGANIZATION_ID = B.LM_ORGANIZATION_ID AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.EFF_STATUS = 'A' AND C.LM_ORGANIZATION_ID = D.LM_ORGANIZATION_ID AND C.EFFDT = D.EFFDT AND B.LM_JOBCODE_ID = E.LM_JOBCODE_ID AND %CurrentDateIn BETWEEN E.EFFDT AND E.LM_END_EFFDT AND E.EFF_STATUS = 'A' AND NOT EXISTS ( SELECT 'X' FROM PS_LM_JOBCODE_LANG F WHERE F.LM_JOBCODE_ID = E.LM_JOBCODE_ID AND F.EFFDT = E.EFFDT AND F.LANGUAGE_CD = D.LANGUAGE_CD)

  • Related Language Record for LM_PERS_DTLI_VW LM_PERS_DTLS_VW LM_PERS_DTL_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
    4 LM_ORG_SDESCR Character(10) VARCHAR2(10) NOT NULL Organization Short Description
    5 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title