LM_SRVY_RSL_TXT (SQL Table)	Index Back
Survey Result in Text Survey Results that are Text format for a given survey are stored in this record.

LM_SRVY_RSL_TXT

(SQL Table)

Survey Result in Text

Survey Results that are Text 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_COMMENT Character(254) VARCHAR2(254) NOT NULL Comments

#	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_COMMENT	Character(254)	VARCHAR2(254) NOT NULL	Comments