LM_SURVEY_PGLVW (SQL View)	Index Back
Survey Results Pivot View Language view Administrator and Instructor can view Survey Results Pivot Grid

LM_SURVEY_PGLVW

(SQL View)

Survey Results Pivot View

Language view Administrator and Instructor can view Survey Results Pivot Grid

SELECT DISTINCT B.LM_SURVEY_ID , L.LM_ACT_CD , E.LM_RESPONSE_VALUE ,L.LM_ACT_ID ,B.LM_LC_ID ,A.LM_ENRLMT_ID ,O.LANGUAGE_CD ,P.LM_CS_LONG_NM , O.LM_LC_LONG_NM , D.LM_QUESTION_TEXT , F.LM_RESPONSE_TXTLBL FROM PS_LM_ENRLMT A , PS_LM_SRVY_RESULT B , PS_LM_SURVEY_DEFN C , PS_LM_QUESTION D , PS_LM_SRVY_RSL_OPT E , PS_LM_RESPONSE F , PS_LM_ACT L , PS_LM_LC M ,PS_LM_CI_TBL N ,PS_LM_LC_LANG O ,PS_LM_CI_LANG P WHERE B.LM_SURVEY_ID = C.LM_SURVEY_ID AND A.LM_ENRLMT_ID = B.LM_ENRLMT_ID AND B.LM_SURVEY_ID = D.LM_SURVEY_ID AND B.LM_ENRLMT_ID = E.LM_ENRLMT_ID AND B.LM_LC_ID = E.LM_LC_ID AND B.LM_SURVEY_ID = E.LM_SURVEY_ID AND E.LM_SURVEY_ID = F.LM_SURVEY_ID AND E.LM_QUESTION_NUM = F.LM_QUESTION_NUM AND E.LM_RESPONSE_NUM = F.LM_RESPONSE_NUM AND E.LM_QUESTION_NUM = D.LM_QUESTION_NUM AND L.LM_ACT_ID = A.LM_ACT_ID AND M.LM_ACT_ID = A.LM_ACT_ID AND M.LM_LC_ID = B.LM_LC_ID AND M.LM_INTERNAL = 'Y' AND A.LM_CI_ID = N.LM_CI_ID AND L.LM_ACT_STATUS IN ('1', '2', '3', '5') AND M.LM_LC_ID = O.LM_LC_ID AND N.LM_CI_ID = P.LM_CI_ID

Related Language Record for LM_SURVEY_PG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_SURVEY_ID Character(10) VARCHAR2(10) NOT NULL The SURVEY_ID is the unique identifier for a Survey definition.

2 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code

3 LM_RESPONSE_VALUE Number(3,0) SMALLINT NOT NULL The RESPONSE_VALUE specifies the value to be associated with the Response if selected by the User as the desired answer to a Survey Question.

4 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

5 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning

6 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

8 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object

9 LM_LC_LONG_NM Character(200) VARCHAR2(200) NOT NULL Learning Component Long Name

10 LM_QUESTION_TEXT Character(254) VARCHAR2(254) NOT NULL The QUESTION_STMT_TEXT string defines the text value to be presented on the Survey page that poses a specific question to the User.

11 LM_RESPONSE_TXTLBL Character(100) VARCHAR2(100) NOT NULL The RESPONSE_LBL_TEXT string specifies the text value to be presented for the Response control on a Survey Question.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_SURVEY_ID	Character(10)	VARCHAR2(10) NOT NULL	The SURVEY_ID is the unique identifier for a Survey definition.
2	LM_ACT_CD	Character(30)	VARCHAR2(30) NOT NULL	Activity Code
3	LM_RESPONSE_VALUE	Number(3,0)	SMALLINT NOT NULL	The RESPONSE_VALUE specifies the value to be associated with the Response if selected by the User as the desired answer to a Survey Question.
4	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
5	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
6	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
7	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
8	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object
9	LM_LC_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Learning Component Long Name
10	LM_QUESTION_TEXT	Character(254)	VARCHAR2(254) NOT NULL	The QUESTION_STMT_TEXT string defines the text value to be presented on the Survey page that poses a specific question to the User.
11	LM_RESPONSE_TXTLBL	Character(100)	VARCHAR2(100) NOT NULL	The RESPONSE_LBL_TEXT string specifies the text value to be presented for the Response control on a Survey Question.