Skip to main content

Objects

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.

Entity relationship diagram
Table 158. 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 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.

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)

Name of the user who the activity was originally assigned to before the activity was reassigned to a delegated approver.

Owner Name

mvn__CM_Owner_Name__c

Formula (Text)

Name of the user who is assigned the activity.

Pubs Notification

mvn__PP_Pubs_Notification__c

Checkbox

When true, a Komodo Publications Planning 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 Komodo Publications Planning 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



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.

Table 159. 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.



The Association (mvn__PP_Association__c) custom object links accounts to events, specifically congresses and journals.

PUBS_AssociationERD.png
Table 160. 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.



The Budget (mvn__PP_Budget__c) custom object stores budget details.

Table 161. 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.



The Concept (mvn__PP_Concept__c) custom object facilitates publication concept requests.

PUBS_ConceptERD.png
Table 162. 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.



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.

PUBS_CongressERD.png
Table 163. 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.

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.



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.

Congress attendee ERD
Table 164. 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.



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 entity relationship diagram
Table 165. 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.



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 ERD
Table 166. 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.



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.

PUBS_ContactVerificationERD.png
Table 167. 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.



The Data Checklist (mvn__PP_Data_Checklist__c) custom object stores publication document data checklist questions and responses.

PUBS_DataChecklistERD.png
Table 168. 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.



The Debug Log (mvn__Debug_Log__c) custom object stores application warnings and error logs.

Table 169. 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 (mvn__CM_Document__c) is a fundamental custom object consisting of metadata. Each Document record can have many associated Document Version records.

PUBS_DocumentERD.png

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 the Komodo Publications Planning 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 the Komodo Publications Planning product.

Table 170. mvn__CM_Document__c schema

Field label

API name

Data type

Description

Annual Plan

mvn__PP_Plan_Budget__c

Lookup

Lookup relationship to the annual plan.

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.

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.

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.



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 ERD
Table 171. mvn__PP_Document_Author__c schema

Field label

Field 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.

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.

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 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.

Groups entity relationship diagram
Table 172. 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



The Document Metric (mvn__PP_DS_Document_Metric__c) custom object is used to store Digital Science (Altmetric and Dimensions) article metrics.

mvn__PP_DS_Document_Metric__c ERD

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 the Komodo Publications Planning product.

Table 173. 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 (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.

MCM_RegionsERD.svg
Table 174. 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 (mvn__CM_Document_Relationship__c) is a polymorphic junction object between either:

  • Document version and document version

    Example 18. 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

    Example 19. 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.

Table 175. 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 is a child to Document and is managed in the CM_Document_Role__c custom object.

Table 176. 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.



The Document Role Share (mvn__CM_Document_Role_Share__c) object is a utility object for keeping track of sharing records for various Komodo Publications Planning objects.

Table 177. 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.



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.

mvn_­_­CM_­Document_­Version_­_­c ERD

Warning

Komodo Publications Planning 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 the Komodo Publications Planning product.

Table 178. 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:

  • Office 365

  • Local

Check Out URL

mvn__CM_Check_Out_URL__c

URL(255)

URL where the file is stored in Office 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 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)

Thumbnail rendition of the document version.

Thumbnail URL

mvn__CM_Thumbnail_URL__c

Text(255)

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.



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 ERD
Table 179. 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 Office 365TM).

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.



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.

Files entity relationship diagram
Table 180. 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 Rendition Type.



The Invoice (mvn__PP_Invoice__c) custom object stores budget invoicing details.

Invoice entity relationship diagram
Table 181. 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.



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.

Journal ERD

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 the Komodo Publications Planning product.

Table 182. 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.

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.

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.



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.

mvn__PP_DS_Journal_Metric__c ERD

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 the Komodo Publications Planning product.

Table 183. 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.



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.

PUBS_PlanBudgetLineItemERD.png
Table 184. 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).



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.

PUBS_LineItemPaymentERD.png
Table 185. 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.



The Mavens Key Contact (mvn__Mavens_Key_Contact__c) object receive communication from Mavens regarding key events for Mavens products.

Table 186. 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.

Email

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.



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 entity relationship diagram
Table 187. 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.



The Milestone (mvn__PP_Milestone_c) custom object tracks milestones.

Milestone entity relationship diagram
Table 188. 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.

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.



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 ERD
Table 189. 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

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 Komodo Publications Planning 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 (mvn__CM_Product__c) is the default product repository for Komodo Publications Planning. Relationships between documents and products are stored on the CM_Document_Relationship__c custom object with the CM_Category__cProduct. Visit Relationships.

Note

Product is an internal system field and should not be modified in any way.

Table 190. 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.



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 entity relationship diagram
Table 191. 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.



The Publication Plan (mvn__PP_Plan__c) custom object is used to facilitate publication planning and the coordination of plan-related activities.

Plan entity relationship diagram
Table 192. 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



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.

PUBS_RateCardERD.png
Table 193. 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.



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.

Region ERD
Table 194. 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.



The Scientific Objective (mvn__PP_Scientific_Objective__c) custom object stores scientific objective data.

Scientific Objective entity relationship diagram
Table 195. 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.



The Strategic Objective (mvn__PP_Strategic_Objective__c) custom object tracks strategic objectives.

Strategic Objective entity relationship diagram
Table 196. 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.



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.

PUBS_StudyERD.png
Table 197. 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.



The Study Document (mvn__PP_Study_Document__c) custom object is a junction between the Study and the Document Version custom objects.

Study Document entity relationship diagram
Table 198. 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.



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..

study product ERD
Table 199. 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.



The Study Plan (mvn__PP_Study_Plan__c) custom object is a junction between the Study and Plan Budget objects.

PUBS_StudyPlan_ERD.png
Table 200. 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.



The Target (mvn__PP_Target__c) custom object connects documents to target events, specifically congresses and journals.

mvn__PP_Target__c ERD
Table 201. 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



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 entity relationship diagram
Table 202. 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.



The User (User) standard object represents a user in Komodo Publications Planning. For more information, reference Salesforce's documentation on the User object.

Table 203. 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.



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 object entity relationship diagram
Table 204. 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.



When a workflow becomes active, a record is inserted to CM_Workflow_Instance__c to track its progress.

Workflow instance relationships
Table 205. 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 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.

Workflow instance relationships
Table 206. 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.



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.

Workflow instance relationships
Table 207. 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.