Overview

This command will list the desired survey template, filtering by its ID #. It is used to search for information of the survey template and details related to it. Data listed in this command can also be searched through the File Survey template (SV004) screen.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
SVSURVEY	Survey table	CDSURVEY	ADTEAM GNACTIVITY GNAPPROV GNREVISION GNSURVEY GNSURVEYEXEC GNTEMPLATEFILE SERICHTEXT SVFORMGROUP
GNSURVEY	Evaluation record table	CDSURVEY	ADTEAM ADALLUSERS GNSURVEYTYPE GNSURVEYSHORTURL
GNGENTYPE	Generic type table	CDGENTYPE	ADCHECKLIST GNACTIVITYTIMECFG GNASSOC GNELETRONICFILECFG GNEVAL GNFAVORITE GNMASK GNREVCONFIG GNSECURITY GNTRANSLATION GNTYPEROLE
ADALLUSERS	User table	CDUSER	ADUSEREXTERNALDATA GNFAVORITE ADALLUSERS
ADTEAM	Team table	CDTEAM	ADAUTHLDAPCONFIG GNMAPPING GNPERMISSION
GNREVISION	Revision table	CDREVISION	ADALLUSERS GNACTIONASSOC GNASSOC GNREASON GNREVCONFIG GNREVISIONSTATUS
SVFORMGROUP	Revision template group table	CDFORMGROUP	GNGENTYPE GNFAVORITE
SVFORMREVISION	Template revision table	CDREVISION CDFORMGROUP	GNREVISION SVFORMGROUP

Oracle/Postgres/SQL Server

SELECT GNREV.IDREVISION ,
   SVREV.FGCURRENT ,
   GNACT.IDACTIVITY ,
   GNACT.NMACTIVITY ,
   SVSUR.FGPURPOSESURVEY ,
   GNTYPE.IDGENTYPE ,
   GNTYPE.NMGENTYPE ,
   AUSER.IDUSER ,
   AUSER.NMUSER ,
   TEAMACT.IDTEAM ,
   TEAMACT.NMTEAM ,
   TEAMFILLIN.IDTEAM ,
   TEAMFILLIN.NMTEAM ,
   SVSUR.FGLANGUAGE ,
   GNSUR.FGANONYMOUSSURVEY ,
   SVSUR.FGTOTEM ,
   SVSUR.FGRESUMEANSWER ,
   SVSUR.FGSCORE ,
   SVSUR.FGSHOWGIVEUP ,
   SVSUR.FGMULTANSWER ,
   GNACT.DSDESCRIPTION ,
   GNACT.DTINSERT ,
   GNACT.DTUPDATE ,
   GNACT.NMUSERUPD ,
   GNSUR.FGCORRECTION ,
   USERCORRECT.IDUSER ,
   USERCORRECT.NMUSER ,
   TEAMCORRECT.IDTEAM ,
   TEAMCORRECT.NMTEAM ,
   GNSUR.FGANONYMOUSCORRECT ,
   GNSUR.NRDAYSCORRECTION ,
   GNSUR.FGVIEWTEMPLATE ,
   SVSUR.FGSHOWRESULTNOTE
FROM   GNACTIVITY GNACT
     INNER JOIN SVSURVEY SVSUR
     ON   (
   SVSUR.CDGENACTIVITY = GNACT.CDGENACTIVITY
   )
     INNER JOIN GNSURVEY GNSUR
     ON   (
   GNSUR.CDSURVEY = SVSUR.CDSURVEY
   )
     INNER JOIN GNGENTYPE GNTYPE
     ON   (
   GNTYPE.CDGENTYPE = GNSUR.CDSURVEYTYPE
   )
     INNER JOIN ADALLUSERS AUSER
     ON   (
   AUSER.CDUSER = GNACT.CDUSER
   )
     LEFT JOIN ADTEAM TEAMACT
     ON   (
   TEAMACT.CDTEAM = GNACT.CDTEAM
   )
     LEFT JOIN ADTEAM TEAMFILLIN
     ON   (
   TEAMFILLIN.CDTEAM = SVSUR.CDTEAMFILLIN
   )
     LEFT JOIN ADTEAM TEAMCORRECT
     ON   (
   TEAMCORRECT.CDTEAM = GNSUR.CDTEAMCORRECTION
   )
     LEFT JOIN ADALLUSERS USERCORRECT
     ON   (
   USERCORRECT.CDUSER = GNSUR.CDRESPCORRECTION
   )
     INNER JOIN GNREVISION GNREV
     ON   (
   GNREV.CDREVISION = SVSUR.CDREVISION
   )
     INNER JOIN SVFORMGROUP SVG
     ON   (
   SVG.CDFORMGROUP = SVSUR.CDFORMGROUP
   )
     INNER JOIN SVFORMREVISION SVREV
     ON   (
   SVREV.CDFORMGROUP = SVG.CDFORMGROUP
   AND   SVREV.CDREVISION = GNREV.CDREVISION
   )
