LM_EQP_AVBL_VW

(SQL View)
Index Back

Equipment Available View

Lists equipment from the LM_EQP_TBL that has NOT already been assigned to a facility or room.

SELECT C.OPRID ,A.LM_EQP_ID , A.LM_EQP_TYPE_ID , A.LM_EQP , A.LM_EQP_SHORT , A.LM_ASSET_TAG , A.LM_SERIAL_NBR , A.LM_EQP_STATUS , A.LM_COST_TYPE , A.LM_COST , A.CURRENCY_CD , A.LM_NOTE FROM PS_LM_EQP_TBL A ,PS_LM_EQP_LE B ,PS_LM_OPRID_LE_VW C WHERE A.LM_EQP_ID = B.LM_EQP_ID AND B.LM_LE_ID = C.LM_LE_ID AND NOT EXISTS ( SELECT D.LM_EQP_ID FROM PS_LM_FCLTY_EQP D WHERE D.LM_EQP_ID = A.LM_EQP_ID) AND NOT EXISTS ( SELECT E.LM_EQP_ID FROM PS_LM_ROOM_EQP E WHERE E.LM_EQP_ID = A.LM_EQP_ID)

  • Related Language Record: LM_EQP_AVBL_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_EQP_ID Number(10,0) DECIMAL(10) NOT NULL Equipment ID
    3 LM_EQP_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Equipment Type ID

    Prompt Table: LM_EQP_TYPE_VW

    4 LM_EQP Character(50) VARCHAR2(50) NOT NULL Equipment Description
    5 LM_EQP_SHORT Character(10) VARCHAR2(10) NOT NULL Equipment Short Description
    6 LM_ASSET_TAG Character(24) VARCHAR2(24) NOT NULL Asset Tag
    7 LM_SERIAL_NBR Character(24) VARCHAR2(24) NOT NULL Serial Number
    8 LM_EQP_STATUS Character(1) VARCHAR2(1) NOT NULL Equipment Status
    1=Available
    2=Out of Service
    9 LM_COST_TYPE Character(2) VARCHAR2(2) NOT NULL Cost Type Units
    01=Per Hour
    02=Per Day
    03=Per Week
    04=Fixed Cost
    05=Per Student
    10 LM_COST Number(19,3) DECIMAL(18,3) NOT NULL Cost
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    12 LM_NOTE Long Character CLOB Notes and Comments