LM_LRN_REQ_HST

(SQL Table)
 Index Back

Learning Request Table

Learning Request Table. This table is required for new functionality addded for V9. It is not required to have data for the customers existing system to continue functioning as is. No upgrade for this table is necessary.

  • Related Language Record: LM_LRNRQLNG_HST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 LM_LRQ_ID Number(10,0) DECIMAL(10) NOT NULL New field for ELM 9.0, stores unique identifier for a single learning request.
    4 LM_TITLE Character(30) VARCHAR2(30) NOT NULL Field to store title of an object
    5 LM_LRQ_STATUS Character(1) VARCHAR2(1) NOT NULL New Field. Uppercase. Stores current status of learning request.
    1=Requested
    2=Inactive
    3=Offered
    6 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date
    7 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
    8 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    9 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    10 LM_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Category ID - System generated number used to uniquely identify a Category.
    11 LM_LRQ_METHOD Character(1) VARCHAR2(1) NOT NULL Method field in learning request o know if learner prefers self-paced or scheduled learning.
    1=No Preference
    2=Online
    3=Classroom
    4=Live Webcast

    Default Value: 1

    12 LM_LRQ_DESCR Character(254) VARCHAR2(254) NOT NULL New Field. Mixed case. Stores description of requested learning (as entered by requestor).
    13 LM_FROM_DT Date(10) DATE From Date
    14 LM_TO_DT Date(10) DATE To Date
    15 LM_LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    16 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID
    17 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID
    18 LM_LRQ_PRTY Character(1) VARCHAR2(1) NOT NULL New Field. Uppercase. Stores learning request priority, as entered by the requestor. Valid values: ???1???: Required for job ???2???: Required to complete objective ???3???: Career goal ???4???: Voluntary
    1=Required for job
    2=Required to complete objective
    3=Career Goal
    4=Voluntary
    5=No Preference

    Default Value: 5

    19 LM_LRQ_COMMENTS Long Character CLOB New Field. Allows free-text entry of comments related to a request.
    20 LM_SEAT_REQ Number(10,0) DECIMAL(10) NOT NULL Number of Seat Request
    21 LM_SEAT_AVL Number(10,0) DECIMAL(10) NOT NULL Number of Seat Request
    22 LM_AUTO_ENROLL_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    23 LM_GEN_FLD1 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    24 LM_GEN_FLD2 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    25 LM_GEN_FLD3 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    26 LM_GEN_FLD4 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    27 LM_GEN_FLD5 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    28 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
    29 LM_HR_COMPANY Character(3) VARCHAR2(3) NOT NULL HR's Company ID brought over during synchronization.
    30 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
    31 LM_FLAT_COST Number(19,3) DECIMAL(18,3) NOT NULL Flat cost
    32 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    33 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.
    34 LM_ISELIG_TRN_RPT Character(1) VARCHAR2(1) NOT NULL Is eligible for training plan report

    Y/N Table Edit

    35 LM_MONDAY Character(1) VARCHAR2(1) NOT NULL Monday
    36 LM_TUESDAY Character(1) VARCHAR2(1) NOT NULL Tuesday
    37 LM_WEDNESDAY Character(1) VARCHAR2(1) NOT NULL Wednesday
    38 LM_THURSDAY Character(1) VARCHAR2(1) NOT NULL Thursday
    39 LM_FRIDAY Character(1) VARCHAR2(1) NOT NULL Friday
    40 LM_SATURDAY Character(1) VARCHAR2(1) NOT NULL Saturday
    41 LM_SUNDAY Character(1) VARCHAR2(1) NOT NULL Sunday
    42 LM_CLASS_TIME Character(1) VARCHAR2(1) NOT NULL Class timings 1. No Preference 2. Morning 3. Afternoon 4. Evening
    1=No Preference
    2=Morning
    3=Afternoon
    4=Evening

    Default Value: 1

    43 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    44 LM_ESTIMATED_HOURS Number(3,0) SMALLINT NOT NULL Estimated Hours
    45 LM_CREATED_DT Date(10) DATE Creation Date
    46 LM_ACT_DIF_FLG Character(1) VARCHAR2(1) NOT NULL DIF Enrollment

    Default Value: N

    47 LM_TRAINING_CLASS Character(10) VARCHAR2(10) NOT NULL Training Class
    48 LM_TRG_PLN_CTGY Character(10) VARCHAR2(10) NOT NULL Training Plan Category
    49 LM_HRS_TRACK_STTS Character(1) VARCHAR2(1) NOT NULL Hour Tracking Status
    1=Pending Review from ELM Admin.
    2=Approved by ELM Administrator
    3=Pending Review from Payroll
    4=Cancelled
    5=Publish Error
    6=Rejected by Payroll Admin
    7=Finalized
    50 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    51 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    52 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    53 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    54 LM_LRN_DECL Character(1) VARCHAR2(1) NOT NULL Flag for declined Learning requests

    Y/N Table Edit

    Default Value: N