LM_ENR_CRS_VW

(SQL View)
 Index Back

Current Enrollment View

Current Enrollment View

SELECT B.LM_ENRLMT_ID ,B.LM_PERSON_ID ,A.LM_CI_ID ,A.LM_ACT_ID ,A.LM_ACT_CD ,A.LM_CS_LONG_NM ,A.LM_DURN_DAYS ,A.LM_DURN_HRS ,A.LM_DURN_MINS ,A.LM_START_DT ,B.LM_TARGET_CMPL_DT ,B.LM_STTS ,B.LM_REQUESTOR_ID ,B.LM_ACT_REQ ,A.LM_DM_LONG_NM ,A.LM_DMTHD_TYPE_ID ,B.LM_ENRL_DT ,B.LM_MAND_ENRL_FLG FROM PS_LM_ACT_CI_VW A , PS_LM_ENRLMT B WHERE B.LM_ACT_ID=A.LM_ACT_ID AND B.LM_CI_ID=A.LM_CI_ID AND B.LM_STTS IN ('ENRL','INPO','PEAP','PEPA','PPYA','WTLT')

  • Related Language Record: LM_ENR_CRS_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_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person 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_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    6 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    7 LM_DURN_DAYS Number(4,0) SMALLINT NOT NULL Length of Activity in Days
    8 LM_DURN_HRS Number(3,0) SMALLINT NOT NULL Duration - Hours
    9 LM_DURN_MINS Number(3,0) SMALLINT NOT NULL Duration - Minutes
    10 LM_START_DT Date(10) DATE Start Date
    11 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.
    12 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
    13 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
    14 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes
    15 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    16 LM_DMTHD_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method Type ID - This is a unique identifier for each delivery method type
    17 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
    18 LM_MAND_ENRL_FLG Character(1) VARCHAR2(1) NOT NULL Mandatory Learning Flag