Data Model Changes in 18R1

Release Date: April 13 & 20, 2018

As part of standardizing the configuration, we’ve made the following changes to standard configuration in all EDC vaults:

• Added the following items to support the Admin: Job Listing in Study Tools Feature
  • EDC Jobs (edc_job_lifecycle__v) lifecycle
  • EDC Job (edc_job__v) object
  • EDC Job Status (edc_job_status__v) picklist
  • EDC Job Type (edc_job_type__v) picklist
  • Link Status (link_status__v) picklist
• Added the Read-only (read_only__v) value to the Item Type (item_type__v) picklist to support the Read-Only Fields feature.
• Added the Deployed with Error (deployed_with_error__v) and Deployed with Failures (deployed_with_failures__v) values to the Inbound Package Component Status (vault_pkg_comp_status__v) picklist for continued configuration migration support.
• Removed the Short Label (short_label__v) field from the Event Definition (event_def__v) and Form Definition (form_def__v) objects to support Label Override for Design View feature.
• Removed the Hint Label (hint_label__v) field from the Item Definition (item_def__v) object to support object reuse.
• Added the Mirror Query Status (mirror_query_status__v) field to the Query Binding (query_binding__v) object to support the Admin: Query Rules in Study Tools feature.
• Added the following fields related to configuration migration to the Inbound Package Step (vault_package_step__v) object:
  • Step Required (step_required__v)
  • Stop on Errors(stop_on_error__v)
  • Step Type (step_type__v)
• Added the following fields related to performance metrics to the Performance Statistics (perf_stats__v) object:
  • Record Action Count (record_action_count__v)
  • Record Trigger Count (record_trigger_count__v)
  • Total Obj Count (total_obj_count__v)
  • Total Obj Record Count (total_obj_record_count__v)
• Added the EDC > Study Tools > Access permission and the EDC Study tools Permissions permission set. Added the EDC Study Tools Permissions permission set to the EDC Lead Data Manager security profile.
• Added the following items to support the Codelist Versioning feature:
  • Codelist Definition - Codelist Item Def (codelist_def_codelist_item_def__v) object
  • Item Definition - Codelist Definition (item_def_codelist_def__v) object
  • Version (version__v) field on the Codelist Definition (codelist_def__v) object and Codelist Item Definition (codelist_item_def__v) objects
  • Previous Version (prev_version__v) and CDM Key (cdm_key__v) fields on the Codelist Item Definition (codelist_item_def__v) object
• Added the Intentionally Left Blank Reason (intentionally_left_blank_reason__v) field on the Form (form__v), Item Group (item_group__v), and Item (item__v) objects to support the Mark Field as Intentionally Left Blank feature.
• Added the following fields to support the Audit Trail Enhancements for Item History feature:
  • Value Modified Date (value_modified_date__v) on the Item (item__v) object
  • First Response Date (first_response_date__v) on the Query (query__v) object
  • Last Close Date (last_close_date__v) on the Query (query__v) object
  • DMR Date (dmr_date__v) on the Form (form__v) object
  • Frozen Date (frozen_date__v) on the Form (form__v) object
  • Locked Date (locked_date__v) on the Form (form__v) object
  • SDV Date (sdv_date__v) on the Form (form__v) object
  • Signed Date (signed_date__v) on the Form (form__v) object
  • Submit Date (submit_date__v) on the Form (form__v) object
• Removed the EDL (edl__v), EDL Item (edl_item__v), EDL Template (edl_template__v), and EDL Item Template (edl_item_template__v) objects. Documents are not available in EDC application vaults.
• Removed the SDV Mode (sdv_mode__v) field from the following objects. This field was not used for the SDV feature.
  • Event (event__v)
  • Form (form__v)
  • Item Group (item_group__v)
• The Unit Definition (unit_definition__v) field is no longer required on the Unit Item Definition (unit_item_def__v) object.
• Added the Study (study__v) field on the Codelist Item Definition (codelist_def_item_def__v) object to support versioning features.
• Added the following items to support the Data Manager Review feature:
  • Added the DMR (dmr__v) value to the Review Plan Type (review_plan_type__v) picklist
  • Added the DMR Mode (dmr_mode__v) field to the Item (item__v) object
• Added the following items to support the Unit Versioning feature:
  • Item Unit Definition (item_def_unit_def__v) object
  • Unit Definition - Unit Item __Def (unit_def_unit_item_def__v) object
  • New fields on the Unit Item Definition (unit_item_def__v) object:
    • Version (version__v)
    • CDM Key (cdm_key__v)
    • Previous Version (previous_version__v)
    • Study (study__v)
• Added the Validating (validating__v) and Validated (validated__v) values to the Definition Status (definition_status__v) picklist to support the Casebook Validations feature.
• Added the Definition Status (definition_status__v) field, with the default value In Progress (in_progress__v) on the following objects:
  • View Definition (view_definition__v)
  • Rule Definition (rule_definition__v)
  • Review Plan (review_plan__v)
• Added an Audit Trail (user_role_assignment__v) to the User Role Assignments feature.