LM_SURVEY_DEFN(SQL Table) |
Index Back |
---|---|
Survey DefinitionDefines the format and structure of a Survey that may be enabled for use in one of several points in an application. |
# | 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. |
2 | LM_ATTRIB_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Learner Attribute Description |
3 | LM_ATTRIB_SDESCR | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
4 | LM_SURVEY_CALC_CD | Character(1) | VARCHAR2(1) NOT NULL |
The CERTIF_CALC_CD specifies the method for appling a weighting calculation to the Survey evaluation.
M=Multiply N=None Default Value: N |
5 | LM_SURVEY_VALUE | Number(6,0) | INTEGER NOT NULL | The SURVEY_VALUE specifies the value calculated as the final value of a Survey completed by the User. |
6 | LM_SURVEY_MAX_VAL | Number(6,0) | INTEGER NOT NULL | Survey Maximum Value |