LM_ORG_LE_VW

(SQL View)
Index Back

Organization LE View

View of all Active, Current Organizations

SELECT A.LM_ORGANIZATION_ID , A.LM_ORG_DESCR , A.LM_ORG_SDESCR , A.LM_ORG_TYPE , A.LM_LE_ID , B.LM_LE_LONG_NM , A.LM_HR_SETID , A.LM_HR_DEPTID , A.BUSINESS_UNIT_GL FROM PS_LM_ORGANIZATION A , PS_LM_LE_VW B WHERE %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND A.EFF_STATUS = 'A' AND A.LM_LE_ID = B.LM_LE_ID

  • Related Language Record: LM_ORGLE_LAN_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
    2 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
    3 LM_ORG_SDESCR Character(10) VARCHAR2(10) NOT NULL Organization Short Description
    4 LM_ORG_TYPE Character(15) VARCHAR2(15) NOT NULL Organization Type
    5 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
    6 LM_LE_LONG_NM Character(60) VARCHAR2(60) NOT NULL Learning Environment Long Name
    7 LM_HR_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    8 LM_HR_DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    9 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Business Unit