Survey Question Group Scores View
CREATE VIEW vwsurveyquestiongroupscores AS (
SELECT surveyquestiongroupscores.surveyid,
surveyquestiongroupscores.conversationid,
survey.completeddate,
survey.completeddateltc,
surveyquestiongroupscores.surveyformid,
surveyquestiongroupscores.surveyname,
surveyquestiongroupscores.agentid,
agent.name AS agentname,
agent.department AS agentdepartment,
manager.name AS agentmanager,
surveyquestiongroupscores.agentteamid,
surveyquestiongroupscores.queueid,
queue.name AS queuename,
surveyquestiongroupscores.questiongroupid,
surveyquestiongroupscores.questiongroupname,
surveyquestiongroupscores.questiongrouptotalscore,
surveyquestiongroupscores.questiongroupmaxtotalscore,
surveyquestiongroupscores.questiongroupmarkedna,
surveyquestiongroupscores.updated
FROM ((((surveyquestiongroupscores
LEFT JOIN surveydata survey ON (((survey.surveyid)::text = (surveyquestiongroupscores.surveyid)::text)))
LEFT JOIN userdetails agent ON (((agent.id)::text = (surveyquestiongroupscores.agentid)::text)))
LEFT JOIN userdetails manager ON (((manager.id)::text = (agent.manager)::text)))
LEFT JOIN queuedetails queue ON (((queue.id)::text = (surveyquestiongroupscores.queueid)::text)))
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| surveyid | varchar(50) | true | Survey ID | |||
| conversationid | varchar(50) | true | Conversation ID | |||
| completeddate | timestamp without time zone | true | Survey Completed Date (UTC) | |||
| completeddateltc | timestamp without time zone | true | Survey Completed Date (LTC) | |||
| surveyformid | varchar(50) | true | Survey Form ID | |||
| surveyname | varchar(200) | true | Survey Name | |||
| agentid | varchar(50) | true | Agent ID | |||
| agentname | varchar(200) | true | Agent Name | |||
| agentdepartment | varchar(200) | true | Agent Department | |||
| agentmanager | varchar(200) | true | Agent Manager | |||
| agentteamid | varchar(50) | true | Agent Team ID | |||
| queueid | varchar(50) | true | Queue ID | |||
| queuename | varchar(255) | true | Queue Name | |||
| questiongroupid | varchar(50) | true | Question Group ID | |||
| questiongroupname | varchar(200) | true | Question Group Name | |||
| questiongrouptotalscore | numeric(20,2) | true | Question Group Total Score | |||
| questiongroupmaxtotalscore | numeric(20,2) | true | Question Group Max Total Score | |||
| questiongroupmarkedna | bit(1) | true | Question Group Marked as N/A | |||
| updated | timestamp without time zone | true | Last Updated |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.surveyquestiongroupscores | 13 | BASE TABLE | |
| public.surveydata | 13 | BASE TABLE | |
| public.userdetails | 14 | BASE TABLE | |
| public.queuedetails | 25 | Queue Lookup data | BASE TABLE |