LM_RESPONSE_LNG(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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
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. |