LM_SURVEY_IDPrompt Table: LM_SURVEY_DEFN
LM_QUESTION_NUMLM_RESPONSE_NUMDefault Value: 0
LM_RESPONSE(SQL Table) |
Index Back |
|---|---|
Response DefinitionRESPONSE is a record that defines the format and structure of the response to 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_RESPONSE_NUM |
Number(3,0) | SMALLINT NOT NULL | The RESPONSE_NUM provides a unique value for each response on a Survey Question. |
| 4 | LM_SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | 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. |
| 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 |