LM_ACTCI_CLS_VW

(SQL View)
Index Back

Activity CI UI View

Activity and Catalog Item View for Catalog User Interface

SELECT A.LM_CI_ID , A.LM_ACT_ID , A.LM_ACT_CD , A.LM_ACT_STATUS , A.LM_CS_LONG_NM , A.LM_CS_DESCR , A.LM_DMTHD_TYPE_ID , A.LM_DMTHD_ID , A.LM_DM_LONG_NM , A.LANGUAGE_CD , A.LM_START_DT , A.LM_END_DT , A.LM_DISP_DATES , A.LM_DISP_START_DT , A.LM_DISP_END_DT , A.LM_MIN_ENRLMT , A.LM_MAX_ENRLMT , A.LM_NFRC_MAX_ENRLMT , A.LM_ENRL_TOT , A.LM_ENABLE_WTLST , A.LM_WTLST_CAP , A.LM_WTLST_TOT , A.LM_APRVL_TYPE_REQ , A.LM_APRVL_REQ_EXT , A.LM_ENRLMT_ADMIN_ID , A.LM_NFRC_PRQ , A.LM_AUTO_ATND , A.LM_AUTO_CMPL_DURN , A.LM_AUTO_ASGN_OBJV , A.LM_CEU , A.LM_LST_ENRL_DAYS , A.LM_LST_ENRL_DT , A.LM_LST_DROP_DAYS , A.LM_LST_DROP_DT , A.LM_RMNDR_DAYS , A.LM_RMNDR_DT , A.LM_RMNDR_ID , A.LM_ACT_OWNER_ID , A.LM_OVERBOOK_PCT , A.LM_MIN_ENRL_DAYS , A.LM_LRN_PD_DAYS , A.LM_WRN_PD_DAYS , A.LM_INSTR_ID , A.LM_RESTRICT_TO_PRG ,%subrec(LM_PRICING_SBR,A) FROM PS_LM_ACT_CI_VW A WHERE LM_ACT_STATUS = '3'

  • Related Language Record: LM_ACTCICLS_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    2 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    3 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    4 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
    1=Active
    2=Inactive
    3=Closed
    4=Pending
    5=Concluded
    5 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    6 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail
    7 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
    8 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
    9 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    10 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    11 LM_START_DT Date(10) DATE Start Date
    12 LM_END_DT Date(10) DATE End Date
    13 LM_DISP_DATES Character(1) VARCHAR2(1) NOT NULL Use Display Dates
    14 LM_DISP_START_DT Date(10) DATE Display Start Date
    15 LM_DISP_END_DT Date(10) DATE Display End Date
    16 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.
    17 LM_MAX_ENRLMT Number(10,0) DECIMAL(10) NOT NULL Maximum Enrollment - Maximum number of students that may be enrolled in an activity.
    18 LM_NFRC_MAX_ENRLMT Character(1) VARCHAR2(1) NOT NULL Enforce Maximum Enrollment - Enforces the amount indicated as the Maximum Enrollment for an activity.
    19 LM_ENRL_TOT Number(6,0) INTEGER NOT NULL Enrollment Total
    20 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.
    21 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.
    22 LM_WTLST_TOT Number(4,0) SMALLINT NOT NULL Stores the total number of learners currently on the waitlist
    23 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
    24 LM_APRVL_REQ_EXT Character(3) VARCHAR2(3) NOT NULL Enrollment Admin Approval Required for Non-Employees
    10=None
    40=Learning Admin
    60=Payment
    25 LM_ENRLMT_ADMIN_ID Number(15,0) DECIMAL(15) NOT NULL Enrollment Administrator ID
    26 LM_NFRC_PRQ Character(1) VARCHAR2(1) NOT NULL Enforce Prerequisites
    27 LM_AUTO_ATND Character(1) VARCHAR2(1) NOT NULL Auto Mark Attendance - Indicates Attendance will automatically be marked at the completion of the activity
    28 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.
    29 LM_AUTO_ASGN_OBJV Character(1) VARCHAR2(1) NOT NULL Auto Assign Objectives
    30 LM_CEU Number(8,2) DECIMAL(7,2) NOT NULL Continuing Education Units
    31 LM_LST_ENRL_DAYS Number(3,0) SMALLINT NOT NULL Last Enroll Days
    32 LM_LST_ENRL_DT Date(10) DATE Last Enroll Date
    33 LM_LST_DROP_DAYS Number(3,0) SMALLINT NOT NULL Last Drop Days
    34 LM_LST_DROP_DT Date(10) DATE Last Drop Date
    35 LM_RMNDR_DAYS Number(3,0) SMALLINT NOT NULL Reminder Days
    36 LM_RMNDR_DT Date(10) DATE Reminder Date
    37 LM_RMNDR_ID Character(30) VARCHAR2(30) NOT NULL Reminder ID
    38 LM_ACT_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Activity Owner
    39 LM_OVERBOOK_PCT Number(3,0) SMALLINT NOT NULL Overbook Percent
    40 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
    41 LM_LRN_PD_DAYS Number(3,0) SMALLINT NOT NULL Learning Period Days -- Number of days student can access online content.
    42 LM_WRN_PD_DAYS Number(3,0) SMALLINT NOT NULL Warning Period Days
    43 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID
    44 LM_RESTRICT_TO_PRG Character(1) VARCHAR2(1) NOT NULL Restrict to Programs
    45 LM_INT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Price
    46 LM_EXT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Price
    47 LM_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Training Units - Price
    48 LM_INT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Drop Price
    49 LM_EXT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Drop Price
    50 LM_DP_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Drop Training Units
    51 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL