LM_LC_HDR_VW

(SQL View)
 Index Back

Component Header view

Component Header view

SELECT A.LM_ACT_ID ,B.LM_LC_ID ,A.LM_CS_LONG_NM ,B.LM_LC_TYPE_ID ,C.LM_LC_TYPE_LONG ,B.LM_LC_LONG_NM ,B.LM_BAS_LC_TYPE ,B.LM_DURN_DAYS ,B.LM_DURN_MINS ,B.LM_DURN_HRS ,B.LM_LC_DESCR ,B.LM_LAUNCH_URL ,A.LM_DMTHD_ID ,A.LM_ACT_CD ,B.LM_CMPLNCE FROM PS_LM_ACT_CI_VW A , PS_LM_LC_VW B , PS_LM_LC_TYPE_VW C WHERE A.LM_ACT_ID = B.LM_ACT_ID AND B.LM_LC_TYPE_ID = C.LM_LC_TYPE_ID

  • Related Language Record: LM_LC_HDR_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_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
    3 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    4 LM_LC_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component Type ID
    5 LM_LC_TYPE_LONG Character(200) VARCHAR2(200) NOT NULL Learning Component Type Long Name
    6 LM_LC_LONG_NM Character(200) VARCHAR2(200) NOT NULL Learning Component Long Name
    7 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
    8 LM_DURN_DAYS Number(4,0) SMALLINT NOT NULL Length of Activity in Days
    9 LM_DURN_MINS Number(3,0) SMALLINT NOT NULL Duration - Minutes
    10 LM_DURN_HRS Number(3,0) SMALLINT NOT NULL Duration - Hours
    11 LM_LC_DESCR Long Character CLOB Learning Component Description
    12 LM_LAUNCH_URL Long Character(2000) VARCHAR2(2000) URL or File path - Holds the URL or File Path name for an activity.
    13 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
    14 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    15 LM_CMPLNCE Character(3) VARCHAR2(3) NOT NULL Compliance - This field is used to comply with the Scorm and AICC regulations.
    10=None
    20=AICC-API
    30=AICC-HACP
    40=SCORM11
    50=SCORM12
    60=SCORM2004