MedicalInquiries
Records questions submitted by healthcare professionals regarding products or treatments.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
A unique identifier for the medical inquiry record, used to distinguish each inquiry within the system. |
| Medical Inquiry Type | String | True |
The type or category of the medical inquiry, such as 'Drug Information', 'Side Effects', or 'Product Usage'. |
| Global ID | String | True |
A globally unique identifier for the medical inquiry, ensuring consistency across various systems and processes. |
| Link | String | False |
A URL or hyperlink associated with the medical inquiry, potentially linking to additional resources or related documents. |
| Medical Inquiry Id | String | True |
The identifier assigned to the medical inquiry, used for tracking and referencing specific inquiries. |
| Status | String | True |
The current status of the medical inquiry, such as 'Open', 'Closed', 'In Progress', indicating the stage of the inquiry. |
| Created By | String | True |
The individual or system that created the medical inquiry, ensuring accountability for its entry into the system. |
| Created Date | Datetime | True |
The timestamp when the medical inquiry was created, used for tracking the inquiry's lifecycle. |
| Last Modified By | String | True |
The individual or system that last modified the medical inquiry record, ensuring transparency in changes made. |
| Last Modified Date | Datetime | True |
The timestamp of the last modification made to the medical inquiry record, providing an audit trail. |
| Address Line 1 | String | False |
The first line of the address associated with the medical inquiry, used for contact or shipping purposes. |
| Address Line 2 | String | False |
The second line of the address, providing additional address information if needed. |
| City | String | False |
The city in which the medical inquiry is located, used for geographic tracking and addressing purposes. |
| Delivery Method | String | False |
The method by which the medical inquiry will be delivered, such as 'Email', 'Postal', or 'Courier'. |
| Disclaimer | String | False |
A legal disclaimer related to the medical inquiry, outlining any conditions, limitations, or risks associated with the inquiry. |
| String | False |
The email address associated with the medical inquiry, used for electronic communication with the relevant parties. | |
| Entity Reference Id | String | False |
An external reference ID used to link the medical inquiry to related entities, such as accounts or customers. |
| Fax Number | String | False |
The fax number associated with the medical inquiry, providing an alternative communication channel. |
| Fulfillment Created | Bool | False |
Indicates whether the fulfillment process for the inquiry has been initiated, marking the start of the resolution process. |
| Fulfillment Status | String | False |
The current status of the fulfillment process, such as 'Pending', 'Completed', or 'Failed'. |
| Group Count | Decimal | False |
The number of groups or categories associated with the medical inquiry, used for reporting or organizational purposes. |
| Group Identifier | String | False |
An identifier for the group associated with the medical inquiry, enabling classification or categorization of the inquiry. |
| Inquiry Text | String | False |
The detailed text or description provided in the medical inquiry, outlining the question or issue raised by the inquirer. |
| Lock | Bool | False |
Indicates whether the medical inquiry record is locked for editing, preventing further changes once it's finalized. |
| Address Line 12 | String | False |
The first address line used for MedComms inquiries, often indicating the primary address for communication. |
| Address Line 22 | String | False |
The second address line used for MedComms inquiries, providing additional address information as needed. |
| City2 | String | False |
The city associated with the MedComms inquiry, used for geographic and delivery tracking. |
| String | False |
The email address used for MedComms communication, ensuring direct contact with the inquiry originator. | |
| Fax | String | False |
The fax number for MedComms inquiries, providing an alternative communication option. |
| Phone | String | False |
The phone number associated with the MedComms inquiry, used for real-time communication or follow-up. |
| Postcode/Zip | String | False |
The postal code or ZIP code for the MedComms inquiry address, used for geographic classification and delivery purposes. |
| First Name | String | False |
The first name of the recipient for MedComms, used for personalized communication. |
| Last Name | String | False |
The last name of the recipient for MedComms, ensuring accurate address and identification of the recipient. |
| MedComms Record ID | String | False |
A unique identifier for the MedComms inquiry record, distinguishing it from other inquiries within the system. |
| State | String | False |
The state or province associated with the MedComms inquiry, helping in addressing and classification. |
| Mobile Created Datetime | Datetime | False |
The timestamp when the mobile inquiry was created, enabling tracking of inquiries originating from mobile devices. |
| Mobile ID | String | False |
A unique identifier for the mobile inquiry, used for tracking and referencing mobile-based inquiries. |
| Override Lock | Bool | False |
Indicates whether the lock on the medical inquiry record can be overridden, allowing for manual adjustments. |
| Phone Number | String | False |
The phone number for direct communication regarding the medical inquiry, used for follow-up and resolution. |
| Previously Submitted? | Bool | False |
Indicates whether the medical inquiry has been previously submitted, helping to avoid duplicate inquiries. |
| Product | String | False |
The product associated with the medical inquiry, such as a drug or medical device, providing context for the inquiry. |
| Receipt Email Address | String | False |
The email address to which receipts or acknowledgments for the inquiry will be sent. |
| Remote Signature Attendee Name | String | False |
The name of the attendee providing a remote signature for the medical inquiry, often required for compliance. |
| Request Receipt | Bool | False |
Indicates whether a receipt is requested for the medical inquiry, confirming acknowledgment of the inquiry submission. |
| Response Document Link | String | False |
A link to the document providing the response to the medical inquiry, allowing easy access to the resolution. |
| Response Notes | String | False |
Notes or comments related to the response of the medical inquiry, providing additional context or information about the resolution. |
| Rush Delivery | Bool | False |
Indicates whether the medical inquiry requires rush delivery for quicker processing and fulfillment. |
| Signature Captured Remotely | Bool | False |
Indicates whether the signature for the medical inquiry was captured remotely, often for compliance or legal reasons. |
| Signature Captured QR Code | Bool | False |
Indicates whether the signature for the medical inquiry was captured using a QR code, providing an alternative method for signature collection. |
| Signature Captured Share Link | Bool | False |
Indicates whether the signature was captured via a shareable link, allowing for remote or distributed signing. |
| Signature Date | Datetime | False |
The date and time when the signature for the medical inquiry was captured, marking the completion of the agreement process. |
| Signature | String | False |
The actual signature associated with the medical inquiry, confirming the approval or acknowledgment of the inquiry. |
| State2 | String | False |
The state or province of the medical inquiry, providing an additional geographic classification. |
| Medical Inquiry Status | String | False |
The current status of the medical inquiry, such as 'Open', 'Closed', or 'Pending', helping track the inquiry's lifecycle. |
| Submitted By Mobile | Bool | False |
Indicates whether the medical inquiry was submitted via a mobile device, often for reporting and tracking purposes. |
| Zip | String | False |
The postal code or ZIP code for the medical inquiry address, ensuring accurate delivery and tracking. |
| Account | String | False |
The account associated with the medical inquiry, used for linking the inquiry to a specific customer or organization. |
| Assign To User | String | False |
The user assigned to manage or respond to the medical inquiry, ensuring accountability for its resolution. |
| Call | String | False |
The phone number associated with the medical inquiry's call center, used for customer service and support. |
| Owner | String | False |
The owner or person responsible for the medical inquiry record, ensuring accountability for its management. |
| Country | String | False |
The country associated with the medical inquiry, used for tracking inquiries across different regions. |
| Lifecycle | String | True |
The lifecycle stage of the medical inquiry, such as 'Open', 'Closed', or 'Resolved', helping categorize the inquiry. |
| Lifecycle State | String | True |
The specific state within the inquiry's lifecycle, detailing where the inquiry stands in its resolution process. |
| Lifecycle State Stage ID | String | True |
An identifier for the specific stage in the lifecycle of the medical inquiry, providing more detailed tracking. |
| Lifecycle Stage | String | True |
The broader stage within the medical inquiry's lifecycle, such as 'Initial Review', 'Follow-Up', or 'Resolved'. |
| Legacy CRM Id | String | False |
The identifier from the legacy CRM system used to link the medical inquiry to previous records or platforms. |
| Child Account Id | String | False |
The identifier for a child account associated with the medical inquiry, typically used for organizations with multiple accounts. |
| Location Id | String | False |
An identifier for the location where the medical inquiry originated, used for geographic and logistical tracking. |
| Child Account | String | False |
The name or identifier of the child account linked to the medical inquiry, often used in hierarchical account structures. |
| Location | String | False |
The location associated with the medical inquiry, used for geographical identification and event tracking. |
| Account Country | String | False |
The country of the account associated with the medical inquiry, providing additional geographic context. |
| MedComms Country | String | False |
The country related to the MedComms aspect of the inquiry, which may differ from the account's country. |
| Documented Interest | String | False |
The specific interest documented in the medical inquiry, often used to track the focus or topic of the inquiry. |