JDBC Driver for Vault CRM

Build 25.0.9434

BenefitDesignLines

Represents the individual components or coverage details within a broader benefit design, such as specific services, drugs, or eligibility conditions. Each row defines a benefit rule or line item.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique identifier for the benefit design line record, used as the primary key.

Global ID String True

System-generated global identifier that ensures uniqueness across environments and Vaults.

Link String False

Internal Vault system reference linking to the document or record associated with this benefit design line.

Linenumber String True

User-defined display name or identifier representing the specific line within the benefit design.

Status String False

Current lifecycle state of the benefit design line, such as Active, Inactive, or Obsolete.

Created By String True

Username of the person or system that originally created this benefit design line entry.

Created Date Datetime True

Timestamp indicating when the benefit design line record was initially created in the system.

Last Modified By String True

Username of the last user or process that modified this benefit design line.

Last Modified Date Datetime True

Date and time when the benefit design line was last updated.

Copay (Source) String False

Origin or reference for the copay value, indicating where the copay information was derived from.

Copay String False

Copayment amount associated with the benefit design line, as defined in the source data or calculated.

External ID String False

Identifier used to map this benefit design line to an external system such as a Customer Relationship Management (CRM) or legacy database.

Notes (Source) String False

Indicates the source or origin of the notes field, such as internal research or external partner data.

Notes String False

Additional remarks, context, or explanatory text provided for this benefit design line.

Restrictions (Source) String False

Denotes where the restriction details were sourced from, such as product labels or formulary documentation.

Status (Source) String False

Provides the origin or reference system of the benefit design line's status, helping validate lifecycle state.

Type String False

Classifies the benefit design line based on its type, such as Coverage, Copay Assistance, or Step Therapy.

Restrictions String False

Specific limitations or conditions applicable to this benefit design line, such as prior authorization requirements.

Benefit Design Line Status String False

Custom status specific to this benefit design line, which can reflect internal tracking beyond standard status.

Benefit Design String False

Reference to the parent benefit design record to which this line belongs, establishing hierarchical context.

Product String False

Product associated with this benefit design line, typically referencing a drug, therapy, or treatment plan.

Competitor Bool True

Boolean flag indicating whether the associated product is considered a competitor in the benefit landscape.

Legacy CRM Id String False

Identifier used in a legacy CRM system for backward compatibility and data migration purposes.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434