LM_SRVY_RSL_OPT (SQL Table)	Index Back
Survey Results in Options Survey Results that are Yes/No, Rating or Multiple Choice format for a given survey are stored in this record.

LM_SRVY_RSL_OPT

(SQL Table)

Survey Results in Options

Survey Results that are Yes/No, Rating or Multiple Choice format for a given survey are stored in this record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment 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.
Prompt Table: LM_SURVEY_DEFN

4 LM_QUESTION_NUM Number(3,0) SMALLINT NOT NULL The QUESTION_NUM provides a unique value for each question in a Survey.

5 LM_RESPONSE_NUM Number(3,0) SMALLINT NOT NULL The RESPONSE_NUM provides a unique value for each response on a Survey Question.

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.
Default Value: 0

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment 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. Prompt Table: LM_SURVEY_DEFN
4	LM_QUESTION_NUM	Number(3,0)	SMALLINT NOT NULL	The QUESTION_NUM provides a unique value for each question in a Survey.
5	LM_RESPONSE_NUM	Number(3,0)	SMALLINT NOT NULL	The RESPONSE_NUM provides a unique value for each response on a Survey Question.
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. Default Value: 0