LM_SURVEY_IDPrompt Table: LM_SURVEY_DEFN
LM_QUESTION_NUMM=Multiple Choice
S=Single Choice
T=Text Response
X=No Response
Default Value: X
Y/N Table Edit
Default Value: N
LM_QUESTION(SQL Table) |
Index Back |
|---|---|
Question DefinitionQUESTION is a record that defines the format and structure of a specific question that is presented as part of a Survey. |
| # | 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.
Prompt Table: LM_SURVEY_DEFN |
| 2 | LM_QUESTION_NUM |
Number(3,0) | SMALLINT NOT NULL | The QUESTION_NUM provides a unique value for each question in a Survey. |
| 3 | LM_SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | LM_RESPONSE_TYPECD | Character(1) | VARCHAR2(1) NOT NULL |
The QUESTION_TYPE_CD specifies the display format and structure for a Question.
M=Multiple Choice S=Single Choice T=Text Response X=No Response Default Value: X |
| 5 | LM_QUESTION_WEIGHT | Number(3,0) | SMALLINT NOT NULL | The QUESTION_WEIGHT specifies the weighting values that is to be applied for a Question. |
| 6 | 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. |
| 7 | LM_REQD_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Learning Component required? - Blended Learning
Y/N Table Edit Default Value: N |