LM_DEPT_LVW

(SQL View)
Index Back

Department Chart Field View

Department Chart Field View

SELECT DISTINCT A.LM_HR_DEPTID , B.LANGUAGE_CD , B.LM_ORG_DESCR , B.LM_ORG_SDESCR FROM PS_LM_ORGANIZATION A , PS_LM_ORG_LANG B WHERE A.LM_ORGANIZATION_ID= B.LM_ORGANIZATION_ID AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND A.EFF_STATUS = 'A' AND A.LM_ORG_TYPE = 'DEPT'

  • Related Language Record for LM_DEPT_CF_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_HR_DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    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