Formulary Item DMO

Represents details of products within the formulary, including the drug tier, coverage and copay.

Object Properties

Object API Name: FormularyItem_std__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

Relationships

• FormularyId has a FOREIGNKEY relationship with the Formulary DMO Id field.
• ItemRecordId has a FOREIGNKEY relationship with the Product DMO Id field.
• ItemRecordId has a FOREIGNKEY relationship with the Life Science Marketable Product DMO Id field.

Fields

• cdp_sys_record_currency
• CopayAmt
• DataSourceId
• DataSourceObjectId
• Description
• EffectiveEndDate
• EffectiveStartDate
• FormularyId
• HasQuantityLimit
• Id
• InternalOrganizationId
• ItemRecordId
• ItemRecordObject
• KQ_FormularyId
• KQ_Id
• KQ_ItemRecordId
• PriorAuthorizationRequiredType
• QuantityLimitDescription
• Status
• StepTherapyLimitType
• TierType
• TotalCoveredLifeCount
• TotalCoveredPharmacyLifeCount

cdp_sys_record_currency

• Field API Name: cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

CopayAmt

• Field API Name: CopayAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the copay amt. Do not include currency symbols or commas.

DataSourceId

• Field API Name: DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DataSourceObjectId

• Field API Name: DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

Description

• Field API Name: Description__c
• Data Type: TEXT
• Description: Description of this record.

EffectiveEndDate

• Field API Name: EffectiveEndDate__c
• Data Type: DATEONLY
• Description: Calendar date representing the effective end date in the YYYY-MM-DD format.

EffectiveStartDate

• Field API Name: EffectiveStartDate__c
• Data Type: DATEONLY
• Description: Calendar date representing the effective start date in the YYYY-MM-DD format.

FormularyId

• Field API Name: FormularyId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

HasQuantityLimit

• Field API Name: HasQuantityLimit__c
• Data Type: BOOLEAN
• Description: Indicates whether this record has quantity limit (true) or not (false).

Id

• Field API Name: Id__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

InternalOrganizationId

• Field API Name: InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ItemRecordId

• Field API Name: ItemRecordId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ItemRecordObject

• Field API Name: ItemRecordObject__c
• Data Type: TEXT
• Description: Alphanumeric string representing the item record object.

KQ_FormularyId

• Field API Name: KQ_FormularyId__c
• Data Type: TEXT
• Description: Key Qualifier system field for FormularyId

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

KQ_ItemRecordId

• Field API Name: KQ_ItemRecordId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ItemRecordId

PriorAuthorizationRequiredType

• Field API Name: PriorAuthorizationRequiredType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the prior authorization required type.

QuantityLimitDescription

• Field API Name: QuantityLimitDescription__c
• Data Type: TEXT
• Description: Alphanumeric string representing the quantity limit description.

Status

• Field API Name: Status__c
• Data Type: TEXT
• Description: The status of this record.

StepTherapyLimitType

• Field API Name: StepTherapyLimitType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the step therapy limit type.

TierType

• Field API Name: TierType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the tier type.

TotalCoveredLifeCount

• Field API Name: TotalCoveredLifeCount__c
• Data Type: DOUBLE
• Description: The number of total covered lives for this record.

TotalCoveredPharmacyLifeCount

• Field API Name: TotalCoveredPharmacyLifeCount__c
• Data Type: DOUBLE
• Description: The number of total covered pharmacy lives for this record.