Extracting Code Request Data
Coder users with EDC Tools permissions can initiate a Code Request Export job to export a CSV file detailing all Code Requests. Users can choose to export that file to an FTP destination, or simply download the file when the job is complete.
Seek the assistance of a SAS programmer if you wish to combine the Code Request Export file and a Data Export in order to review study and coding data together. The files can be joined together by using key value pairs, specifically Subject ID and Form Sequence, and in some cases Subject ID and Item Group Sequence.
Accessing EDC Tools
To access the EDC Tools administration area, click the Tools tab in the primary navigation bar, and then click EDC Tools.
By default, once you open EDC Tools, Vault displays a list of automated deployment Studies. You can use the Automatic and Manual radio buttons to switch between these listings. Select Manual to access your manual deployment Studies.
For manual deployment Studies, click on the Study to open EDC Tools for that Study. For automatic deployment Studies, click on the Study to open the Deployments page. From here, you can click on an Environment to open EDC Tools for that study environment.
Once you’ve entered the EDC Tools area, select your Study if you have access to more than one Study. To return to the study list, click Back to Study Listing.
Create a Code Request Export Job
You can run or schedule a Code Request Export in the Job Schedule sub-tab of EDC Tools > Jobs:
- Go to EDC Tools > Jobs.
- Click + New Job.
- Select Code Request Export for Type.
Optional: Once Code Request Export is selected, an option will come up to choose an FTP connection if you wish to export using an FTP. You must configure a Connection to use this option. Leave the External Connection field blank if you do not wish to export to a FTP connection. You will be able to download the export from Study Tools > Jobs > Job History after the job has run.
- Click Save.
- If you have selected Run Now, the job will begin once you have clicked Save. Scheduled jobs will be run at the configured time. Once the job is completed, Vault sends you an email notification with a link to download the job log and relevant out each time the job runs.
The CSV file produced will contain Site, Study, Form, and Code information for all Code Requests within the study.
You can also download the job log and output file from Jobs > Job History. Click the Download (cloud) icon to begin a download.
Vault displays the status of your job in EDC Tools > Jobs, along with other details about the job. You can click the Information (i) icon for additional details about a job.
|In Progress||Vault is currently performing the job.|
|Failed||The job instance encountered one or more errors.|
|Completed||The job instance completed without errors.|
Job Logs & Output Files
Vault provides a CSV job log file for each job. This log includes details about which objects were affected by the job and whether or not the job was successful on each object. When applicable, Vault also provides a link to the output files from a job.
To access these files, click the icon in either the Log or File column.
Which permissions control your access depends on when your vault was created. If your vault uses the Role by Study feature, see the first section, Role by Study Permissions. If your vault does not use the CDMS Role by Study feature, see the second section, Profile Permissions.
Role by Study Permissions
Users with the CDMS Clinical Coder Administrator and a security profile that provides access to EDC Tools are able to perform the actions described above by default. If your vault uses custom Application Roles, your role must have the following permissions:
|Standard Tab||EDC Tools Tab||
Ability to access the EDC Tools tab
|Functional Permission||Manage Jobs||
Ability to create, edit, and delete scheduled jobs
If your Study contains restricted data, you must have the Restricted Data Access permission to view it.
Learn more about Study Roles.
Users with the Vault Owner security profile are able to perform the actions described above by default. If your vault uses custom Security Profiles, you must have the following permissions:
|Security Profile||EDC: Study Tools: Access||Ability to access the EDC Tools area.|
Learn more about permission sets.