LM_EN_AC_SCP_VW

(SQL View)
 Index Back

Activity Details View

Activity details view used by Maintain Enrollments, Administer Activity Roster and Mark Grades and Attendance

SELECT DISTINCT A1.LM_ACT_ID , B3.LM_CI_ID , B3.EFFDT , B3.LM_END_EFFDT , A1.LM_ACT_CD , B2.LM_DM_LONG_NM , B1.EFFDT , B1.LM_END_EFFDT , A1.LM_ENRL_TOT , A1.LM_START_DT , A1.LM_END_DT , B1.LM_DMTHD_TYPE_ID , A1.LM_INSTR_ID , B3.LM_CS_LONG_NM , A1.LANGUAGE_CD , A1.LM_ACT_STATUS , ' ' FROM PS_LM_ACT A1 , PS_LM_DMTH_TYP_TBL B2 , PS_LM_CI_TBL B3 , PS_LM_DMTHD_TBL B1 , PS_LM_ACT_SMPL_VW C1 WHERE A1.LM_DMTHD_TYPE_ID = B1.LM_DMTHD_TYPE_ID AND A1.LM_DMTHD_ID = B1.LM_DMTHD_ID AND A1.LM_CI_ID = B1.LM_CI_ID AND B1.LM_CI_ID = B3.LM_CI_ID AND B1.LM_DMTHD_TYPE_ID = B2.LM_DMTHD_TYPE_ID AND C1.LM_ACT_ID = A1.LM_ACT_ID AND C1.LM_STTS IN ('ENRL','PEPA', 'PPYA', 'CNCL', 'INPO')

  • Related Language Record: LM_EN_AC_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    5 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    6 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    7 LM_DMTHD_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    8 LM_DMTHD_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    9 LM_ENRL_TOT Number(6,0) INTEGER NOT NULL Enrollment Total
    10 LM_START_DT Date(10) DATE Start Date
    11 LM_END_DT Date(10) DATE End Date
    12 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
    13 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID
    14 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    15 LM_LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    16 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
    1=Active
    2=Inactive
    3=Closed
    4=Pending
    5=Concluded
    17 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