Page tree
Skip to end of metadata
Go to start of metadata

The report shows the mean score (the average results of the rating scale questions) for each survey; survey page; and survey question and the percentage of users who selected each response.

The date range provide in the selection section takes 00:00:00 as Default time. This time refers to Datacenter time zone. If Admins runs the report from other time zone, it may result in wrong result. Thus please adjust the selection date accordingly.

Report NameItem Evaluation
REPORT_NAME_IDItemEvaluation
REPORT_ID119
CATEGORY_IDLearning
GROUP_IDItemEvaluation
WORKFLOW_IDRun ItemEvaluation Report
TYPEBIRT /PRD
USER_TYPEAdmin
SHOW_IN_MENU

Yes

 

MeanScoreForItem
SELECT ( CASE 
           WHEN (SELECT Count(DISTINCT( rating_scale_id )) AS V_RATING_SETS 
                 FROM   pa_survey_question 
                 WHERE  section_id IN (SELECT section_id 
                                       FROM   pa_survey_section 
                                       WHERE  survey_id = ?) 
                        AND question_type = 'RATING SCALE') = 1 THEN 
           (SELECT 
Decode(Round(SUM(PSR.stud_response_value) / Count(*), 1), NULL, 
-1, 
Round(SUM(PSR.stud_response_value) / Count(*), 1)) 
FROM   pa_survey_responses PSR, 
pa_stud_survey PSS, 
pa_cpnt_survey PCS, 
pa_survey_question PSQ, 
pa_ssg_inst PSI, 
pa_ssg_locn PSL 
WHERE  PSS.cpnt_survey_id = PCS.cpnt_survey_id 
AND PSR.stud_survey_id = PSS.stud_survey_id 
AND PSR.question_id = PSQ.question_id 
AND PSS.survey_status_id = 'COMPLETED' 
AND PCS.survey_id = ? 
AND PSS.cpnt_survey_id = ? 
AND PSQ.question_type = 'RATING SCALE' 
AND PSR.stud_response_value <> 0 
AND PSS.sch_id = PSI.schd_id(+) 
AND PSS.sch_id = PSL.schd_id(+) 
AND PSS.item_completion_date = (SELECT Min(item_completion_date) 
                             FROM   pa_stud_survey 
                             WHERE 
 cpnt_survey_id = PSS.cpnt_survey_id 
 AND stud_survey_id = PSS.stud_survey_id) 
/**  and (PCS.CPNT_TYP_ID,PCS.CPNT_ID,PCS.REV_DTE) IN [ItemSearch]  and PSS.STUD_ID IN [UserSearch]  and PSS.SCH_ID IN [ScheduledOfferingSearch]  and trunc(PSS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate]  and NOT trunc(PSS.ITEM_COMPLETION_DATE) > [LearningEventToDate]  and PSI.INST_ID IN [InstructorSearch]  and PSL.LOCN_ID IN [LocationSearch]  and PCS.IS_ACTIVE = [IncludePreviousItemAssociations]  */ 
) 
ELSE -1 
END ) AS MEAN_SCORE 
FROM   dual 
MeanScoreForSection
SELECT ( CASE 
           WHEN (SELECT Count(DISTINCT( rating_scale_id )) AS V_RATING_SETS 
                 FROM   pa_survey_question 
                 WHERE  section_id IN (SELECT section_id 
                                       FROM   pa_survey_section 
                                       WHERE  survey_id = ? 
                                              AND section_id = ?) 
                        AND question_type = 'RATING SCALE') = 1 THEN 
           (SELECT 
Decode(Round(SUM(PSR.stud_response_value) / Count(*), 1), NULL, 
-1, 
Round(SUM(PSR.stud_response_value) / Count(*), 1)) 
FROM   pa_survey_responses PSR, 
pa_stud_survey PSS, 
pa_cpnt_survey PCS, 
pa_survey_question PSQ, 
pa_ssg_inst PSI, 
pa_ssg_locn PSL 
WHERE  PSS.cpnt_survey_id = PCS.cpnt_survey_id 
AND PSR.stud_survey_id = PSS.stud_survey_id 
AND PSR.question_id = PSQ.question_id 
AND PSS.survey_status_id = 'COMPLETED' 
AND PCS.survey_id = ? 
AND PSQ.question_type = 'RATING SCALE' 
AND PSR.stud_response_value <> 0 
AND PSS.sch_id = PSI.schd_id(+) 
AND PSS.sch_id = PSL.schd_id(+) 
AND PSQ.section_id = ? 
AND PCS.cpnt_survey_id = ? 
AND PSS.item_completion_date = (SELECT Min(item_completion_date) 
                             FROM   pa_stud_survey 
                             WHERE 
 cpnt_survey_id = PSS.cpnt_survey_id 
 AND stud_survey_id = PSS.stud_survey_id) 
/**  and (PCS.CPNT_TYP_ID,PCS.CPNT_ID,PCS.REV_DTE) IN [ItemSearch]  and PSS.STUD_ID IN [UserSearch]  and PSS.SCH_ID IN [ScheduledOfferingSearch]  and trunc(PSS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate]  and NOT trunc(PSS.ITEM_COMPLETION_DATE) > [LearningEventToDate]  and PSI.INST_ID IN [InstructorSearch]  and PSL.LOCN_ID IN [LocationSearch]  and PCS.IS_ACTIVE = [IncludePreviousItemAssociations]  */ 
) 
ELSE -1 
END ) AS MEAN_SCORE 
FROM   dual 
MeanScoreForSurvey
SELECT ( CASE 
           WHEN (SELECT Count(DISTINCT( rating_scale_id )) AS V_RATING_SETS 
                 FROM   pa_survey_question 
                 WHERE  section_id IN (SELECT section_id 
                                       FROM   pa_survey_section 
                                       WHERE  survey_id = ?) 
                        AND question_type = 'RATING SCALE') = 1 THEN 
           (SELECT 
Decode(Round(SUM(PSR.stud_response_value) / Count(*), 1), NULL, 
-1, 
Round(SUM(PSR.stud_response_value) / Count(*), 1)) 
FROM   pa_survey_responses PSR, 
pa_stud_survey PSS, 
pa_cpnt_survey PCS, 
pa_survey_question PSQ, 
pa_ssg_inst PSI, 
pa_ssg_locn PSL 
WHERE  PSS.cpnt_survey_id = PCS.cpnt_survey_id 
AND PSR.stud_survey_id = PSS.stud_survey_id 
AND PSR.question_id = PSQ.question_id 
AND PSS.survey_status_id = 'COMPLETED' 
AND PCS.survey_id = ? 
AND PSQ.question_type = 'RATING SCALE' 
AND PSR.stud_response_value <> 0 
AND PSS.sch_id = PSI.schd_id(+) 
AND PSS.sch_id = PSL.schd_id(+) 
AND PSS.item_completion_date = (SELECT Min(item_completion_date) 
                             FROM   pa_stud_survey 
                             WHERE 
 cpnt_survey_id = PSS.cpnt_survey_id 
 AND stud_survey_id = PSS.stud_survey_id) 
/**  and (PCS.CPNT_TYP_ID,PCS.CPNT_ID,PCS.REV_DTE) IN [ItemSearch]  and PSS.STUD_ID IN [UserSearch]  and PSS.SCH_ID IN [ScheduledOfferingSearch]  and trunc(PSS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate]  and NOT trunc(PSS.ITEM_COMPLETION_DATE) > [LearningEventToDate]  and PSI.INST_ID IN [InstructorSearch]  and PSL.LOCN_ID IN [LocationSearch]  and PCS.IS_ACTIVE = [IncludePreviousItemAssociations]  */ 
) 
ELSE -1 
END ) AS MEAN_SCORE 
FROM   dual 
QuestionComments
SELECT DISTINCT PSR.stud_comments, 
                Concat(( INSTDETAIL.fname ), Concat(' ', Concat(( 
                                             INSTDETAIL.lname ), 
                                                         Concat(' ', ( 
                                                         INSTDETAIL.mi ))))) 
                COMMENTS_INSTRUCTOR_NAME 
