LM_LRNR_GROUPS

(SQL Table)
 Index Back

Learner Groups

Learner Groups - Create student groups

  • Related Language Record: LM_GROUP_LANG

  • Parent Record Of LM_GROUPS_CRIT LM_GROUP_PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID

    Default Value: 123456789

    2 LM_HRTALENTPOOL Character(1) VARCHAR2(1) NOT NULL Used For Talent Pool

    Y/N Table Edit

    3 LM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
    N=Inactive
    Y=Active

    Default Value: Y

    4 LM_LRNR_GRP_DESCR Character(50) VARCHAR2(50) NOT NULL Learner Group Description
    5 LM_LRNR_GRP_SDESCR Character(10) VARCHAR2(10) NOT NULL Learner group - Description
    6 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID

    Prompt Table: LM_PERS_NAME_VW

    7 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

    Prompt Table: LM_LE_VW

    8 LM_LRNR_GROUP_ALL Character(1) VARCHAR2(1) NOT NULL All
    9 LM_LG_TYPE Character(1) VARCHAR2(1) NOT NULL Used to determine if the Learner Group is created using Criteria, Query or Combine Learner Groups.
    C=Criteria Type
    Q=Query Type
    X=Combine Learner Groups
    10 LM_DYNAMIC_LG Character(1) VARCHAR2(1) NOT NULL Used to determine if the Learner Groups is dynamically maintained.
    N=Manually Maintained
    Y=Automatically Maintained

    Default Value: N

    11 LM_QUERY_NAME Character(30) VARCHAR2(30) NOT NULL Query Name.
    12 LM_RECURRENCE_TYPE Character(1) VARCHAR2(1) NOT NULL Used to determine when the Query Type Learner Groups need to be rebuild.
    1=Days
    2=Hours
    3=Minutes
    13 LM_RECURRENCE_TIME Number(5,0) INTEGER NOT NULL Refresh Period
    14 LM_REBUILD_DTTM DateTime(26) TIMESTAMP Last Refreshed On
    15 LM_COMMENT Character(254) VARCHAR2(254) NOT NULL Comments
    16 LM_LG_ERROR Character(1) VARCHAR2(1) NOT NULL Learner Group Error
    17 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    18 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    19 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    20 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid