LM_ENR_BL_VW

(SQL View)
 Index Back

Enrollment BL View

Enrollment View for Blended Learning

SELECT A.LM_ENRLMT_ID , A.LM_CI_ID , A.LM_ACT_ID , A.LM_PERSON_ID , A.LM_TYPE , A.LM_STTS , A.LM_PASS_VAL_ID , B.LM_PASS_STTS_LABEL , A.LM_GRADE_VAL_ID , C.LM_GRADE_LABEL , A.LM_SCORE , A.LM_ENRLMT_DESCR , A.LM_TARGET_CMPL_DT , A.LM_COMPL_DT , D.LM_LAUNCHABLE_HIST , D.LM_START_DT , D.LM_END_DT , D.LM_ACT_STATUS , A.LM_WTLST_NBR , A.LM_ACT_REQ , D.LM_NFRC_COMP_ORDR FROM PS_LM_ENRLMT_VW A , PS_LM_PASS_VAL_VW B , PS_LM_GRD_SCH_VW C , PS_LM_ACT_VW D WHERE A.LM_PASS_VAL_ID = B.LM_PASS_VAL_ID AND A.LM_GRADE_VAL_ID = C.LM_GRADE_VAL_ID AND A.LM_ACT_ID = D.LM_ACT_ID

  • Related Language Record: LM_ENR_BL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    2 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    3 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    4 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    5 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
    6 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
    7 LM_PASS_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Passing Scheme Value ID
    8 LM_PASS_STTS_LABEL Character(30) VARCHAR2(30) NOT NULL Passing Scheme status label
    9 LM_GRADE_VAL_ID Number(10,0) DECIMAL(10) NOT NULL This will uniquely identify the combination of User Label / Grade value.

    Prompt Table: LM_GRD_SCH_VW

    10 LM_GRADE_LABEL Character(30) VARCHAR2(30) NOT NULL Grade
    11 LM_SCORE Character(30) VARCHAR2(30) NOT NULL Score for this Enrollment. Score will be passed by Content Vendor.
    12 LM_ENRLMT_DESCR Long Character(2000) VARCHAR2(2000) Comments
    13 LM_TARGET_CMPL_DT Date(10) DATE The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value.
    14 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
    15 LM_LAUNCHABLE_HIST Character(1) VARCHAR2(1) NOT NULL Launchable from History
    16 LM_START_DT Date(10) DATE Start Date
    17 LM_END_DT Date(10) DATE End Date
    18 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
    1=Active
    2=Inactive
    3=Closed
    4=Pending
    5=Concluded
    19 LM_WTLST_NBR Number(10,0) DECIMAL(10) NOT NULL Number on the Waitlist for an Activity.
    20 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes
    21 LM_NFRC_COMP_ORDR Character(1) VARCHAR2(1) NOT NULL Enforce Component Order