WHERE  GNACT.IDACTIVITY = 'Survey template ID'
     --AND SVREV.FGCURRENT = 1 --Current revision optional

Notes

▪1: If you wish to view the current survey template revision only, simply remove the“--” in “--AND SVREV.FGCURRENT”.

Fields used on the view screen

survey-01

survey-02

#	Field ID	Type	Description
1	IDREVISION	VARCHAR(50)	Revision ID #
2	FGCURRENT	NUMERIC(5)	Current template revision: 1- Yes 2- No
3	IDACTIVITY	VARCHAR(50)	Survey template ID #
4	NMACTIVITY	VARCHAR(255)	Survey template name
5	FGPURPOSESURVEY	NUMERIC(5)	Evaluation purpose: 1- Survey 2- Test
6	IDGENTYPE	VARCHAR(50)	Type ID #
7	NMGENTYPE	VARCHAR(255)	Type name
8	IDUSER	VARCHAR(50)	User ID #
9	NMUSER	VARCHAR(255)	User name
10	IDTEAM	VARCHAR(50)	Execution team ID #
11	NMTEAM	VARCHAR(255)	Execution team name
12	IDTEAM	VARCHAR(50)	ID # of the responsible team for completing
13	NMTEAM	VARCHAR(255)	Name of the responsible team for completing
14	FGLANGUAGE	NUMERIC(5)	Indicates the evaluation language: 1 - English (USA) 2 - Portuguese (Brazil) 3 - Spanish 4 - Portuguese (Portugal) 5 - German 6 - French 9 - Italian 11 - English (United Kingdom)
15	FGANONYMOUSSURVEY	NUMERIC(5)	Indicates whether the survey will be answered anonymously: 1- Yes 2- No
16	FGTOTEM	NUMERIC(5)	Indicates whether the evaluation will be restarted after the thank you screen: 1- Yes 2- No
17	FGRESUMEANSWER	NUMERIC(5)	Allow viewing a summary of the evaluation answers before execution: 1- Yes 2- No
18	FGSCORE	NUMERIC(5)	Indicates if there will be a score in the evaluation: 1- Yes 2- No
19	FGSHOWGIVEUP	NUMERIC(5)	Indicates if the option to give up will be displayed in the evaluation execution: 1- Yes 2- No
20	FGMULTANSWER	NUMERIC(5)	Indicates if the survey allows multiple responses: 1- Yes 2- No
21	DSDESCRIPTION	TEXT(16)	Description
22	DTINSERT	DATETIME(8)	Insertion date
23	DTUPDATE	DATETIME(8)	Update date
24	NMUSERUPD	VARCHAR(255)	Name of the user who updated it
25	FGCORRECTION	NUMERIC(5)	Correction mode: 1- Manual 2- Automatic 3- No correction
26	IDUSER	VARCHAR(50)	ID # of the user responsible for the correction
27	NMUSER	VARCHAR(255)	Name of the user responsible for the correction
28	IDTEAM	VARCHAR(50)	ID # of the team responsible for the correction
29	NMTEAM	VARCHAR(255)	Name of the team responsible for the correction
30	NRDAYSCORRECTION	NUMERIC(9)	Deadline in days for correction
31	FGANONYMOUSCORRECT	NUMERIC(5)	Indicates if the survey correction will be anonymous: 1- Yes 2- No
32	FGVIEWTEMPLATE	NUMERIC(5)	Allow correction viewing: 1- Yes 2- No
33	FGSHOWRESULTNOTE	NUMERIC(5)	Indicates if it is possible to view the answer score: 1- Yes 2- No

Survey template and details

Overview

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen