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

LM_SURVEY_PG_VW

(SQL View)

Survey Results Pivot View

Administrator and Instructor can view Survey Results Pivot Grid

SELECT DISTINCT N.LM_CS_LONG_NM , B.LM_SURVEY_ID , M.LM_LC_LONG_NM , D.LM_QUESTION_TEXT , L.LM_ACT_CD , E.LM_RESPONSE_VALUE , F.LM_RESPONSE_TXTLBL ,L.LM_ACT_ID ,B.LM_LC_ID ,A.LM_ENRLMT_ID 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 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')

Related Language Record: LM_SURVEY_PGLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 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.

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

6 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.

7 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.

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object
2	LM_SURVEY_ID	Character(10)	VARCHAR2(10) NOT NULL	The SURVEY_ID is the unique identifier for a Survey definition.
3	LM_LC_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Learning Component Long Name
4	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.
5	LM_ACT_CD	Character(30)	VARCHAR2(30) NOT NULL	Activity Code
6	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.
7	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.
8	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
9	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
10	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID