Medication

Name	Label	Type	Description
Id	Medication ID	ID
OwnerId	Owner ID	LOOKUP
IsDeleted	Deleted	CHECKBOX
Name	Name	TEXT(255)
CreatedDate	Created Date	DATETIME
CreatedById	Created By ID	LOOKUP
LastModifiedDate	Last Modified Date	DATETIME
LastModifiedById	Last Modified By ID	LOOKUP
SystemModstamp	System Modstamp	DATETIME
LastViewedDate	Last Viewed Date	DATETIME
LastReferencedDate	Last Referenced Date	DATETIME
MedicationCodeId	Code Set Bundle ID	LOOKUP
Status	Status	PICKLIST
MedicationFormId	Code Set Bundle ID	LOOKUP
ManufacturerId	Account ID	LOOKUP
QuantityNumerator	Quantity Numerator	NUMBER(4,2)
QuantityUnitId	Unit of Measure ID	LOOKUP
QuantityDenominator	Quantity Denominator	NUMBER(4,2)
SourceSystem	Source System	TEXT(64)
SourceSystemIdentifier	Source System ID	TEXT(255)
SourceSystemModified	Source System Modified	DATETIME
BatchNumber	Batch Number	AUTO NUMBER
ExpirationDateTime	Expiration Date	DATETIME
MedicationCategory	Medication Category	PICKLIST
BrandNameAlternative	Brand Name Alternative	TEXT(255)
ProductId	Product ID	LOOKUP

Name	Id
Label	Medication ID
Type	ID
Required	Yes

Name	OwnerId
Label	Owner ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	Name
Label	Name
Type	TEXT(255)
Required	Yes

Name	CreatedDate
Label	Created Date
Type	DATETIME
Required	Yes

Name	CreatedById
Label	Created By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	LastModifiedDate
Label	Last Modified Date
Type	DATETIME
Required	Yes

Name	LastModifiedById
Label	Last Modified By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	SystemModstamp
Label	System Modstamp
Type	DATETIME
Required	Yes

Name	LastViewedDate
Label	Last Viewed Date
Type	DATETIME

Name	LastReferencedDate
Label	Last Referenced Date
Type	DATETIME

Name	MedicationCodeId
Label	Code Set Bundle ID
Type	LOOKUP
Foreign key	Yes

Name	Status
Label	Status
Type	PICKLIST
Picklist values	Active Inactive Entered in error

Name	MedicationFormId
Label	Code Set Bundle ID
Type	LOOKUP
Foreign key	Yes
Help Text	The system-defined code for the dosage form this medication is manufactured in.

Name	ManufacturerId
Label	Account ID
Type	LOOKUP
Foreign key	Yes

Name	QuantityNumerator
Label	Quantity Numerator
Type	NUMBER(4,2)
Help Text	The total amount of the medication contained in the packaged product. If the medication dosage is a ratio, specify the numerator value. If the medication dosage is a range, specify the lower dosage value. If the medication dosage is a simple dose, specify the quantity. Examples: If quantity is 10 units/ml, then enter 10 in this field and 1 in Quantity Denominator. If quantity is 1-2 pills/day, then enter 1 in this field and 2 in Quantity Denominator.

Name	QuantityUnitId
Label	Unit of Measure ID
Type	LOOKUP
Foreign key	Yes

Name	QuantityDenominator
Label	Quantity Denominator
Type	NUMBER(4,2)
Help Text	The denominator for the amount of medication contained in the packaged product when the dose is a ratio or a range. If the medication dosage is a ratio, specify the denominator value. If the medication dosage is a range, specify the upper dosage value. Examples: If quantity is 10 units/ml, then enter 10 in Quantity Numerator and 1 in this field. If quantity is 1-2 pills/day, then enter 1 in Quantity Numerator and 2 in this field.

Name	SourceSystem
Label	Source System
Type	TEXT(64)

Name	SourceSystemIdentifier
Label	Source System ID
Type	TEXT(255)

Name	SourceSystemModified
Label	Source System Modified
Type	DATETIME
Help Text	The most recent date when the integration system wrote the record from the source record.

Name	BatchNumber
Label	Batch Number
Type	AUTO NUMBER

Name	ExpirationDateTime
Label	Expiration Date
Type	DATETIME

Name	MedicationCategory
Label	Medication Category
Type	PICKLIST
Picklist values	Branded Product Therapeutic Moeity Generic Product Innovator Product

Name	BrandNameAlternative
Label	Brand Name Alternative
Type	TEXT(255)

Name	ProductId
Label	Product ID
Type	LOOKUP
Foreign key	Yes

Name
Medication Management
Pharmacy Benefits Verification

Name	Parent object	Child object	Parent object field	Child object field
AdministeredProduct	Medication	CarePlanActivity	Id	AdministeredProductId
MedicationCode	Medication	CareRequestDrug	Id	MedicationCodeId
Subject	Medication	ClinicalAlert	Id	SubjectId
FirstPublishLocation	Medication	ContentVersion	Id	FirstPublishLocationId
ReferenceObject	Medication	DocumentEnvelope	Id	ReferenceObjectId
RelatedRecord	Medication	FlowOrchestrationWorkItem	Id	RelatedRecordId
ReferenceObject	Medication	GeneratedDocument	Id	ReferenceObjectId
ParentRecord	Medication	Identifier	Id	ParentRecordId
Medication	Medication	MedicationDispense	Id	MedicationId
Medication	Medication	MedicationRequest	Id	MedicationId
Medication	Medication	MedicationStatement	Id	MedicationId
ParentRecord	Medication	MedicinalIngredient	Id	ParentRecordId
Ingredient	Medication	MedicinalIngredient	Id	IngredientId
DetailRecord	Medication	PatientMedicalProcedureDetail	Id	DetailRecordId

Name	Parent object	Child object	Parent object field	Child object field
Owner	User	Medication	Id	OwnerId
CreatedBy	User	Medication	Id	CreatedById
LastModifiedBy	User	Medication	Id	LastModifiedById
MedicationCode	CodeSetBundle	Medication	Id	MedicationCodeId
MedicationForm	CodeSetBundle	Medication	Id	MedicationFormId
Manufacturer	Account	Medication	Id	ManufacturerId
QuantityUnit	UnitOfMeasure	Medication	Id	QuantityUnitId
Product	Product2	Medication	Id	ProductId

Label	Value