FROM   pa_cpnt_survey PCS, 
       pa_stud_survey PSS, 
       pa_survey_responses PSR, 
       pa_ssg_inst PSI, 
       pa_ssg_locn PSL, 
       pa_inst INSTDETAIL 
WHERE  PCS.cpnt_survey_id = PSS.cpnt_survey_id 
       AND PSS.stud_survey_id = PSR.stud_survey_id 
       AND PSL.schd_id(+) = PSS.sch_id 
       AND PSI.schd_id(+) = PSS.sch_id 
       AND INSTDETAIL.inst_id(+) = PSR.inst_id 
       AND PSR.stud_comments IS NOT NULL 
       AND PSS.cpnt_survey_id = ? 
       AND PSR.question_id = ? 
/**          AND PCS.SURVEY_ID in [SurveyIDSearch]    AND (PCS.CPNT_TYP_ID,PCS.CPNT_ID,PCS.REV_DTE) in [ItemSearch]    AND PCS.IS_ACTIVE  = [IncludePreviousItemAssociations]    AND PSS.STUD_ID in [UserSearch]    AND trunc(PSS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate]    AND NOT trunc(PSS.ITEM_COMPLETION_DATE) > [LearningEventToDate]    AND PSS.SCH_ID in [ScheduledOfferingSearch]           AND PSI.INST_ID IN [InstructorSearch]    AND PSL.LOCN_ID in [LocationSearch]    */ 
SurveyByItem
SELECT ? 
       AS fromDate, 
       ? 
       AS toDate, 
       QS.survey_id, 
       CS.cpnt_survey_id, 
       CPNT.cpnt_title, 
       SQ.section_id, 
       SQ.question_id, 
       Decode(SR.stud_response_value, NULL, SR.stud_response_text, 
                                      SR.stud_response_value) 
       ANSWER_ID, 
       QS.name, 
       CS.cpnt_typ_id, 
       CS.cpnt_id, 
       CS.rev_dte, 
       SSEC.section_order, 
       SSEC.section_title, 
       SSEC.resource_type, 
       SQ.question_order, 
       SQ.question_type, 
       SQ.question_text, 
       CONCAT(( INSTDETAIL.fname ), CONCAT(' ', CONCAT(( INSTDETAIL.lname ), 
                                                CONCAT(' ', 
       ( INSTDETAIL.mi ))))) 
       INSTRUCTOR_NAME, 
       Nvl(Decode(SQ.question_type, 'RATING SCALE', (SELECT 
CONCAT(CONCAT(pa_rating_scale_label.rating, ' - '), al.label_value) 
                                      FROM 
           pa_rating_scale_label, 
           pv_i18n_active_locale_label al 
                                                     WHERE 
               pa_rating_scale_label.rating = SR.stud_response_value 
               AND pa_rating_scale_label.rating_scale_id = SQ.rating_scale_id 
               AND al.label_id (+) = pa_rating_scale_label.rating_label 
               AND al.locale_id (+) = ?), 
                                    'OPEN ENDED', Max(SR.stud_response_text), 
                                    Max(QAC.choice_label)), 'N/A') 
       ANSWER, 
       COUNT(DISTINCT SR.response_id) 
       ANSWER_COUNT, 
       Round(Decode(COUNT(DISTINCT SR.response_id), 0, 0, 
                                                    ( 
                   COUNT(DISTINCT SR.response_id) / (SELECT 
                   COUNT(DISTINCT PSS1.stud_survey_id) 
                                                     FROM 
                   pa_cpnt_survey PCS1, 
                   pa_stud_survey PSS1, 
                   pa_survey_responses PSR1, 
                   pa_ssg_inst PSI1, 
                   pa_ssg_locn PSL1 
                                                     WHERE 
                         PCS1.cpnt_survey_id = PSS1.cpnt_survey_id 
                         AND PSS1.stud_survey_id = PSR1.stud_survey_id 
                         AND PSL1.schd_id(+) = PSS1.sch_id 
                         AND PSI1.schd_id(+) = PSS1.sch_id 
                         AND PSS1.cpnt_survey_id = CS.cpnt_survey_id 
                         AND PSR1.question_id = SQ.question_id 
                         AND PSS1.survey_status_id = 'COMPLETED' 
                                                    /** AND PCS1.SURVEY_ID in [SurveyIDSearch] AND (PCS1.CPNT_TYP_ID,PCS1.CPNT_ID,PCS1.REV_DTE) in [ItemSearch] AND PCS1.IS_ACTIVE  = [IncludePreviousItemAssociations] AND PSS1.STUD_ID in [UserSearch] AND trunc(PSS1.ITEM_COMPLETION_DATE) >= [LearningEventFromDate] AND NOT trunc(PSS1.ITEM_COMPLETION_DATE) > [LearningEventToDate]                                                     AND PSS1.SCH_ID in [ScheduledOfferingSearch] AND PSI1.INST_ID IN [InstructorSearch] AND PSL1.LOCN_ID in [LocationSearch] */) * 100 )), 1)
       ANSWER_PERCENTAGE, 
       --( select count(*) as TotalSurveys from PA_STUD_SURVEY pss,PA_CPNT_SURVEY psc where psc.CPNT_SURVEY_ID = pss.CPNT_SURVEY_ID and psc.survey_id = QS.survey_id ) TOTAL_SURVEY,
       (SELECT COUNT(DISTINCT PSS.stud_survey_id) 
        FROM   pa_stud_survey PSS, 
               pa_cpnt_survey PCS, 
               pa_ssg_inst PSI, 
               pa_ssg_locn PSL 
        WHERE  PCS.cpnt_survey_id = PSS.cpnt_survey_id 
               AND PSL.schd_id(+) = PSS.sch_id 
               AND PSI.schd_id(+) = PSS.sch_id 
               AND PCS.survey_id = QS.survey_id 
       /** and (PCS.CPNT_TYP_ID,PCS.CPNT_ID,PCS.REV_DTE) IN [ItemSearch]         and PSS.STUD_ID IN [UserSearch] and PSS.SCH_ID IN [ScheduledOfferingSearch] and trunc(PSS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate] and NOT trunc(PSS.ITEM_COMPLETION_DATE) > [LearningEventToDate]        and PSI.INST_ID IN [InstructorSearch]and PSL.LOCN_ID IN [LocationSearch] and PCS.IS_ACTIVE =  [IncludePreviousItemAssociations] */)                                                                 TOTAL_SURVEY,
       --( select count(*) as TotalSurveys from PA_STUD_SURVEY pss,PA_CPNT_SURVEY psc where psc.CPNT_SURVEY_ID = pss.CPNT_SURVEY_ID and psc.survey_id = QS.survey_id and pss.survey_status_id = 'COMPLETED') COMPLETED_SURVEY,
       (SELECT COUNT(DISTINCT PSS.stud_survey_id) 
        FROM   pa_stud_survey PSS, 
               pa_cpnt_survey PCS, 
               pa_ssg_inst PSI, 
               pa_ssg_locn PSL 
        WHERE  PCS.cpnt_survey_id = PSS.cpnt_survey_id 
               AND PSS.survey_status_id = 'COMPLETED' 
               AND PSL.schd_id(+) = PSS.sch_id 
               AND PSI.schd_id(+) = PSS.sch_id 
               AND PCS.survey_id = QS.survey_id 
       /** and (PCS.CPNT_TYP_ID,PCS.CPNT_ID,PCS.REV_DTE) IN [ItemSearch] and PSS.STUD_ID IN [UserSearch] and PSS.SCH_ID IN [ScheduledOfferingSearch] and trunc(PSS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate]        and NOT trunc(PSS.ITEM_COMPLETION_DATE) > [LearningEventToDate] and PSI.INST_ID IN [InstructorSearch] and PSL.LOCN_ID IN [LocationSearch] and PCS.IS_ACTIVE =  [IncludePreviousItemAssociations]*/) COMPLETED_SURVEY,
       --( select count(*) as TotalSurveys from PA_STUD_SURVEY pss,PA_CPNT_SURVEY psc where psc.CPNT_SURVEY_ID = pss.CPNT_SURVEY_ID and psc.CPNT_SURVEY_ID = CS.CPNT_SURVEY_ID) TOTAL_ITEM_SURVEY,
       (SELECT COUNT(DISTINCT PSS.stud_survey_id) 
        FROM   pa_stud_survey PSS, 
               pa_cpnt_survey PCS, 
               pa_ssg_inst PSI, 
               pa_ssg_locn PSL 
        WHERE  PCS.cpnt_survey_id = PSS.cpnt_survey_id 
               AND PSL.schd_id(+) = PSS.sch_id 
               AND PSI.schd_id(+) = PSS.sch_id 
               AND PCS.cpnt_survey_id = CS.cpnt_survey_id 
       /** and (PCS.CPNT_TYP_ID,PCS.CPNT_ID,PCS.REV_DTE) IN [ItemSearch]         and PSS.STUD_ID IN [UserSearch] and PSS.SCH_ID IN [ScheduledOfferingSearch] and trunc(PSS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate] and NOT trunc(PSS.ITEM_COMPLETION_DATE) > [LearningEventToDate]        and PSI.INST_ID IN [InstructorSearch]and PSL.LOCN_ID IN [LocationSearch] and PCS.IS_ACTIVE =  [IncludePreviousItemAssociations] */)
       TOTAL_ITEM_SURVEY, 
       --( select count(*) as TotalSurveys from PA_STUD_SURVEY pss,PA_CPNT_SURVEY psc where psc.CPNT_SURVEY_ID = pss.CPNT_SURVEY_ID and psc.CPNT_SURVEY_ID = CS.CPNT_SURVEY_ID and pss.survey_status_id = 'COMPLETED') COMPLETED_ITEM_SURVEY,
       (SELECT COUNT(DISTINCT PSS.stud_survey_id) 
        FROM   pa_stud_survey PSS, 
               pa_cpnt_survey PCS, 
               pa_ssg_inst PSI, 
               pa_ssg_locn PSL 
        WHERE  PCS.cpnt_survey_id = PSS.cpnt_survey_id 
               AND PSS.survey_status_id = 'COMPLETED' 
               AND PSL.schd_id(+) = PSS.sch_id 
               AND PSI.schd_id(+) = PSS.sch_id 
               AND PCS.cpnt_survey_id = CS.cpnt_survey_id 
       /** and (PCS.CPNT_TYP_ID,PCS.CPNT_ID,PCS.REV_DTE) IN [ItemSearch] and PSS.STUD_ID IN [UserSearch] and PSS.SCH_ID IN [ScheduledOfferingSearch] and trunc(PSS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate]        and NOT trunc(PSS.ITEM_COMPLETION_DATE) > [LearningEventToDate] and PSI.INST_ID IN [InstructorSearch] and PSL.LOCN_ID IN [LocationSearch] and PCS.IS_ACTIVE =  [IncludePreviousItemAssociations]*/) COMPLETED_ITEM_SURVEY,
       --( SELECT COUNT(*) AS OFFERINGS FROM PA_CPNT_SURVEY PCS,PA_STUD_SURVEY PSS WHERE PCS.cpnt_survey_id=pss.cpnt_survey_id and pss.sch_id is not null and PCS.cpnt_survey_id = CS.CPNT_SURVEY_ID) SCHDULE_OFFERING    
       (SELECT COUNT(DISTINCT sch_id) 
        FROM   pa_stud_survey 
        WHERE  sch_id IS NOT NULL 
               AND cpnt_survey_id IN (SELECT PCS.cpnt_survey_id 
                                      FROM   pa_cpnt_survey PCS, 
                                             pa_stud_survey PSS, 
                                             pa_ssg_inst PSI, 
                                             pa_ssg_locn PSL 
                                      WHERE 
                   PCS.cpnt_survey_id = PSS.cpnt_survey_id 
                   AND PSS.sch_id IS NOT NULL 
                   AND PSL.schd_id(+) = PSS.sch_id 
                   AND PSI.schd_id(+) = PSS.sch_id 
                   AND PCS.cpnt_survey_id = CS.cpnt_survey_id 
                                     /** and (PCS.CPNT_TYP_ID,PCS.CPNT_ID,PCS.REV_DTE) IN [ItemSearch] and PSS.STUD_ID IN [UserSearch] and PSS.SCH_ID IN [ScheduledOfferingSearch] and trunc(PSS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate]                                      and NOT trunc(PSS.ITEM_COMPLETION_DATE) > [LearningEventToDate] and PSI.INST_ID IN [InstructorSearch] and PSL.LOCN_ID IN [LocationSearch] and PCS.IS_ACTIVE =  [IncludePreviousItemAssociations]                                      */ 
                                      GROUP  BY ( PCS.cpnt_survey_id )) 
       /** and SCH_ID IN [ScheduledOfferingSearch]*/) 
       SCHDULE_OFFERING, 
       QS.anonymous 
FROM   pa_questionnaire_survey QS 
       LEFT OUTER JOIN pa_cpnt_survey CS 
                    ON QS.survey_id = CS.survey_id 
       RIGHT OUTER JOIN pa_stud_survey SS 
                     ON CS.cpnt_survey_id = SS.cpnt_survey_id 
       LEFT OUTER JOIN pa_survey_responses SR 
                    ON SS.stud_survey_id = SR.stud_survey_id 
       LEFT OUTER JOIN pa_survey_question SQ 
                    ON SR.question_id = SQ.question_id 
       LEFT OUTER JOIN pa_survey_section SSEC 
                    ON SQ.section_id = SSEC.section_id 
       LEFT OUTER JOIN pa_question_answer_choices QAC 
                    ON QAC.question_id = SQ.question_id 
       LEFT OUTER JOIN pa_ssg_inst INSTRUCTOR 
                    ON INSTRUCTOR.schd_id = SS.sch_id 
       LEFT OUTER JOIN pa_ssg_locn LOCATION 
                    ON LOCATION.schd_id = SS.sch_id 
       LEFT OUTER JOIN pa_inst INSTDETAIL 
                    ON INSTDETAIL.inst_id = SR.inst_id, 
       -- PA_QUESTION_ANSWER_CHOICES QAC, 
       pv_course CPNT--, 
--  PA_SSG_INST INSTRUCTOR, 
-- PA_SSG_LOCN LOCATION  
--AND ( ( SQ.QUESTION_TYPE = 'MULTIPLE CHOICE' OR SQ.QUESTION_TYPE = 'ONE CHOICE' ) AND ( QAC.ANSWER_ID = SR.STUD_RESPONSE_VALUE OR QAC.ANSWER_ID IS NULL OR SR.STUD_RESPONSE_VALUE IS NULL))
WHERE  ( QAC.answer_id = SR.stud_response_value 
          OR SR.stud_response_value IS NULL 
          OR SQ.question_type = 'RATING SCALE' ) 
       AND SQ.section_id IS NOT NULL 
       AND SS.survey_status_id = 'COMPLETED' 
       AND CS.cpnt_typ_id = CPNT.cpnt_typ_id 
       AND CS.cpnt_id = CPNT.cpnt_id 
       AND CS.rev_dte = CPNT.rev_dte 
       AND QS.level_indicator = 1 
--AND ( SS.SCH_ID = INSTRUCTOR.SCHD_ID OR SS.SCH_ID IS NULL ) 
--AND ( SS.SCH_ID = LOCATION.SCHD_ID OR SS.SCH_ID IS NULL )        
/**             and QS.SURVEY_ID in [SurveyIDSearch]       and SS.STUD_ID in [UserSearch]       and trunc(SS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate]       and NOT trunc(SS.ITEM_COMPLETION_DATE) > [LearningEventToDate]       and SS.SCH_ID in [ScheduledOfferingSearch]       AND INSTRUCTOR.INST_ID IN [InstructorSearch]       AND LOCATION.LOCN_ID in [LocationSearch]       and QS.IS_ACTIVE  = [QuestionnaireSurveyStatus]       and CS.IS_ACTIVE  = [IncludePreviousItemAssociations]     and (CS.cpnt_typ_id,CS.cpnt_id,CS.rev_dte) in [ItemSearch]  */ 
/**            and [security:PA_QUESTIONNAIRE_SURVEY QS]        */ 
GROUP  BY QS.survey_id, 
          CS.cpnt_survey_id, 
          CPNT.cpnt_title, 
          SQ.section_id, 
          SQ.question_id, 
          Decode(SR.stud_response_value, NULL, SR.stud_response_text, 
                                         SR.stud_response_value), 
          QS.name, 
          CS.cpnt_typ_id, 
          CS.cpnt_id, 
          CS.rev_dte, 
          SSEC.section_order, 
          SSEC.section_title, 
          SSEC.resource_type, 
          SQ.question_order, 
          SQ.question_type, 
          SQ.question_text, 
          SR.stud_response_text, 
          SR.stud_response_value, 
          SQ.rating_scale_id, 
          QS.anonymous, 
          INSTDETAIL.fname, 
          INSTDETAIL.lname, 
          INSTDETAIL.mi 
TotalRespondents
SELECT Count(DISTINCT PSR.stud_survey_id) AS TOTAL_RESPONDENTS 
FROM   pa_survey_responses PSR, 
       pa_stud_survey PSS, 
       pa_cpnt_survey PCS, 
       pa_ssg_inst PSI, 
       pa_ssg_locn PSL 
WHERE  PSR.stud_survey_id = PSS.stud_survey_id 
       AND PSS.cpnt_survey_id = PCS.cpnt_survey_id 
       AND PSS.sch_id = PSI.schd_id(+) 
       AND PSS.sch_id = PSL.schd_id(+) 
       AND PSS.survey_status_id = 'COMPLETED' 
       AND PCS.survey_id = ? 
       AND PCS.cpnt_survey_id = ? 
       AND PSR.question_id = ? 
/**       AND trunc(PSS.ITEM_COMPLETION_DATE) >= [LearningEventFromDate]       AND NOT trunc(PSS.ITEM_COMPLETION_DATE) > [LearningEventToDate]       AND PSS.STUD_ID in [UserSearch]       AND PSS.SCH_ID in [ScheduledOfferingSearch]       AND PSI.INST_ID IN [InstructorSearch]       AND PSL.LOCN_ID in [LocationSearch]  */ 

 

 

Link:

 

 

 

  • No labels