LM_GROUPS_CRIT

(SQL Table)
 Index Back

Learner Groups Criteria

Learner Groups Criteria

  • Parent record: LM_LRNR_GROUPS

    • # 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
    2 LM_CRITERIA_ID Number(10,0) DECIMAL(10) NOT NULL Learner Group Criteria ID
    3 LM_CRITERIA_TYPE Character(4) VARCHAR2(4) NOT NULL Learner Group Criteria Type
    BUSS=Business Unit
    CNTR=Country
    CUST=Customer
    DEPT=Department
    HIER=Department Hierarchy
    JOBC=Job Code
    LENV=Learning Environment
    LOC=Location
    LRNR=Learner
    REGN=Region
    4 LM_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Used to hold the field name.
    5 LM_CRITERIA_VALUE Character(15) VARCHAR2(15) NOT NULL Criteria Value

    Prompt Table: %EDITTABLE

    6 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    7 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    8 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    9 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    10 LM_ORDER Number(4,0) SMALLINT NOT NULL Order of Completion

    Default Value: 1

    11 LM_ARITH_OPER Character(3) VARCHAR2(3) NOT NULL /* 07-27-04, G.Yu, Arithmetic operator field */
    <=Less Than
    <==Less Than or Equal to
    <>=Not Equal to
    ==Equal
    >=Greater Than
    >==Greater Than or Equal to

    Default Value: =

    12 LM_LOGICAL_OPER Character(3) VARCHAR2(3) NOT NULL /* 07-27-04, G.Yu, logical operator field, AND/OR */
    AND=AND
    OR=OR

    Default Value: OR

    13 LM_LEFT_PAREN Character(3) VARCHAR2(3) NOT NULL /* 07-27-04, G.Yu, Left Parenthesis */
    14 LM_RIGHT_PAREN Character(3) VARCHAR2(3) NOT NULL /* 07-27-04, G.Yu, Right Parenthesis */