LM_ROOM_TBL

(SQL Table)
 Index Back

Room Table

Stores all of the training rooms located in a facility.

  • Parent Record Of LM_ROOM_ACMDTN LM_ROOM_ATCH LM_ROOM_EQP LM_ROOM_LE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID

    Prompt Table: LM_FCLTY_SRCH

    2 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID
    3 LM_ROOM_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Room Type ID

    Prompt Table: LM_ROOM_TYPE_VW

    4 LM_ROOM_NBR Character(24) VARCHAR2(24) NOT NULL Room Number
    5 LM_ROOM Character(50) VARCHAR2(50) NOT NULL Room Name
    6 LM_BLDG Character(50) VARCHAR2(50) NOT NULL Building Name
    7 LM_FLOOR_NBR Character(6) VARCHAR2(6) NOT NULL Floor Number
    8 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
    9 LM_COST Number(19,3) DECIMAL(18,3) NOT NULL Cost
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    11 LM_ROOM_STATUS Character(1) VARCHAR2(1) NOT NULL Room Status
    1=Active
    2=Inactive

    Default Value: 1

    12 LM_MAX_OCPNCY Number(6,0) INTEGER NOT NULL Maximum Occupancy
    13 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    14 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    15 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    16 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid