PER_CHK_SURVEY_RESPONSES_V

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

SURVEY_RESPONSE_ID

SURVEY_CATEGORY

CHECKLIST_ID

TASK_IN_CHECKLIST_ID

PERSON_ID

ASSIGNMENT_ID

PERIOD_START_DATE

PERIOD_END_DATE

RESPONSE_STATUS

SUBMIT_DATE

SCORE

QUESTIONNAIRE_ID

QSTNR_PARTICIPANT_ID

FREQUENCY

THRESHOLD_SCORE

ANALYSIS_PERIOD

ANALYSIS_PERIOD_UOM

NAME

Query

SQL_Statement

SELECT rsp.survey_response_id,

rsp.survey_category,

rsp.checklist_id,

rsp.task_in_checklist_id,

rsp.person_id,

rsp.assignment_id,

rsp.period_start_date,

rsp.period_end_date,

rsp.response_status,

rsp.submit_date,

rsp.score,

rsp.questionnaire_id,

rsp.qstnr_participant_id,

rsp.frequency,

sch.threshold_score,

sch.analysis_period,

sch.analysis_period_uom,

chk.name

FROM per_chk_survey_responses rsp,

per_checklists_vl chk,

per_checklist_schedules sch

WHERE survey_type = 'ORA_SURVEY'

AND chk.checklist_id = sch.schedule_owner_id

AND sch.schedule_owner = 'CHECKLIST'