LM_PG_MGR_CRSE

(SQL Table)
 Index Back

Learning Compliance Record

Learning Compliance Pivot Operator table

  • Related Language Record: LM_PG_MR_CS_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    3 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    4 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    5 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code

    Prompt Table: LM_PG_MGRCRS_VW

    6 LM_LRN_TYPE_DESC Character(15) VARCHAR2(15) NOT NULL Type
    7 LM_ACT_NAME Character(254) VARCHAR2(254) NOT NULL Learning
    8 LM_CAT_FLG Character(1) VARCHAR2(1) NOT NULL Categories
    9 LM_CURR_USER_FLG Character(1) VARCHAR2(1) NOT NULL Current User AdHoc Learner Groups.
    10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: LM_BU_VW

    11 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

    Prompt Table: LM_ORG_VW

    12 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID

    Prompt Table: %EDITTABLE

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

    Prompt Table: LM_CI_LE_VW

    14 LM_STTS Character(4) VARCHAR2(4) NOT NULL Enrollment Status
    CANC=Dropped
    COMP=Completed
    DECL=Denied
    ENRL=Enrolled
    INCO=Not Completed
    INPO=In-Progress
    MACT=Moved to New Activity
    NOTS=Not Started
    PEAP=Pending Approval
    PEPA=Pending Payment
    PLAN=Planned
    PPYA=Payment Approval
    RQST=Learning Request
    WAIV=Waived
    WTLT=Waitlisted
    15 LM_ENRL_DT_FRM Date(10) DATE Enrollment Date From
    16 LM_ENRL_DT_TO Date(10) DATE Enrollment Date To