LM_LRNRQLNG_HST

(SQL Table)
 Index Back

Related language table

Related language for 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 for LM_LRN_REQ_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LM_TITLE Character(30) VARCHAR2(30) NOT NULL Field to store title of an object
    6 LM_LRQ_DESCR Character(254) VARCHAR2(254) NOT NULL New Field. Mixed case. Stores description of requested learning (as entered by requestor).
    7 LM_LRQ_COMMENTS Long Character CLOB New Field. Allows free-text entry of comments related to a request.
    8 LM_GEN_FLD1 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    9 LM_GEN_FLD2 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    10 LM_GEN_FLD3 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    11 LM_GEN_FLD4 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    12 LM_GEN_FLD5 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.