LM_EQP_LE_VW

(SQL View)
 Index Back

Equipment LE View

Equipment Learning Environment View

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

  • Related Language Record: LM_EQP_LE_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

    Prompt Table: LM_EQP_SRCH

    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

    Prompt Table: CURRENCY_CD_TBL

    12 LM_NOTE Long Character CLOB Notes and Comments