Objects
This reference page provides information about the objects that the Scientific Publications Cloud product uses. Each object section on this page includes a description of the object, an entity relationship diagram for that object (where available), and a table of custom and standard fields that the object uses. The schema tables do not include standard fields that the Scientific Publications Cloud product does not use out of the box.
The simplified Scientific Publications Cloud product entity relationship diagram below displays many of the custom primary objects and their relationships. The diagram does not depict every object or relationship that the module uses. To see a diagram for a particular object that contains all relevant relationships, navigate to that object's section on this page or use Salesforce's Schema Builder in your org.
Activity
The primary metadata used to store task data is the Task standard object. The Task object inherits all of its fields from the Activity standard object. For more information on the Task object, visit Salesforce's documentation.
Activity schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Assigned Document Role Developer Name | mvn__CM_Assigned_Document_Role_Developer_Name__c | Text(40) | System maintained field with the assigned document role for this workflow task. |
| Capacity Code | mvn__CM_Capacity_Code__c | Text(255) | Capacity in which this activity is being carried out. |
| Complete On Behalf Of Flag | mvn__CM_Complete_On_Behalf_Of_Flag__c | Checkbox | When checked, a document collaborator has closed the task on another user's behalf using the CM_Task_Completion_On_Behalf_Of custom permission. |
| Completed By | mvn__CM_Completed_By__c | Formula (Text) | The name of the document collaborator who completed the workflow task. If the document collaborator completed the workflow task on behalf of another user, the value will appear as "<name of document collaborator> on behalf of <name of task assignee>". |
| Completed By Name | mvn__CM_Completed_By_Name__c | Text(255) | The name of the document collaborator who completed the workflow task. |
| Completed Date | mvn__PP_Completed_Date__c | Formula (Date) | Formula for the task CompletedDateTime datevalue. |
| Completed Date Time | mvn__PP_Completed_Date_Time__c | Formula (Date/Time) | Formula for the task CompletedDateTime date time value: IF(IsClosed, LastModifiedDate, null) |
| Contact Verification | mvn__PP_Contact_Verification__c | Lookup(Contact Verification) | Lookup relationship to the contact verification (mvn__PP_Contact_Verification__c) object. |
| Created By Name | mvn__CM_Created_By_Name__c | Formula (Text) | Name of the user who created the activity. |
| Directions | mvn__CM_Directions__c | Text Area(255) | Directions to the assignee. |
| Document Version | mvn__CM_Document_Version__c | Lookup(Document Version) | Id of the associated Document Version. |
| Document Version Fully Qualified Name | mvn__CM_Document_Version_Fully_Qualified_Name__c | Formula (Text) | Fully Qualified Name of the document version. The Fully Qualified Name is comprised of the document version's Title followed by the Version Number. For example, if the Fully Qualified Name of a document version is Dosing Guide (v0.4), Dosing Guide is the Title, and 0.4 is the Version Number. |
| Document Version URL | mvn__PP_Document_Version_URL__c | Formula (Text) | A link to the related Document Version (mvn__CM_Document_Version__c) record for easier access on the mobile application. |
| Notifications Muted | mvn__CM_Notifications_Muted__c | Checkbox | When true, notifications for the task will not be sent. |
| Original Assignee | mvn__CM_Original_Assignee__c | Lookup(User) | The document collaborator who was originally assigned to the workflow task before the activity was reassigned or completed by another user. |
| Outcome | mvn__CM_Workflow_Instance_Outcome__c | Formula (Text) | The outcome of the workflow instance. |
| Owner Name | mvn__CM_Owner_Name__c | Formula (Text) | The name of the document collaborator who is currently assigned to the workflow task. |
| Pubs Notification | mvn__PP_Pubs_Notification__c | Checkbox | When true, a notification will be sent out for the task. |
| Record Type Developer Name | mvn__CM_Record_Type_Developer_Name__c | Formula (Text) | API name of the record type. |
| Record Type Name | mvn__CM_Record_Type_Name__c | Formula (Text) | Name of the record type. |
| Signing Reason | mvn__CM_Signing_Reason__c | Picklist | Reason a user completed the activity. Picklist values include: - I have reviewed this document - I am the author of this document |
| Target Submission | mvn__PP_Target_Submission__c | Lookup(Target Submission) | Lookup relationship to the Target Submission (mvn__PP_Target_Submission__c) record. |
| TwoFactorInfoId | mvn__CM_TwoFactorInfoId__c | Text(18) | Record ID of the TwoFactorInfo record used to electronically sign this activity. |
| Verification Code | mvn__CM_TOTP_Code__c | Text(100) | One-time code that the activity owner inputs when marking the activity as complete. This code verifies the activity owner's identity. This field is only used when electronic signature is enabled. |
| Workflow Instance Document | mvn__CM_Workflow_Instance_Document__c | Lookup(Workflow Instance Document) | Id of the associated Workflow Instance Document. |
| Workflow Instance ID | mvn__CM_Workflow_Instance_ID__c | Formula (Text) | Id of the associated Workflow Instance. |
| Workflow Instance Stage | mvn__CM_Workflow_Instance_Stage__c | Lookup(Workflow Instance Stage) | Id of the associated Workflow instance Stage. |
| Workflow Process Flag | mvn__CM_Workflow_Process_Flag__c | Checkbox | System field used when this activity is being processed by a workflow service. |
| Workflow Stage Activity Developer Name | mvn__CM_Workflow_Stage_Activity_Dev_Name__c | Text(40) | Used as a lookup field for Workflow Stage Activity Dev Name |
Annual Plan
The Annual Plan (mvn__PP_Plan_Budget__c) custom object facilitates
budgets for a plan record. It is on the master side of a master-detail
relationship with the Publication Plan object.
Annual Plan schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Annual Plan Name | Name | Text(80) | Name of the Annual Plan. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| End Date | mvn__PP_End_Date__c | Date | Annual plan end date. |
| Estimated # of Abstracts | mvn__PP_Estimated_of_Abstracts__c | Number(18, 0) | Preliminary planned number of abstracts. |
| Estimated # of Manuscripts | mvn__PP_Estimated_of_Manuscripts__c | Number(18, 0) | Preliminary planned number of manuscripts. |
| Estimated # of Posters | mvn__PP_Estimated_of_Posters__c | Number(18, 0) | Preliminary planned number of posters. |
| Estimated # of Presentations | mvn__PP_Estimated_of_Presentations__c | Number(18, 0) | Preliminary planned number of presentations. |
| Estimated Amount | mvn__PP_Estimated_Amount__c | Currency(16, 2) | Preliminary planned amount for the budget. |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Sensitive) | Unique identifier from an external source system. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Paid Amount | mvn__PP_Paid_Amount__c | Roll-Up Summary (SUM Line Item) | Roll-up summary of line item payments, calculating the actual amount paid for the budget. |
| Publication Plan | mvn__PP_Plan__c | Master-Detail(Publication Plan) | Master-detail relationship to the Publication Plan. |
| Plan Budget # | mvn__PP_Plan_Budget_Num__c | Auto Number (External ID) | Automatically incremented record number. |
| Remaining Amount | mvn__PP_Remaining_Amount__c | Formula (Currency) | Formula calculating the remaining budget (Total Amount - Paid Amount). |
| Start date | mvn__PP_Start_date__c | Date | Annual plan start date. |
| Status | mvn__PP_Status__c | Picklist | Picklist indicating the annual plan status values. |
| Total Amount | mvn__PP_Total_Amount__c | Roll-Up Summary (SUM Line Item) | Roll-up summary of line item amounts, calculating the actual total amount for the budget. |
| Vendor | mvn__PP_Vendor__c | Lookup(Account) | Lookup relationship to an Account. |
Association
The Association (mvn__PP_Association__c) custom object links accounts
to events, specifically congresses and journals.
Association schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Account | mvn__PP_Account__c | Master-Detail(Account) | Master-detail relationship to the account. |
| Congress | mvn__PP_Congress__c | Lookup(Congress) | Lookup relationship to the Congress. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| External Source | mvn__PP_External_Source__c | Text(255) | Name of the external system sourcing the association data. |
| Journal | mvn__PP_Journal__c | Lookup(Journal) | Lookup relationship to the Journal. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Name | Name | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
Budget
The Budget (mvn__PP_Budget__c) custom object stores budget details.
Budget schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Budget # | Name | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Sensitive) | Unique identifier from an external source system. |
| External Source | mvn__PP_External_Source__c | Text(255) | Name of the external system sourcing the budget data. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who owns the record. |
Communication
The Communication (mvn__CO_Communication__c) custom object stores
customer information that appear on the
Collaborator Portal, like announcements and
links to reference materials and other content.
mvn__CO_Communication__c record types
| Record type | API name | Description |
|---|---|---|
| Announcement | CO_Announcement | Used to store and share organization-wide announcements with users. |
| Resource Link | CO_Resource_Link | Used to store any links to reference materials, informational content, or helpful resources. |
mvn__CO_Communication__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Communication # | Name | Auto Number | The unique identifier of the Communication record. It is formatted as CO-\{0000000\} and generates and increments automatically. |
| Notes | mvn__CO_Notes__c | Rich Text Area(32768) | Any notes to go along with the communication. |
| Priority | mvn__CO_Priority__c | Picklist | The priority level of the announcement. Picklist values include: - High - Low |
| Resource Link | mvn__CO_Resource_Link__c | URL(255) | The URL for the resource link. |
| Subject | mvn__CO_Subject__c | Text(255) | The subject of the communication. |
Concept
The Concept (mvn__PP_Concept__c) custom object facilitates publication
concept requests.
Concept schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Classification | mvn__PP_Classification__c | Picklist | Picklist indicating the document classification that will be applied when the concept is converted to a document. Note: Picklist values and dependencies must be kept in sync with the Document Version classification picklist field. |
| Concept # | mvn__PP_Concept_Num__c | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
| Concept Name | Name | Text(80) | Name of the concept. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Description | mvn__PP_Description__c | Rich Text Area(10000) | Detailed information about the concept. |
| Document Subtype | mvn__PP_Document_Subtype__c | Picklist | Picklist indicating the document subtype that will be applied when the concept is converted to a document. Note: Picklist values and dependencies must be kept in sync with the Document Version document subtype picklist field. |
| Document Type | mvn__PP_Document_Type__c | Picklist | Picklist indicating the document type that will be applied when the concept is converted to a document. Note: Picklist values and dependencies must be kept in sync with the Document Version document type picklist field. |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| External Source | mvn__PP_External_Source__c | Text(255) | Name of the external system sourcing the concept data. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who owns the record. |
| Publication Plan | mvn__PP_Plan__c | Lookup(Publication Plan) | Lookup relationship to the plan. |
| Annual Plan | mvn__PP_Plan_Budget__c | Lookup(Annual Plan) | Lookup relationship to the annual plan. |
| Product | mvn__PP_Product__c | Lookup(Product (Pubs)) | Lookup relationship to the product. |
| Status | mvn__PP_Status__c | Picklist | Picklist indicating the concept status values. |
| Study | mvn__PP_Study__c | Lookup(Study) | Lookup relationship to the study. |
| Sum of Related Documents | mvn__PP_Sum_of_Related_Documents__c | Number(18, 0) | Number of documents with a relationship to the concept. This field is calculated by a trigger. |
Congress
The Congress (mvn__Congress__c) custom object represents a congress.
Congresses are associated to Documents through the Target junction
object and to Accounts through the Association junction object. The
Congress object is on the master side of a master-detail relationship
with the Congress Attendee and Congress Location custom objects.
Congress schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| # of Attendees | mvn__PP_Num_of_Attendees__c | Number(7, 0) | Number of attendees that will participate in the congress. |
| Abstracts Published In | mvn__PP_Abstracts_Published_In__c | Text(255) | Details pertaining to where the congress publishes abstracts. |
| Abstracts Published? | mvn__PP_Abstracts_Published__c | Picklist | Picklist indicating if the congress publishes abstracts. |
| Accepts Encores? | mvn__PP_Accepts_Encores__c | Picklist | Picklist indicating if the congress accepts encore presentations |
| Acronym | mvn__PP_Acronym__c | Text(150) | The acronym used for the congress. |
| Active | mvn__Active__c | Checkbox | Represents if the Congress is currently active or not. |
| Audience | mvn__PP_Audience__c | Picklist (Multi-Select) | The expected audience participating in the congress. |
| Call for Abstract URL | mvn__PP_Call_for_Abstract_URL__c | URL(255) | URL of the congress's call for abstract. |
| CME Credit? | mvn__PP_CME_Credit__c | Picklist | Picklist indicating if the congress provides Continuing Medical Education (CME) credits. |
| Congress Contact Email | mvn__PP_Congress_Contact_Email__c | Text(255) | Congress primary contact email address. |
| Congress Name | Name | Text(80) | Name of the congress. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Description | mvn__PP_Description__c | Long Text Area(5000) | Description of the congress. |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| External Last Modified Date | mvn__PP_External_Last_Modified_Date__c | Date | The date the record was last modified in the external system. |
| External Source | mvn__PP_External_Source__c | Text(255) | Name of the external system sourcing the congress data. |
| Formal Name | mvn__PP_Formal_Name__c | Text(255) | The proper name for a congress. |
| Frequency | mvn__PP_Frequency__c | Picklist | Picklist indicating the frequency of the congress. |
| Language | mvn__PP_Language__c | Picklist (Multi-Select) | Supported languages for the congress. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Notes | mvn__PP_Notes__c | Long Text Area(32678) | Additional notes about the congress. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who owns the record. |
| Rank | mvn__PP_Rank__c | Number(7, 0) | Congress rank provided by PubsHub. |
| Restrictions | mvn__PP_Restrictions__c | Long Text Area(32678) | Details pertaining to congress restrictions. |
| Therapeutic Area(s) | mvn__PP_Therapeutic_Areas__c | Picklist (Multi-Select) | The therapeutic areas of focus for the congress. |
| Website | mvn__PP_Website__c | URL(255) | URL of the congress's website. |
Congress Attendee
The Congress Attendee (mvn__Congress_Attendee__c) object represents a
Congress Attendee from the organization and has a Master-Detail
relationship with the Congress object.
mvn__Congress_Attendee__c
| Field label | API name | Data type | Description |
|---|---|---|---|
| Attendee | mvn__Attendee__c | Lookup(User) | Represents the Congress Attendee. |
| Congress | mvn__Congress__c | Master-Detail(Congress) | The Congress record associated with this record. |
| Congress Attendee # | Name | Auto Number | Identifier of the Congress Attendee record. |
| Created By | CreatedById | Lookup(User) | ID of the user who created the record. |
| Last Modified By | LastModifiedById | Lookup(User) | ID of the user who last modified the record. |
Congress Location
The Congress Location (mvn__Congress_Location__c) custom object stores
the locations of congresses and is on the detail side of a master-detail
relationship with the Congress custom object.
Congress Location schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Abstract Due Date | mvn__Abstract_Due_Date__c | Date | The abstract submission due date for a congress. |
| Abstract Due Date Confirmed? | mvn__PP_Abstract_Due_Date_Confirmed__c | Checkbox | Checkbox indicating whether the abstract due date is confirmed (true) or not confirmed (false). |
| Abstract Late-Breaking Date | mvn__PP_Abstract_Late_Breaking_Date__c | Date | The abstract late breaking due date for a congress. |
| Abstract Late-Breaking Date Confirmed? | mvn__PP_Abstract_Late_Breaking_Date_Confirmed__c | Checkbox | Checkbox indicating whether the abstract late breaking date is confirmed (true) or not confirmed (false). |
| Abstract Notification Date | mvn__PP_Abstract_Notification_Date__c | Date | The abstract notification date for a congress. |
| Abstract Notification Date Confirmed? | mvn__PP_Abstract_Notification_Date_Confirmed__c | Checkbox | Checkbox indicating whether the abstract notification date is confirmed (true) or not confirmed (false). |
| City | mvn__City__c | Text(255) | The designated city in which the congress takes place. |
| Clinical Trial Late-Breaking Date | mvn__PP_Clinical_Trial_Late_Breaking_Date__c | Date | The clinical trial late breaking date for a congress. |
| Congress | mvn__Congress__c | Master-Detail(Congress) | Master-detail relationship to the congress. |
| Congress End Date | mvn__Congress_End_Date__c | Date | The congress end date. |
| Congress End Date Confirmed? | mvn__PP_Congress_End_Date_Confirmed__c | Checkbox | Checkbox indicating whether the congress end date has been confirmed (true) or not confirmed (false). |
| Congress Location # | Name | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
| Congress Start Date | mvn__Congress_Start_Date__c | Date | The congress start date. |
| Congress Start Date Confirmed? | mvn__PP_Congress_Start_Date_Confirmed__c | Checkbox | Checkbox indicating whether the congress start date is confirmed (true) or not confirmed (false). |
| Country | mvn__Country__c | Picklist | The designated country in which the congress takes place. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| CT Late Breaking Date Confirmed? | mvn__PP_CT_Late_Breaking_Date_Confirmed__c | Checkbox | Checkbox indicating whether the clinical trial late breaking date has been confirmed (true) or not confirmed (false). |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| External Source | mvn__PP_External_Source__c | Text(255) | Name of the external system sourcing the congress location data. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Location Details | mvn__Location_Details__c | Text Area(255) | Details about the congress location. |
| State | mvn__State__c | Text(255) | The designated state in which the congress takes place. |
| Symposia Due Date | mvn__PP_Symposia_Due_Date__c | Date | The symposia due date for a congress. |
| Symposia Due Date Confirmed? | mvn__PP_Symposia_Due_Date_Confirmed__c | Checkbox | Checkbox indicating whether the symposia due date has been confirmed (true) or not confirmed (false). |
| Year | mvn__Year__c | Picklist | The designated year in which the congress takes place. |
Contact
The Contact standard object represents a person. Contact records are
associated with
Document (mvn__CM_Document__c) records via the
Document
Collaborator (mvn__PP_Document_Author__c) junction
object.
Contact schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Account Name | AccountId | Lookup(Account) | The parent Account record. |
| Address | mvn__PP_Address_Formula__c | Formula (Text) | The contact's complete mailing address, including their street, city, state, postal (zip) code, and country. |
| Contact Record Type | RecordTypeId | Record Type | The ID of the Contact record type. Record types include: - Employee (PP_Employee) - HCP (PP_HCP) - Non-HCP (PP_Non_HCP) |
| Credentials | mvn__PP_Credentials__c | Picklist | The contact's credentials. Picklist values are: - DO - MD - PharmD - RN - RNP |
| External ID | mvn__PP_External_Id__c | Text(50) (External ID) (Unique Case Sensitive) | The unique identifier of the Contact record from an external source system. |
| External Source | mvn__PP_External_Source__c | Text(255) | The name of the external system sourcing the contact's data. |
| Latest Background Check | mvn__PP_Latest_Background_Check__c | Lookup(Contact Verification) | The related Contact Verification (mvn__PP_Contact_Verification__c) record with the most recent contact verification background check. |
| NPI # | mvn__PP_NPI__c | Text(20) | The contact's National Provider Identifier (NPI) number. |
| Pending New User Request | mvn__PP_Pending_New_User_Request__c | Roll-Up Summary (SUM User Request) | The roll-up summary of pending new user requests (i.e., User Request (mvn__PP_User_Request__c) records whose record type equals PP_New_User and whose Status field equals Pending). |
| Pending Password Reset Request | mvn__PP_Pending_Password_Reset_Request__c | Roll-Up Summary (SUM User Request) | The roll-up summary of pending password reset user requests (i.e., User Request (mvn__PP_User_Request__c) records whose record type equals PP_Password_Reset and whose Status field equals Pending). |
| Publication User | mvn__PP_Publication_User__c | Lookup(User) | The related User record with the document collaborator's user. |
| Specialty | mvn__PP_Specialty__c | Picklist | The contact's specialty. Picklist values include, but are not limited to: - Cardiology - Emergency Medicine - Family Medicine |
| User Type | mvn__PP_User_Type__c | Formula (Text) | The icon used to represent the contact in the Document Collaborator Search wizard. |
| User Type Label | mvn__PP_User_Type_Label__c | Text(255) | The label used to describe the contact in the Document Collaborator Search wizard. |
Contact Verification
The Contact Verification (mvn__PP_Contact_Verification__c) custom
object tracks contact verification details and is on the detail side of
a master-detail relationship with the Contact object.
Contact Verification schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Comments | mvn__PP_Comments__c | Text Area(255) | Text area for contact verification comments. |
| Consent Language | mvn__PP_Consent_Language__c | Rich Text Area(32768) | Rich text area for contact verification consent language. |
| Contact | mvn__PP_Contact__c | Master-Detail(Contact) | Master-detail relationship to the contact. |
| Contact Verification # | Name | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Document Author | mvn__PP_Document_Author__c | Lookup(Document Collaborator) | Lookup relationship to the document author, filtered based on contact. |
| Expiration Date | mvn__PP_Expiration_Date__c | Date | Contact's verification expiration date. |
| External ID | mvn__PP_External_Id__c | Text(50) (External ID) (Unique Case Sensitive) | Unique identifier from an external source system. |
| External Source | mvn__PP_External_Source__c | Text(255) | Name of the external system sourcing the contact data. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Record Type | RecordTypeId | Record Type | Id of the record type. Record types include: - Author Agreement - contact verification type for external collaborator author agreement. - Background Check - contact verification type for external collaborator background check. - Conflicts of Interest - contact verification type for external collaborator providing conflicts of interest. - Editorial Support Agreement - contact verification type for external collaborator editorial support agreement. |
| Status | mvn__PP_Status__c | Picklist | Picklist indicating the contact verification status. |
| Verification Date | mvn__PP_Verification_Date__c | Date | Date the contact's verification was performed. |
Data Checklist
The Data Checklist (mvn__PP_Data_Checklist__c) custom object stores
publication document data checklist questions and responses.
Data Checklist schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Data Checklist # | Name | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
| Document | mvn__PP_Document__c | Lookup(Document) | Lookup relationship to the document. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who owns the record. |
| Related Document | mvn__PP_Related_Document__c | Lookup(Document) | Lookup relationship to the publication document related to the data checklist document. |
| Status | mvn__PP_Status__c | Picklist | Picklist indicating the status of the document checklist. |
Debug Log
The Debug Log (mvn__Debug_Log__c) custom object stores application
warnings and error logs.
mvn__Debug_Log__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Body | mvn__Body__c | Text(255) | The full error or warning message. |
| Class | mvn__Class__c | Text(50) | The class name, if applicable. |
| Log Number | Name | Auto Number | The auto-generated record name. |
| LWC | mvn__LWC__c | Text(50) | The name of the Lightning Web Component, if applicable. |
| Message | mvn__Message__c | Text(255) | The debug message. |
| Method | mvn__Method__c | Text(50) | The method name, if applicable. |
| Severity | mvn__Severity__c | Picklist | The severity of the log. Picklist values include: - ERROR - WARN - INFO - DEBUG - FINE - FINER - FINEST |
| Stack Trace | mvn__Stack_Trace__c | Text(255) | The stack trace for the exception, if applicable. |
Document
Document (mvn__CM_Document__c) is a fundamental custom object
consisting of metadata. Each Document record can have many associated
Document Version records.
note
Any field listed below whose API name has the mvn__PP_DS prefix is
only available as part of the Digital Science
integration to store data returned from Digital Science.
If you do not have the Digital Science package installed, you will not
have that field in your instance of Scientific Publications Cloud product. Likewise, any field
listed below whose API name has the mvn__PP_UP prefix is only
available as part of the Unpaywall
integration. If you do not have the Unpaywall package
installed, you will not have that field in your instance of Scientific Publications Cloud product.
mvn__CM_Document__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Active | mvn__PP_Active__c | Checkbox | |
| Annual Plan | mvn__PP_Plan_Budget__c | Lookup | Lookup relationship to the annual plan. |
| Cloned From | mvn__CM_Cloned_From__c | Lookup(Document) | The related Document (mvn__CM_Document__c) record from which this document was cloned. |
| Concept | mvn__PP_Concept__c | Lookup(Concept) | |
| Created By Name | mvn__CM_Created_By_Name__c | Formula | |
| Customer Id | mvn__CM_Customer_Id__c | Text(255) | Enables CSOs to segment documents by customers. |
| Document Lifecycle Developer Name | mvn__CM_Document_Lifecycle_Developer_Name__c | Text(255) | Developer name of the Document Lifecycle this Document is associated with. |
| Document Number | Name | Auto Number | |
| DOI | mvn__PP_DOI__c | Formula | Formula field referencing the Latest Document Version Digital Object Identifier. DOI is a unique article ID provided when the article is published and made available electronically. |
| DS Altmetric ID | mvn__PP_DS_Altmetric_ID__c | Text(255) (External ID) | The Digital Science Altmetric article ID. |
| DS Altmetric Score | mvn__PP_DS_Altmetric_Score__c | Number(10, 0) | The Digital Science Altmetric attention score. |
| DS Altmetric URL | mvn__PP_DS_Altmetric_URL__c | URL | The link to the Digital Science article data on the Altmetric platform. |
| DS Article Citations Count | mvn__PP_DS_Article_Citations_Count__c | Number(10, 0) | The number of citations the Digital Science article has received since its publication. |
| DS Article News Count | mvn__PP_DS_Article_News_Count__c | Number(10, 0) | The number of news stories mentioning the Digital Science article since its publication. |
| DS Article Policy Count | mvn__PP_DS_Article_Policy_Count__c | Number(10, 0) | The number of policy documents citing the Digital Science article since its publication. |
| DS Article Policy Relative Index | mvn__PP_DS_Article_Policy_Relative_Index__c | Number(10, 2) | The Digital Science policy citations divided by the equivalent baseline values to produce an indication of relative performance. |
| DS Article Score Relative Index | mvn__PP_DS_Article_Score_Relative_Index__c | Number(10, 2) | The Digital Science Altmetric attention score divided by the equivalent baseline values to produce an indication of relative performance. |
| DS Article Twitter Count | mvn__PP_DS_Article_Twitter_Count__c | Number(10, 0) | The number of Tweets mentioning the Digital Science article since its publication. |
| DS Authors JSON | mvn__PP_DS_Authors_JSON__c | Long Text Area(3000) | The Digital Science list of article authors. This is in JSON format. |
| DS Badge URL | mvn__PP_DS_Badge_URL__c | URL | The link to the Digital Science article's Altmetric Badge. |
| DS Dimensions ID | mvn__PP_DS_Dimensions_ID__c | Text(255) (External ID) | The Digital Science Dimensions article ID. |
| DS Dimensions URL | mvn__PP_DS_Dimensions_URL__c | URL | The link to the Digital Science article data on the Dimensions platform. |
| DS Field Citation Ratio | mvn__PP_DS_Field_Citation_Ratio__c | Number(10, 2) | The Digital Science Field Citation Ratio (FCR). FCR is a field-normalized citation-based metric that is calculated once an article is two years old. |
| DS Journal ID | mvn__PP_DS_Journal_ID__c | Text(255) (External ID) | The Digital Science Dimensions journal ID. |
| DS Last Modified Date/Time | mvn__PP_DS_Last_Modified_Date_Time__c | Date/Time | The date and time that the Digital Science article was last updated. |
| DS Open Access | mvn__PP_DS_Open_Access__c | Picklist | Whether or not there is open access to the Digital Science article. |
| DS Publication Year | mvn__PP_DS_Publication_Year__c | Text(20) | The Digital Science article publication year. |
| DS RCDC Categories | mvn__PP_DS_RCDC_Categories__c | Long Text Area(10000) | The Digital Science list of Research, Condition and Disease Categorization (RCDC) values. |
| DS Title | mvn__PP_DS_Title__c | Text(255) | The Digital Science article title. |
| External Content Version Id | mvn__CM_External_Content_Version_Id__c | Text(18) | The ID of the latest external ContentVersion record associated with the document. |
| Language | mvn__CM_Latest_Version_Language__c | Formula | |
| Latest Version | mvn__CM_Latest_Version__c | Lookup | Document Version with highest version number. |
| Latest Document Version Classification | mvn__PP_Latest_Version_Classification__c | Formula | Latest Document Version Classification. |
| Mute Document Level Notifications? | mvn__CM_Mute_Document_Level_Notifications__c | Checkbox | When true, the system event notifications for the document are muted. |
| Pending Sharing Document | mvn__CM_Pending_Sharing_Update__c | Checkbox | When true, the document's related records need to be synced and a warning message will appear on the Document Collaborators related list to indicate that a sync is pending or in process. |
| Preview | mvn__CM_Preview__c | Formula | |
| Publication Plan | mvn__PP_Plan__c | Lookup | Lookup relationship to the plan. |
| Status | mvn__CM_Latest_Version_Status__c | Formula | |
| Studies | mvn__PP_Studies__c | Text(255) | Semicolon delimited list of study names related to the document. Studies are added or removed whenever a related Study Document is created or deleted. |
| Subtype | mvn__CM_Latest_Version_Subtype__c | Formula | |
| Title | mvn__CM_Latest_Version_Title__c | Formula | |
| Type | mvn__CM_Latest_Version_Type__c | Formula | |
| UP Article is Open Access | mvn__PP_UP_Article_is_Open_Access__c | Checkbox | Unpaywall boolean that indicates if the resource is open access. |
| UP Article is Paratext | mvn__PP_UP_Article_is_Paratext__c | Checkbox | Unpaywall boolean that indicates if the article is an ancillary part of a journal (e.g. a table of contents). |
| UP Authors JSON | mvn__PP_UP_Authors_JSON__c | Text Area (Long) | Unpaywall JSON list of article authors. |
| UP Best OA Host Type | mvn__PP_UP_Best_OA_Host_Type__c | Picklist | Unpaywall type of host that serves this open access location. |
| UP Best OA Landing URL | mvn__PP_UP_Best_OA_Landing_URL__c | URL | Unpaywall URL for a landing page describing this OA copy. - When the Host Type is ""publisher"" the landing page usually includes HTML fulltext." |
| UP Best OA License | mvn__PP_UP_Best_OA_License__c | Text | Unpaywall license under which this copy is published. |
| UP Best OA Location JSON | mvn__PP_UP_Best_OA_Location_JSON__c | Text Area (Long) | Unpaywall best open access location object for the article DOI. |
| UP Best OA PDF URL | mvn__PP_UP_Best_OA_PDF_URL__c | URL | Unpaywall URL to the resource PDF. |
| UP Best OA URL | mvn__PP_UP_Best_OA_URL__c | URL | Unpaywall resource URL. Will be the PDF URL if there is one, otherwise it will be the Landing URL. |
| UP Best OA Version | mvn__PP_UP_Best_OA_Version__c | Picklist | Unpaywall content version accessibility at this location. - Submitted Version = not yet peer reviewed - Accepted Version = peer reviewed, but lacks publisher-specific formatting - Published Version = the version of the record |
| UP Data Standard | mvn__PP_UP_Data_Standard__c | Number | Unpaywall indication for the data collection approaches used for this resource. - 1 = First-generation hybrid detection - 2 = Second-generation hybrid detection |
| UP DOI URL | mvn__PP_UP_DOI_URL__c | URL | Unpaywall DOI hyperlink. |
| UP First OA Location JSON | mvn__PP_UP_First_OA_Location_JSON__c | Text Area (Long) | Unpaywall first open access location object for the article DOI. |
| UP Genre | mvn__PP_UP_Genre__c | Text(255) | Unpaywall type of resource. |
| UP Journal is in DOAJ | mvn__PP_UP_Journal_is_in_DOAJ__c | Checkbox | Unpaywall boolean that indicates if the resource is published in a DOAJ indexed journal. |
| UP Journal is Open Access | mvn__PP_UP_Journal_is_Open_Access__c | Checkbox | Unpaywall boolean that indicates if the resource published in a completely OA journal. |
| UP Journal ISSN-L | mvn__PP_UP_Journal_ISSN_L__c | Text(255) | Unpaywall primary ISSN for the journal publishing this resource. |
| UP Journal ISSNs | mvn__PP_UP_Journal_ISSNs__c | Text(255) | Unpaywall list of ISSNs assigned to the journal publishing this resource. |
| UP Journal Name | mvn__PP_UP_Journal_Name__c | Text(255) | Unpaywall name of the journal publishing this resource. |
| UP Journal Publisher | mvn__PP_UP_Journal_Publisher__c | Text(255) | Unpaywall name of the journal publisher for this resource. |
| UP Last Modified Date/Time | mvn__PP_UP_Last_Modified_Date_Time__c | Date/Time | Unpaywall date/time the article location was last updated. |
| UP Open Access Status | mvn__PP_UP_Open_Access_Status__c | Picklist | Unpaywall classification of open access status. |
| UP Publication Year | mvn__PP_UP_Publication_Year__c | Text(10) | Unpaywall year the resource was published. |
| UP Published Date | mvn__PP_UP_Published_Date__c | Date | Unpaywall date the resource was published. |
| UP Title | mvn__PP_UP_Title__c | Text(255) | Unpaywall article title. |
Document Collaborator
The Document Collaborator (mvn__PP_Document_Author__c) custom object
is a junction between the
Contact standard object and the
Document (mvn__CM_Document__c) custom object. Each
Document Collaborator record stores information about a single document
collaborator on a given document and can relate to several Contact
Verification (mvn__PP_Contact_Verification__c) records.
mvn__PP_Document_Author__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Account Name | mvn__PP_Account_Name__c | Formula (Text) | A sortable formula field with the related contact's account name. |
| Assigned Roles | mvn__PP_Assigned_Roles__c | Picklist (Multi-Select) | The author's assigned document role(s). The available picklist values should align with the existing metadata records on the Role (mvn__CM_Role__mdt) custom metadata type. Picklist values include, but are not limited to: - Approver - Author - Publication Specialist |
| Author Agreement | mvn__PP_Author_Agreement__c | Formula (Text) | The details of the document collaborator's author agreement verification. |
| Author Agreement Verification | mvn__PP_Author_Agreement_Verification__c | Lookup(Contact Verification) | The related Contact Verification (mvn__PP_Contact_Verification__c) record representing the author agreement for the related document. |
| Author Contact | mvn__PP_Author_Contact__c | Lookup(Contact) | The related Contact record. |
| Background Check | mvn__PP_Background_Check__c | Formula (Text) | The details of the related contact's latest background check. |
| Conflicts of Interest | mvn__PP_Conflicts_of_Interest__c | Formula (Text) | The details of the document collaborator's conflicts of interest verification. |
| Conflicts of Interest Verification | mvn__PP_Conflicts_of_Interest_Verification__c | Lookup(Contact Verification) | The related Contact Verification (mvn__PP_Contact_Verification__c) record representing the conflicts of interest for the related document. |
| Contact Name | mvn__PP_Contact_Name__c | Formula (Text) | A sortable formula field with the related contact's name. |
| Document | mvn__PP_Document__c | Lookup(Document) | The related Document (mvn__CM_Document__c) record. |
| Document Collaborator # | Name | Auto Number | The unique identifier for the Document Collaborator record. It is formatted as DA-\{0000000\} and generates and increments automatically. |
| Document Roles | mvn__PP_Document_Roles__c | Rich Text Area(32768) | The assigned roles of the document collaborator on the related document. This is formatted so that users can click on each role to view its permissions. Note: This field does not store any data. It is only used for display purposes in the Pubs - Related Document Authors ( ppRelatedDocumentAuthors) component. |
| Document Title | mvn__PP_Document_Title__c | Formula (Text) | The title of the latest version of the related document. |
| Editorial Support | mvn__PP_Editorial_Support__c | Formula (Text) | The details of the document collaborator's editorial support verification. |
| Editorial Support Verification | mvn__PP_Editorial_Support_Verification__c | Lookup(Contact Verification) | The related Contact Verification (mvn__PP_Contact_Verification__c) record representing the editorial support agreement for the related document. |
| External ID | mvn__PP_External_Id__c | Text(50) (External ID) (Unique Case Sensitive) | The unique identifier of the record from an external source system. |
| Group | mvn__PP_Group__c | Lookup(Document Group) | The related Document Group (mvn__CM_Document_Group__c) record. |
| Name | mvn__PP_Name__c | Formula (Text) | The name of the document collaborator. This is formatted so that users can click on the name to open the User or Document Group (mvn__CM_Document_Group__c) record. |
| Notifications? | mvn__PP_Notifications__c | Checkbox | When checked (true), the document collaborator will receive notifications for a specific document. When unchecked (false), notifications from a given document are muted for the document collaborator. |
| Role | mvn__PP_Role__c | Picklist | The default or initial role of the document collaborator on a given document. The available picklist values should align with the existing metadata records on the Role (mvn__CM_Role__mdt) custom metadata type. Picklist values include, but are not limited to: - Author - Reviewer - Approver |
| Status | mvn__PP_Status__c | Picklist | The status of the document collaborator. Possible picklist values are: - Pending - Active - Inactive |
| User | mvn__PP_User__c | Lookup(User) | The related User record. |
| User Status | mvn__PP_User_Status__c | Formula (Text) | The status of the related contact. Possible statuses are: - Pending - Active - Inactive |
| User Type | mvn__PP_User_Type__c | Formula (Text) | The icon used to represent the document collaborator based on the Document Collaborator record type. The icon is derived from the PP_Default metadata record on the Pubs Global Setting (mvn__PP_Global_Setting__mdt) custom metadata type.Note: This field does not store any data. It is only used for display purposes in the Pubs - Related Document Authors ( ppRelatedDocumentAuthors) component. |
| User Type Label | mvn__PP_User_Type_Label__c | Text(255) | The label used to describe the document collaborator based on the Document Collaborator record type. The label is derived from the PP_Default metadata record on the Pubs Global Setting (mvn__PP_Global_Setting__mdt) custom metadata type.Note: This field does not store any data. It is only used for display purposes in the Pubs - Related Document Authors ( ppRelatedDocumentAuthors) component. |
Document Group
Document groups define groups of users and are maintained in the
CM_Document_Group__c custom object. A document group is always
associated with both a Public Group and a Group.
mvn__CM_Document_Group__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Document Group Name | Name | Text(80) | Name of the Document Group |
| Group Developer Name | mvn__CM_Group_Developer_Name__c | Text(255) | DeveloperName of the associated Group__mdt record |
| Public Group Id | mvn__CM_Public_Group_Id__c | Text(255) | The ID of the Salesforce Public Group |
Document Metric
The Document Metric (mvn__PP_DS_Document_Metric__c) custom object is
used to store Digital Science (Altmetric and Dimensions) article
metrics.
note
The Document Metric custom object is only available as part of the Digital Science integration. If you do not have the Digital Science package installed, you will not have this custom object in your instance of Scientific Publications Cloud product.
mvn__PP_DS_Document_Metric__c
| Field label | API name | Data type | Description |
|---|---|---|---|
| Document | mvn__PP_DS_Document__c | Lookup(Document) | The related Document (mvn__CM_Document__c) record. |
| Document Metric # | Name | Auto Number | The unique identifier of the Document Metric record. It is formatted as DM-\{0000000\} and generates and increments automatically. |
| DS Document Metrics JSON | mvn__PP_DS_Document_Metrics_JSON__c | Long Text Area(131072) | The Digital Science document metrics. This is JSON data returned from Digital Science as part of the Digital Science integration. |
| DS Last Modified Date/Time | mvn__PP_DS_Last_Modified_Date_Time__c | Date/Time | The date and time when the document metric was last updated in Digital Science. |
| Source | mvn__PP_DS_Source__c | Text(255) | The name of the external system sourcing the document metric data. |
Document Region
Document Region (CM_Document_Region__c) is a junction between the
Region and Document Version custom objects. A validation rule ensures
that a Document Region can only be created if it looks up to a Region
and a Document Version.
mvn__CM_Document_Region__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Country ISO Code | mvn__CM_Country_ISO_Code__c | Formula(Text) | ISO 3166-1 country code. |
| Document Region Name | Name | Auto Number | Auto-generated name of the document region. |
| Document Version | mvn__CM_Document_Version__c | Master-Detail(Document Version) | Associated version of a document. |
| External ID | mvn__CM_External_ID__c | Text(255) (External ID) (Unique Case Insensitive) | External ID used for Apex DML purposes. |
| Region | mvn__CM_Region__c | Lookup(Region) | Associated region. |
Document Relationship
Document Relationship (mvn__CM_Document_Relationship__c) is a
polymorphic junction object between either:
-
Document version and document version
Document version and document version relationship
Document Version 1 Document Version 2 Product Category Type <document version 1 ID> <document version 2 ID> Document Bundle -
Document version and product
Document version and product relationship
Document Version 1 Document Version 2 Product Category Type <document version 1 ID> <product ID> Product
A document relationship record is deleted if one of the lookup objects
it connects is deleted. For example, a document relationship connecting
Document A to Document B is deleted if either Document A or
Document B is deleted.
mvn__CM_Document_Relationship__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Category | CM_Category__c | Formula(Text) | Category of the relationship (document vs product). |
| Controlling Document Version Id | CM_Controlling_Document_Version_Id__c | Formula (Text) | Either Document Version 1 or Document Version 2. If the value of CM_Type__c is Local Version or Translation, the Controlling Document Version Id is Document Version 1. If the value of CM_Type__c is Bundle, Relevant, or Sourced, the Controlling Document Version Id is Document Version 2. The Controlling Document Version Id field is only set when the CM_Category__c equals Document. |
| Dependent Document Name | CM_Dependent_Document_Name__c | Formula (Text) | Either Document Version 1 or Document Version 2. If the value of CM_Type__c is Local Version or Translation, the Dependent Document Name is Document Version 2. If the value of CM_Type__c is Bundle, Relevant, or Sourced, the Dependent Document Name is Document Version 1. The Dependent Document Name field is only set when the CM_Category__c equals Document. |
| Document Relationship Name | Name | Auto Number | Autogenerated record name. |
| Document Version 1 | CM_Document_Version_1__c | Lookup(Document Version) | Version that is the source of the relationship. |
| Document Version 2 | CM_Document_Version_2__c | Lookup(Document Version) | Version that is the target of the relationship. |
| Document Version 2 Name | CM_Document_Version_2_Name__c | Formula (Text) | Fully qualified name of the target version. |
| External ID | CM_External_ID__c | Text(255) (External ID) (Unique Case Insensitive) | External ID used for Apex DML purposes. |
| Product | CM_Product__c | Lookup(Product) | Product associated to Document Version 1. |
| Type | CM_Type__c | Picklist | Type of the relationship if the Category is a document-document relationship. Visit Relationships. |
Document Role
Document Role is a child to Document and is managed in the
CM_Document_Role__c custom object.
mvn__CM_Document_Role__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Document | mvn__CM_Document__c | Master-Detail(Document) | Document associated to this Document Role. |
| Document Group | mvn__CM_Document_Group__c | Lookup(Document Group) | Document Group associated to this Document Role. |
| Document Role Name | Name | Auto Number | Name of the Document Role. |
| External ID | mvn__CM_External_ID__c | Text(255) (External ID) (Unique Case Insensitive) | For Apex DML purposes. |
| Public Group ID | mvn__CM_Public_Group_ID__c | Formula (Text) | ID of the Public Group associated to this Document Role, if one exists (via the Document Group). |
| Role Custom Label API Name | mvn__CM_Role_Custom_Label_API_Name__c | Text(255) | Stamped with the Custom Label API Name defined on the Role. |
| Role Developer Name | mvn__CM_Role_Developer_Name__c | Text(255) | Stamped with the DeveloperName of the Role. |
| Role User Name | mvn__CM_Role_User_Name__c | Formula (Text) | Name of the user associated to this Document Role, if one exists (via the user). |
| User | mvn__CM_User__c | Lookup(User) | User associated to this Document Group. |
Document Role Share
The Document Role Share (mvn__CM_Document_Role_Share__c) object is a
utility object for keeping track of sharing records for various objects.
mvn__CM_Document_Role_Share__c
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | CreatedById | Lookup(User) | ID of the user that created the record. |
| Document Role | mvn__CM_Document_Role__c | Master-Detail(Document Role) | Document roles manage users or groups and their associated role(s) on a document. This field has a Master-detail relationship to the Document Role Share object. |
| Document Role Share Name | Name | Auto Number | Automatically incremented record number. |
| Last Modified By | LastModifiedById | Lookup(User) | ID of the user that last modified the record. |
| Object Share ID | mvn__CM_Object_Share_Id__c | Text(18) (External ID) | ID of the Object Share record associated to the Document Role Share object. |
| Share Object Name | mvn__CM_Share_Object_Name__c | Text(255) | The name of the Share object this record makes reference to, e.g. mvn__CM_Document_Version__Share. |
Document Version
A mvn__CM_Document_Version__c record maps to a mvn__CM_Document__c
record. Many mvn__CM_Document_Version__c records can map to the same
mvn__CM_Document__c record. Each mvn__CM_Document_Version__c record
associated to the same mvn__CM_Document__c record can have different
metadata and a different internal or external file associated to it.
warning
Ships with a mvn__CM_Document_Version__c field set named
mvn__CM_System_Fields. This field set is considered protected system
metadata and should not be modified or deleted.
note
Any field listed below whose API name has the mvn__PP_DS prefix is
only available as part of the Digital Science
integration to store data returned from Digital Science
on the parent Document (mvn__CM_Document__c) record. If you do not
have the Digital Science package installed, you will not have that field
in your instance of Scientific Publications Cloud product.
mvn__CM_Document_Version__c Schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Allowed Audience | mvn__CM_Allowed_Audience__c | Picklist (Multi-Select) | Audience allowed to use the document version. |
| Annual Plan | mvn__PP_Plan_Budget__c | Lookup(Annual Plan) | Lookup relationship to the Annual Plan. |
| Answer | mvn__CM_Answer__c | Rich Text Area(32768) | FAQ answer content for a FAQ document version. |
| Approved Channels | mvn__CM_Approved_Channels__c | Picklist (Multi-Select) | Channels where the document version can be consumed. |
| Authors | mvn__PP_Authors__c | Long Text Area(10000) | List of publication article authors. |
| Changelog | mvn__CM_Changelog__c | Text Area(255) | Description of changes made to a document version. The Changelog for the first version of a document is blank. |
| Check Out Date Time | mvn__CM_Check_Out_Date_Time__c | Date/Time | Date and time when the document version was checked out. |
| Check Out Id | mvn__CM_Check_Out_Id__c | Text(36) (External ID) | Unique identifier for the checkout. |
| Check Out Type | mvn__CM_Check_Out_Type__c | Picklist | Type of check out the user requested. Picklist values include: - Office365 - Local - FilesConnect |
| Check Out URL | mvn__CM_Check_Out_URL__c | URL(255) | URL where the file is stored in Microsoft 365. |
| Check Out User | mvn__CM_Check_Out_User__c | Lookup(User) | User who checked out the document version. |
| Check Out User Name | mvn__CM_Check_Out_User_Name__c | Formula (Text) | Full name of the user who checked out the document version. |
| Checked Out | mvn__CM_Checked_Out__c | Formula (Checkbox) | Whether the document version is currently checked out. |
| Citation | mvn__PP__Citation__c | Long Text Area(10000) | Publication article citation. |
| Classification | mvn__CM_Classification__c | Picklist | Classification of the document version. Classification depends on Document Subtype. Visit Document Types. |
| Concept | mvn__PP_Concept__c | Lookup(Concept) | Lookup relationship to the concept. |
| Content (rich text) | mvn__CM_Content_Rich_Text__c | Rich Text Area(32768) | A rich text field. For documents without files, content in this field will appear in the document preview. Merge fields are supported. For more information, reference Salesforce's documentation on Merge Fields. |
| Content Version Id | mvn__CM_Content_Version_Id__c | Text(18) (External ID) | Content Version ID of a file that is associated to the document version. |
| Delivery Option | mvn__CM_Delivery_Option__c | Picklist | Approved fulfillment delivery options for the document version. |
| Description | mvn__CM_Description__c | Text Area(255) | Description of the document version. |
| Document | mvn__CM_Document__c | Lookup(Document) | Parent document of the document version. |
| Document Lifecycle | mvn__CM_Document_Lifecycle__c | Formula (Text) | Lifecycle is the parent document. Visit Document lifecycles. |
| Document Number | mvn__CM_Document_Number__c | Formula (Text) | Document number of the parent document. |
| Document Response ID | mvn__CM_Document_Response_ID__c | Long Text Area(1000) | Comma-separate list of document request IDs associated to the document version. |
| Document Subtype | mvn__CM_Document_Subtype__c | Picklist | Subtype of the document version. Subtype depends on Document Type and controls Document Classification. Visit Document Types. |
| Document Type | mvn__CM_Document_Type__c | Picklist | Document Type of the document version. Visit Document Types. |
| Document Version Name | Name | Auto Number | Automatically generated name of the document version. |
| DOI | mvn__PP_DOI__c | Text(255) (External ID) (Unique Case Insensitive) | Digital Object Identifier (DOI) is a unique article ID provided when the article is published and made available electronically. |
| DS Altmetric Score | PP_DS_Altmetric_Score__c | Formula | The Digital Science Altmetric attention score. |
| DS Article Citations Count | PP_DS_Article_Citations_Count__c | Formula | The number of citations the Digital Science article has received since its publication. |
| DS Article News Count | PP_DS_Article_News_Count__c | Formula | The number of news stories mentioning the Digital Science article since its publication. |
| DS Article Policy Count | PP_DS_Article_Policy_Count__c | Formula | The number of policy documents citing the Digital Science article since its publication. |
| DS Article Policy Relative Index | PP_DS_Article_Policy_Relative_Index__c | Formula | The Digital Science policy citations divided by the equivalent baseline values to produce an indication of relative performance. |
| DS Article Score Relative Index | PP_DS_Article_Score_Relative_Index__c | Formula | Digital Science Altmetric attention score divided by the equivalent baseline values to produce an indication of relative performance. |
| DS Article Twitter Count | PP_DS_Article_Twitter_Count__c | Formula | The number of Tweets mentioning the Digital Science article since its publication. |
| DS Field Citation Ratio | PP_DS_Field_Citation_Ratio__c | Formula | The Digital Science Field Citation Ratio (FCR). FCR is a field-normalized citation-based metric that is calculated once an article is two years old. |
| DS Last Modified Date/Time | PP_DS_Last_Modified_Date_Time__c | Formula | The date and time that the Digital Science article was last updated. |
| DS Open Access | PP_DS_Open_Access__c | Formula | Whether or not there is open access to the Digital Science article. |
| Expected Start Date | mvn__PP_Expected_Start_Date__c | Date | The anticipated start date for the document. |
| Expiration Date | mvn__CM_Expiration_Date__c | Date/Time | Expiration date of the document version. |
| Expiration Reminder Date | mvn__CM_Expiration_Reminder_Date__c | Date | Date when expiration reminders are sent. |
| External File | mvn__CM_External_File__c | Checkbox | Whether the document version points to an external file. |
| External URL | mvn__CM_External_URL__c | URL(255) | URL of an externally hosted file that is associated to the document version. |
| File Extension | mvn__CM_File_Extension__c | Text(40) | Extension of the related file. |
| File Id | mvn__CM_File_Id__c | Text(255) (External ID) | File ID of a file that is associated the document version. |
| File Size | mvn__CM_File_Size__c | Number(9, 0) | Size of the associated file in bytes. |
| Fully Qualified Name | mvn__CM_Fully_Qualified_Name__c | Formula (Text) | Fully Qualified Name of the document version. The Fully Qualified Name is comprised of the Title followed by the Version Number. For example, if the Fully Qualified Name of a document version is Dosing Guide (v0.4), Dosing Guide is the Title, and 0.4 is the Version Number. |
| Is Clone | mvn__CM_Is_Clone__c | Checkbox | True when the document version has been cloned from an existing document. |
| Is Latest Version | mvn__CM_Is_Latest_Version__c | Checkbox | Whether this is the latest document version of the document record that the document version is associated to. |
| Language | mvn__CM_Language__c | Picklist | Language of the document version. |
| Latest Document Version ID | mvn__CM_Latest_Document_Version_ID__c | Formula (Text) | Record ID of the latest document version. |
| Latest Version Number | mvn__CM_Latest_Version_Number__c | Formula (Text) | Version number of the latest document version. |
| Latest Version Title | mvn__CM_Latest_Version_Title__c | Formula (Text) | Title of the latest document version. |
| Major Version Number | mvn__CM_Major_Version_Number__c | Number(18, 0) | Major version number of the document version. For example, if the Version Number is 5.4, the Major Version Number is 5. |
| Metadata Last Modified By | mvn__CM_Metadata_Last_Modified_By__c | Lookup(User) | User who last modified the document version's metadata. Note: This Metadata Last Modified By field should be used in place of Salesforce's standard Last Modified By ( LastModifiedById) field. This is because the Last Modified By field is updated frequently by hidden and automatic processes. |
| Metadata Last Modified Date | mvn__CM_Metadata_Last_Modified_Date__c | Date/Time | Date and time when the document version metadata was last modified. |
| Minor Version Number | mvn__CM_Minor_Version_Number__c | Number(18, 0) | Minor version number of the version. For example, if the Version Number is 5.4, the Minor Version Number is 4. |
| Preview | mvn__CM_Preview__c | Text Area(255) | Plain text preview of the document version. |
| Previous Document Version | mvn__CM_Previous_Document_Version__c | Lookup(Document Version) | Previous version of the document. |
| Primary Target | mvn__PP_Primary_Target__c | Lookup(Target) | Lookup relationship to the primary target. A document can have only one target marked as primary. |
| Product | mvn__CM_Product__c | Picklist (Multi-Select) | System field for querying products related to the document version. This field will not display data when queried using the standard API. Visit Products Note: Product is an internal system field and should not be modified in any way. |
| Products | mvn__CM_Products__c | Text(255) | An automated list of products from Document Relationship (CM_Document_Relationship__c) records. This is displayed on the Documents list view page and used for sorting MCM Product (mvn__CM_Product__c) records. |
| Publication Plan | mvn__PP_Plan__c | Lookup(Publication Plan) | Lookup relationship to the plan. |
| Question | mvn__CM_Question__c | Text Area(255) | FAQ question content for a FAQ document version. |
| Region | mvn__CM_Region__c | Picklist (Multi-Select) | System field for querying regions related to the document version. This field will not display data when queried using the standard API. Visit Regions . Note: Region is an internal system field and should not be modified in any way. |
| Regions | mvn__CM_Regions__c | Text(255) | An automated list of regions from Document Region (CM_Document_Region__c) records. This is displayed on the Documents list view page and used for sorting Region (mvn__Region__c) records. |
| Scheduled Publish Date | mvn__CM_Scheduled_Publish_Date__c | Date/Time | Date and time when the document version is scheduled to be published. |
| Status | mvn__CM_Status__c | Text(255) (External ID) | DeveloperName of the CM_Status__mdt associated to the document version. |
| Status Custom Label | mvn__CM_Status_Custom_Label__c | Text(255) (External ID) | Custom label for the document version's status. |
| Thumbnail | mvn__CM_Thumbnail__c | Formula (Text) | Relative URL of the thumbnail rendition. |
| Title | mvn__CM_Title__c | Text(255) (External ID) | Title of the document version, e.g. Dosing Guide. Title does not include Version Number. |
| UP Article is Open Access | PP_UP_Article_is_Open_Access__c | Formula (Checkbox) | Unpaywall boolean that indicates if the resource is open access. |
| UP Best OA Host Type | mvn__PP_UP_Best_OA_Host_Type__c | Formula (Text) | Unpaywall type of host that serves this open access location. |
| UP Best OA URL | mvn__PP_UP_Best_OA_URL__c | Formula (URL) | Unpaywall resource URL. Will be the PDF URL if there is one, otherwise it will be the Landing URL. |
| UP DOI URL | mvn__PP_UP_DOI_URL__c | Formula (URL) | Unpaywall DOI hyperlink. |
| UP Journal is Open Access | mvn__PP_UP_Journal_is_Open_Access__c | Formula (Checkbox) | Unpaywall boolean that indicates if the resource published in a completely OA journal. |
| UP Journal ISSN-L | mvn__PP_UP_Journal_ISSN_L__c | Formula (Text) | Unpaywall primary ISSN for the journal publishing this resource. |
| UP Journal ISSNs | mvn__PP_UP_Journal_ISSNs__c | Formula (Text) | Unpaywall list of ISSNs assigned to the journal publishing this resource. |
| UP Journal Name | mvn__PP_UP_Journal_Name__c | Formula (Text) | Unpaywall name of the journal publishing this resource. |
| UP Open Access Status | mvn__PP_UP_Open_Access_Status__c | Formula (Picklist) | Unpaywall classification of open access status. |
| UP Publication Year | mvn__PP_UP_Publication_Year__c | Formula (Text) | Unpaywall year the resource was published. |
| UP Published Date | mvn__PP_UP_Published_Date__c | Formula (Text) | Unpaywall date the resource was published. |
| Version Number | mvn__CM_Version_Number__c | Formula (Text) | Version Number of the document version, e.g. 5.4 where 5 is the Major Version Number and 4 is the Minor Version Number. |
Document Version Package File
The Document Version Package File
(mvn__CM_Document_Version_Package_File__c) custom object relates
multiple files, or package files, to a single document version and
stores the checkout information of the package files.
mvn__CM_Document_Version_Package_File__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Check Out Date Time | mvn__CM_Check_Out_Date_Time__c | Date/Time | The date and time when the package file was checked out. |
| Check Out Id | mvn__CM_Check_Out_Id__c | Text(36) (External ID) | The unique identifier for the package file checkout. |
| Check Out URL | mvn__CM_Check_Out_URL__c | URL(255) | The URL of where the package file was checked out (e.g., in Microsoft 365). |
| Check Out User | mvn__CM_Check_Out_User__c | Lookup(User) | The related User record of the user who checked out the package file. |
| Check Out User Name | mvn__CM_Check_Out_User_Name__c | Formula (Text) | The full name of the user who checked out the package file. |
| Checked Out | mvn__CM_Checked_Out__c | Formula (Checkbox) | Indicates whether or not the package file is currently checked out. |
| Content Document Id | mvn__CM_Content_Document_Id__c | Text(255) (External ID) | The external ID of a ContentDocument record. |
| Document Version | mvn__CM_Document_Version__c | Master-Detail(Document Version) | The parent Document Version (mvn__CM_Document_Version__c) record. |
| Document Version Package File Name | Name | Auto Number | The unique identifier of the Document Version Package File record. It is formatted as DVP-\{0000000\} and generates and increments automatically. |
Document Version Rendition
The Document Version Rendition custom object stores metadata for renditions and is on the detail side of a master-detail relationship with the Document Version custom object. This relationship ensures that if you have access to a Document Version record, you also have access to its Document Version Rendition child records.
CM_Document_Version_Rendition__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Document Version | CM_Document_Version__c | Master-Detail(Document Version) | Document version record to associate the document rendition. |
| Document Version Rendition Name | Name | Auto Number | Autogenerated number of the document version rendition. |
| File Id | CM_File_Id__c | Text(255) (External ID) | File ID associated with the rendition. |
| Type | CM_Type__c | Text(255) (External ID) | Developer name of the rendition type. Visit Renditions. |
Invoice
The Invoice (mvn__PP_Invoice__c) custom object stores budget invoicing
details.
Invoice schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| External Source | mvn__PP_External_Source__c | Text(255) | Name of the external system sourcing the invoice data. |
| Invoice # | Name | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who created the record. |
| Annual Plan | mvn__PP_Plan_Budget__c | Lookup(Annual Plan) | Lookup relationship to the plan budget. |
Journal
The Journal (mvn__PP_Journal__c) custom object stores journal details
and has a master-detail relationship with the Journal
Metrics (mvn__PP_Journal_Metrics__c) custom object.
Journal records are related to
Document (mvn__CM_Document__c) records through the
Target (mvn__PP_Target__c) junction object and to
Account records through the
Association (mvn__PP_Association__c) junction object.
note
Any field listed below whose API name has the mvn__PP_DS prefix is
only available as part of the Digital Science
integration to store data returned from Digital Science.
If you do not have the Digital Science package installed, you will not
have that field in your instance of Scientific Publications Cloud product.
mvn__PP_Journal__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Acceptance to Online Publish (Max) | mvn__PP_Acceptance_to_Online_Publish_Max__c | Number(9, 0) | The maximum number of days between the manuscript acceptance and online publish. |
| Acceptance to Online Publish (Min) | mvn__PP_Acceptance_to_Online_Publish_Min__c | Number(9, 0) | The minimum number of days between the manuscript acceptance and online publish. |
| Acceptance to Publish (Max) | mvn__PP_Acceptance_to_Publish_Max__c | Number(9, 0) | The maximum number of days between the manuscript acceptance and publish. |
| Acceptance to Publish (Min) | mvn__PP_Acceptance_to_Publish_Min__c | Number(9, 0) | The minimum number of days between the manuscript acceptance and publish. |
| Accepts Case Reports | mvn__PP_Accepts_Case_Reports__c | Picklist | Whether or not the journal accepts case reports. |
| Accepts Continuing Education | mvn__PP_Accepts_Continuing_Education__c | Picklist | Whether or not the journal accepts continuing education. |
| Accepts Pharmacoeconomics | mvn__PP_Accepts_Pharmacoeconomics__c | Picklist | Whether or not the journal accepts pharmacoeconomics. |
| Accepts Submissions | mvn__PP_Accepts_Submissions__c | Picklist | Whether or not the journal accepts submissions. |
| Altmetric Attention News Count | mvn__PP_DS_Metric_AM_Attn_News_Rel_Index__c | Long Text Area(43691) | The annual total news mentions for the last five years. This is in JSON format. |
| Altmetric Attention Score Mean | mvn__PP_DS_Metric_AM_Attn_Score_Mean__c | Long Text Area(43691) | The annual mean Altmetric score for the last five years. This is in JSON format. |
| Altmetric Attention Score Relative Index | mvn__PP_DS_Metric_AM_Attn_Score_Rel_Index__c | Long Text Area(43691) | The annual mean Altmetric score for the last five years divided by the equivalent baseline values to produce an indication of relative performance. This is in JSON format. |
| Altmetric Attention Top Sources | mvn__PP_DS_Metric_Top_Attn_Sources__c | Long Text Area(43691) | The Altmetric scores of the top sources for the last five years in proportion to one another. This is in JSON format. |
| Altmetric Attention Twitter Rel Index | mvn__PP_DS_Metric_AM_Attn_Twitter_Rel_Index__c | Long Text Area(43691) | The annual mean Twitter mentions for the last five years divided by the equivalent baseline values to produce an indication of relative performance. This is in JSON format. |
| Altmetric Attn Policy Relative Index | mvn__PP_DS_Metric_AM_Attn_Policy_Rel_Index__c | Long Text Area(43691) | The annual mean policy citations for the last five years divided by the equivalent baseline values to produce an indication of relative performance. This is in JSON format. |
| Audience | mvn__PP_Audience__c | Picklist (Multi-Select) | The expected audience subscribing to or reading the journal. |
| Authors Instructions Available | mvn__PP_Authors_Instructions_Available__c | Picklist | Whether or not the journal has instructions for authors. |
| Brief Commentary | mvn__PP_Brief_Commentary__c | Picklist | Whether or not the journal has brief commentary. |
| Clinically Focused | mvn__PP_Clinically_Focused__c | Picklist | Whether or not the journal is clinically focused. |
| CME (Continuing Medical Education) Accredited | mvn__PP_CME_Accredited__c | Picklist | Whether or not the journal is CME accredited. |
| CME/CE (Continuing Medical Education/Continuing Education) Focus | mvn__PP_CME_CE_Focus__c | Picklist | Whether or not the journal is CME/CE focused. |
| Cursory Outlines | mvn__PP_Cursory_Outlines__c | Picklist | Whether or not the journal allows cursory outlines. |
| Customer Article Count (Last 5 years) | mvn__PP_DS_Metric_Customer_Article_Count_L5Y__c | Long Text Area(43691) | The Dimensions annual count of all articles, proceedings, and preprints with client-affiliated authors associated with this journal for the last five years. This is in JSON format. |
| Description | mvn__PP_Description__c | Long Text Area(5000) | The description of the journal. |
| DS Altmetric URL | mvn__PP_DS_Altmetric_URL__c | URL(255) | The link to the Digital Science journal data on the Altmetric platform. |
| DS Dimensions URL | mvn__PP_DS_Dimensions_URL__c | URL(255) | The link to the Digital Science journal data on the Dimensions platform. |
| DS eISSNs | mvn__PP_DS_eISSNs__c | Text(255) | The list of Digital Science journal eISSNs. |
| DS ISSNs | mvn__PP_DS_ISSNs__c | Text(255) | The list of Digital Science journal ISSNs. |
| DS Journal ID | mvn__PP_DS_Journal_ID__c | Text(255) (External ID) | The Digital Science journal ID. |
| DS Journal Name | mvn__PP_DS_Journal_Name__c | Text(255) | The Digital Science journal name. |
| DS Last Modified Date/Time | mvn__PP_DS_Last_Modified_Date_Time__c | Date/Time | The date and time that the Digital Science journal was last updated. |
| DS Publisher | mvn__PP_DS_Publisher__c | Text(255) | The Digital Science journal publisher name. |
| Editorial Board Details | mvn__PP_Editorial_Board_Details__c | Long Text Area(5000) | Details about the journal editorial board. |
| Education Focus | mvn__PP_Education_Focus__c | Picklist | Whether or not the journal is education focused. |
| eISSN | mvn__PP_eISSN__c | Text(150) (External ID) | The Electronic International Standard Serial Number (eISSN) used to uniquely identify a publication. |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Insensitive) | The unique identifier of the journal from an external source system. |
| External Last Modified Date/Time | mvn__PP_External_Last_Modified_Date_Time__c | Date/Time | The date and time that the journal was last updated by the external source. |
| External Source | mvn__PP_External_Source__c | Text(255) | The name of the external system sourcing the journal data. |
| FCR Mean Score | mvn__PP_DS_Metric_FCR_Mean__c | Long Text Area(43691) | The mean Field Citation Ratio (FCR). FCR is a field-normalized citation-based metric that is calculated once an article is two years old. This is in JSON format. |
| Frequency | mvn__PP_Frequency__c | Text(150) | The frequency of the journal publication. |
| Fully Open Access | mvn__PP_Fully_Open_Access__c | Picklist | Whether or not there is full open access to the journal. |
| Impact Factor | mvn__PP_Impact_Factor__c | Number(3, 3) | The journal impact rating provided by PubsHub. |
| Impact Factor Tier | mvn__PP_Impact_Factor_Tier__c | Picklist (Multi-Select) | The journal impact factor tier provided by PubsHub. |
| Index Medicus | mvn__PP_Index_Medicus__c | Text(50) (External ID) | The scientific bioliographic index. |
| Indexed in PubMed / Medline | mvn__PP_Indexed_in_PubMed_Medline__c | Picklist | Whether or not the journal is indexed in PubMed/Medline. |
| ISSN | mvn__PP_ISSN__c | Text(150) (External ID) | The International Standard Serial Number (ISSN) used to uniquely identify a publication. |
| Issues / Year | mvn__PP_Issues_Year__c | Number(7, 0) | The number of journal issues per year. |
| JCR Category | mvn__PP_JCR_Category__c | Picklist (Multi-Select) | The Journal Citation Report (JCR) category. |
| Journal Article Count (Last 5 years) | mvn__PP_DS_Metric_Journal_Article_Count_L5Y__c | Long Text Area(43691) | The annual count of all articles, proceedings, and preprints associated with this journal for the last five years. This is in JSON format. |
| Journal Name | Name | Text(80) | The name of the journal. |
| Journal OA Proportion | mvn__PP_DS_Metric_Journal_OA_Proportion__c | Long Text Area(131072) | The proportion of articles per year over the last five years that are currently open access. This proportion will shift as articles age. This is in JSON format. |
| Journal OA Proportion, Current Year | mvn__PP_DS_Metric_Journal_OA_Proportion_CY__c | Long Text Area(43691) | The proportion of articles in the most recent year that are currently open access. This proportion will shift as articles age. This is in JSON format. |
| Journal Proportion of Top RCDC Cats | mvn__PP_DS_Metric_Jrnl_Prop_of_Top_RCDC_Cats__c | Long Text Area(43691) | The proportion of articles in each of the top Research, Condition, and Disease Categorization (RCDC) categories. This is in JSON format. |
| Language | mvn__PP_Language__c | Picklist (Multi-Select) | The supported languages for the journal. |
| Letters to the Editor | mvn__PP_Letters_to_the_Editor__c | Picklist | Whether or not the journal allows letters to the editor. |
| Notes | mvn__PP_Notes__c | Long Text Area(32768) | Additional notes about the journal. |
| Online Circulation | mvn__PP_Online_Circulation__c | Number(12, 0) | The number of digital journals, articles, or subscribers in circulation. |
| Online Circulation Details | mvn__PP_Online_Circulation_Details__c | Text(255) (External ID) | The details about the online circulation number. |
| Online Only | mvn__PP_Online_Only__c | Picklist | Whether or not the journal is online only. |
| Open Access | mvn__PP_Open_Access__c | Picklist | Whether or not there is open or hybrid access to the journal's published content. |
| Original Research | mvn__PP_Original_Research__c | Picklist | Whether or not the journal has original research. |
| Other Articles Accepted | mvn__PP_Other_Articles_Accepted__c | Long Text Area(32768) | Details about the other articles that have been accepted. |
| Other Publishing Services | mvn__PP_Other_Publishing_Services__c | Long Text Area(32768) | Details about other publishing services. |
| Peer Reviewed | mvn__PP_Peer_Reviewed__c | Picklist | Whether or not the journal is peer reviewed. |
| Policy Focus | mvn__PP_Policy_Focus__c | Picklist | Whether or not the journal is policy focused. |
| Practice Focus | mvn__PP_Practice_Focus__c | Picklist | Whether or not the journal is practice focused. |
| Presubmission Criteria | mvn__PP_Presubmission_Criteria__c | Long Text Area(32768) | Details about the presubmission criteria. |
| Presubmission Package | mvn__PP_Presubmission_Package__c | Picklist | Whether or not the journal allows presubmission packages. |
| Print Circulation | mvn__PP_Print_Circulation__c | Number(12, 0) | The number of print journals or subscribers in circulation. |
| Print Circulation Details | mvn__PP_Print_Circulation_Details__c | Text(255) (External ID) | The details about the print circulation number. |
| Program Issues | mvn__PP_Program_Issues__c | Picklist | Whether or not the journal has program issues. |
| Publisher | mvn__PP_Publisher__c | Text(255) | The publisher of the journal. |
| Publisher End Date/Time | mvn__PP_Publisher_End_Date_Time__c | Date/Time | The date and time that the journal ceased the publication. |
| Publisher ID | mvn__PP_Publisher_ID__c | Text(50) (External ID) | The publisher ID of the journal. |
| Publisher Start Date/Time | mvn__PP_Publisher_Start_Date_Time__c | Date/Time | The date and time that the journal started the publication. |
| Rank | mvn__PP_Rank__c | Number(7, 0) | The journal rank provided by PubsHub. |
| Rapid Communications | mvn__PP_Rapid_Communications__c | Picklist | Whether or not the journal has rapid communications. |
| Rejection Rate | mvn__PP_Rejection_Rate__c | Percent(3, 0) | The journal rejection rate. |
| Reprint Details | mvn__PP_Reprint_Details__c | Long Text Area(5000) | Details about the journal reprint. |
| Require Clinical Trial Registration | mvn__PP_Require_Clinical_Trial_Registration__c | Picklist | Whether or not the journal requires clinical trial registration. |
| Research Oriented | mvn__PP_Research_Oriented__c | Picklist | Whether or not the journal is research oriented. |
| Reviews | mvn__PP_Reviews__c | Picklist | Whether or not the journal allows reviews. |
| Society | mvn__PP_Society__c | Text(255) | The society responsible for the journal. |
| Submission to Acceptance (Max) | mvn__PP_Submission_to_Acceptance_Max__c | Number(9, 0) | The maximum number of days between the manuscript submission and acceptance. |
| Submission to Acceptance (Min) | mvn__PP_Submission_to_Acceptance_Min__c | Number(9, 0) | The minimum number of days between the manuscript submission and acceptance. |
| Submission URL | mvn__PP_Submission_URL__c | URL(255) | The URL for submitting a manuscript. |
| Supplements | mvn__PP_Supplements__c | Picklist | Whether or not the journal allows supplements. |
| Therapeutic Area(s) | mvn__PP_Therapeutic_Areas__c | Picklist (Multi-Select) | The therapeutic areas of focus for the journal. |
| Website | mvn__PP_Website__c | URL(255) | The URL of the event's website for the journal or congress. |
Journal Metric
The Journal Metric (mvn__PP_DS_Journal_Metric__c) custom object is
used to store Digital Science (Altmetric and Dimensions) journal metrics
and has a master-detail relationship with the
Journal (mvn__PP_Journal__c) custom object.
note
The Journal Metric custom object is only available as part of the Digital Science integration to store data returned from Digital Science. If you do not have the Digital Science package installed, you will not have this custom object in your instance of Scientific Publications Cloud product.
mvn__PP_DS_Journal_Metric__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| DS Journal Metrics JSON | mvn__PP_DS_Journal_Metrics_JSON__c | Long Text Area(131072) | The Digital Science journal metrics. This is in JSON format. |
| DS Last Modified Date/Time | mvn__PP_DS_Last_Modified_Date_Time__c | Date/Time | The date and time when the journal metric was last updated in Digital Science. |
| Journal | mvn__PP_DS_Journal__c | Master-Detail(Journal) | The master Journal (mvn__PP_Journal__c) record. |
| Journal Metric # | Name | Auto Number | The unique identifier of the Journal Metric record. It is formatted as JM-\{0000000\} and generates and increments automatically. |
| Source | mvn__PP_DS_Source__c | Text(255) | The name of the external system sourcing the journal metric data. |
Line Item
The Line Item (mvn__PP_Plan_Budget_Line_Item__c) custom object
facilitates line items for an Annual Plan and is on the detail side of a
master-detail relationship with the Annual Plan object. Line Item is on
the master side of a master-detail relationship with the Line Item
Payment custom object, which facilitates payments for Line Items.
Line Item schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Document | mvn__PP_Document__c | Lookup(Document) | Lookup relationship to the document. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Line Item Name | Name | Text(80) | Name of the Line Item. |
| Paid Amount | mvn__PP_Paid_Amount__c | Roll-Up Summary (SUM Line Item Payment) | Roll-up summary of line item payments, calculating the actual paid amount for the budget line item. |
| Annual Plan | mvn__PP_Plan_Budget__c | Master-Detail(Annual Plan) | Master-detail relationship to the Annual Plan. |
| Plan Budget Line Item # | mvn__PP_Plan_Budget_Line_Item_Num__c | Auto Number | Auto number for the Line Item. |
| Rate Card | mvn__PP_Rate_Card__c | Lookup(Rate Card) | The Rate Card associated via the Vendor for this Line Item |
| Record Type | RecordTypeId | Record Type | Id of the record type. Record types include: - Administrative - Flat-Fee - Time and Materials |
| Remaining Amount | mvn__PP_Remaining_Amount__c | Formula (Currency) | Formula calculating the remaining budget (Total Amount - Invoiced Amount). |
| Service Level | mvn__PP_Service_Level__c | Picklist | Global picklist indicating line item level of service. |
| Total Amount | mvn__PP_Total_Amount__c | Currency(16, 2) | Total amount for the budget line item. |
| Vendor | mvn__PP_Vendor__c | Lookup(Account) | Lookup relationship to the Vendor (Account). |
Line Item Payment
The Line Item Payment (mvn__PP_Line_Item_Payment__c) custom object
facilitate payments for Line Items and is on the detail side of a
master-detail relationship with the Line Item custom object.
Line Item Payment schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Line Item Payment # | Name | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
| Paid Amount | mvn__PP_Paid_Amount__c | Currency(16, 2) | Amount paid for the line item. |
| Line Item | mvn__PP_Plan_Budget_Line_Item__c | Master-Detail(Line Item) | Master-detail relationship to the Line Item. |
Mavens Key Contact
The Mavens Key Contact (mvn__Mavens_Key_Contact__c) object receive
communication from Mavens regarding key events for Mavens products.
mvn__Mavens_Key_Contact__c
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | Created By | Lookup(User) | Id of the user who created the record. |
| mvn__Email__c | Email (Unique) | Email of the key contact. | |
| First Name | mvn__First_Name__c | Text(40) | First name of the key contact. |
| Full Name | mvn__Full_Name__c | Formula (Text) | Derived formula of first and last name. |
| Key Contact Id | Name | Auto Number | |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Last Name | mvn__Last_Name__c | Text(80) | Last name of the key contact. |
| Owner | OwnerId | Lookup(User,Group) | Id of the owner or group who created the record. |
| Receive MIC Communication | mvn__Do_Receive_MIC_Communication__c | Checkbox | Indicates whether the key contact should receive communication specific to MIC. |
| Receive MICM Communication | mvn__Do_Receive_MICM_Communication__c | Checkbox | Indicates whether the key contact should receive communication specific to MICM. |
Medical Objective
The Medical Objective (mvn__PP_Medical_Objective__c) custom object
tracks medical objectives. Medical Objectives are associated with
Documents through the Publication Objective junction objection.
Medical Objective schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Active? | mvn__PP_Active__c | Checkbox | Checkbox that indicates if the medical objective is an active record (true) or not (false). |
| Category | mvn__PP_Category__c | Picklist | Picklist indicating objective category. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Description | mvn__PP_Description__c | Long Text Area(3000) | Description of the medical objective. |
| End Date | mvn__PP_End_Date__c | Date | Medical Objective end date. |
| External ID | mvn__PP_External_ID__c | Text(150) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Medical Objective Name | Name | Text(80) | Name of the medical objective. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who owns the record. |
| Annual Plan | mvn__PP_Plan_Budget__c | Lookup(Annual Plan) | Lookup relationship to the plan budget. |
| Start Date | mvn__PP_Start_Date__c | Date | Medical Objective start date. |
| Strategic Objective | mvn__PP_Strategic_Objective__c | Lookup(Strategic Objective) | Lookup relationship to the strategic objective. |
| Year | mvn__PP_Year__c | Formula (Text) | Formula field that determines the applicable year for the medical objective based on the start date. |
Milestone
The Milestone (mvn__PP_Milestone_c) custom object tracks milestones.
Milestone schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Amount | mvn__PP_Amount__c | Currency(16, 2) | Amount due upon completion of the milestone. |
| Amount % | mvn__PP_Amount_Percent__c | Percent(18, 0) | Percentage of the budget line item amount applicable to this milestone. |
| Completed Date | mvn__PP_Completed_Date__c | Date | Date the milestone was completed. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Date | mvn__PP_Date__c | Date | Actual milestone date. |
| Days Remaining | mvn__PP_Days_Remaining__c | Formula (Number) | Formula field that indicates the number of days remaining for pending milestones (TODAY - PP_Date__c). |
| Document | mvn__PP_Document__c | Lookup(Document) | Lookup relationship to the document. |
| Due Date Status | mvn__PP_Due_Date_Status__c | Formula (Text) | Evaluates the status of the milestone to render an icon on the enhanced timeline visualization, such as whether the milestone is overdue, due today, approaching its deadline, or completed. |
| Formatted Name | mvn__PP_Formatted_Name__c | Formula (Text) | The formatted name of the milestone to appear on the enhanced timeline visualization. |
| External ID | mvn__PP_External_ID__c | Text(150) (External ID) (Unique Case Insensitive) | Unique name concatenating PP_Study__c ID and PP__Document__c ID |
| Initial Date | mvn__PP_Initial_Date__c | Date | Initial plan date for the milestone. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Milestone # | mvn__PP_Milestone_Num__c | Auto Number | Automatically incremented record number. |
| Milestone Name | Name | Text(80) | Record number for the Milestone record. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group that owns the record. |
| Line Item | mvn__PP_Plan_Budget_Line_Item__c | Lookup(Line Item) | Lookup relationship to the plan budget line item. |
| Record Type | RecordTypeId | Record Type | Id of the record type. |
| Service Level | mvn__PP_Service_Level__c | Picklist | Service Level of the Plan Budget Line Item |
| Status | mvn__PP_Status__c | Picklist | Picklist that indicates the milestone status. |
| Study Document | mvn__PP_Study_Document__c | Lookup(Study Document) | Lookup relationship to the study document. |
| Target | mvn__PP_Target__c | Lookup(Target) | Lookup relationship to the target. |
Notification Log
The Notification Log (mvn__SE_Notification_Log__c) custom object
tracks all of the emails and Salesforce notifications that are sent to a
given user or contact, including workflow task assignments and
Collaborator Portal welcome emails, user
verification emails, and password reset emails. Notification Log records
can be created programmatically with the
Notification Log Service global Apex class.
mvn__SE_Notification_Log__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Contact | mvn__SE_Contact__c | Lookup(Contact) | The related Contact record. |
| Document | mvn__PP_Document__c | Lookup(Document) | The related Document (mvn__CM_Document__c) record. |
| Document Version | mvn__PP_Document_Version__c | Lookup(Document Version) | The related Document Version (mvn__CM_Document_Version__c) record. |
| mvn__SE_Email__c | The email address of the recipient. | ||
| Error Message | mvn__SE_Error_Message__c | Long Text Area(32768) | Any errors that were thrown when the email or notification was sent. |
| Message Sent At | mvn__SE_Message_Sent_At__c | Date/Time | The date and time that the email or notification was sent. |
| Notification Type | mvn__SE_Notification_Type__c | Picklist | The type of notification that was sent. Picklist values include: - Email - Notification |
| Subject | mvn__SE_Subject__c | Text(250) | The subject of the email or notification. |
| Success | mvn__SE_Success__c | Checkbox | When checked (i.e., true), the email or notification was sent successfully. |
| User | mvn__SE_User__c | Lookup(User) | The related User record. |
| What ID | mvn__SE_WhatId__c | Text(150) | The target object of the email or notification. |
Plan Team Member
The Plan Team Member (mvn__PP_Plan_Team_Member__c) custom object
identifies publication plan team members and their corresponding roles.
mvn__PP_Plan_Team_Member__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Existing Role | mvn__PP_Existing_Role__c | Picklist | The role of the plan team member on existing documents in the publication plan. Picklist values are: - Owner - Publication Specialist - Statistician - Budget Manager - Viewer - Plan Owner |
| External Id | mvn__PP_External_Id__c | Text(150) (Unique Case Sensitive) | The unique identifier of the Plan Team Member record from an external source system. |
| Plan Team Member # | Name | Auto Number | The unique identifier of the Plan Team Member record. It is formatted as MEM-\{0000000\} and generates and increments automatically. |
| Processing Error Message | mvn__PP_Processing_Error_Message__c | Long Text Area(32678) | Any error messages related to the batch process of propagating Document Collaborator (mvn__PP_Document_Author__c) records on existing documents. |
| Processing Result | mvn__PP_Processing_Result__c | Picklist | The result status of the batch process of propagating Document Collaborator (mvn__PP_Document_Author__c) records on existing documents. Picklist values are: - Complete - Error - Pending |
| Publication Plan | mvn__PP_Plan__c | Master-Detail(Publication Plan) | The parent Publication Plan (mvn__PP_Plan__c) record. |
| Role | mvn__PP_Role__c | Picklist | The role of the plan team member on the publication plan. Picklist values are: - Owner - Publication Specialist - Statistician - Budget Manager Note: For plan team members to automatically be provisioned access to a document when the document is related to a plan, the following must be true: - The API name of the Document Type ( CM_Latest_Version_Type__c) value on the Document record must match the Publication Document Criteria (mvn__PP_Publication_Document_Criteria__c) value on the Default (PP_Default) metadata record of the Pubs Global Setting (mvn__PP_Global_Setting__mdt) custom metadata type. - The API names of the Role picklist values must match the Name (DeveloperName) values of Role (mvn__CM_Role__mdt) custom metadata records. When both of the above are true, plan team members are added as document collaborators and provisioned with the corresponding role and permissions configured for the document lifecycle. |
| Status | mvn__PP_Status__c | Picklist | The status of the plan team member. Picklist values are: - Active - Inactive Note: If a user is deactivated from the system, the Status field for all of their associated Plan Team Member records will automatically be set to Inactive. |
| User | mvn__PP_User__c | Lookup(User) | The related User record. |
Product
Product (mvn__CM_Product__c) is the default product repository for .
Relationships between documents and products are stored on the
CM_Document_Relationship__c custom object with the
CM_Category__c``Product. Visit
Relationships.
note
Product is an internal system field and should not be modified in any way.
mvn__CM_Product__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Active | mvn__CM_Active__c | Checkbox | Whether the Product is active. |
| Country | mvn__CM_Country__c | Picklist | Country associated to this Product. |
| External ID | mvn__CM_External_Id__c | Text(255) (External ID) (Unique Case Sensitive) | External ID for this Product. |
| Generic Name | mvn__CM_Generic_Name__c | Text(255) | Generic drug name. |
| Investigational Drug Name | mvn__CM_Investigational_Drug_Name__c | Text(255) | Investigational drug name. |
| Product Display Name | Name | Text(80) | Name of the Product. |
| Product Group | mvn__CM_Product_Group__c | Lookup(Product) | Product Group associated to this Product. |
| Therapeutic Area | mvn__CM_Therapeutic_Area__c | Picklist | Therapeutic Area associated to this Product. |
| Trade Name | mvn__CM_Trade_Name__c | Text(255) | This Product's Trade Name. |
Publication Objective
The Publication Objective (mvn__PP_Publication_Objective__c) custom
object tracks publication objectives. It is a junction between documents
and scientific and medical objectives.
Publication Objective schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| External ID | mvn__PP_External_ID__c | Text(150) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Medical Objective | mvn__PP_Medical_Objective__c | Lookup(Medical Objective) | Lookup relationship to the medical objective. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who owns the record. |
| Publication | mvn__PP_Publication__c | Lookup(Document) | Lookup relationship to the document. |
| Publication Objective Name | Name | Text(80) | Name of the publication objective. |
| Publication Title | mvn__PP_Publication_Title__c | Formula (Text) | Title of the related Document. |
| Scientific Objective | mvn__PP_Scientific_Objective__c | Lookup(Scientific Objective) | Lookup relationship to the scientific objective. |
Publication Plan
The Publication Plan (mvn__PP_Plan__c) custom object is used to
facilitate publication planning and the coordination of plan-related
activities.
mvn__PP_Plan__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Description | mvn__PP_Description__c | Long Text Area(10000) | Detailed information about the publication plan. |
| End Date | mvn__PP_End_Date__c | Date | The end date of the publication plan. |
| External ID | mvn__PP_External_ID__c | Text(150) (External ID) (Unique Case Insensitive) | The unique identifier of the Publication Plan record from an external source system. |
| Parent Publication Plan | mvn__PP_Parent_Plan__c | Lookup(Publication Plan) | The parent Publication Plan (mvn__PP_Plan__c) record, if any. |
| Plan # | mvn__PP_Plan_Num__c | Auto Number | The unique identifier of the Publication Plan record. It is formatted as PLAN-\{0000000\} and generates and increments automatically. |
| Product | mvn__PP_Product__c | Lookup(Product (Pubs)) | The related Product (Pubs) (mvn__CM_Product__c) record. |
| Start Date | mvn__PP_Start_Date__c | Date | The start date of the publication plan. |
| Status | mvn__PP_Status__c | Picklist | The status of the publication plan. Picklist values are: - Draft - Proposed - Active - Closed |
Rate Card
The Rate Card (mvn__PP_Rate_Card__c) custom object stores vendor rate
card details. The Rate Card object is on the detail side of a
master-detail relationship with the Account object.
Rate Card schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Active | mvn__PP_Active__c | Checkbox | Checkbox that indicates if the rate card is an active record. |
| Amount | mvn__PP_Amount__c | Currency(16, 2) | Rate card amount. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Document Classification | mvn__PP_Document_Classification__c | Picklist | Picklist field indicating the document classification for the associated rate card. |
| Document Subtype | mvn__PP_Document_Subtype__c | Picklist | Picklist field indicating the document subtype for the associated rate card. |
| Document Type | mvn__PP_Document_Type__c | Picklist | Picklist field indicating the document type for the associated rate card. |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| External Source | mvn__PP_External_Source__c | Text(255) | Name of the external system sourcing the contact verification data. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Rate Card Name | Name | Text(80) | Name of the rate card. |
| Rate Card Number | mvn__PP_Rate_Card_Num__c | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
| Vendor | mvn__PP_Vendor__c | Master-Detail(Account) | Master-detail relationship to the account. |
Region
Regions are customer-defined geographical areas that can be associated
to documents as metadata. Regions are configured with the Region
(mvn__Region__c) custom object and can be configured as a hierarchy
through associations to other regions and
countries (mvn__Country__mdt). For example, the North
America region might have three child regions: Canada, Mexico, and
United States.
mvn__Region__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Country | mvn__Country__c | Text(255) (External ID) | DeveloperName of the mvn__Country__mdt record associated to this region. The value you enter must match an existing mvn__Country__mdt record, or an error will occur. |
| Country ISO Code | mvn__Country_ISO_Code__c | Text(2) (External ID) | mvn__ISO_Code__c of the mvn__Country__mdt record associated to this region. |
| Parent Region | mvn__Parent_Region__c | Lookup(Region) | Parent region. |
| Region Name | Name | Text(80) | Name of the region. |
| Type | mvn__Type__c | Picklist | Type of the region. |
Scientific Objective
The Scientific Objective (mvn__PP_Scientific_Objective__c) custom
object stores scientific objective data.
Scientific Objective schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Active? | mvn__PP_Active__c | Checkbox | Checkbox that indicates if the scientific objective is an active record (true) or not active (false). |
| Annual Plan | mvn__PP_Plan_Budget__c | Lookup(Annual Plan) | Lookup relationship to the Annual Plan (mvn__PP_Plan_Budget__c). |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Description | mvn__PP_Description__c | Long Text Area(3000) | Description of the scientific objective. |
| End Date | mvn__PP_End_Date__c | Date | Scientific Objective end date. |
| External ID | mvn__PP_External_ID__c | Text(150) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Medical Objective | mvn__PP_Medical_Objective__c | Lookup(Medical Objective) | Lookup relationship to the medical objective. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who owns the record. |
| Scientific Objective | Name | Text(80) | Name of the scientific objective. |
| Start Date | mvn__PP_Start_Date__c | Date | Scientific Objective start date. |
| Year | mvn__PP_Year__c | Formula (Text) | Formula field that determines the applicable year for the scientific objective based on the start date. |
Strategic Objective
The Strategic Objective (mvn__PP_Strategic_Objective__c) custom object
tracks strategic objectives.
Strategic Objective schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Active? | mvn__PP_Active__c | Checkbox | Checkbox that indicates if the strategic objective is an active record (true) or not active (false). |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Description | mvn__PP_Description__c | Long Text Area(3000) | Description of the strategic objective. |
| End Date | mvn__PP_End_Date__c | Date | Strategic Objective end date. |
| External ID | mvn__PP_External_ID__c | Text(150) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who owns the record. |
| Product | mvn__PP_Product__c | Lookup(Product (Pubs)) | Lookup relationship to the product. |
| Start Date | mvn__PP_Start_Date__c | Date | Strategic Objective start date. |
| Strategic Objective Name | Name | Text(80) | Name of the strategic objective. |
| Year | mvn__PP_Year__c | Formula (Text) | Formula field that determines the applicable year for the strategic objective based on the start date. |
Study
The Study (mvn__PP_Study__c) custom object stores study details and
corresponding trial data. Studies are associated to Documents through
the Study Document junction object, to Plan Budgets through the Study
Plan junction object, and to Products through the Study Product junction
object. Studies are also related to Products through the Primary Product
lookup field. This field specifies the product that the study primarily
focuses on.
Study schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Actual Completion Date | mvn__PP_Actual_Completion_Date__c | Date | The actual study completion date. |
| Actual Enrollment | mvn__PP_Actual_Enrollment__c | Number(18, 0) | The actual number of participants enrolled in the study. |
| Actual FSFV Date | mvn__PP_Actual_FSFV_Date__c | Date | Actual First Subject First Visit (FSFV) date. |
| Actual LSLV Date | mvn__PP_Actual_LSLV_Date__c | Date | Actual Last Subject Last Visit (LSLV) date. |
| Comments | mvn__PP_Comments__c | Long Text Area(32768) | Additional details or comments about the study. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| CSR Date | mvn__PP_CSR_Date__c | Date | Clinical Study Report (CSR) date. |
| CT Results Publication Date | mvn__PP_CT_Results_Publication_Date__c | Date | Clinical trial results publication date. |
| CT Results Submission Date | mvn__PP_CT_Results_Submission_Date__c | Date | Clinical trial results submission date. |
| EudraCT # | mvn__PP_EudraCT__c | Text(100) | European Union Drug Regulating Authorities Clinical Trial (EudraCT) number. |
| External ID | mvn__PP_External_ID__c | Text(150) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| External Source | mvn__PP_External_Source__c | Text(255) | Name of the external system sourcing the study data. |
| External Study # | mvn__PP_External_Study__c | Text(100) | External system study number. |
| Hypothesis | mvn__PP_Hypothesis__c | Long Text Area(32768) | The study hypothesis. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| NCT # | mvn__PP_NCT__c | Text(100) (External ID) (Unique Case Insensitive) | National Clinical Trial (NCT) number. |
| Objective | mvn__PP_Objective__c | Long Text Area(32768) | The objective of the study. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who owns the record. |
| Pediatric Study | mvn__PP_Pediatric_Study__c | Checkbox | Checkbox that indicates if the study is a pediatric trial. |
| Planned Completion Date | mvn__PP_Planned_Completion_Date__c | Date | The planned study completion date. |
| Planned Enrollment | mvn__PP_Planned_Enrollment__c | Number(18, 0) | The planned number of participants enrolled in the study. |
| Planned FSFV Date | mvn__PP_Planned_FSFV_Date__c | Date | Planned First Subject First Visit (FSFV) date. |
| Planned LSLV Date | mvn__PP_Planned_LSLV_Date__c | Date | Planned Last Subject Last Visit (LSLV) date. |
| Primary Product | mvn__PP_Primary_Product__c | Lookup(Product (Pubs)) | Lookup relationship to the study primary product. |
| Results | mvn__PP_Results__c | Long Text Area(32768) | The results of the study. |
| Scientific Title | mvn__PP_Scientific_Title__c | Long Text Area(2500) | The formal study title. |
| Short Title | Name | Text(80) | The abbreviated study title. |
| Study # | mvn__PP_Study_Num__c | Auto Number | Automatically incremented record number. |
| Study Phase | mvn__PP_Study_Phase__c | Picklist | Picklist indicating the clinical trial phase. |
| Study Status | mvn__PP_Study_Status__c | Picklist | Picklist indicating the study status. |
| Study Type | mvn__PP_Study_Type__c | Picklist | Picklist indicating the type of clinical trial. |
| Subject Type | mvn__PP_Subject_Type__c | Picklist | Picklist indicating the type of subjects enrolled in the study. |
Study Document
The Study Document (mvn__PP_Study_Document__c) custom object is a
junction between the Study and the Document Version custom objects.
Study Document schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Document | mvn__PP_Document__c | Lookup(Document) | Lookup relationship to the document. |
| External Id | mvn__PP_External_Id__c | Text(150) (Unique Case Sensitive) | Unique identifier set by a trigger to prevent duplicate study products. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Study | mvn__PP_Study__c | Master-Detail(Study) | Master-detail relationship to the study. |
| Study Document # | Name | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
| Type | mvn__PP_Type__c | Picklist | Picklist indicating the type of publication relationship to the study. |
Study Product
The Study Product (mvn__PP_Study_Product__c) object is used as a
junction between the study and product and has a Master-Detail
relationship with the Study object..
mvn__PP_Study_Product__c
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| External Id | mvn__PP_External_Id__c | Text(150) (Unique Case Sensitive) | Concatenation of PP_Study__c and PP_Product__c to enforce uniqueness. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Primary | mvn__PP_Primary__c | Formula (Checkbox) | Formula field product related to the study is the primary product: IF(mvn__PP_Study__r.mvn__PP_Primary_Product__c = mvn__PP_Product__c , true, false) |
| Product | mvn__PP_Product__c | Lookup(Product (Pubs)) | Lookup relationship to the product. |
| Study | mvn__PP_Study__c | Master-Detail(Study) | Master-detail relationship to the study. Read/Write: Allows users with at least Read/Write access to the Master record to create, edit, or delete related Detail records. |
| Study Product # | Name | Auto Number | Automatically incremented record number. |
Study Plan
The Study Plan (mvn__PP_Study_Plan__c) custom object is a junction
between the Study and Plan Budget objects.
Study Plan schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Annual Plan | mvn__PP_Plan_Budget__c | Master-Detail(Annual Plan) | Master-detail relationship to the Annual Plan. |
| Study | mvn__PP_Study__c | Master-Detail(Study) | Master-detail relationship to the study. |
| Study Plan # | Name | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
Target
The Target (mvn__PP_Target__c) custom object connects documents to
target events, specifically congresses and journals.
mvn__PP_Target__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Annual Plan | mvn__PP_Plan_Budget__c | Lookup(Annual Plan) | The related Annual Plan (mvn__PP_Plan_Budget__c) record. |
| Concept | mvn__PP_Concept__c | Lookup(Concept) | The related Concept (mvn__PP_Concept__c) record. |
| Congress | mvn__PP_Congress__c | Lookup(Congress) | The related Congress (mvn__Congress__c) record. |
| Congress Location | mvn__PP_Congress_Location__c | Lookup(Congress Location) | The related Congress Location (mvn__Congress_Location__c) record. |
| Document | mvn__PP_Document__c | Lookup(Document) | The related Document (mvn__CM_Document__c) record. |
| Estimated Submission Date | mvn__PP_Estimated_Submission_Date__c | Date | The estimated target submission date for the publication. |
| External ID | mvn__PP_External_ID__c | Text(56) (External ID) (Unique Case Sensitive) | The unique identifier of the Target record. |
| Journal | mvn__PP_Journal__c | Lookup(Journal) | The related Journal (mvn__PP_Journal__c) record. |
| Primary | mvn__PP_Primary__c | Checkbox | Whether the target is primary (true) or not primary (false). A document can only have one target marked as primary. |
| Priority | mvn__PP_Priority__c | Picklist | The targeted event preference. Picklist values are: - Preferred - Alternate - Considered |
| Record Type | RecordTypeId | Record Type | The ID of the Target record type. Record types include: - Congress (PP_Congress) - Journal (PP_Journal) - Proposed Congress (PP_Proposed_Congress) - Proposed Journal (PP_Proposed_Journal) |
| Target # | Name | Auto Number | The unique identifier of the Target record. It is formatted as TARG-\{0000000\} and generates and increments automatically. |
| Target | mvn__PP_Target_Name__c | Formula (Text) | The name on the related Journal (mvn__PP_Journal__c) or Congress (mvn__Congress__c) record. |
| Type | mvn__PP_Type__c | Formula (Text) | The target type. Types include: - Congress - Journal |
Target Submission
The Target Submission (mvn__PP_Target_Submission__c) custom object
tracks target submissions and is on the detail side of a master-detail
relationship with the Target custom object.
Target Submission schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Description | mvn__PP_Description__c | Long Text Area(3200) | Target submission description. |
| External ID | mvn__PP_External_ID__c | Text(50) (External ID) (Unique Case Insensitive) | Unique identifier from an external source system. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Response Date | mvn__PP_Response_Date__c | Date | Date a response was received for a given publication. |
| Status | mvn__PP_Status__c | Picklist | Picklist indicating the target submission status. |
| Submission Date | mvn__PP_Submission_Date__c | Date | Date the publication was submitted to a designated target. |
| Target | mvn__PP_Target__c | Master-Detail(Target) | Master-detail relationship to the Plan Budget Line Item. |
| Target Submission # | Name | Auto Number | Number that is automatically assigned to the record upon the record's creation. |
User
The User (User) standard object represents a user in . For more
information, reference Salesforce's documentation on the User
object.
User schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Gender | mvn__PP_Gender__c | Picklist | The user's gender identity. |
| Language | mvn__CM_Default_Language__c | Picklist | The language that should be considered the MCM default. |
| ORCID Id | mvn__PP_ORCID_Id__c | Text(150) (External ID) (Unique Case Sensitive) | The external unique ORCID ID of the document collaborators that publish scientific articles. For more information, reference ORCID's website at https://orcid.org/. |
| Pronoun | mvn__PP_Pronoun__c | Picklist | The user's preferred pronouns. |
User Request
The User Request mvn__PP_User_Request__c) object stores user request
details for provisioning user access and resetting user passwords.
System run batch jobs process User Request records at the beginning of
every hour by default. Once a User Request record is processed, the
Result field changes to Success, and the Status field changes to
Complete. Processed records are not deleted.
note
To create a User Request record, you must have the
PP_Provision_User_Accounts custom permission set.
User Request schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Completed Date/Time | mvn__PP_Completed_Date_Time__c | Date/Time | Date and time the user request is completed. |
| Contact | mvn__PP_Contact__c | Master-Detail(Contact) | Master-detail relationship to the contact. |
| Created By | CreatedById | Lookup(User) | Id of the user who created the record. |
| Document Collaborator | mvn__PP_Document_Author__c | Lookup(Document Collaborator) | Lookup relationship to the document author. |
| Error Message | mvn__PP_Error_Message__c | Long Text Area(32768) | Message that displays when an error occurs. |
| Last Modified By | LastModifiedById | Lookup(User) | Id of the user who last modified the record. |
| Owner | OwnerId | Lookup(User,Group) | Id of the user or group who owns the record. |
| Record Type | RecordTypeId | Record Type | Id of the record type. Record types include: - New User - user request record type for provisioning a new user. - Password Reset - user request record type for resetting a user password. |
| Result | mvn__PP_Result__c | Picklist | Outcome of the batch job that processed the user request record. Picklist values include: - Success - Failed |
| Status | mvn__PP_Status__c | Picklist | Picklist indicating the user request record status. Picklist values include: - Pending - Complete |
| User | mvn__PP_User__c | Lookup(User) | Lookup relationship to the user. |
| User JSON Definition | mvn_PP_User_JSON_Definition__c | Long Text Area(32768) | JSON definition for creating user records. This field does not need to be manually filled out. Here is a sample JSON definition: { "ProfileId":"00e3F000001E9ViQAK", "CountryCode":"US", "LastName":"Smith", "Street":"123 Maple Ln.", "Phone":null, "CompanyName":"Test Account", "EmailEncodingKey":"UTF-8", "City":"Chicago", "PostalCode":"US", "Title":"Head Physician", "StateCode":"IL", "FirstName":"Jonathan", "TimeZoneSidKey":"America/Los_Angeles", "LanguageLocaleKey":"en_US", "LocaleSidKey":"en_US", "Email":"jsmith@example.com" } |
| User Request # | Name | Auto Number | Automatically incremented record number. |
Workflow Instance
When a workflow becomes active, a record is inserted to
CM_Workflow_Instance__c to track its progress.
mvn__CM_Workflow_Instance__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Workflow Developer Name | mvn__CM_Workflow_Developer_Name__c | Text(40) | DeveloperName of the Workflow__mdt record associated to this instance. |
| Outcome | mvn__CM_Outcome__c | Picklist | The outcome of the workflow as defined by the final stage's CM_Final_Stage_Outcome__c value on CM_Workflow_Stage__mdt. |
| Status | mvn__CM_Status__c | Picklist | The status of the instance of the workflow. |
| Workflow Instance Name | Name | Auto Number | Autogenerated name. |
Workflow Instance Activity Content
The Workflow Instance Activity Content
(mvn__CM_Workflow_Instance_Activity_Content__c) object is a junction
object that assists in adding the content attachments from workflow
instances to system event notifications. In other words, this object
helps attach files to email notifications for workflow tasks.
mvn__CM_Workflow_Instance_Activity_Content__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Content Version Id | mvn__CM_Content_Version_Id__c | Text(18) (External ID) | The ID of the Content Version (ContentVersion) record, or the file to be attached to a system event (e.g., email) notification. |
| Workflow Instance | mvn__CM_Workflow_Instance__c | Master-Detail(Workflow Instance) | The parent Workflow Instance (mvn__CM_Workflow_Instance__c) record. |
| Workflow Instance Activity Dev Name | mvn__CM_Workflow_Instance_Activity_Dev_Name__c | Text(40) (External ID) | The API name of the related Workflow Stage Activity (mvn__CM_Workflow_Stage_Activity__mdt) metadata record, or the workflow stage for which a system (e.g., email) notification with content attachments may be sent out for. |
Workflow Instance Document
Workflow Instance Documents contain the list of documents associated to
Workflows. They connect Document Versions to Workflow Instances.
Workflow Instance Documents are defined in the
CM_Workflow_Instance_Documents__c custom object.
note
While the data model supports associating multiple documents to a workflow, multi-document workflows are not supported.
mvn__CM_Workflow_Instance_Document__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Document | mvn__CM_Document__c | Master-Detail(Document) | Document associated to this instance. |
| Document Version | mvn__CM_Document_Version__c | Lookup(Document Version) | Version associated to this instance. |
| Document Version Entry State | mvn__CM_Document_Version_Entry_State__c | Text(255) | State of the version when it entered the workflow. |
| Workflow Instance | mvn__CM_Workflow_Instance__c | Master-Detail(Workflow Instance) | Instance of a workflow. |
| Workflow Instance Document Name | Name | Auto Number | Autogenerated name. |
Workflow Instance Stage
A Workflow Instance Stage record is created every time a workflow
transitions to a new stage and is associated to a Workflow Instance.
Workflow Instance and Workflow Instance Stage are associated by a
one-to-many relationship. Workflow Instance Stages are defined in the
CM_Workflow_Instance_Stage__c custom object.
mvn__CM_Workflow_Instance_Stage__c schema
| Field label | API name | Data type | Description |
|---|---|---|---|
| Active | mvn__CM_Active__c | Text(40) | DeveloperName of the Workflow__mdt record associated to this instance. |
| Pending Activity Assignment | mvn__CM_Pending_Activity_Assignment__c | Checkbox | If checked, this stage requires manual intervention to assign activities. |
| Previous Stage | mvn__CM_Previous_Stage__c | Lookup(Workflow Instance Stage) | Pointer to the previous stage. |
| Transaction IDs | mvn__CM_Transaction_IDs__c | Long Text Area(32768) | Comma-separated list of Transaction IDs to associate to the stage for event orchestration purposes. |
| Workflow Instance | mvn__CM_Workflow_Instance__c | Lookup(Workflow Instance) | Workflow instance associated to this stage. |
| Workflow Instance Stage Name | Name | Auto Number | Autogenerated Name. |
| Workflow Stage Developer Name | mvn__CM_Workflow_Stage_Developer_Name__c | Text(255) | DeveloperName of the Workflow_Stage_mdt record associated to this instance. |