LM_ACT_CI_VW5

(SQL View)
 Index Back

Activity CI View

Activity and Catalog Item View for Enrollment

SELECT ACT.LM_ACT_ID , ACT.LM_ACT_CD , ACT.LM_ACT_STATUS , ACT.LM_CI_ID , CI.LM_CS_LONG_NM , CI.LM_CS_SHRT_NM , CI.LM_CS_DESCR , ACT.LM_DMTHD_TYPE_ID , ACT.LM_DMTHD_ID , DMTH.LM_DM_LONG_NM , ACT.LANGUAGE_CD , ACT.LM_START_DT , ACT.LM_END_DT , ACT.LM_DISP_DATES , ACT.LM_DISP_START_DT , ACT.LM_DISP_END_DT , ACT.LM_MIN_ENRLMT , ACT.LM_MAX_ENRLMT , ACT.LM_NFRC_MAX_ENRLMT , ACT.LM_ENRL_TOT , ACT.LM_ENABLE_WTLST , ACT.LM_WTLST_CAP , ACT.LM_WTLST_TOT , ACT.LM_APRVL_TYPE_REQ , ACT.LM_APRVL_REQ_EXT , ACT.LM_ENRLMT_ADMIN_ID , ACT.LM_NFRC_PRQ , ACT.LM_AUTO_ATND , ACT.LM_AUTO_CMPL_DURN , ACT.LM_AUTO_ASGN_OBJV , ACT.LM_CEU , ACT.LM_LST_ENRL_START , ACT.LM_LST_ENRL_DAYS , ACT.LM_LST_ENRL_TYPE , ACT.LM_LST_ENRL_DT , ACT.LM_LST_DROP_START , ACT.LM_LST_DROP_DAYS , ACT.LM_LST_DROP_TYPE , ACT.LM_LST_DROP_DT , ACT.LM_RMNDR_DAYS , ACT.LM_RMNDR_DT , ACT.LM_RMNDR_ID , ACT.LM_ACT_OWNER_ID , ACT.LM_OVERBOOK_PCT , ACT.LM_MIN_ENRL_DAYS , ACT.LM_LRN_PD_DAYS , ACT.LM_WRN_PD_DAYS , ACT.LM_INSTR_ID , ACT.LM_NFRC_COMP_ORDR , ACT.LM_ACT_TYPE , ACT.LM_ALLOW_CMPL_HIST , ACT.LM_LAUNCHABLE_HIST , ACT.LM_DURN_DAYS , ACT.LM_DURN_HRS , ACT.LM_DURN_MINS , ACT.LM_RESTRICT_TO_PRG , ACT.LM_RSRV_SEAT_MAX , ACT.LM_RSRV_SEAT_TOT , CI.LM_CRSE_CODE ,%subrec(LM_PRICING_SBR,ACT) , ACT.LANGUAGE_CD , CI.LM_EXTRNL_OFRNG , ACT.LM_WTLST_ENRL_DT , ACT.LM_RSRV_ORG_ID , DMTH.LM_AUTO_LAUNCH , ACT.LM_PRG_AUTO_ENROLL FROM PS_LM_ACT ACT , PS_LM_CI_TBL CI , PS_LM_DMTH_TYP_TBL DMTH WHERE ACT.LM_CI_ID = CI.LM_CI_ID AND %CurrentDateIn BETWEEN CI.EFFDT AND CI.LM_END_EFFDT AND DMTH.LM_DMTHD_TYPE_ID = ACT.LM_DMTHD_TYPE_ID AND ACT.LM_ACT_STATUS = '1' AND ACT.LM_PRG_AUTO_ENROLL = 'Y'

  • Related Language Record: LM_ACT_CI_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_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    3 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
    1=Active
    2=Inactive
    3=Closed
    4=Pending
    5=Concluded
    4 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    5 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    6 LM_CS_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name - Describes the short name of an object
    7 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail
    8 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
    9 LM_DMTHD_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method
    10 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    11 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    12 LM_START_DT Date(10) DATE Start Date
    13 LM_END_DT Date(10) DATE End Date
    14 LM_DISP_DATES Character(1) VARCHAR2(1) NOT NULL Use Display Dates
    15 LM_DISP_START_DT Date(10) DATE Display Start Date
    16 LM_DISP_END_DT Date(10) DATE Display End Date
    17 LM_MIN_ENRLMT Number(10,0) DECIMAL(10) NOT NULL Minimum Enrollment - Minimum number of students that are required to be in an activity in order for an activity to be held.
    18 LM_MAX_ENRLMT Number(10,0) DECIMAL(10) NOT NULL Maximum Enrollment - Maximum number of students that may be enrolled in an activity.
    19 LM_NFRC_MAX_ENRLMT Character(1) VARCHAR2(1) NOT NULL Enforce Maximum Enrollment - Enforces the amount indicated as the Maximum Enrollment for an activity.
    20 LM_ENRL_TOT Number(6,0) INTEGER NOT NULL Enrollment Total
    21 LM_ENABLE_WTLST Character(3) VARCHAR2(3) NOT NULL Enable Waitlist - A Yes/No field. Selecting the checkbox indicates that learners may be waitlisted for this activity.
    22 LM_WTLST_CAP Number(10,0) DECIMAL(10) NOT NULL Waitlist Capacity - Maximum number of students that may enroll and be placed on the waitlist.
    23 LM_WTLST_TOT Number(4,0) SMALLINT NOT NULL Stores the total number of learners currently on the waitlist
    24 LM_APRVL_TYPE_REQ Character(30) VARCHAR2(30) NOT NULL Specifies the approval type required to take a given course, refer to the translate values
    10=None
    20=Standard
    25 LM_APRVL_REQ_EXT Character(3) VARCHAR2(3) NOT NULL Enrollment Admin Approval Required for Non-Employees
    10=None
    40=Learning Admin
    60=Payment
    26 LM_ENRLMT_ADMIN_ID Number(15,0) DECIMAL(15) NOT NULL Enrollment Administrator ID
    27 LM_NFRC_PRQ Character(1) VARCHAR2(1) NOT NULL Enforce Prerequisites
    28 LM_AUTO_ATND Character(1) VARCHAR2(1) NOT NULL Auto Mark Attendance - Indicates Attendance will automatically be marked at the completion of the activity
    29 LM_AUTO_CMPL_DURN Number(3,0) SMALLINT NOT NULL Auto Completion Duration - Provides the number of days after the conclusion of an activity that triggers the Auto Mark Attendance process to run.
    30 LM_AUTO_ASGN_OBJV Character(1) VARCHAR2(1) NOT NULL Auto Assign Objectives
    31 LM_CEU Number(8,2) DECIMAL(7,2) NOT NULL Continuing Education Units
    32 LM_LST_ENRL_START Character(1) VARCHAR2(1) NOT NULL Last Enrollment Date = Activity Start Date
    33 LM_LST_ENRL_DAYS Number(3,0) SMALLINT NOT NULL Last Enroll Days
    34 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
    35 LM_LST_ENRL_DT Date(10) DATE Last Enroll Date
    36 LM_LST_DROP_START Character(1) VARCHAR2(1) NOT NULL Last Drop Date = Activity Start Date
    37 LM_LST_DROP_DAYS Number(3,0) SMALLINT NOT NULL Last Drop Days
    38 LM_LST_DROP_TYPE Character(1) VARCHAR2(1) NOT NULL Last Drop Type: Before or After the start date
    1=Before the Start Date
    2=After the Enrollment Date
    39 LM_LST_DROP_DT Date(10) DATE Last Drop Date
    40 LM_RMNDR_DAYS Number(3,0) SMALLINT NOT NULL Reminder Days
    41 LM_RMNDR_DT Date(10) DATE Reminder Date
    42 LM_RMNDR_ID Character(30) VARCHAR2(30) NOT NULL Reminder ID
    43 LM_ACT_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Activity Owner
    44 LM_OVERBOOK_PCT Number(3,0) SMALLINT NOT NULL Overbook Percent
    45 LM_MIN_ENRL_DAYS Number(3,0) SMALLINT NOT NULL Minimum Enrollment Days -- Days prior to the start date that the min enrollment should be met
    46 LM_LRN_PD_DAYS Number(3,0) SMALLINT NOT NULL Learning Period Days -- Number of days student can access online content.
    47 LM_WRN_PD_DAYS Number(3,0) SMALLINT NOT NULL Warning Period Days
    48 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID
    49 LM_NFRC_COMP_ORDR Character(1) VARCHAR2(1) NOT NULL Enforce Component Order
    50 LM_ACT_TYPE Character(4) VARCHAR2(4) NOT NULL Activity Type
    BLND=Blended
    SCHD=Scheduled
    SELF=Self Paced
    51 LM_ALLOW_CMPL_HIST Character(1) VARCHAR2(1) NOT NULL Allow Completion from History
    52 LM_LAUNCHABLE_HIST Character(1) VARCHAR2(1) NOT NULL Launchable from History
    53 LM_DURN_DAYS Number(4,0) SMALLINT NOT NULL Length of Activity in Days
    54 LM_DURN_HRS Number(3,0) SMALLINT NOT NULL Duration - Hours
    55 LM_DURN_MINS Number(3,0) SMALLINT NOT NULL Duration - Minutes
    56 LM_RESTRICT_TO_PRG Character(1) VARCHAR2(1) NOT NULL Restrict to Programs
    57 LM_RSRV_SEAT_MAX Number(10,0) DECIMAL(10) NOT NULL Reserved Seats Max Allowed
    58 LM_RSRV_SEAT_TOT Number(10,0) DECIMAL(10) NOT NULL Reserved Seat Total
    59 LM_CRSE_CODE Character(30) VARCHAR2(30) NOT NULL Course Code - User defined Code
    60 LM_INT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Price
    61 LM_EXT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Price
    62 LM_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Training Units - Price
    63 LM_INT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Drop Price
    64 LM_EXT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Drop Price
    65 LM_DP_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Drop Training Units
    66 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    67 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
    68 LM_EXTRNL_OFRNG Character(3) VARCHAR2(3) NOT NULL Internal/External Offering - A checkbox allowing the user to select whether the course is Internal or External.
    10=Internal
    20=External
    69 LM_WTLST_ENRL_DT Date(10) DATE Identifies the last date in which waitlisted learners are automatically enrolled in an activity.
    70 LM_RSRV_ORG_ID Number(15,0) DECIMAL(15) NOT NULL Holds the department or organization identifier.
    71 LM_AUTO_LAUNCH Character(1) VARCHAR2(1) NOT NULL One-Step Launch and Enroll
    72 LM_PRG_AUTO_ENROLL Character(1) VARCHAR2(1) NOT NULL Program Auto Enrollment
    N=No
    Y=Yes