MCSR license support for Veeva CRM

Massachusetts Controlled Substances Registration (MCSR) licenses can be mapped between Network fields and Veeva CRM fields for the Network Bridge. When Veeva CRM users download records, the MCSR license details will be included on MA addresses for accounts.

There are configuration steps for Veeva CRM and Network.

About MCSR licenses

Massachusetts has requirements for Controlled Substance Registrations (MCSR) for HCPs.

To support this, Veeva OpenData includes specific address information and drug schedule information for each MA CDS license.

  • Address VID (address_vid__v)

  • Drug Schedule (drug_schedule__v)

Example

When the Network Bridge (data subscription) runs, the drug schedule information will be populated on the specified address for the MA CDS license. This is supported for Network Account Search and DCR account import.

Example

Addresses without a MCSR license

For sampling, a single MCSR license can cover all practice addresses for an HCP within the state.

MCSR: Advisory on Delivery of Samples to Massachusetts Licensed Practitioners.

When the Network Bridge (data subscription) runs, the MCSR license is populated on the HCP's active Massachusetts addresses that do not have an MCSR license.

Note: This is not yet supported for Network Account Search and DCR account import.

MCSR license used

If an HCP has multiple MCSR licenses, the one that is populated on MA addresses without a license is determined using the following criteria (in order):

  1. active license

  2. license with the most Drug Schedules (to allow the most products to be covered)

  3. license with the farthest expiration date

Example

In this example, an HCP practices at four Massachusetts addresses. Two of the addresses have MSCR licenses.

The active license with the most drug schedules (MCSR100) is populated on the MA addresses that do not have a license.

Enabling MCSR licenses for Veeva CRM

Veeva CRM configuration

The MCSR data is stored on the CDS fields on the Address object.

In Veeva CRM, grant the Network integration user edit permission to the CDS fields on the Address object (including the CDS Schedule field).

Additional configuration steps are required to enable MCSR sampling validation. For detailed information, see Veeva CRM Help: Configuring CDS Validation for Non-Controlled and Schedule Specific Sampling (MCSR).

Network configuration

Push the records through the Network Bridge to update all the existing Massachusetts addresses in Veeva CRM.

To do this:

  1. Run a query to identify the HCPs in Massachusetts (Reports > SQL Query Editor).

    Example query 

    SELECT
        DISTINCT hcp.vid__v
    FROM
        hcp INNER JOIN license
            ON (
            entity_vid__v = hcp.vid__v
            AND type_value__v = 'MA'
            AND type__v = 'CDS'
            AND license_status__v = 'A'
            AND license.record_state__v = 'VALID'
        ) INNER JOIN customkey
            ON (
            hcp.vid__v = custom_key_entity_id__v
            AND custom_key_status__v = 'A'
            AND custom_key_source_type__v LIKE '%CRM%'
        )

    Note: Change the last line of the query if your Veeva CRM system name in Network doesn't include "CRM".

  2. Add the HCP VIDs to the Export by VID functionality in the Veeva CRM target subscription that is used by the bridge.

The addresses will be pushed to Veeva CRM the next time the Network Bridge runs.

License mapping

Network (License object)

 Veeva CRM (Address_vod__c object)
Field Name Label API Name Label
expiration_date__v Expiration Date CDS_Expiration_Date_vod__c CDS Expiration Date
license_number__v License CDS_vod__c CDS #
license_status__v License Status CDS_Status_vod__c CDS Status
vid__v Network Entity ID Network_CDS_Entity_ID_vod__c Network CDS Enity ID
drug_schedule__v Drug Schedule CDS_Schedule_vod CDS Drug Schedule