This lesson provides an overview of Viedoc Clinic. It describes the user interface and summarizes the main settings that can be configured in Viedoc Clinic.
Viedoc Clinic is the interface for the end user, and is primarily used by site and study staff (Investigators, Study Coordinators, Monitors, Data Managers and so on) and keeps track of all the activities performed by the site.
The access to Viedoc Clinic is by invitation only and provided by either the Study Manager or Site Manager. If invited, you will find the invitation in your email inbox (from no-reply@viedoc.net). In some cases the email can be caught by your email spam filter and in that case you will find it in the email spam folder. For detailed instructions on account activation, see Managing your Viedoc account.
The following main actions can be performed in Viedoc Clinic:
Customer computer requirements are defined as capabilities required by the customer computer to use all features of Viedoc with the intended graphical presentation and within guaranteed response times of Viedoc.
Viedoc supports the following browsers:
For non-compliant browsers you will receive a message on the login page that your browser is not supported.
For Viedoc Designer:
Viedoc does not support the use of private mode browsing in Safari.
The following are required for Viedoc to run in the compatible web browsers:
No data is permanently stored on the customer computer. All data stored in session cookies or local web storage is deleted when the browser session is terminated. The only exception to this is the optional persistent cookie used in the main portal of Viedoc 4 to remember if a user chooses to issue a 2FA trust for the browser for 30 days, and thus avoid further second-factor authentication during this period.
Viedoc 3 has no automatic checks enforcing the above requirements. Viedoc 4 checks for, and enforces, browser type and version, and support for JavaScript, local web storage, and session cookies.
The following screen resolutions are required:
Viedoc requires an internet connection of at least 384 kbit/s.
Viedoc requires an outbound firewall policy allowing encrypted HTTP to be established and communicated to a remote server on port 443 (HTTPS) using Transport Layer Security (TLS) version 1.2 or higher.
There are several layers of security built into the platform. Below are some examples:
| Important! All information related to managing your Viedoc account can be found in the following user guide: Viedoc User Account Management |
From the settings button (wheel) you can perform all actions related to managing your Viedoc account by selecting any of the following: Edit your profile, Change Password, Security Settings:
Selecting any of these options opens a new page, in the example below, the User Settings page. Select the Viedoc learning link to open the Viedoc User Account Management Guide:
Once logged in, you can edit your profile.
To view or edit your user settings, select the settings button (wheel) in the top right corner of the landing page, and select Edit your profile. The User Settings page opens, where you can configure the following:
1. User name - this is your primary email address used for your Viedoc account. This is the user name you use to log in to Viedoc. See below information on primary email address.
2. First name and Last name - fill in these fields that will be used to compose the Display name which will be used in Viedoc to identify your user.
3. System language - select the language of your choice from the drop-down menu.
4. Primary email address - this is the same as the User name described above. It is the email address used in Viedoc to log in, as well as for Viedoc user account-related operations (account setup, password recovery, study invitations).
By default, this is set to the email address used to initiate the Viedoc user account.
The primary email address must be unique and is mandatory. Therefore, it is not possible to delete the primary email address.
See Changing the primary email address.
5, 6, 7, 8. Secondary email addresses - you can add up to 3 additional email addresses that will be used by Viedoc to send notifications on alerts and trackers as configured in Viedoc Designer. Viedoc alert emails will be sent to all the primary and verified secondary email addresses set up for your account.
See Adding a secondary email address and Verifying a secondary email address.
9, 10, 11. Phone number - enter your phone number in format +[CountryCodePhoneNumber] (for example +46123456789) and if you want to receive text messages, select This phone can receive text messages.
See Editing your phone number and Verifying your phone number.
Notes!
Phone number formats are also supported with:
Important!
|
12. Contact information - fill in the following fields: your street address, city, state, postal code and country.
To add a new (secondary) email address to your account:
| 1 | Select Add another email address link (8) next to the current primary email address. |
| 2 | Enter the email address in the new field under Secondary email addresses. |
| 3 | Select Save changes. A notification email is sent to both the primary email address and to the newly added email address to inform you about the change. At the top of the Edit your profile window, you will see a warning message saying that the newly entered email address is not verified (13). |
To verify a secondary email address:
| 1 |
Select the Verify email (7) link next to the newly added email address. A six-digit code will be sent to your new email address and a Verify ownership window is displayed asking you to provide the code in order to verify the new email address. Note! The verification link for the secondary email address is shown only after having saved the changes you may have performed on the other fields on the same page. |
| 2 | Enter the received code and select Confirm. The newly added secondary email address is now verified. |
To change the primary address to one of the existing secondary email addresses:
| 1 | Select Set as primary (5) next to the secondary email address that is to be set as the primary email address. |
| 2 | Select Save changes. A notification email will be sent to both email addresses to inform you about the change. You will use the new primary email address the next time you log in to Viedoc. |
Note! For a secondary email address to be able to be set as primary, it has to be verified first.
To edit your phone number:
| 1 | Enter the number in the Phone number field in the format +[CountryCodePhoneNumber] (for example: +46123456789). |
| 2 | Select Save changes. A notification email will be sent to your primary email address to inform you about the change. |
To verify your phone number:
| 1 | Make sure that the phone number is correctly entered and that the Phone can receive text messages option is selected. |
| 2 | Select the Verify phone number link. A six-digit code will be sent as a text message to your phone and a Verify ownership window is displayed. It will ask you to provide the code in order to verify the phone number. |
| 3 | Enter the code and select Confirm. The phone number is now verified. |
From the settings button (wheel) you can perform all actions related to study access management in Access Settings.
Select the settings button (wheel) in the top right corner of the window, and select Access settings.
The following information is provided, grouped by study:
For users with organization roles, these are listed in the top of the page, in a separate section, providing the following information:
To remove yourself from a certain role within a study:
| 1 |
Select the trash can icon on the right, corresponding to the role, site and study to be removed from: A confirmation window is displayed. |
| 2 |
Select Delete to confirm the deletion: A notification email will be sent to all the Study Managers, or to the Site Managers if any roles are delegated. |
You can remove your Viedoc account when you have no study memberships left, that is, 0 roles in 0 studies.
To delete your Viedoc account:
| 1 | Go to Access Settings. To be able to remove your account, you should have no roles left in any study and no pending invitations: |
| 2 | Select Remove account from Viedoc. You will be prompted to confirm the account removal by entering your password: |
| 3 | Enter your password and select Delete. A confirmation message is displayed and a notification email will be sent to your primary email address:
For identification purposes, Viedoc will keep: the user ID, display name, primary email address, and login history. They are kept until all the studies you have participated in are deleted. All other information related to your account will be removed from Viedoc. |
In case you have study invitations that you have not accepted or rejected yet, the Pending invitations window displays a list of all your pending study invitations:
To accept a study invitation, select Approve next to the respective study role. If this is the first role you have in the respective study, and if the study requires an activation password, you will be prompted to enter it:
Note! All the pending role invitations for a user are automatically approved when the Application Programming Interface (API) method GetToken/Token is used.
To reject a study invitation, select Reject next to the respective study role. The invitation will be removed from the Pending invitations list.
To postpone the approval or rejection of study invitations, select Close in the top right corner of the Pending invitations window and postpone providing an answer to the study invitation.
To access the pending invitations again, the Pending invitations window is shown:
From Viedoc you can log out from different locations:
Note! If you exit the system without logging out, any subject you are currently working with will be locked for other users. After 5 minutes, the subject will be automatically unlocked.
This lesson describes the Viedoc landing page, which is displayed directly after a successful log in:
The landing page provides the following summary information:
| Skill level | Icon | Description |
|---|---|---|
| Rookie |  |
≤ 20 logins |
| Semi-pro |  |
21-100 logins |
| Pro |  |
101-1000 logins |
| Legend |  |
> 1000 logins |
The study slider shows the studies you have access to - each study is represented by a study logo. If you have access to many studies, you can easily find a specific study by entering the study name in the search field. All studies containing characters of the search string appear in the search results.
A progress bar is shown below each study logo. The percentage displayed is calculated by the mean completion of each subject (rounded down). Thus, it measures the total completion of the study.
Note!
Select a study logo to select a study to work with. The study start page is loaded on the lower half of the screen, for more information, see Study start page.
If you are an Administrator and/or Designer you will also have access to Viedoc Admin and Viedoc Designer. Select the respective icon at the upper right corner of the landing page:
When you select the study logo in the landing page, the study start page loads, which contains the following icons that give access to different features, or enable you to view information about the study:
1. Study status
2. Messages
3. Data Export
4. Metrics and Viedoc Reports
5. Roles
6. Reference data
7. Medical coding
8. Viedoc Logistics
9. Viedoc eTMF
10. Demo mode
11. Launch
12. eLearning / Documentation & Training
13. Support
Notes!
The first page displayed when you select a study is, depending on the status of the mandatory documentation and training materials, as below:
| Important! All the mandatory materials must be "Read & Understood" and signed before you can launch the study. You might be able to launch the study in demo mode, depending on the study settings performed by the Study Manager. |
The Study status page is the first page that is shown when accessing a study, if you do not have any mandatory documentation and training material that needs to be signed. This page gives you an overview of the progress of the study - on study, country and/or site level (depending on which sites you have access to):
You can filter the displayed data for country or site by selecting the name of the country or site:
The following statistical information is provided, for the selected site(s):
Note! For resolved and open queries, this includes only manual and validation queries, not missing data queries. For resolved queries, the following statuses are included: Resolved, Rejected, Approved, and Closed.
Note! All the numbers reflect the data entered in the selected operation mode (demo or production), that is, if demo mode is selected, then the numbers reflect only the data entered in demo mode.
A message can either be a system message (such as notifications on password expiration), a study message (such as eCRF changes - for more information, see Approving eCRF changes, or other notifications according to the study configuration).
In the message window, a blue dot indicates a study-specific alert, a yellow dot indicates a form change requiring approval, and a red dot indicates an expiring password.
An indicator in the top bar of the application indicates whether you have unread messages.
Alert messagesAccording to the study configuration, you can receive alert notifications about important occurrences in the data. (For example, in case of a Serious Adverse Event). Alert notifications can be received in the Messages page and as an email.
Depending on the configuration/study setup, the email might have the PDF of the form that triggered that alert as an attachment.
If the option to enable password protection for the alert email attachments has been selected for your study, you should receive a password to enter to open the attachments. The password is provided by your Study Manager.
When you receive an email copy of the alert message with a password-protected attachment, when you open the file you will see the pop-up below where you can enter your password:
The Data export page enables you to review and download study data in the following formats:
Note! Data export might not be available to all users.
For more information about data export and preview, see Exporting data.
The Metrics page gives an overview of the quality of data in terms of open queries and missing data.
Note! Metrics might not be available to all users.
For a detailed description, see Metrics.
If Viedoc Reports is included in the study license and enabled, it is accessed from the Metrics feature. For more information, see Launching Viedoc Reports.
Note! The Roles page is only available for users with special permission to view roles, as per the study design.
The Roles page provides information on:
Under My roles you can see the roles that you have in the respective study:
The following information is displayed (with examples):
By selecting the green arrow button to the right, you will be directed to the Selection page. This is equivalent to selecting the Launch button.
Here you can see a list of all the roles and the respective user(s) for the site(s) you have access to:
To see user details of each role, select Show log. The log displays:
*date and time in Coordinated Universal Time (UTC) time zone
For each study, you can download user logs in PDF and Excel format with information about all users and roles for the sites you have access to.The generated file reflects the country/site selection in the language you have currently set in Viedoc.
Notes!
You can generate the log for the country/site selection in your current Viedoc language by selecting Generate a PDF file / Generate an Excel file at the bottom of the study start page:
Once the user log is generated you can:
The Log of users and roles PDF contains the following chapters:
The User administration log contains information about all users and roles for the sites you have access to, with the following sheets:
When you select the reference data icon, the list of available reference data source-scope combinations is displayed. From here you can open the reference data editor. For details see Working with reference data.
Note! Reference data might not be available to all users.
The medical coding feature allows you to code reported events like Adverse Events, Medical History and Concomitant Medications. When you select the medical coding icon, the page displays metrics regarding medical coding. There is one set of metrics for each medical coding scope available.
Note! Medical coding might not be available to all users.
For more information about medical coding, see Medical coding.
Viedoc Logistics is the interface for managing the supply of your study. A valid license is required to use Viedoc Logistics.
For more information about Viedoc Logistics, see Viedoc Logistics User Guide.
Viedoc eTMF is a digital repository for capturing, managing, sharing, and storing essential documents.
For more information about Viedoc eTMF, see Viedoc eTMF User Guide.
If enabled, a study can operate in demo mode. You can easily switch between demo mode and production mode using the DEMO MODE switch:
The DEMO MODE switch is only visible when you have access to both production and demo mode.
The demo mode is clearly indicated with demo icons. Make sure you do not enter any real data in demo mode!
See also the video tutorial Activate demo mode.
Select the Launch button to access the patient data and electronic Case Report Forms (eCRFs). The button is only visible when you have access to the study in Viedoc Clinic.
If multiple roles are assigned to you in this study, you are first prompted to select the role you would like to use to access the study.
If you have mandatory documentation pending to be read and signed, this is the first page that is displayed when you access the study.
Under this section, you have access to several eLearning programs and various documentation, depending on the roles that have been assigned to you. For details about the user documentation and certificates, see Documentation & Training.
The Viedoc Clinic User Guides are available in the following languages:
To change the language of the Viedoc User Guide, once opened, select the language from the upper right corner, as illustrated below:
Tip! The various lessons in the Viedoc eLearning can easily be compiled into a PDF and printed if you need to store them in the investigator binder.
Select the support icon to open a pop-up with contact details to the users that can help you in case you need support. Normally you will find the contact details of the Monitor here, as the Monitor typically is the first point of contact to the site.
Depending on the study settings and on the role(s) you have within a study, you might have access to various user documentation. This lesson describes the scenario when, under the eLearning section, you get access to the Documentation & Training page, with mandatory and/or optional documentation section(s), as illustrated in the following image:
The available documentation and training materials are split in two main categories:
1. Mandatory sections - contains all the materials that are mandatory for you to read, understand and sign before starting to work.
If you have mandatory documentation pending to be read and signed, then the first page that opens when you access the study is the Documentation and Training.
| Important! All the materials under Mandatory sections must be "Read & Understood" and signed before you can launch the study. You might be able to launch the study in demo mode, depending on the study settings performed by the Study Manager. |
2. Optional sections - contains additional educational and reference materials that you have access to. Simply click on the link to open each of the available documents/links.
To work within a study for which mandatory training sections were assigned, you need to read, understand and sign all the sections listed as mandatory.
To obtain the user certificate:
| 1 | Click the link to open the section. Read through and, when you're done, go back to the Documentation and Training page and click Read & Understood. A date and time stamp in Coordinated Universal Time (UTC) will be shown in the Read & Understood at column: |
| 2 | Repeat step 1 for each of the mandatory sections. When all the mandatory sections are marked as "Read & Understood", a Confirm 'Read & Understood' link becomes available: |
| 3 | Click Confirm 'Read & Understood'. A confirmation pop-up opens: |
| 4 | Enter your Viedoc account password and click Confirm. A confirmation message together with the date and time stamp (UTC) is displayed at the bottom of Mandatory sections. Also, a link to Download your User Certificate becomes available: |
| 5 |
Now you got your certification and are able to access the study. The Launch button is now available. You can also Download your User Certificate. For details, see Downloading your user certificate. The mandatory sections are still available for your further reference, you can at any time go back and open any of those by clicking the section link. |
After you have completed all your mandatory readings and have signed and confirmed, as described in the previous section, you can download your user certificate in PDF format by clicking Download your User Certificate in the bottom of Mandatory sections.
The following information is provided on the certificate:
The Selection page displays all the subjects from all the sites you have access to:
In the default view, each subject is represented by a card. Depending on your study setup, the Selection page can be displayed in several ways. See Views of the Selection page.
In the top right corner of the Selection page, you have dropdown menus to sort and filter the view. The options depend on the selected view. The selected sorting will be kept throughout your session.
In the table view of the Selection page, you can also sort by column in descending or ascending order by selecting a column header with the arrow symbol. Lit-up arrows indicate the selected sorting in orange:
Notes!
To search for a specific subject or any other information collected for a subject, you can type the text you are looking for in the search field:
The system will return the subjects with the information sought that has been entered in the Case Report Form (CRF).
Subject key and All data are two filters that can be applied to the search.
Note! For faster searches, we recommend that you select the Subject key filter.
| Important! If your search returns nothing, it could indicate a problem with your study design. Please contact your Professional Services representative to assist you. |
The Selection page displays a number of icons explained in the following table:
| Icon | Description |
|---|---|
 |
