LM_ENR_SCHD_VW

(SQL View)
 Index Back

Scheduled View

Scheduled View

SELECT DISTINCT E.LM_ENRLMT_ID , E.LM_PERSON_ID , A.LM_CI_ID , A.LM_ACT_ID , B.LM_LC_ID , A.LM_ACT_CD , A.LM_LST_ENRL_DT , A.LM_START_DT , A.LM_LST_ENRL_START , A.LM_LST_ENRL_DAYS , A.LM_LST_ENRL_TYPE , B.LM_SES_DT , B.LM_START_TM , B.LM_END_TM , B.TIMEZONE , B.LM_BAS_LC_TYPE , B.LM_SES_ID , E.LM_STTS , E.LM_REQUESTOR_ID , E.LM_ACT_REQ , A.LM_DM_LONG_NM , E.LM_MAND_ENRL_FLG FROM PS_LM_ACT_CI_VW A , PS_LM_LC_SES_FL_VW B , PS_LM_ENRLMT E WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_ACT_STATUS='1' AND (A.LM_END_DT>=%CurrentDateIn OR A.LM_END_DT IS NULL) AND E.LM_ACT_ID=A.LM_ACT_ID AND E.LM_CI_ID=A.LM_CI_ID AND E.LM_STTS IN ('ENRL','INPO','PEAP','PEPA','PPYA','WTLT', 'COMP','INCO')

  • Related Language Record: LM_ENR_SCHD_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_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
    6 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    7 LM_LST_ENRL_DT Date(10) DATE Last Enroll Date
    8 LM_START_DT Date(10) DATE Start Date
    9 LM_LST_ENRL_START Character(1) VARCHAR2(1) NOT NULL Last Enrollment Date = Activity Start Date
    10 LM_LST_ENRL_DAYS Number(3,0) SMALLINT NOT NULL Last Enroll Days
    11 LM_LST_ENRL_TYPE Character(1) VARCHAR2(1) NOT NULL Last Enroll Type: Before or After the start date
    1=Before the Start Date
    2=After the Start Date
    12 LM_SES_DT Date(10) DATE Session Date
    13 LM_START_TM Time(15) TIMESTAMP Start Time
    14 LM_END_TM Time(15) TIMESTAMP End Time
    15 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    16 LM_BAS_LC_TYPE Character(3) VARCHAR2(3) NOT NULL Base Learning Component Type
    10=Web-based
    20=Sessions
    30=Webcast
    40=Assignment
    50=Test
    60=Survey
    17 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
    18 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
    19 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
    20 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes
    21 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    22 LM_MAND_ENRL_FLG Character(1) VARCHAR2(1) NOT NULL Mandatory Learning Flag