Medication DMO

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

• ManufacturerId has a FOREIGNKEY relationship with the Account DMO Id field.
• MedicationCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• QuantityUnitId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• QuantityNumeratorUnitId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• QuantityDenominatorUnitId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• MedicationFormId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.

• AlternateBrandName
• BatchNumber
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• ExpirationDateTime
• Id
• InternalOrganizationId
• KQ_Id
• KQ_ManufacturerId
• KQ_MedicationCodeId
• KQ_MedicationFormId
• KQ_ProductId
• KQ_QuantityDenominatorUnitId
• KQ_QuantityNumeratorUnitId
• KQ_QuantityUnitId
• ManufacturerId
• MedicationCategory
• MedicationCodeId
• MedicationFormId
• MedicationStatus
• Name
• ProductId
• QuantityDenominatorNumber
• QuantityDenominatorUnitId
• QuantityNumeratorNumber
• QuantityNumeratorUnitId
• QuantityUnitId

• Field API Name: ssot__AlternateBrandName__c
• Data Type: TEXT
• Description: The branded alternative for a generic medication.

• Field API Name: ssot__BatchNumber__c
• Data Type: DOUBLE
• Description: An identifier assigned by the manufacturer that helps trace its history and production.

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

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

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

• Field API Name: ssot__ExpirationDateTime__c
• Data Type: DATETIME
• Description: When the drug should no longer be consumed.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this Medication record. Maximum size is 36 characters.

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

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

• Field API Name: KQ_ManufacturerId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ManufacturerId

• Field API Name: KQ_MedicationCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for MedicationCodeId

• Field API Name: KQ_MedicationFormId__c
• Data Type: TEXT
• Description: Key Qualifier system field for MedicationFormId

• Field API Name: KQ_ProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductId

• Field API Name: KQ_QuantityDenominatorUnitId__c
• Data Type: TEXT
• Description: Key Qualifier system field for QuantityDenominatorUnitId

• Field API Name: KQ_QuantityNumeratorUnitId__c
• Data Type: TEXT
• Description: Key Qualifier system field for QuantityNumeratorUnitId

• Field API Name: KQ_QuantityUnitId__c
• Data Type: TEXT
• Description: Key Qualifier system field for QuantityUnitId

• Field API Name: ssot__ManufacturerId__c
• Data Type: TEXT
• Description: An account for the company that produced the medicine.

• Field API Name: ssot__MedicationCategory__c
• Data Type: TEXT
• Description: The category of the medication.

• Field API Name: ssot__MedicationCodeId__c
• Data Type: TEXT
• Description: What medication was taken. Set of codes for it. Based on HL7 medication-codes. For example 747006 for Oxamniquine.

• Field API Name: ssot__MedicationFormId__c
• Data Type: TEXT
• Description: A form used to request a medication.

• Field API Name: ssot__MedicationStatus__c
• Data Type: TEXT
• Description: Values of medication status may include: approved, unapproved and withdrawn.

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name of a medication. For example, Pfizer BNT162b2 COVID-19 Vaccine.

• Field API Name: ssot__ProductId__c
• Data Type: TEXT
• Description: The product associated with medication.

• Field API Name: ssot__QuantityDenominatorNumber__c
• Data Type: DOUBLE
• Description: A numeric value used in the denominator of a formula used to specify the medication’s dosage.

• Field API Name: ssot__QuantityDenominatorUnitId__c
• Data Type: TEXT
• Description: Unit of measure used in the denominator of a formula used to specify a prescription.

• Field API Name: ssot__QuantityNumeratorNumber__c
• Data Type: DOUBLE
• Description: A numeric value used in the numerator of a formula used to specify the medication’s dosage.

• Field API Name: ssot__QuantityNumeratorUnitId__c
• Data Type: TEXT
• Description: Unit of measure used in the numerator of a formula used to specify a prescription.

• Field API Name: ssot__QuantityUnitId__c
• Data Type: TEXT
• Description: The unit of measure used to specify the dosage of a medication.