LM_SRVY_RESULT(SQL Table) |
Index Back |
---|---|
Survey ResultSurvey Result stores the calculated survey score for a given survey. |
# | 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_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |
5 | LM_SURVEY_SCORE | Number(6,0) | INTEGER NOT NULL | The SURVEY_VALUE specifies the value calculated as the final value of a Survey completed by the User. |