# Medication DMO

## Object Properties

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

## Relationships

- **ManufacturerId** has a FOREIGNKEY relationship with the [Account DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-accountdmo-dmo.md) `Id` field.
- **MedicationCodeId** has a FOREIGNKEY relationship with the [Code Set Bundle DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-codesetbundledmo-dmo.md) `Id` field.
- **QuantityUnitId** has a FOREIGNKEY relationship with the [Unit of Measure DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-unitofmeasuredmo-dmo.md) `Id` field.
- **QuantityNumeratorUnitId** has a FOREIGNKEY relationship with the [Unit of Measure DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-unitofmeasuredmo-dmo.md) `Id` field.
- **QuantityDenominatorUnitId** has a FOREIGNKEY relationship with the [Unit of Measure DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-unitofmeasuredmo-dmo.md) `Id` field.
- **MedicationFormId** has a FOREIGNKEY relationship with the [Code Set Bundle DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-codesetbundledmo-dmo.md) `Id` field.
- **ProductId** has a FOREIGNKEY relationship with the [Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productdmo-dmo.md) `Id` field.

## Fields

- [AlternateBrandName](#alternatebrandname)
- [BatchNumber](#batchnumber)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [ExpirationDateTime](#expirationdatetime)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [KQ_ManufacturerId](#kq_manufacturerid)
- [KQ_MedicationCodeId](#kq_medicationcodeid)
- [KQ_MedicationFormId](#kq_medicationformid)
- [KQ_ProductId](#kq_productid)
- [KQ_QuantityDenominatorUnitId](#kq_quantitydenominatorunitid)
- [KQ_QuantityNumeratorUnitId](#kq_quantitynumeratorunitid)
- [KQ_QuantityUnitId](#kq_quantityunitid)
- [ManufacturerId](#manufacturerid)
- [MedicationCategory](#medicationcategory)
- [MedicationCodeId](#medicationcodeid)
- [MedicationFormId](#medicationformid)
- [MedicationStatus](#medicationstatus)
- [Name](#name)
- [ProductId](#productid)
- [QuantityDenominatorNumber](#quantitydenominatornumber)
- [QuantityDenominatorUnitId](#quantitydenominatorunitid)
- [QuantityNumeratorNumber](#quantitynumeratornumber)
- [QuantityNumeratorUnitId](#quantitynumeratorunitid)
- [QuantityUnitId](#quantityunitid)

### AlternateBrandName

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

### BatchNumber

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

### cdp_sys_record_currency

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

### DataSourceId

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

### DataSourceObjectId

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

### ExpirationDateTime

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

### Id

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

### InternalOrganizationId

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

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_ManufacturerId

- **Field API Name:** `KQ_ManufacturerId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ManufacturerId

### KQ_MedicationCodeId

- **Field API Name:** `KQ_MedicationCodeId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for MedicationCodeId

### KQ_MedicationFormId

- **Field API Name:** `KQ_MedicationFormId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for MedicationFormId

### KQ_ProductId

- **Field API Name:** `KQ_ProductId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProductId

### KQ_QuantityDenominatorUnitId

- **Field API Name:** `KQ_QuantityDenominatorUnitId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for QuantityDenominatorUnitId

### KQ_QuantityNumeratorUnitId

- **Field API Name:** `KQ_QuantityNumeratorUnitId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for QuantityNumeratorUnitId

### KQ_QuantityUnitId

- **Field API Name:** `KQ_QuantityUnitId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for QuantityUnitId

### ManufacturerId

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

### MedicationCategory

- **Field API Name:** `ssot__MedicationCategory__c`
- **Data Type:** TEXT
- **Description:** The category of the medication.

### MedicationCodeId

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

### MedicationFormId

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

### MedicationStatus

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

### Name

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

### ProductId

- **Field API Name:** `ssot__ProductId__c`
- **Data Type:** TEXT
- **Description:** The product associated with medication.

### QuantityDenominatorNumber

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

### QuantityDenominatorUnitId

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

### QuantityNumeratorNumber

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

### QuantityNumeratorUnitId

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

### QuantityUnitId

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