RIM Maintenance allows you to load data to your Vault or extract data from your Vault in bulk. RIM Maintenance is similar to Vault Loader, but it performs jobs specific to RIM applications. Extracted information downloads to a CSV or Excel file, which you can load back into your Vault or into other systems.
In the current release, you can use RIM Maintenance to extract and load content plan Constraints and Application relationships and to import MedDRA terminology.
Note: This feature is only available on RIM Vaults.
How to Use RIM Maintenance
To use RIM Maintenance:
- Navigate to the RIM Maintenance tab.
- In the left panel, click Load or Extract.
- Select an Action.
- Select an Action Type when applicable.
- Loading: Click Choose and browse to your file.
- Click Load or Extract.
Vault begins processing the request. When finished, you’ll receive a Vault notification and email with request details and the CSV output files.
Available Actions
| Available Actions | RIM Application | File |
|---|---|---|
| Extract Content Plan Template Constraints | Submissions | Excel output |
| Load Content Plan Template Constraints | Submissions | Excel input |
| Extract Application Relationships | Submissions | ZIP with CSV (.csv) output |
| Load Application Relationships | Submissions | ZIP with CSV (.csv) input |
| Import MedDRA Dictionary > Initial Load | Registrations | ZIP with ASCII (.asc) input |
| Import MedDRA Dictionary > Sequential Load | Registrations | ZIP with ASCII (.seq) input |
Notifications & Output Files
Vault shows the status of loader jobs in Admin > Operations > Job Status and also sends notifications for both successes and failures. Admins can modify the notification message templates if needed.
Success & Failure Log Files
After each load, Vault creates separate success and failure logs as CSV files. You can download these files from the Vault notification or email. Both files contain the system-managed id values for each record.
Failure Logs
Failure logs include:
- Error messages for each record that failed to load
- Original data alongside corresponding errors
- Row IDs from the original CSV file for the corresponding row
You can review and fix errors from within the error log. Once you correct any errors, you can re-import the failure log.
Related Permissions
The following permissions are required when using RIM Maintenance:
| Type | Permission Label | Controls |
|---|---|---|
| Security Profile | Application: RIM: RIM Maintenance | Ability to use RIM Maintenance. |
| Security Profile | Tabs: RIM Maintenance | Ability to access the RIM Maintenance tab. |
| Security Profile | Objects: Coded Indication: Create | Ability to create records in the Coded Indication object. This is required to use Import MedDRA Dictionary > Initial Load. |
| Security Profile | Objects: Coded Indication: Edit | Ability to edit records in the Coded Indication object. This is required to use Import MedDRA Dictionary > Sequential Load. |
| Security Profile | Objects: Content Plan Template Constraint: Create, Delete | Ability to load Content Plan Template Constraints through the Load action on the RIM Maintenance tab. |
| Security Profile | Objects: Content Plan Template: Read | Ability to view Content Plan Template records through the Extract action on the RIM Maintenance tab. |
| Security Profile | Objects: Content Plan Item Template: Read | Ability to view Content Plan Item Template records through the Extract action on the RIM Maintenance tab. |
| Security Profile | Objects: Content Plan Template Constraint: Read | Ability to view Content Plan Template Constraint records through the Extract action on the RIM Maintenance tab. |
| Security Profile | Objects: Constraint: Read | Ability to view Constraint records through the Extract action on the RIM Maintenance tab. |
| Security Profile | Objects: Application: Read, Create Objects: [Application relationship object]: Read, Create |
Ability to view and create Application and its relationship records (e.g., Application Clinical Study) through the Extract and Load actions on the RIM Maintenance tab. |
| Security Profile | Objects: Submission: Read, Create Objects: [Submission relationship object]: Read, Create |
Ability to view and create Submission and its relationship records (e.g., Submission Drug Product) through the Extract and Load actions on the RIM Maintenance tab. |
| Security Profile | Objects: Regulatory Objective: Read, Create Objects: [Regulatory Objective relationship object]: Read, Create |
Ability to view and create Regulatory Objective and its relationship records (e.g., Regulatory Objective Drug Product) through the Extract and Load actions on the RIM Maintenance tab. |