Issue - at least one open query and/or missing data |
 |
Task - there are tasks to be completed, the number indicates the number of tasks |
 |
Complete - all initiated events have been completely filled in |
 |
Signed - all data that is possible to sign has been signed |
 |
Read-only - the card is being open for edit by another user. Note that the subject card can still be accessed for review or SDV by a user without edit permissions, for example a monitor or a data manager. |
 |
In progress - the event is initiated but not completed This icon is only shown when none of the other status icons apply |
 |
Locked - the data in all forms of the event is locked |
Note! The icons showing depend on your user role permissions.
Depending on the study setup, the Selection page looks a bit different.
In the Cards view, you can see all the subjects from all the sites you have access to. Select to display the subject cards side-by-side (default) or in a table:
The subjects are sorted by added date, where the most recently added subject is displayed first. You can sort the subject cards by selecting an option in the upper right corner:
To display only the subjects for a particular site, select the site from the dropdown list. Click Include deleted subjects at the bottom of the dropdown menu to display deleted subjects:
Each card provides subject information as per the respective study design:
If all the forms were locked (typically by the Monitor), this is shown with a padlock icon on the respective subject card:
Note! The Selection page does not consider the role visibility except for task count; therefore, the subject status reflects the general status of the subject in the study, regardless of the user who has work to be performed. The subject details view reflects the subject status considering the role visibility. This could result in a subject status where a subject could have a green check mark or be locked, while in the Selection page it is not (due to some other user role having unfinished work or forms to complete on the respective subject). See Entering and Editing data for more information on the subject details view.
In the Issues view, you can see the existing issues listed in a table:
Click any row to open the form where the issue was raised:
Close the form to go back to the Issues list.
You can filter the Issues list using the dropdown lists in the upper right corner of the page:
In the Viedoc Me account view, you can monitor and follow up on the subjects' expected Viedoc Me event submissions.
For each subject, the following information is listed:
In the Events view, you can see the status of each event for each subject listed in a table.
The first column indicates if there are issues/tasks in any of the subjects' events. If there are both issues and tasks for a subject, then issues [ i ] are shown in the column.
Select any cell to go to the event in the Details page:
Click back in the browser to return to the Events view.
Select an empty cell to view the subject's latest event.
The list of subjects can be filtered using the dropdown lists in the upper right corner of the page:
Note! On the selection page, in the Events view, the event name (as set in the Study event settings in the study design) is displayed. If there is a recurring event, a counter is shown under the event name, for example: Follow up 1, Follow up 2.
To add a new subject:
| 1 |
Make sure that you have selected a site (center) from the sites dropdown list.
|
| 2 |
Complete the form and select Save changes on the top right side of the page. A new subject is now added. |
Note! Only user roles with editing permissions for the study start event form can add a new subject. If you do not have editing permissions, you cannot select Add new card and no icon is visible in the top right side of the page.
See also the video tutorial Add and select subjects.
If you receive the following message, the maximum number of subjects that is configured for your site has been reached, and you cannot add new subjects. If you need to add a new subject anyway, contact your Study Manager.
A query is a question about data. In Viedoc, queries can be raised:
Note! All the related queries are automatically closed, when:
In case of a validation query, when this is resolved by data edit, it is automatically closed. See Validation queries.
Resolving a query always breaks the form signature, even if there are no data changes involved.
A summary of the number of queries is displayed on the study start page, as illustrated below.
Note! This is a summary of the whole study and it does not take into consideration the role visibility conditions.
A query is raised in a form field. After a query is raised, the respective form is marked with the red issue icon i:
| Important! For all new studies started after release 4.80, the default setting Enable role-based queries is selected. For studies started before release 4.80, the default setting Enable role-based queries is cleared. For studies started before Viedoc release 4.80, all query actions will still work as usual until role-based queries is enabled. |
When the role-based queries option is enabled for your study, it restricts, at study level, the approval of the query resolution to the same user role who raised the query.
Notes!
For more information, see the eLearning lesson on Role-based queries.
Viedoc Clinic users with permission to raise queries/pre-queries, can manually add a query to any field value.
Manually raised queries can be:
Viedoc offers support for query review, that is, to review a query before it is released to the site. This is done through pre-queries.
The pre-query process can involve either two or three roles, as follows:
An unlimited number of pre-queries can be added on the same field at the same time.
The following image illustrates the main actions that can be performed on a pre-query and all the states the pre-query goes through before it is released as a query:
1. The pre-query is added by the user with permission to add pre-queries, typically the Data Manager.
As a result, a pre-query is raised, becoming visible for the Viedoc Clinic user with permission to promote pre-queries, typically the Monitor.
2. The raised pre-query can be removed, for example if it is invalid or added by mistake.
3. The raised pre-query is promoted or rejected by the Viedoc Clinic user with permission to promote pre-queries, typically the Monitor.
4. The promoted pre-query is released by the Viedoc Clinic user with permission to add queries (typically the Monitor), becoming a raised query that is visible for the Viedoc Clinic user with permission to add/update query answers (typically the Investigator), who will be responsible for resolving the query, as described in Queries.
The table below summarizes the different states of a pre-query in Viedoc Clinic, in the export output (Excel/Operational Data Model (ODM), as well as the possible actions that can be performed on a pre-query and the state this will transition to.
| In Viedoc Clinic | In export output | through... | becomes... |
|---|---|---|---|
| Awaits promotion | PrequeryRaised | Promote pre-query (by Monitor) | PrequeryPromoted (Ready for release) |
| Reject pre-query (by Monitor) | PrequeryRejected (Rejected) | ||
| Ready for release | PrequeryPromoted | Release pre-query (by Monitor) | QueryRaised (Awaits answer) |
| Reject pre-query (by Monitor) | PrequeryRejected (Rejected) | ||
| Rejected | PrequeryRejected | N/A. No action can be performed on a rejected pre-query. | N/A. Final state |
| Removed | PrequeryRemoved | N/A. No action can be performed on a removed pre-query. | N/A. Final state |
The query process involves two different roles with different permissions in handling queries:
A query is raised in Viedoc either when a query is manually added or when a pre-query is released.
An unlimited number of queries can be added on the same item at the same time.
The following image illustrates the main actions that can be performed on a query and all the states it goes through:
1. A query is raised through one of the following:
2. A raised query can be removed, for example if it is invalid or added by mistake.
3.a. The user with permission to add/update subject/event/form data and query answers, typically the Investigator, resolves the query by one of the following:
3.b. When confirming data as missing, typically by the Investigator, this becomes a resolved query that awaits approval. This type of query can only be approved at step 4 below.
4. The user with permission to add/change queries can:
See also Query states.
The following image illustrates the main actions that can be performed on a validation query and all the states it goes through:
1. A query is raised as a result of a validation performed by the system.
2. The user with permission to add/update subject/event/form data and query answers, typically the Investigator, resolves the query by one of the following:
3. The user with permission to add/change queries can:
See also Query states.
The table below summarizes the different states of a query in Viedoc Clinic, in the export output (Excel/ODM, as well as the possible actions that can be performed on a query and the state this will transition to.
Note! All the related queries are automatically closed, when:
| In Viedoc Clinic | In export output | Through... | Becomes... |
|---|---|---|---|
| Awaits answer | QueryRaised | Remove query (by Monitor) | QueryRemoved (Removed) |
| Edit query (by Monitor) | QueryRaised (Awaits answer) | ||
| Resolve query (by Investigator) | QueryResolved (Awaits approval) | ||
| Awaits approval | QueryResolved | Approve query (by Monitor) | QueryApproved (Approved) |
| Reject query (by Monitor) | QueryRejected (Rejected) | ||
| Rejected | QueryRejected | N/A. No action can be performed on a rejected query. Note! When a query is rejected, this is regarded as a final state for the original query and a new query is raised again automatically by the system. |
N/A. Final state |
| Approved | QueryApproved | N/A. No action can be performed on an approved query. | N/A. Final state |
| Closed | QueryClosed | N/A. No action can be performed on a closed query. | N/A. Final state |
| Removed | QueryRemoved | N/A. No action can be performed on a removed query. | N/A. Final state |
In order to include the query information in the exported file, you need to select Queries under the Type of data in the Data export page. When selecting to include Queries, the Query history option becomes available.
The queries can be exported to the following export output formats:
For more details and instructions on how to perform an export, see Exporting data.
For details on how queries look in the ODM export see Queries in ODM export.
For details on how queries look in the Excel/CSV exported file see Queries in Excel export.
For an overview of the entire query process see Queries overview.
To be able to raise a pre-query you must have the permission to add pre-queries, typically the Data Manager (DM).
To add a pre-query:
| 1 | Open the form that contains the field the pre-query will be raised on. |
| 2 | Click the + icon in the top-right corner of the group that contains the respective field. The Add new action pop-up is displayed:
|
| 3 |
Click Ready. The pre-query is created and needs to be promoted and released by the user with permission to promote pre-queries (typically the Monitor), in order to be visible as a query for the site staff. A Removed state is a final state for a pre-query. |
A pre-query is always marked by this icon:
Once a pre-query has been promoted and released, it becomes a query and it is marked by this icon:
To be able to promote/reject a pre-query you must have the permission to promote pre-queries, typically the Monitor.
If there are any pre-queries that await promotion, these are marked as tasks. For details about tasks, see Issues and tasks.
To promote a pre-query:
| 1 |
Browse to the task and open the respective pre-query that is marked with state Awaits promotion. A pop-up is displayed where you can either Promote or Reject the pre-query: 
|
| 2 |
|
A pre-query can be released after it has been promoted, that is, a pre-query in Ready for release state.
A pre-query waiting to be released is marked as a task. For details about tasks, see Issues and tasks.
After releasing a pre-query, this will become a raised query visible to the site staff. This is why, releasing a pre-query can be performed by a user with permission to add queries.
To release a pre-query:
| 1 | Browse to the task and open the pre-query that is Ready for release. A pop-up is displayed where you can either Release or Reject the pre-query: |
| 2 |
Note! When role-based queries is enabled for your study, when a pre-query is released, (typically by the Monitor):
For more information on pre-queries, see Queries overview. |
For an overview of the entire query process see Queries overview.
A query can be added/edited/removed/approved by the user with permission to add/change queries.
Note! When the role-based queries option is enabled for your study, all of the above actions are restricted to the same role as the role who raised the query. For more information, see Role-based queries.
To raise a query:
| 1 | Open the form that contains the field the query will be raised on. |
| 2 | Click the + icon in the top-right corner of the group that contains the respective field. The Add new action pop-up is displayed.
|
| 3 |
Click Ready. The query was raised and it is now visible for the site and ready to be resolved, with state Awaits answer: 
|
After the query has been raised it can be:
The text of a raised query can be edited as long as the query was not resolved (Awaits answer).
To edit a query:
| 1 |
Open the query (from the respective form) and click Edit: 
Note! The avatar icon and the user role who raised the query is only visible if role-based queries is enabled for the study. For more information, see Role-based queries. |
| 2 |
Edit the text and click Save query: The query text is now updated. |
A query can be removed, for example if invalid or added by mistake, as long as the query was not resolved (Awaits answer).
To remove a query:
| 1 |
Open the query (from the respective form) and click Remove: 
Note! The avatar icon and the user role who raised the query is only visible if role-based queries is enabled for the study. For more information, see Role-based queries. |
| 2 |
Click Save query to confirm: 
The query state is Removed. This is a final state for a query. |
After the query was resolved by the site (typically the Investigator), it is marked as a task, it is in Awaits approval state and can be either approved or rejected.
Note! An exception is a query raised as a result of confirming data as missing by the site user. This type of query can only be approved.
To approve a query:
| 1 | Open the query. The query pop-up opens displaying the list of the query history: |
| 2 |
Select Approve and click Save query: The query is now Approved. This is a final state for a query: 
|
To reject a query:
| 1 |
Open the query. The query pop-up opens displaying the list of the query history: 
Note! The avatar icon and the user role who raised the query is only visible if role-based queries is enabled for the study. For more information, see Role-based queries. |
| 2 |
Select Reject, optionally rephrase the query and click Save query: 
The old query is closed with state Rejected and a new query is raised that Awaits answer: 
|
The Data Export page can be accessed by selecting the Data Export icon in the study start page:
The Data Export page enables you to preview and download study data:
You can filter the data that you want to preview/export, as described in the following sections.
If you have access to multiple sites, you can filter the data for a specific country or site.
To filter data for a specific country, select the name of the country. The selected country appears in blue letters besides the Data Export header, while the site(s) for the selected country are listed below:
For a specific country, you can choose to export the data for:
To undo the selection of the site, select All sites.
To undo the selection of a country, select the cross x icon beside the name of that country.
While filtering for country or site, the number of subjects depicted in between brackets in the Subjects to include field is updated accordingly.
You can choose to include all subjects in the data preview or export, or include a selection of subjects.
To select which subjects to include:
| 1 | Select Include single subject(s). |
| 2 |
Select the Repeat this step for each subject you want to include in the data preview/export. |
To undo the selection of certain subjects, select the - icon, or select the cross x icon next to the subject ID:
You can choose to include all the data or only for certain events. You can also filter the data added or edited during a certain time period.
Note! The available events are the ones existing in the latest design version applied on the first of the selected sites to be included in the export. If there are multiple design versions running for different of the selected sites, you have to select one site at a time in order to get the available events for the respective site.
You can choose to:
To select which events to include:
| 1 | Select Single event(s). |
| 2 |
Select the |
To undo the selection of certain events, select the - icon, or select the cross x icon next to the event:
To include data from a specific time period:
| 1 | Select the Time period checkbox: |
| 2 | Select one of the following options from the first drop-down list:
|
| 3 | Select whether to define the time period until a certain date, from a certain date, or between two dates. |
| 4 | Select the date(s). |
Tip! Filtering for data that were added or edited since a specific date is especially useful if you want to see all new and changed data since for example your last monitoring visit.
To undo the selection of a certain time period, select the cross x icon next to it:
You can choose which forms and items to be included in the export output:
Note! Only data belonging to forms and items that exist in the latest effective design applied to the first of the selected sites will be included in the export. Also note that the forms and fields available to choose from are determined by the visibility settings for your user role.
To include data from specific form(s):
| 1 | Select Include single forms and items. |
| 2 | Select the forms and items to be included, in one of the following ways:
|
To undo the selection of a certain form, select the cross x icon next to it:
You can filter the data to be included in the export by the review status, as follows:
You can select to include additional information, depending on the export output format, as described in the following sections.
For PMS studies, there is an option to include booklet status and booklet status history in the export.
When selecting to include Booklet status, the Booklet status history option becomes available.
Depending on if the booklet status is included in the export or not, the export contains the following information:
Booklets in submitted status are not included in exports triggered by users on the sponsor side. The booklets are included to those users when they are received.
Note! Clinic actions to submit/recall back and forth are not available on the sponsor side. Only the latest submit of the booklet that was received by the sponsor is included.
If the Booklet Status is selected and the following options: Require Responsible Investigator for booklet submission, and Require Contract for booklet submission, are enabled for the study, two columns are added to the export.
If Booklet history is selected at export, the historically selected Contract and Responsible Investigator are included in the respective booklet status. The most recent contract information shall be shown, regardless of the booklet status.
Note! If the contract linked to a booklet is edited, the contract information is updated in the existing row for that booklet in the export performed after the information was updated.
The booklet status can be exported to the following export output formats:
When selecting to include Booklet status in the Excel export, a separate Booklet status sheet is created that lists all the forms with the following information:
| Column name | Description |
|---|---|
| Site sequence number | A counter that identifies the site globally within the study |
| Site name | The site name, as set in Viedoc Admin |
| Site code | The site code, as set in Viedoc Admin |
| Subject sequence number | A counter that identifies the subject within the site |
| Subject Id | The Subject ID, in the format configured in Viedoc Designer. The Subject ID is the subject identifier displayed in Viedoc Clinic on the subject card, subject details page, and so on. |
| Booklet sequence number | A counter that identifies the booklet within the sequence of booklets for the same subject |
| Booklet Id | The booklet ID, as set in the study design (in Viedoc Designer) |
| Booklet name | The booklet name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic |
| Booklet status | One of Not initiated, Initiated, Submitted, Received, Returned, or Frozen |
| Booklet activity | Initiated, Submitted, Recalled, Received, Frozen, Unfrozen, or Returned |
| Date & time (UTC) | The date and time of the status change |
| User name (ID) | The name (ID) of the user who changed the booklet status |
| Contract number | The number of the selected contract for the specific booklet. Note! This column is present in the export only if the option to link the booklet to a contract is enabled for the study. |
| Responsible Investigator | User name (internal userID ) of the user selected as Responsible Investigator for the specific booklet. Note! This column is present in the export only if the option to link the booklet to a contract is enabled for the study. |
When selecting to include Queries, the Query history option becomes available.
The Queries can be exported to the following export output formats:
See also:
The review status can be exported to the following export output formats:
See also:
The event dates can be exported to the following export output formats:
When selecting to include Event dates in the Excel export, a separate Event dates sheet is created that lists all the events with the following information:
| Column name | Description |
|---|---|
| Site sequence number | A counter that identifies the site globally within the study |
| Site name | The site name, as set in Viedoc Admin |
| Site code | The site code, as set in Viedoc Admin |
| Subject sequence number | A counter that identifies the subject within the site |
| Subject Id | The Subject ID, in the format configured in Viedoc Designer. The Subject ID is the subject identifier displayed in Viedoc Clinic on the subject card, subject details page, and so on. |
| Event Id | The event ID, as set in the study design (in Viedoc Designer) |
| Event name | The event name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic |
| Event repeat key | For recurring events, the counter that identifies different occurrences of the same event (identified by the Event ID). Available for output versions Viedoc 4.39 and onward. |
| Event status | The current status of the event. It can be one of the following:
|
| Event date | The event date, as set in Viedoc Clinic when the event is initiated |
| Planned date | The event planned date, as set in Viedoc Clinic when the event is planned |
| Proposed date | The proposed date for the event, if set in the study design |
| Window start date | The event time window start date, if set in the study design. |
| Window end date | The event time window end date, if set in the study design |
| Initiated by | The name and ID of the user who initiated the event |
| Initiated date (UTC) | The date and time (UTC) when the event was initiated |
| Last edited by | The name and ID of the user who last edited the event |
| Last edited date (UTC) | The date and time (UTC) when the event was last edited |
| Design version | The design version/revision that is active for the event |
When selecting the Uploaded files option, the uploaded file together with the thumbnail (if it exists) are part of the Excel, CSV and PDF export output:
The folder structure obtained when you unzip the file is as follows:
|
- SponsorCode_YYYYMMDD_HHmmss (date and time in UTC format) - FileData - StudySite (SiteCode) - SubjectKey - StudyEventOID - EventRepeatKey - ActivityOID - ActivityRepeatKey - FormOID - FormRepeatKey (if any) - ItemGroupOID - ItemGroupRepeatKey (if any) - ItemDefOID - FileName.extension (original filename) - FileName_tn.extension (thumbnail filename) |
The export output (Excel, PDF, CSV, ODM) as well as the Data preview provides the following information about uploaded files:
The following information on the uploaded file is available in the full history:
The pending forms can be exported to the following export output formats:
Forms are considered pending when they are uninitiated in initiated events. This applies to all types of events, including subject-initiated events. For repeating forms, if the first instance of the form is uninitiated, the form is considered pending. Resetting a form results in that form being pending.
When selecting to include Pending forms in the Excel export, a separate Pending forms sheet is created that lists all the forms with the following information:
| Column name | Description |
|---|---|
| Site sequence number | A counter that identifies the site globally within the study |
| Site name | The site name, as set in Viedoc Admin |
| Site code | The site code, as set in Viedoc Admin |
| Subject sequence number | A counter that identifies the subject within the site |
| Subject Id | The Subject ID, in the format configured in Viedoc Designer. The Subject ID is the subject identifier displayed in Viedoc Clinic on the subject card, subject details page, and so on. |
| Event sequence number | A counter that identifies the event within the sequence of events for the same subject |
| Event Id | The event ID, as set in the study design (in Viedoc Designer) |
| Event name | The event name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic |
| Event repeat key | For recurring events, the counter that identifies different occurrences of the same event (identified by the Event ID). Available for output versions Viedoc 4.39 and onward. |
| Activity Id | The activity ID, as set in the study design (in Viedoc Designer) |
| Activity name | The activity name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic |
| Form Id | The form ID, as set in the study design (in Viedoc Designer) |
| Form name | The form name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic |
| Event date | The event date, as set in Viedoc Clinic when the event is initiated |
| Pending since |
The date and time since when the form has been pending This is not always the date when the event was initiated. For a form that has been hidden due to a visibility condition, the pending since date is the date when the form is made available. |
The medical coding can be exported to the following export output formats:
The edit status can be exported to the following export output formats:
The subject status can be exported to the following export output formats:
The sheet Calculated subject status contains the following columns:
Select the export output format of the data under Output format > Output to:
You can export the data to one of the following formats:
1. Microsoft Excel - Office Open XML
2. CSV
3. PDF - PDF/A
4. ODM
Viedoc uses Microsoft Excel Open XML format which is compatible with Excel version 2007 and later.
For details about the Excel export options and the format/structure of the output file, see Excel export.
The output of the CSV export is similar to the Excel export output. The CSV export output consists of a zip archive containing one CSV file that corresponds to each sheet from the Excel export. For details about the Excel export options and the format/structure of the output file, see Excel export.
For the CSV export and one row per activity selected layout, there is also the option to Include corresponding SAS script. For details, see Exporting for SAS.
Notes! The export to CSV fails if the same OID was used in Viedoc Designer in different design versions withdifferent casing (for example, an OID defi ned as AE in design version 1 and AE in design version 2).
Labels are truncated to 200 characters when CSV data is imported to SAS using the CSV2SAS macro.
The Excel/CSV export does not include items set to “Hide Always" in visibility conditions when a singleform is selected for export.
For details about the PDF export and the format/structure of the output file, see PDF export output.
The Clinical Data Interchange Standards Consortium (CDISC) Operational Data Model (ODM) is a vendor neutral, platform independent format for interchange and archive of clinical trials data. The format includes the clinical data along with its associated metadata, administrative data, reference data and audit information. All of the information that needs to be shared among different software systems during the setup, operation, analysis, submission or for long-term retention as part of an archive is included in the model.
This is used for exporting the data to an ODM file, with or without Viedoc extensions. To include the Viedoc extensions in the exported file, select the Include extensions checkbox. Viedoc extensions are Viedoc-specific settings that cannot be described as part of the CDISC standards. If the exported file is to be imported to Viedoc at a future time, the checkbox should be selected.
Select SAS compliant XML to automatically populate the SAS field name and the SAS dataset name.
The ODM export file is built up as follows:
Study tag contains the information on the study settings, study design, workflow.AdminData contains data about the user and site settings.ClinicalData tag contains the data that was filled in in Viedoc Clinic.Association tag contains information about the performed actions such as SDV, raising and approving queries, medical coding, lock, CRA and DM reviews.See also:
It is possible to select the Viedoc version that the exported file should be compatible with. This option enables you to export files that have the same format as files exported from previous Viedoc versions.
Note! This functionality is optional and set in the study settings in Viedoc Admin. It might not be activated for your study.
If activated for your study, you can select the Viedoc version that you wish the exported file to be compatible with under Output format and export, from the Output version drop-down menu. If you wish to create an export file according to the latest Viedoc version, select Latest Viedoc version:
The Viedoc version used for data export is listed in the Latest exports area on the right side of the export page.
The exported file contains information about which Viedoc version was used to create it. You can find information about the Viedoc version in the following places:
The Viedoc versions available in the Output version dropdown menu are only those versions in which changes to the data structure were introduced.
As of Viedoc release 4.79, the following output versions are available:
| Output version | Changes in data structure |
|---|---|
| Latest Viedoc version | When choosing Latest Viedoc version, the exported data will automatically follow the structure of the latest Viedoc release in which changes to the data structure were introduced. |
| Viedoc 4.79 | Introduction of a number of changes to the ODM data export. See the table below for details. |
| Viedoc 4.77 | For studies where item-level SDV is enabled, when exporting review status, the SDV sheet in the CSV and Excel data exports will include only the items that require SDV and are visible to the user. On the Review status sheet, items that do not require SDV are indicated with N/A. |
| Viedoc 4.68 |
Introduction of pdf archive export system check which splits the archive into one pdf file per subject and stores resultant PDF in a zip file. |
| Viedoc 4.67 | Introduction of two new columns for approving medical coding: "approved by" and "approved on date". |
| Viedoc 4.51 | Introduction of three new form repeat keys and the table of contents in the PDF export, see the table below for details |
| Viedoc 4.39 | Introduction of repeating forms and recurring events, see the table below for details. |
| Viedoc 4.38 | Original output format (Viedoc versions 4.38 or older). |
In Viedoc 4.79, the following changes to the export output were introduced:
| File type | Changes in the export output format |
|---|---|
| ODM |
Introduction of support for partial datetime, date, and time. This is now the default type when exporting designs and data in ODM format. Partial dates as per the ISO 6801 standard are written up to the most detailed value available. This makes the export compliant with CDISC ODM. |
| ODM |
When exporting a design to ODM, multi-selection code lists are handled as follows: Checkbox item definitions are split by code list items.
For example, when splitting a checkbox ItemDef with OID="CHK" and code list IDs "Yes" and "No", the split checkbox ItemDefs will have the OIDs "__CHK__Yes" and "__CHK__No", respectively. That is, the original OIDs and the code list IDs are prefixed with two underscore characters and separated by two underscore characters. In Viedoc Designer, checkbox items are exported as multiple ItemDefs - one for each selection value. In Viedoc Clinic and the Viedoc API: In the latest export version, checkboxes are exported as separate items for metadata and clinical data. In previous export versions, checkboxes are exported as one item. This has been introduced to be compliant with CDISC ODM. |
| ODM |
Bug fix: In the ODM data export, the content of the Question element for study event items and booklet forms was not complete. According to the CDISC standard, the element should include one of the TranslatedText attributes. This is now solved, and the Question element is populated with a string related to the corresponding OID. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, the MeasuremetUnit.Name contained HTML code, making it non-compliant with the CDISC standard. This is now solved, and the HTML code is removed from the name. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, the translated text was missing for meta.Protocol.Description.TranslatedText. This is now solved, and the body is populated with the protocol name, as visible on the design overview page. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, the Length attribute was incorrect, making it non-compliant with the CDISC standard. This is now solved, and Length is populated as per the ItemDef data type. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, there was a mismatch between the item data type and the code list data type for checkboxes. This is now solved, and the checkbox data is split into different items, in the same way as for CSV and Excel exports. This is implemented in a new export version, version 4.79. |
| ODM |
Bug fix: In the ODM data export, the study OID and ClinicalData didn't respect the Production/Demo mode for sites. This is now solved, and the study OID and ClinicalData are populated based on the Production/Demo mode of the exported study. This is applied without a new export version. |
| ODM |
Bug fix: In the ODM data export, non-repeating forms included a repeat key, making the ODM data export non-compliant with the CDISC standard. This is now solved. This is implemented in a new export version, version 4.79. |
| ODM |
Bug fix: In the ODM data export, the KeySet elements had an unregistered value for the ItemOID attribute, making the ODM data export non-compliant with the CDISC standard. This is now solved, and the KeySet elements reference items within the same MetaDataVersion. This is implemented in a new export version, version 4.79. |
| ODM |
Bug fix: In the ODM data export, the attribute OrderNumber of the element StudyEventRef was not valid with respect to its type, integer. This is now solved, and StudyEventRef elements have unique and non-empty consecutive order numbers. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, there was a data type mismatch between CodeList and ItemDef, making the ODM data export non-compliant with the CDISC standard. This is now solved by always having a matching data type between ItemDef and CodeList. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, the element MeasurementUnitRef had an unregistered value for the MeasurementUnitOID attribute, making the ODM data export non-compliant with the CDISC standard. This is now solved, and measurement units not referenced in any MetaDataVersion are not included in the ODM data export. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, the Alias names were not correctly populated. This is now solved, and any code list item aliases with empty names are removed at import and export - and the Alias names are populated with the context values. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, the SAS field name and the SAS dataset name were not populated. This is now solved, and the SAS field name is populated based on the ItemDef OID, and the SAS dataset name is populated based on the FormDefOID, which means that the OIDs are SAS-compliant. There is an option for this in the data export. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, revisions linked to study events and revisions linked to forms requiring approval of the new design revision were not included. This is now solved. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, alerts had repeating order numbers. This is now solved, and the order numbers for all study settings alerts in Viedoc Designer are removed. This is applied to all export versions. |
| ODM |
Bug fix: In the ODM data export, the item group containing the reference data items was not added to the MetaDataVersion. This is now solved. This is applied to all export versions. |
In Viedoc 4.51, the following changes to the export output were introduced:
| File type | Changes in the export output format |
|---|---|
| Excel | Addition of three columns for the new form sequence numbers introduced:
|
| ODM | Three new form sequence numbers were introduced, as Viedoc extensions: v4:SubjectFormSeqNo, v4:OriginSubjectFormSeqNo and v4:SourceSubjectFormSeqNo, within the FormData, right after the FormRepeatKey. |
| A table of contents was added to the PDF archive, starting on page 2 of the file. |
In Viedoc 4.39, the following changes to the export output were introduced:
| File type | Changes in the export output format |
| Excel | Addition of a column for Form sequence number (FormSeq) that contains the FormRepeatKey. |
| ODM | The FormRepeatKey now contains the activity ID as well, in the following format: FormRepeatKey$ActivityId. The ExportVersion attribute has been added to the ODM. |
| The summary formats are used to display the event and form names. |
When exporting data from Viedoc, the system determines the available events, forms, and data points based on the study design version applied to the first selected site. Understanding how this works is important when a study includes sites with different study designs or multiple design versions.
What happens when study designs differ?
If a study contains multiple study designs or different versions across sites, the exported data is structured based on the design of the first selected site. This means:
What does "first selected site" mean?
The first selected site is the first site in the study that is chosen for export. The exact determination depends on:
Example: If a study has sites in Germany, Sweden, United States, and Japan, and Germany is the first selected site, the export will be based on the latest design version applied to the first site in Germany.
Selecting multiple sites with different study designs
If multiple sites are selected and they have different design versions, users must:
Best practices to ensure accurate exports:
Note! User visibility settings affect data exports. If an item is missing, check that your user role has the necessary permissions, and that the item exists in the latest design version applied to the first selected site.
Example scenario: How study design affects data export
Scenario: A study has Site A using Design Version 1.0, and Site B using Design Version 2.0. When exporting data:
The Preview data button is only available when you have selected Excel or CSV as output format for the export.
The preview is not available when you have selected 1 row per item.
On the data tab, you can preview the data in table format:
1. If you have selected Group data by form, you can select the form for which you want to display data.
2. Use the Filter text box to filter the preview data by any text in any field. The preview is filtered on all words in this field.
3. Toggle between spacious view and compact view.
4. Select a column header to sort the data in ascending order. Select again to sort in descending order. Selecting a third time removes the column sort order. To rearrange the order of the columns in the table, simply select a column header and drag the column sideways.
5. Select to open the column menu. For more information, see Column menu.
6. Select to access the column filter. For more information, see Column filter.
7. Select any hyperlink data point in the table to view the underlying form in read-only mode.
8. Select Cross-check to display a second data table. This lets you cross-check data between the two tables. Form selection and the filtering and sorting of data in the second table are independent of the settings in the first table.
The column menu contains:
|
 |
|
 |
|
 |
For more information, see the following sub-sections.
Pin Left/Right makes a column remain visible in the leftmost or rightmost position when you scroll sideways. Select No Pin to unpin the column.
Autosize adjusts the column width to the width of the text in the column.
Reset Columns resets the pinning, sizing, and order of columns to the initial state.
Use the column filters to narrow down the selection of preview data.
1. Depending on the type of item in the column, you can specify one of these types of filters:
Form items that are radio buttons, drop-down menus, checkboxes, dates, or date/time items are treated as text.
Note! The text filters are case-insensitive.
2. Once you have specified a filter, you can specify another one for the same column, either as an AND filter or an OR filter.
3. Predefined filter options based on the data available in the column.
Select the columns to be displayed in the preview table.
Use the Search field to search for columns.
By default, system data is excluded from the table. To include system data, select the column(s) to include from the System data category. Note that some system data columns are only available when you have selected 1 row per activity. For more information, see Excel export.
When you right-click in a cell in the data table, this context menu is displayed:
Copy: Copies the cell value to your clipboard.
Copy with Headers: Copies the cell value and its column header to your clipboard.
Excel Export: Exports the preview data on the data tab. The resulting Excel file will have the same sorting and filtering of data and order of columns as the preview.
Select the data set you wish to plot in a chart, and select Draw:
If you have selected Group data by form, you can only choose data sets from the form you have selected on the data table tab.
Select any data point to view its details.
Note! The pie chart has access to the same data as the data tab. That means that if you applied filters on the data tab, only the filtered data will be available in the pie chart.
Select which data you would like to plot on the X-axis and Y-axis, which series should be created, and select Draw:
If you have selected Group data by form, you can only choose data sets from the form you have selected on the data table tab.
Select any column to view details of the data.
Note! The column chart has access to the same data as the data tab. That means that if you applied filters on the data tab, only the filtered data will be available in the column chart.
Select which data you would like to plot on the X-axis and Y-axis, which series should be created, and select Draw:
If you have selected Group data by form, you can only choose data sets from the form you have selected on the data table tab.
Note! The line chart has access to the same data as the data tab. That means that if you applied filters on the data tab, only the filtered data will be available in the line chart.
When you have made settings for an export, you can save them as a template. Then you, and optionally others, can use the template to easily make new exports with the same settings.
To save your settings as a template:
| 1 |
Select Save settings as a new export template. 
|
| 2 |
In the pop-up that is displayed, enter a name for the template and select whether it should be private or shared. If you select Shared, you are prompted to also select the roles that will be able to use the template. The roles available in the drop-down list are the ones with export permissions for the latest effective design of the study in question. 
|
| 3 |
Select Save. Now the Export templates list is displayed, with your newly created template at the top of the list: 
|
To apply a data export template:
| 1 |
Select View all templates in the Export templates area of the Data export page. 
|
| 2 |
Select the apply icon for the template that you want to apply. 
|
| 3 | Select Export data to perform an export with the settings in the template. |
Tip! Alternatively, you can use the quick access apply, available in the Export templates area:
To edit a data export template:
| 1 |
Select View all templates in the Export templates area of the Data export page.
|
| 2 |
The Export templates list is displayed. Select the edit icon for the template that you want to edit. 
|
| 3 |
In the pop-up that is displayed, you can edit the name of the export template and the settings for Private/Shared. Note! You can only edit a template that you created yourself. |
To delete a data export template:
| 1 |
Select View all templates in the Export templates area of the Data export page.
|
| 2 |
The Export templates list is displayed. Select the trash can icon for the template that you want to delete. 
|
| 3 |
In the pop-up that is displayed, select Delete. 
Note: You can only delete a data export template that you created yourself. |
To perform a data export:
| 1 | Filter the data to be exported. See Filtering the data to be exported. |
| 2 | Select the Output format. |
| 3 | Optionally, select the Output version. |
| 4 | Optionally, preview the data to be exported. |
| 5 |
Select Export data. The status of the export is displayed in the Latest exports area, on the top of the list. When the export is completed, you can download the exported file: The exported file is downloaded locally. The filename is generated as follows: SponsorCode_CountryCode_SiteCode_Date_Time, where:
Note! If any of the characters that are invalid for a filename in Windows are used within any of the SponsorCode or SiteCode, these characters will be automatically replaced with - within the exported filename. |
You can see a log of the requested exports in the Latest exports area, where you can download the exported files or delete the logs.
Note! The list of the latest exports is user-specific, that is, you can only see the exports made by yourself.
The latest five exports are shown in the list. To get the complete list of the initiated exports, select the View all exports link at the bottom of the list.
Each log entry provides the following information:
1. The date and time when the export was initiated.
2. The export status:
3. Viedoc output version - see Output versions.
4. The number of exported subjects.
5. The format of the output file.
6. The selected layout, if applicable.
7. File size
Note! If data has been masked after an export was made, it is not possible to download that export because it could include the data that was later masked.
The following are some frequently asked questions and answers about exporting data in Viedoc:
Q: How do I export the audit trail (history)?
A: Any PDF data export will include the audit trail (history) by default. You can also get an Excel or CSV version by changing the layout to one row per item and including the history. See the Include history section in the Excel Export lesson for more information.
Q: Is there a size limit to exports?
A: No, there are no size limits to exports.
Q: Can I schedule exports automatically?
A: Yes, you can configure customized automatic exports using Viedoc's web API. Please see the Exporting data via Viedoc's web API for more information.
Q: How is missing data handled?
A: Viedoc's approach to missing data is to leave it blank. The system does not use "N/A" or "missing." Both unconfirmed and confirmed missing data are included when exporting queries and query history.
Q: Why does the export seem stuck at a certain percent?
A. Sometimes exports (especially PDF exports of large studies) can take a take a longer time to complete and appear "stuck". If you log out, the export will continue in the background. Please do not make multiple requests for the same export. If the export fails with an error message, please contact Viedoc for assistance.
Viedoc uses Microsoft Excel Open Extensible Markup Language (XML) format which is compatible with Excel version 2007 and later.
When selecting Microsoft Excel as Output format in the Data export page, you have different options for grouping data and for the layout, as described in the following sections.
For general information about data export in Viedoc, see Exporting data.
Note! Since the maximum number of rows supported for Excel is 1048576, in case data in a sheet exceeds this number, data will be split into multiple sheets.
The Excel export contains the following sheets:
Note! If the Output IDs (OID) and Output labels have been defined in the study design, these are shown in the Excel/CSV/SAS export. If the Output IDs (OID) and Output labels are left undefined (blank) in the study design, then the configured Item ID and label is used. For more information about the item settings in the study design, see Outputs and Validation.
The table below lists which sheets are included in the Excel file, depending on the selected Grouping and Layout:
| Group data by form | Do not group data | |
|---|---|---|
| one row per subject |
|
|
| one row per activity |
|
|
| one row per item |
|
|
The headers are always represented by the first two rows in a sheet, as illustrated in the following image:
1. Human-readable format
2. Machine-readable format
An item that was changed within a new/revised study design version will have a "__n" suffix added, where n is incremented for each study design version where the respective item was changed:
Under Type of data, you can filter the data to be exported. If you filter data for Signed data, Not signed data, SDV performed or NA, or SDV pending, certain cells in the data sheets in the exported Excel file may appear empty. The data rows that contain empty cells due to the filtering are marked by an “X” in the last column of the data sheets that is named Empty cells on row may be due to export filter.
For example, let's say that we have an Add Patient event, and the Date of Birth is one of the data entered during this event. For a particular subject, this data was entered, signed by the Investigator, and afterwards modified, but not signed after the change. We perform an export that includes only the signed data, as illustrated in the image below:
The value of the Date of birth field that was recently changed and not signed is not included in the export (the cell appears empty). The data row containing the empty cell is marked by a "X" the Empty cells on row may be due to export filter, as shown below:
You can select whether the data should be grouped by form or not, from the Data grouping dropdown list.
Note! The data grouping is available only for the Excel/Comma-Separated Values (CSV) output.
When grouping the data by form, a separate sheet is created for each form. The sheet name is the Form ID, as set in the study design (in Viedoc Designer).
In each form sheet, the first columns (to the left) are the same for all the forms and provide information about the site, subject, event, activity and design version:
| Column | Description |
|---|---|
| Site Sequence number | Counter that identifies the site globally within the study. |
| Site name | The site name, as set in Viedoc Admin. |
| Site code | The site code, as set in Viedoc Admin. |
| Subject sequence number | Counter that identifies the subject within the site. |
| Subject Id | The Subject ID, in the format configured in Viedoc Designer. The Subject ID is the subject identifier displayed in Viedoc Clinic on the subject card, subject details page, and so on. |
| Event sequence number | Counter that identifies the event within the sequence of events for the same subject. |
| Event Id | The event ID, as set in the study design (in Viedoc Designer). |
| Event name | The event name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic. |
| Event date | The event date, as set in Viedoc Clinic when the event is initiated. |
| Activity Id | The activity ID, as set in the study design (in Viedoc Designer). |
| Activity name | The activity name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic. |
| Form sequence number |
Counter that identifies the instance of the respective form within the respective activity. This is mostly used for repeating forms. For non-repeating forms, this is "1". If a form is reset and then saved again the new form has sequence number "2", and so on. Form sequence number increases one step every time reset/initiate occurs. |
| Subject form sequence number | Counter that uniquely identifies the instance of a specific form on a subject level, that is, it starts with 1 and it is incremented each time a new instance of the form is created for that subject. |
| Origin Subject form sequence number | For a copied form instance, it identifies the form instance from which data was copied for the first time. For the first instance of the form (that is, not copied) it gets the value of the SubjectFormSeqNo. |
| Source Subject form sequence number | For a copied form instance, a counter that identifies the source of a copied form instance (the form instance the data was copied from). It gets the value of the SubjectFormSeqNo from which the form instance was copied. For the first instance of the form (not copied) it is empty (null). |
| Design version | The design version used at the time of data edit for the respective form. |
The example in the image below shows an export with the default settings for the Layout, that is, 1 row per activity.
The following columns are specific to each form, one column for each item in the respective form. Each column has the <Item name>, as set in the study design (in Viedoc Designer) as column header.
If you choose not to group the data, then all data from all forms will be exported in the same sheet (Data) of the output file.
The example in the image below shows an export with the default settings for the Layout, that is, 1 row per activity.
In the Data sheet, the first columns (to the left, marked in green) are the common for all the forms and provide information about the site, subject, event and activity.
The following columns (to the right, marked in orange) contain form-specific information for all the forms within the event. For each of the forms, the following columns are added:
In the Layout section, you can select whether the data should be organized in the output file as:
The output in this case will look as shown in the below image. The example shows an export performed with all the default settings except for the Layout which is set to 1 row per subject.
There is one sheet for each form, as the default setting is to Group data by form.
There is one row per subject, that is, one row for each SubjectID (that uniquely identifies the subject).
The first columns provide information on the site and subject:
| Column | Description |
|---|---|
| Site name | The site name, as set in Viedoc Admin. |
| Site code | The site code, as set in Viedoc Admin. |
| Subject sequence number | Counter that identifies the subject within the site. |
| Subject Id | The Subject ID, in the format configured in Viedoc Designer. The Subject ID is the subject identifier displayed in Viedoc Clinic on the subject card, subject details page, and so on. |
The following columns are the item-specific values, one set as described below for each item in the exported data. The order of the items is by event, as set in the study workflow.
Note! The columns Event sequence number, Event Id, Activity Id, Form sequence number, Subject form sequence number, Origin Subject form sequence number, and Source Subject form sequence number are not included when you have selected 1 row per subject.
The output in this case will look as shown in the below image. The example shows an export performed with all the default settings except for the Layout which is set to 1 row per activity.
There is one sheet for each form, as the default setting is to Group data by form.
The data is grouped so that, for each subject (1), there is one row for each activity (2).
All checkbox responses for an activity are exported within a single row, with each code list option occupying distinct columns. The items that have a code list assigned are output to an additional row with the ID suffixed with "CD", for the code.
For each code list option, two columns are included: one for the label and one for the code value. Column headers use the item's OID and Export Label, each suffixed with a 1-based index (for example, CHECKBOXOID_LABEL1, CHECKBOXOID_LABEL1CD). Only the selected code list values are populated in the corresponding columns. Unselected options are left empty.
The output in this case will look as shown in the below image. The example shows an export performed with all the default settings except for the Layout which is set to 1 row per item.
There is one sheet for each form, as the default setting is to Group data by form.
The data is grouped so that there is one row for each item (3) within an activity (2) for a subject (1).
The data is sorted by: site, subject, event date, event repeat key, form repeat key, form ID, item group ID, item ID.
If the Include history option is selected (see following section), the data is ordered from the oldest to the current item data (that is, by the Edit sequence number).
When selecting 1 row per item, the option to Include history becomes available. If selected, the edit history information (audit trail) will be included in the exported output (that is, the information shown in Viedoc Clinic on form level when selecting Show history).
The following information (columns) is added for each entry in the output file:
The items belonging to a reset or deleted form/event/subject are included as well in the export, together with a full history that gives the reason for resetting or deleting the form/event/subject.
Checkbox items are output as one row per code list item. The items that have a code list assigned are output to an additional row with the ID suffixed with "CD", for the code.
All code list items are included in the output, regardless of whether they were selected or not.
The Item Id column contains the item's Object Identifier (OID) with a 1-based index appended, as illustrated in the following image:
The Item Export Label column similarly includes the Export Label with the same 1-based index.
Two columns are generated per code list item: one for the code label and one for the code value. If a code list value is selected, its corresponding value appears in these columns. Otherwise, they may remain empty.
If the option to Include history is selected, then the code list items are ordered by the time of data entry (that is, by the Edit sequence number).
When reference ranges are used for a laboratory form, the laboratory name and the laboratory code are included and the following two columns are added:
SCOPE_XXX and SCOPE_XXXCD (where XXX is the numeric value)
Form link items can be organized in the Output format as:
Selecting 1 row per activity generates the output as shown in the image below. The exported file contains two columns per linked form instance, the Data column and the Identifier column, (the header is labelled Identifier).
In the example below:
There are also two header rows in the output:
| Header rows, one row per activity | |
|---|---|
| Row 1: Data column | Item Label, Counter of the selected link starting at one |
| Row 1: Identifier column | Item Label, Counter of the selected link starting at one, Identifier |
| Row 2: Data column | Item ID, Counter of the selected link starting at one |
| Row 2: Identifier column | Item ID, Counter of the selected link starting at one, ID |
Selecting 1 row per item generates the output as shown in the image below. The exported file contains two additional columns with the headers Item value and Item code, and one row per linked form instance.
Note! In the export preview the form identifier column is excluded by default. The order the form link item was added (time of data entry) is followed in the export.
Selecting 1 row per subject generates the output as shown in the image below. The exported file adds two columns per linked form instance to the exported file, the Data column and the Identifier column:
There are also two header rows in the output:
| Header rows, one row per subject | |
|---|---|
| Row 1: Data column | Event Label (event counter), Activity label (activity counter), Item label (counter of the selected link.) |
| Row 1: Identifier column | Event Label (event counter), Activity label (activity counter), Item label (counter of the selected link), Identifier |
| Row 2: Data column | Event ID (event counter), Activity ID (activity counter), Item ID (counter of the selected link.) |
| Row 2: Identifier column | Event ID (event counter), Activity ID (activity counter), Item ID, (counter of the selected link), ID |
Recurring events are identified in the export output by the StudyEventRepeatKey.
The image illustrates the form Vital Signs in the Excel export output. The form is used in three events (Visit 1, Visit 2 and Visit 3), of which Visit 3 is a recurring event. The four instances of Visit 3 are identified by the StudyEventRepeatKey that is listed in the Event sequence number (EventSeq) column:
Note! Support for recurring events has been added in Viedoc release 4.39. That means that if you would like to export recurring events, you should select Viedoc version 4.39 or later in the Output version dropdown menu under Output format.
Repeating forms are identified in the export output by the FormRepeatKey.
The image illustrates the repeating form Lab in the export to Excel. The instances of the form are identified by the FormRepeatKey that is listed in the Form sequence number (FormSeq) column:
Note! Support for repeating forms has been added in Viedoc release 4.39. That means that if you would like to export repeating forms, you should select Viedoc version 4.39 or later in the Output version dropdown menu under Output format.
The following form sequence numbers are used to make it easier to track different form instances at subject level, which are useful especially for the form instances initiated by copying the data from previous event.
FormRepeatKey: Counter that identifies the specific instance of a repeating form within a specific activity. This is available in the export output for Viedoc output version 4.39 and onwards.SubjectFormSeqNo: Counter that uniquely identifies the instance of a specific form on a subject level, that is, it starts with 1 and it is incremented each time a new instance of the form is created for that subject. This is available in the export output for Viedoc output version 4.51 and onwards.OriginSubjectFormSeqNo: For a copied form instance, it identifies the form instance from which data was copied for the first time. For the first instance of the form (that is, not copied) it gets the value of the SubjectFormSeqNo. This is available in the export output for Viedoc output version 4.51 and onwards.SourceSubjectFormSeqNo: For a copied form instance, a counter that identifies the source of a copied form instance (the form instance the data was copied from). It gets the value of the SubjectFormSeqNo from which the form instance was copied. For the first instance of the form (that is, not copied) it is empty, that is, null. This is available in the export output for Viedoc output version 4.51 and onwards.The example below illustrates how the values for these sequence numbers are assigned. The demo form used is set as repeatable and copyable and is included in Visit 1, Visit 2 and Visit 3.
We perform the following actions in Viedoc Clinic:
| 1 | Initiate Visit 1 and fill in three instances of the Demo form, these instances will get the sequence numbers as illustrated below: |
| 2 | Initiate Visit 2. Demo form will be available to be initiated by copying data from one of the previously filled-in form instances within Visit 1, so all the three instances will be shown as ghost forms: |
| 3 | Create an instance of Demo form within Visit 2 by copying the data from the third instance of the form filled in within Visit 1. This will result in the new form instance getting the sequence numbers as illustrated below: |
| 4 | Initiate Visit 3. Demo form will be available to be initiated by copying data from one of the previously filled-in form instances within Visit 1 and Visit 2, as below: |
| 5 | Create an instance of Demo form within Visit 3 by copying the data from the form filled in within Visit 2. This will result in the new form instance getting the sequence numbers as illustrated below: |
These sequence numbers are available to be used within expressions only to get the value of the sequence number for a specific form instance, that is, by using {SubjectFormSeqNo}, {OriginFormSeqNo}, {SourceFormSeqNo}.
In the above example, the form Summary format was configured by using these sequence numbers as below:
Form Repeat Key {FormRepeatKey}, SubjectFormSeqNo {SubjectFormSeqNo}, OriginFormSeqNo {OriginFormSeqNo}, SourceFormSeqNo {SourceFormSeqNo}
Notes!
In the excel export output, these form sequence numbers allows to track, for the form instances that were initiated by copying data from previous events, where the data originates from, as below:
Analyzing the values of the form sequence numbers, only the form instances that were initiated by copying the data from previous visits have values populated in the Source Subject form sequence number column, that is, the last two rows in the example. The data was copied from the form instance having the same Subject form sequence number value, highlighted in green in the above image. The form instance that the data was copied for the first time is identified by the value of the Origin Subject form sequence number, that is, "3" in our example.
When choosing PDF as output format, you have the following options:
Notes!
One .zip file is downloaded for each PDF export performed.
This section describes the structure of the exported PDF file.
The file is structured as follows:
1. A study summary on the first page.
2. A site summary page.
3. One separate sub-section for each subject in the respective site.
4. For each subject, one sub-section for each event.
5. For each event, one sub-section for each activity.
6. For each activity, one sub-section for each form. The latest version of the form PDFs are included here. See also Audit trail and Form History section in Entering/editing data.
The meaning of the signature in Viedoc is included on the last page.
Note! If the number of forms for a site exceeds 1000, the system splits the archive into one PDF file per subject and stores them in a zip file.
The first page provides a short summary, as illustrated in the image and explained below:
1. The study logo image, if any, as set in Viedoc Admin, under Study Settings.
2. Study name, as set in Viedoc Admin, under Study Settings.
3. Study description, as set in Viedoc Designer.
4. The dates for:
5. The number of sites:
6. The number of subjects:
The site summary page provides a summary of the site, as illustrated in the image and explained below:
1. The study name, as set in Viedoc Admin.
2. The site name, as set in Viedoc Admin.
3. The site code, as set in Viedoc Admin.
4. The country for the respective site, as set in Viedoc Admin.
5. The site time zone, as set in Viedoc Admin.
6. Date of First Patient Added (FPA) to the site, in the site timezone.
7. Date of Last Patient Added (LPA) to the site, in the site timezone.
8. Number of subjects from the site included in the export / total number of subjects in the site (this number will exclude deleted subjects if Exclude deleted subjects/events/forms is checked).
Following the site summary page, comes a Contents list of the subjects included in the export for the respective site, with the Subject ID and corresponding pages. After that, comes one sub-section for each subject, described in the next topic.
The subject summary page provides the following information:
1. The study name and site name, as set in Viedoc Admin.
2. Subject ID in the format set in Viedoc Designer.
3. The date and time the subject was added.
4. The number of Forms filled in / the total number of forms for that subject.
5. A table of Contents with a list of all the events that contain data for the respective subject, the event status and the page numbers where the data related to the respective event can be found.
The event summary page provides the following information:
1. The study name and site name, as set in Viedoc Admin.
2. Subject ID in the format set in Viedoc Designer and the event name together with the date when it was initiated.
3. A table of Contents with a list of all the forms within the respective event for Scheduled and Unscheduled events, providing the following information:
For Common Events, each entry will have its own Event summary page.
For each form, the form PDF is included, in the same format as for the form history pdf file. For details, see Form history PDF in Entering/editing data.
The forms in the PDF are sorted by these characteristics:
The following example illustrates the sort order.
Suppose the study design looks like this:
For the event E01, all forms belong to the same activity. This means that the order of the forms in the PDF will always be like this:
For the event E02, there are three activities. This means that if any form from A02 gets saved first, then any form from A01 gets saved second, and then any form from A03 gets saved third, the order of the forms will be:
In other words, the order of forms for event E02 for this specific example will be like this:
This lesson describes how the medical coding information is structured within an Excel file exported from Viedoc.
To include the medical coding information in the exported file, you need to select Medical coding under Type of data in the Data Export page:
For general details about data export, see Exporting data.
For medical coding, in the Excel export output file, there is one sheet for each dictionary. Only values that have been coded will be present in the export:
The columns provide information on the item that was coded, followed by the medical coding specific information, as listed in the following table:
| Column name | Description | ||
|---|---|---|---|
| Columns that identify the item | |||
| Site sequence number | A counter that identifies the site globally within the study | ||
| Site name | The site name, as set in Viedoc Admin | ||
| Site code | The site code, as set in Viedoc Admin | ||
| Subject sequence number | A counter that identifies the subject within the site | ||
| Subject Id | The Subject ID, in the format configured in Viedoc Designer. The Subject ID is the subject identifier displayed in Viedoc Clinic on the subject card, subject details page, and so on. | ||
| Event sequence number | A counter that identifies the event within the sequence of events for the same subject | ||
| Event Id | The event ID, as set in the study design (in Viedoc Designer) | ||
| Event name | The event name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic | ||
| Event date | The event date, as set in Viedoc Clinic when the event is initiated | ||
| Activity Id | The activity ID, as set in the study design (in Viedoc Designer) | ||
| Activity name | The activity name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic | ||
| Form Id | The form ID, as set in the study design (in Viedoc Designer) | ||
| Form name | The form name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic | ||
| Form sequence number |
Counter that identifies the instance of the respective form within the respective activity. This is mostly used for repeating forms. For non-repeating forms, this is 1. If a form is reset and then saved again the new form has sequence number 2, and so on. Form sequence number increases one step every time reset/initiate occurs. |
||
| Subject form sequence number | Counter that uniquely identifies the instance of a specific form on a subject level, that is, it starts with 1 and it is incremented each time a new instance of the form is created for that subject. | ||
| Origin Subject form sequence number | For a copied form instance, it identifies the form instance from which data was copied for the first time. For the first instance of the form (that is, not copied) it gets the value of the SubjectFormSeqNo. |
||
| Source Subject form sequence number |
For a copied form instance, a counter that identifies the source of a copied form instance (the form instance the data was copied from). It gets the value of the |
||
| Item Id | The item ID, as set in the study design (in Viedoc Designer) | ||
| Item Name | The item name, as set in the study design (in Viedoc Designer) and displayed in Viedoc Clinic | ||
| Medical coding-specific information | |||
| Term | The coded term | ||
| Dictionary instance | The description of the dictionary instance, as set in Viedoc Admin when uploading the dictionary | ||
| Version | The dictionary version. | ||
| Coding scope description | The coding scope description, as defined in Viedoc Designer | ||
| Coding scope level | The coding scope level, as defined in Viedoc Designer, can be one of the following:
|
||
| Code sequence number | A counter that identifies the code for those values with more than one code | ||
| Dictionary-specific information | |||
|
WHODrug:
|
MedDRA:
|
ATC without DDD:
|
IDF:
|
| Interpretation | The medical coder's interpretation of the applied coding value | ||
| Coded by user | The name of the user who performed the coding, followed by the user ID in parentheses | ||
| Coded on date | The date and time when the coding was performed | ||
| Approved by user | The name and ID of the user who approved the items | ||
| Approved on date (UTC) | The date and time (UTC) when the item was approved | ||
This section illustrates an example of how the data coded using the World Health Organization Drug Dictionary (WHO DD) dictionary looks in the Excel export output.
There are two different use cases, depending on the which level of granularity is selected when applying the code in Viedoc Clinic:
1. Drug (default)
2. Preferred name
The image below illustrates how the coded data looks in the export output, if the Drug is selected when applying the code in Viedoc Clinic.
When Drug is selected, the Preferred code and Preferred name come out in the export as well, in the last columns, as illustrated in the image.
The image below illustrates how the coded data looks in the export output, if the Preferred name is selected when applying the code in Viedoc Clinic.
After the Preferred name is selected and the code is applied, for the respective coded item, the value of the Preferred name ends up in both Drug and Pref fields, in both Viedoc Clinic, as well as in the exported output.
To convert an Anatomic Therapeutic Chemical classification system (ATC) dictionary:
| 1 | Open the xlsx file in Microsoft Excel. |
| 2 | Sort the contents of the file by column A, on cell contents, and in the order A to Z. |
| 3 |
If Defined Daily Dose (DDD) is included in the file (columns C, D, E, and F), delete these columns, as well as the note column if there is one. 
|
| 4 |
Insert a new column B. 
|
| 5 |
In cell B2, write a formula. To add a formula, start by typing an equal sign ( The formula will look different depending on the language of your Excel installation. These are some examples:
Note! Depending on the regional settings in your operating system, you might need to replace the semicolons with commas. 
|
| 6 |
Fill all cells in the B column with the same formula, for example by dragging the small plus sign ( 
|
| 7 |
Remove row 1 (the header row). Do to this, you might first need to turn off the header row on the Table Design page.
|
| 8 |
Select column B and copy it. 
|
| 9 | Paste the copied column into a raw text editor such as Windows Notepad. It is important to use an editor that does not add any formatting. |
| 10 |
In the raw text editor, search for the quotation mark character ( 
|
| 11 |
If there are empty lines at the end of the file, remove them. 
|
| 12 | Save your file with an appropriate filename that reflects the ATC version and with the filename extension asc. |
| 13 | Upload the file to Viedoc according to these instructions: Creating a dictionary instance. |
Viedoc Coder allows you to code data, such as Adverse Events, Medical History, and Concomitant Medications, in a standardized way. You can access Viedoc Coder from the landing page.
The Viedoc Coder page displays metrics about coding, for example, the number and percentage of items that have been coded and approved. There is one set of metrics for each coding scope. The metrics displayed are based on the data and sites that you have permission to view.
Note!
| 1. |
To open Viedoc Coder, select the dictionary icon: 
Viedoc Coder opens in a new window: 
|
| 2. |
Select Open medical coding on a scope: 
Viedoc Coder displays a table that lists all of the items to be coded in the Value column. 
|
In Viedoc Coder, you can:
1. Select the coding scope (the data) to be coded.
2. Select to display items from all countries or from an individual country.
3. Select to display items from all sites or from an individual site.
4. Select to display all uncoded (and rejected) items, all coded items, all approved items, or all items.
5. Perform a text search among all values of the items.
6. If configured for your study, there can be additional columns included with supporting values for the coding, for example route, indication, or other.
7. Find and apply codes (see Finding and applying a medical code).
8. Select here to change the settings of Viedoc, access the help center, or logout of Viedoc.
When applying codes, you can:
See Finding and applying a medical code.
In Viedoc Coder, you can find the following symbols:
1. The three horizontal lines is a filter function. Select the symbol to open a dropdown list with a search field and a list of selectable items.
2. Fields have a sorting function which will list its contents in ascending and descending order. This function is not available for all columns.
3. A numbered list in the code field means that there is more than one medical code applied to that value.
4. An orange pen icon in the value field, together with a light orange background in the code field, means that the value (form item) has been changed in Viedoc Clinic by the Investigator after the item was coded. The applied code may not be correct anymore and the item should be re-coded.
5. A clip icon in the code field means that an interpretation has been added. Move the mouse pointer over the clip icon to view the contents of the interpretation.
6. An activated tick mark indicates that the coding has been approved.
7. The checkbox is used to mark the values to which a selected code should be applied.
8. The white cross in a grey circle is used to delete the applied code.
This section gives an example of medical coding of adverse events using the Medical Dictionary for Regulatory Activities (MedDRA) and an example of medical coding of concomitant medication using the World Health Organization Drug Dictionary (WHODrug). The coding procedure is similar even if you are using other types of dictionaries.
To find a code that you want to apply to a value, use the Find and apply code section.
There are three search options available:
You can search for codes or (substrings of) terms in the Search field. Codes matching the term will be listed in a dropdrown list that deploys from the Search field. If a term is linked to multiple System Organ Classes (SOCs), the code that links to the primary SOC is displayed in black, while the codes that link to secondary SOCs are displayed in grey.
Searching is not case sensitive. If you type in "Anaphylaxis", the search can return results such as "anaphylaxis" and "Anaphylaxis".
You can also search a code by selecting the System Organ Class (SOC), High Level Group Term (HLGT), High Level Term (HLT), Preferred Term (PT) and Low Level Term (LLT) using the dropdown lists below the search field.
By default, the search returns low level terms (LLTs) that have the status 'current' in the MedDRA dictionary. You can search among non-current MedDRA codes (that is, terms that are vague, ambiguous, truncated, abbreviated, out-dated, or misspelled and thus no longer used), by clearing the checkbox for Only current items.
Select the code you would like to apply. The details of this code appear in the fields below the search field.
You can select to use the Preferred Term (PT) or the Low Level Term (LLT) by selecting one of the blue radio buttons next to the PT and LLT fields, as shown below:
If you would like to add more than one code to the same value, select Add another code.
If you would like to add an interpretation, that is, a comment or explanation of the selected code, select Add interpretation and type your interpretation in the field.
You can reset your selections by selecting Clear.
Tip! If you want to apply a code that has been used before, select that code in the left side of the table. The Find and apply code section is then automatically populated with the selections for that code.
To apply a selected code, select the checkboxes for the value or values you want to apply that code to, and select Apply to selected items. The selected code will be applied to the selected subjects and values.
Note! You can remove an applied code by selecting the cross icon to the right of the applied code.
To find a code that you want to apply to a value, use the Find and apply code section.
When using WHODrug, you can select to search by:
; and the search will return all drugs that contain all specified ingredients.There are three search options available:
You can search for codes or (substrings of) terms in the Search field. Codes matching the term will be listed in a dropdrown list that deploys from the Search field.
Searching is not case sensitive. If you type in "paRacetaMol", the search can return results such as "paracetamol" or "Paracetamol".
The number behind the entries in the list depicts the number of active ingredients. If you hover the cursor over the number, a dialog box appears that lists the active ingredients:
Select the code (drug) you would like to apply. The details of this drug will appear in the fields below the search field.
In WHODrug, all drugs have a preferred drug. You can select to use the Preferred drug (Pref) or the Drug name by selecting one of the blue radio buttons next to the Pref and Drug fields. Drug is the default.
Note! When exporting medical coding, both the preferred drug and drug name are included in the export (in separate columns). But if you select to apply Pref while coding, the preferred name ends up in both columns in the export. This is to provide consistency for the data managers, so that they only have to look in one column to find their data.
Use the dropdown lists to select Country (Cntr), Marketing Authorization Holder (MAH), Pharmaceutical Form (Form), Strength (Str), or Medicinal Product ID (MPID), if applicable.
If you would like to add more than one code to the same field, select Add another code.
If you would like to add an interpretation, that is, a comment or explanation of the selected code, select Add interpretation and type your interpretation in the field.
You can reset you selections by selecting Clear.
Tip! If you want to apply a code that has been used before, select that code in the left side of the table. The Find and apply code section is then automatically populated with the selections for that code.
If you selected a drug that carries multiple Anatomic Therapeutic Chemical Classification System (ATC) codes, all ATC codes will be displayed in the ATC field. You can define whether to include all ATC codes in the coding or only a selection. Select the ATC code to include it or select the X icon to remove an ATC code.
To apply a selected code, select the checkboxes for the value or values you want to apply that code to, and select Apply to selected. The selected code will be applied to the selected subjects and values.
You can remove an applied code by selecting the cross icon to the right of the applied code.
After applying codes to the items, you can approve/reject/reset the items as shown in the below table.
| Action | Current state/found in list | New state/found in list |
| Approve |
Coded Rejected |
Approved items |
| Reject |
Coded Approved |
Uncoded items |
| Reset |
Approved Rejected |
Coded items |
Tip! To see all items in one list, select the filter All items.
To approve items that have been coded:
| 1 |
Select the item(s) that you want to approve and select Approve selected: 
|
| 2 |
The selected item(s) now disappear from the list and are found with the blue "Approved" symbol in the Approved items list. 
|
Tip! The metrics of the medical coding that have been approved can be seen on the landing page:
To reject items that have been coded:
| 1 |
Select the items that you want to reject and select Reject selected. 
|
| 2 |
The selected item(s) now disappear from the list and are found with the red "rejected" symbol in the Uncoded items list for re-evaluation. 
|
To reset items that have been approved or rejected:
| 1 |
Select the item(s) that you want to reset and select Reset selected. 
|
| 2 |
The selected item(s) now disappear from the list and are found in the Coded items list without the approved/rejected flag. 
|
You can export medical coding using Viedoc's data export feature, for more information, see Exporting data.
To export the medical coding, select the checkbox in front of Medical coding in the Type of data section.
For more information about how medical coding is exported, see:
Note! You can only export medical coding if permission to export data is activated for your role. If you do not see the data export icon, you do not have a role with export permissions.
In Viedoc Coder, you can choose to enable auto coding. Viedoc supports auto coding for the MedDRA, ATC and WHO Drug dictionaries.
Note! Support for MedDRA-J is planned for inclusion in a future release.
Auto coding can be enabled and disabled for individual scopes within the MedDRA/ATC terminology. Currently, auto coding includes an exact match to MedDRA, any language and ATC, and is applied automatically.
We also support WHODrug Koda, an automated coding service custom-built by UMC. The integration in Viedoc Coder displays WHODrug Koda suggestions to enhance the medical coding.
WHODrug Koda can code both the drug name and the ATC assignment for a specific drug. For more information, see WHODrug Koda
Notes!
For the MedDRA, and ATC dictionaries, auto coding is disabled by default for ongoing studies and enabled for new studies. However, it can be disabled for new studies.
For WHODrug, auto coding is disabled by default.
The auto coding setting is always available in Viedoc Admin, but is only functional for the new Viedoc Coder and not for the old Viedoc Coding console. Please contact your Viedoc representative if you wish to switch to the new Viedoc Coder.
When auto-coding is enabled for your study, all existing uncoded items are auto coded, and all new items are coded automatically without any manual action required.
Note! Items that are auto coded without a match will be flagged, and will still need to be manually coded.
To apply an auto coded suggestion:
| 1. | Select the blue radio button. The Apply autocoded suggestions button appears |
| 2. | Select Apply auto coded suggestions to add the item to the coded items: |
The up and down arrows indicate the level of certainty for auto coded items.
An upward arrow signifies a high level of certainty, whereas a downward arrow signifies a lower level of certainty.
Items with a low level of certainty should be reviewed carefully.
An auto coded item is indicated within the column for coded items with the following symbols:
| Symbol | Meaning |
| A | auto coded with a match |
| ! | auto coded without a match and must be manually coded |
| a | suggestion available |
| (empty) | indicates that no auto coding has been run |
For the available suggestions, hover over the a icon to see a tooltip which describes how WHODrug Koda has found the match:
The list of suggested coding paths are as follows:
For more information, see WHODrug Koda
Viedoc Coder allows you to code data, such as Adverse Events, Medical History, and Concomitant Medications, in a standardized way. You can access Viedoc coder on the landing page.
The Viedoc Coder page displays metrics about coding that tell the user the number and percentage of items that have been coded and approved. There is one set of metrics for each coding scope. The metrics displayed are based on the data and sites that you have permission to view.
Note! You can only access Viedoc Coder if permission to view, perform, and/or approve medical coding is activated for your role. If you do not see the medical coding icon, you do not have a role with medical coding permissions.
You can select to display the metrics of:
To enter the medical coding console, click Open Viedoc Coder in the lower left corner of the coding scope.
The Viedoc Coder console opens in the same window:
The Viedoc Coder console displays a table that lists all items to be coded in the Values column. You can view the corresponding form (Electronic Case Report Form (eCRF)) of an item by clicking on the value.
On the Viedoc Coder console, you can:
1. Select the coding scope (that is, data) to be coded.
2. Select to display items from all countries or from an individual country.
3. Select to display items from all sites or from an individual site.
4. Select to display all uncoded (and disapproved) items, all coded items, all approved items, or all items.
5. Perform a text search among all values of the items.
6. If configured for your study, there can be additional columns included with supporting values for the coding, for example route, indication, or other.
7. Find and apply codes (see Finding and applying a medical code).
When applying codes, it is possible to:
See Finding and applying a medical code.
On the Viedoc Coder console, you can find the following symbols:
1. The three horizontal lines is a filter function. Click the symbol to open a drop-down list with a search field and a list of selectable items.
2. A filter symbol indicates that a selection has been made and the column only displays your filtered items.
3. A numbered list in the code field means that there is more than one medical code applied to that value.
4. An orange pen icon in the value field, together with a light orange background in the code field, means that the value (form item) has been changed in Viedoc Clinic by the Investigator after the item was coded. The applied code may not be correct anymore and the item needs to be re-coded.
5. A clip icon in the code field means that an interpretation has been added. Move the mouse pointer over the clip icon to view the contents of the interpretation.
6. An activated tick mark indicates that the coding has been approved.
7. The checkbox is used to mark the values to which a selected code should be applied.
8. The white cross in a grey circle is used to delete the applied code.
This section gives an example of medical coding of adverse events using the Medical Dictionary for Regulatory Activities (MedDRA) and an example of medical coding of concomitant medication using the World Health Organization Drug Dictionary (WHO DD). The coding procedure is similar even if you are using other types of dictionaries.
To find a code that you want to apply to a value, use the Find and apply code section.
There are three search options available:
You can search for codes or (substrings of) terms in the Search field. Codes matching the term will be listed in a drop-drown list that deploys from the Search field. If a term is linked to multiple System Organ Classes (SOCs), the code that links to the primary SOC is displayed in black, while the codes that link to secondary SOCs are displayed in grey.
Searching is not case sensitive. If you type in "Anaphylaxis", the search can return results such as "anaphylaxis" and "Anaphylaxis".
You can also search a code by selecting the System Organ Class (SOC), High Level Group Term (HLGT), High Level Term (HLT), Preferrred Term (PT) and Low Level Term (LLT) using the drop-down lists below the search field.
By default, the search returns low level terms (LLTs) that have the status 'current' in the MedDRA dictionary. It is possible to search among non-current MedDRA codes (that is, terms that are vague, ambiguous, truncated, abbreviated, out-dated, or misspelled and thus no longer used), by clearing the checkbox for Only current items.
Select the code you would like to apply. The details of this code appear in the fields below the search field. The checkbox Current displays whether the selected Low Level Term (LLT) has the status current in the MedDRA dictionary or not.
You can select to use the Preferred Term (PT) or the Low Level Term (LLT) by clicking one of the blue radio buttons behind the PT and LLT fields, see image.
If you would like to add more than one code to the same field, click Add another code.
If you would like to add an interpretation, that is, a comment or explanation of the selected code, click Add interpretation and type your interpretation in the field.
You can reset your selections by clicking Clear.
Tip! If you want to apply a code that has been used before, click that code in the left side of the table. The Find and apply code section is then automatically populated with the selections for that code.
To apply a selected code, select the checkboxes for the value or values you want to apply that code to, and click Apply to selected. The selected code will be applied to the selected subjects and values. In the example in the image, we applied two codes to the value Allergic reaction, anaphylaxis for subject SE-AHU-058.
You can remove an applied code by clicking the cross icon to the right of the applied code.
To find a code that you want to apply to a value, use the Find and apply code section.
When using the WHO DD, you can select to search by:
; and the search will return all drugs that contain all specified ingredients.There are three search options available:
You can search for codes or (substrings of) terms in the Search field. Codes matching the term will be listed in a drop-drown list that deploys from the Search field.
Searching is not case sensitive. If you type in "paRacetaMol", the search can return results such as "paracetamol" or "Paracetamol".
The number behind the entries in the list depicts the number of active ingredients. If you click that number, a pop-up appears that lists the active ingredients.
Select the code (drug) you would like to apply. The details of this drug will appear in the fields below the search field.
In the WHO DD, all drugs have a preferred drug as parent. You can select to use the Preferred drug (Pref) or the Drug name by clicking one of the blue radio buttons behind the Pref and Drug fields. Drug is the default.
Note! When exporting medical coding, both the preferred drug and drug name are included in the export (in separate columns). But if you select to apply Pref while coding, the preferred name ends up in both columns in the export. This is to provide consistency for the data managers, so that they only have to look in one column to find their data.
Click Show variants to display and specify variants of the selected code (drug), and use the drop-down lists to select Country (CNTR), Marketing Authorization Holder (MAH), Pharmaceutical Form (FORM), Strength (STR), or Medicinal Product ID (MPID), if applicable. Click Hide variants to hide the variants, see image.
If you would like to add more than one code to the same field, click Add another code.
If you would like to add an interpretation, that is, a comment or explanation of the selected code, click Add interpretation and type your interpretation in the field.
You can reset you selections by clicking Clear.
Tip! If you want to apply a code that has been used before, click that code in the left side of the table. The Find and apply code section is then automatically populated with the selections for that code..
If you selected a drug that carries multiple Anatomic Therapeutic Chemical Classification System (ATC) codes, all ATC codes will be displayed in the ATC field. You can define whether to include all ATC codes in the coding or only a selection. Click the cross to remove an ATC code, or click the ATC field to add ATC codes.
To apply a selected code, select the checkboxes for the value or values you want to apply that code to, and click Apply to selected. The selected code will be applied to the selected subjects and values.
You can remove an applied code by clicking the cross icon to the right of the applied code.
After applying codes to the items, it is possible to approve/disapprove/reset the items as shown in the below table.
| Action | Current state/found in list | New state/found in list |
| Approve |
Coded Disapproved |
Approved items |
| Disapprove |
Coded Approved |
Uncoded items |
| Reset |
Approved Disapproved |
Coded items |
Tip! To see all items in one list, select the filter All items.
To approve items that have been coded:
| 1 |
Select the item(s) that you want to approve and click Approve selected. 
|
| 2 |
The selected item(s) now disappear from the list and are found with the blue "Approved" symbol in the Approved items list. 
|
Tip! The metrics of the medical coding that have been approved can be seen on the landing page:
To disapprove items that have been coded:
| 1 |
Select the items that you want to disapprove and click Disapprove selected. 
|
| 2 |
The selected item(s) now disappear from the list and are found with the red "Disapproved" symbol in the Uncoded items list for re-evaluation. 
|
To reset items that have been approved or disapproved:
| 1 |
Select the item(s) that you want to reset and click Reset selected. 
|
| 2 |
The selected item(s) now disappear from the list and are found in the Coded items list without the approved/disapproved flag. 
|
It is possible to export medical coding using the export feature of Viedoc, see Exporting data.
To export the medical coding, select the checkbox in front of Medical coding in the Type of data section.
For more information about how medical coding is exported, see:
Note! You can only export medical coding if permission to export data is activated for your role. If you do not see the data export icon, you do not have a role with export permissions.
This video walks you through the process of creating a Viedoc user account.
If you have difficulties in viewing this video click here.
This video shows how to log in/log out to/from Viedoc and how to reset your password.
If you have difficulties in viewing the video, click here.
This video provides a quick overview of the landing page as well as of the study start page.
If you have difficulties in viewing this video, click here.
This video demonstrates how to switch between demo and production mode within a study.
If you have difficulties in viewing this video, click here.
Our Working Smarter webinar series is designed to help Viedoc users get the most out of the platform, from practical tips and feature deep dives to best practices and expert insights. Each session addresses topics for our users including highlighting new features, sharing useful tips, best practices, or deeper insights into specific areas of Viedoc.
Whether you're new to the system or an experienced user, these webinars are here to help you work smarter.
The full list of webinars in Viedoc’s Working Smarter Series, including recordings and Q&A, is provided below.
October 2024
https://help.viedoc.net/l/a29eab/en/
November 2024
https://help.viedoc.net/l/04c262/en/
January 2025
https://help.viedoc.net/l/893419/en/
February 2025
https://help.viedoc.net/l/bb2d9a/en/
March 2025
https://help.viedoc.net/l/027d45/en/
April 2025
https://help.viedoc.net/l/f94362/en/
June 2025
https://help.viedoc.net/l/227838/en/
September 2025
https://help.viedoc.net/l/b01136/en/
November 2025
https://help.viedoc.net/l/f914f3/en/