LM_SES

(SQL Table)
Index Back

Session Table

Session Table

  • Related Language Record: LM_SES_LANG
  • Parent Record Of LM_SES_EQP LM_SES_INSTR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    2 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
    3 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
    4 LM_SES_DT Date(10) DATE NOT NULL Session Date
    5 LM_START_TM Time(15) TIMESTAMP NOT NULL Start Time
    6 LM_END_DT Date(10) DATE End Date

    Default Value: LM_SES.LM_SES_DT

    7 LM_END_TM Time(15) TIMESTAMP NOT NULL End Time
    8 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    9 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID

    Prompt Table: LM_FCLTY_SRCH

    10 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID

    Prompt Table: LM_ROOM_SRCH

    11 LM_SS_FCLTY_DISP Character(1) VARCHAR2(1) NOT NULL Display facility through self service

    Y/N Table Edit

    Default Value: Y

    12 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    13 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    14 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    15 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    16 LM_NOTE Long Character CLOB Notes and Comments