LM_SRVY_PVT_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.LM_PERSON_ID , A.LM_ENRLMT_ID , A.LM_ACT_ID , B.LM_SURVEY_ID , D.LM_QUESTION_TEXT , D.LM_QUESTION_NUM , L.LM_ACT_CD , E.LM_RESPONSE_VALUE , F.LM_RESPONSE_TXTLBL , L.LM_ACT_CD , M.LM_LC_ID , M.LM_LC_LONG_NM FROM PS_LM_ENRLMT A , PS_LM_SRVY_RESULT B , PS_LM_SURVEY_DEFN C , PS_LM_QUESTION D , PS_LM_SRVY_RSL_OPT E , PS_LM_RESPONSE F , PS_LM_ACT L , PS_LM_LC M WHERE B.LM_SURVEY_ID = C.LM_SURVEY_ID AND A.LM_ENRLMT_ID = B.LM_ENRLMT_ID AND B.LM_SURVEY_ID = D.LM_SURVEY_ID AND B.LM_ENRLMT_ID = E.LM_ENRLMT_ID AND B.LM_LC_ID = E.LM_LC_ID AND B.LM_SURVEY_ID = E.LM_SURVEY_ID AND E.LM_SURVEY_ID = F.LM_SURVEY_ID AND E.LM_QUESTION_NUM = F.LM_QUESTION_NUM AND E.LM_RESPONSE_NUM = F.LM_RESPONSE_NUM AND E.LM_QUESTION_NUM = D.LM_QUESTION_NUM AND L.LM_ACT_ID = A.LM_ACT_ID AND M.LM_ACT_ID = A.LM_ACT_ID AND M.LM_LC_ID = B.LM_LC_ID AND M.LM_INTERNAL = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 2 | LM_ENRLMT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 3 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 4 | LM_SURVEY_ID | Character(10) | VARCHAR2(10) NOT NULL | The SURVEY_ID is the unique identifier for a Survey definition. |
| 5 | 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. |
| 6 | LM_QUESTION_NUM | Number(3,0) | SMALLINT NOT NULL | The QUESTION_NUM provides a unique value for each question in a Survey. |
| 7 | LM_ACT_CD | Character(30) | VARCHAR2(30) NOT NULL | Activity Code |
| 8 | 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. |
| 9 | 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. |
| 10 | LM_SUR_ACT | Character(30) | VARCHAR2(30) NOT NULL | Test Activity Code |
| 11 | LM_LC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
| 12 | LM_LC_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Learning Component Long Name |