LM_LRN_REQ_ATTR

(SQL Table)
 Index Back

Learning Requests Attributes

Learning Requests Attributes Tabel. 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. We will deliver this table with system data that the user can change.

  • Related Language Record: LM_LRQ_ATTR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_LRN_REQ_ATTR_ID Number(1,0) SMALLINT NOT NULL Setup Id
    2 LM_FROM_DT_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    3 LM_TO_DT_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    4 LM_LANG_CD_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    5 LM_INSTR_ID_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    6 LM_FCLTY_ID_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    7 LM_LRQ_PRTY_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    8 LM_ACCSBLTY_YN Character(1) VARCHAR2(1) NOT NULL New Field. Uppercase. Indicates need for handicapped accessibility.

    Y/N Table Edit

    9 LM_GEN_FLD1_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    10 LM_GEN_FLD2_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    11 LM_GEN_FLD3_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    12 LM_GEN_FLD4_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    13 LM_GEN_FLD5_YN Character(1) VARCHAR2(1) NOT NULL New field. Yes no Flag.

    Y/N Table Edit

    14 LM_GEN_FLD1_LABEL Character(30) VARCHAR2(30) NOT NULL New field. Label for generic field.
    15 LM_GEN_FLD2_LABEL Character(30) VARCHAR2(30) NOT NULL New field. Label for generic field.
    16 LM_GEN_FLD3_LABEL Character(30) VARCHAR2(30) NOT NULL New field. Label for generic field.
    17 LM_GEN_FLD4_LABEL Character(30) VARCHAR2(30) NOT NULL New field. Label for generic field.
    18 LM_GEN_FLD5_LABEL Character(30) VARCHAR2(30) NOT NULL New field. Label for generic field.
    19 LM_DAYS_YN Character(1) VARCHAR2(1) NOT NULL Yes no Flag for days field.

    Y/N Table Edit

    20 LM_DESCR_YN Character(1) VARCHAR2(1) NOT NULL Yes no Flag for description field.

    Y/N Table Edit

    21 LM_COMMENTS_YN Character(1) VARCHAR2(1) NOT NULL Yes no Flag for comments field.

    Y/N Table Edit

    22 LM_TIMES_YN Character(1) VARCHAR2(1) NOT NULL Yes no Flag for times field.

    Y/N Table Edit