LM_LC_SURVEY_VW

(SQL View)
 Index Back

Survey Definition

Defines the format and structure of a Survey that may be enabled for use in one of several points in an application.

SELECT A.LM_ACT_ID , A.LM_LC_ID , B.LM_SURVEY_ID , B.LM_ATTRIB_DESCR , B.LM_ATTRIB_SDESCR , B.LM_SURVEY_CALC_CD , B.LM_SURVEY_VALUE , B.LM_SURVEY_MAX_VAL FROM PS_LM_LC A , PS_LM_SURVEY_DEFN B WHERE A.LM_SURVEY_ID = B.LM_SURVEY_ID

  • Related Language Record: LM_LC_SRVY_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_SURVEY_ID Character(10) VARCHAR2(10) NOT NULL The SURVEY_ID is the unique identifier for a Survey definition.
    4 LM_ATTRIB_DESCR Character(50) VARCHAR2(50) NOT NULL Learner Attribute Description
    5 LM_ATTRIB_SDESCR Character(10) VARCHAR2(10) NOT NULL Short Description
    6 LM_SURVEY_CALC_CD Character(1) VARCHAR2(1) NOT NULL The CERTIF_CALC_CD specifies the method for appling a weighting calculation to the Survey evaluation.
    M=Multiply
    N=None

    Default Value: N

    7 LM_SURVEY_VALUE Number(6,0) INTEGER NOT NULL The SURVEY_VALUE specifies the value calculated as the final value of a Survey completed by the User.
    8 LM_SURVEY_MAX_VAL Number(6,0) INTEGER NOT NULL Survey Maximum Value