LM_CURR_ACT_VW2

(SQL View)
 Index Back

Learner Activity view

view of learner's current activities

SELECT A.LM_PERSON_ID , A.LM_ENRLMT_ID , A.LM_CI_ID , A.LM_ACT_ID , A.LM_ACT_REQ , A.LM_TYPE , A.LM_STTS , A.LM_ACT_FEE , A.LM_COMPL_DT , A.LM_GRADE_VAL_ID , E.LM_GRADE_LABEL , A.LM_SCORE , A.LM_REQUESTOR_ID , A.LM_ENRLMT_DESCR , C.LM_CS_LONG_NM , A.LM_ENRL_DT ,%subrec(LM_ROWAUDIT_SBR,A) FROM PS_LM_ENRLMT_VW A , PS_LM_CI_VW C , PS_LM_GRD_SCH_VAL E WHERE A.LM_STTS IN ('ENRL','INPO','PEAP','PLAN','WTLT','COMP','INCO','PEPA','PPYA') AND A.LM_CI_ID = C.LM_CI_ID AND A.LM_GRADE_VAL_ID = E.LM_GRADE_VAL_ID

  • Related Language Record: LM_CUR_ACT_LVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    2 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    3 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    4 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    5 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes

    Y/N Table Edit

    6 LM_TYPE Character(4) VARCHAR2(4) NOT NULL Type of the Enrollment. This field for now will have only one value STDD
    ADHC=Adhoc
    PLAN=Planned
    RSRV=Reserved
    STDD=Standard
    7 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
    8 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class
    9 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
    10 LM_GRADE_VAL_ID Number(10,0) DECIMAL(10) NOT NULL This will uniquely identify the combination of User Label / Grade value.
    11 LM_GRADE_LABEL Character(30) VARCHAR2(30) NOT NULL Grade
    12 LM_SCORE Character(30) VARCHAR2(30) NOT NULL Score for this Enrollment. Score will be passed by Content Vendor.
    13 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
    14 LM_ENRLMT_DESCR Long Character(2000) VARCHAR2(2000) Comments
    15 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    16 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
    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