LM_CMPNY_DPT_VW

(SQL View)
Index Back

Departments

Contains all Active Departments

SELECT LM_HR_COMPANY ,LM_ORGANIZATION_ID , LM_ORG_DESCR , LM_ORG_SDESCR , LM_MANAGER_ID , LM_HR_SETID , LM_HR_DEPTID FROM PS_LM_ORGANIZATION WHERE LM_ORG_TYPE = 'DEPT' AND %CurrentDateIn BETWEEN EFFDT AND LM_END_EFFDT

  • Related Language Record: LM_CMP_DEPT_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_HR_COMPANY Character(3) VARCHAR2(3) NOT NULL HR's Company ID brought over during synchronization.
    2 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
    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_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
    6 LM_HR_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    7 LM_HR_DEPTID Character(10) VARCHAR2(10) NOT NULL Department